The practice of obtaining the reading number of articles on the WeChat public account (the request parameter does not support the article ID)

by 永夜 · 2020/11/20

浏览量： 5

1. The new requirements are: the display of the number of articles that needs to realize the WeChat channel. as shown in Figure 1

Figure 1

2. In fact, the most ideal situation should be able to obtain the number of readings of this article based on the article ID, just like Douyin. View Douyin Open Platform Documents – Resource Center – Open API – Video Management – Douyin – Query Video – Query video data for specific videos. Request parameters support article ID. as shown in Figure 2

实则最为理想的情况，应该是能够基于文章 ID 获取此文章的阅读数，就像抖音。查看抖音开放平台文档 - 资源中心 - Open Api - 视频管理 - 抖音 - 查询视频 - 查询特定视频的视频数据。请求参数支持文章 ID。

Figure 2

3. Check the official WeChat document – public account – data statistics – graphic analysis – interface call request description. It does not support the article ID, only the date range of the data is supported. BEGIN_DATE, the starting date of the data is obtained, the difference between BEGIN_DATE and END_DATE should be less than “Maximum time span (For example, when the maximum time span is 1, the difference between BEGIN_DATE and END_DATE can only be 0, it can be less than 1), otherwise an error will be reported. END_DATE, get the end date of the data, the maximum value that END_DATE allows to set is yesterday. as shown in Figure 3

查看微信官方文档 - 公众号 - 数据统计 - 图文分析 - 接口调用请求说明。其不支持文章 ID，仅支持数据的日期范围。begin_date，获取数据的起始日期，begin_date和end_date的差值需小于“最大时间跨度”(比如最大时间跨度为1时，begin_date和end_date的差值只能为0，才能小于1)，否则会报错。end_date，获取数据的结束日期，end_date允许设置的最大值为昨日。

Figure 3

4. Check the official WeChat document – public account – data statistics – graphic analysis – return parameter description. Please note: the msgid here is actually composed of msgid (graphic message id, which is the msg_data_id returned after the group interface call) and index (message order index), such as 12003_3, Among them, 12003 is msgid, that is, the ID of a mass message; 3 is index, assuming that there are 5 articles in the graphic and text messages sent this time (because it may be multi-graphics), 3 represents the third of the five. as shown in Figure 4

查看微信官方文档 - 公众号 - 数据统计 - 图文分析 - 返回参数说明。请注意：这里的msgid实际上是由msgid(图文消息id，这也就是群发接口调用后返回的msg_data_id)和index(消息次序索引)组成，例如12003_3，其中12003是msgid，即一次群发的消息的id； 3为index，假设该次群发的图文消息共5个文章(因为可能为多图文)，3表示5个中的第3个。

Figure 4

5. When the WeChat article is successfully mass posted, store the ID of the message sending task and the data ID of the message to the table. Its field type is: BIGINT. Because the maximum value of int is: 2147483647. Values less than msg_data_id: 2247483783. as shown in Figure 5

当微信文章群发成功后，将消息发送任务的ID 与消息的数据ID，存储至表中。其字段类型为：bigint。因为 int 的最大值为：2147483647。小于 msg_data_id 的值：2247483783。

Figure 5

6. Post https://api.weixin.qq.com/datacube/GetArticleTotal?access_token={access_token} , the response is as follows, as shown in Figure 6

$POST https://api.weixin.qq.com/datacube/getarticletotal?access_token={access_token} ，响应如下$

Figure 6

{
"begin_date": "2020-11-13",
"end_date": "2020-11-13"
}

{
"list":[
{
"ref_date": "2020-11-13",
"msgid": "2247483782_1",
"title": "33333r",
"user_source": 0,
"details": [
{
"stat_date": "2020-11-13",
"target_user": 356,
"int_page_read_user": 51,
"int_page_read_count": 68,
"ori_page_read_user": 4,
"ori_page_read_count": 6,
"share_user": 1,
"share_count": 1,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 51,
"int_page_from_session_read_count": 68,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-14",
"target_user": 356,
"int_page_read_user": 64,
"int_page_read_count": 82,
"ori_page_read_user": 5,
"ori_page_read_count": 7,
"share_user": 1,
"share_count": 1,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 64,
"int_page_from_session_read_count": 82,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-15",
"target_user": 356,
"int_page_read_user": 64,
"int_page_read_count": 84,
"ori_page_read_user": 6,
"ori_page_read_count": 8,
"share_user": 1,
"share_count": 1,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 64,
"int_page_from_session_read_count": 84,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-16",
"target_user": 356,
"int_page_read_user": 64,
"int_page_read_count": 84,
"ori_page_read_user": 6,
"ori_page_read_count": 8,
"share_user": 1,
"share_count": 1,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 64,
"int_page_from_session_read_count": 84,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-17",
"target_user": 356,
"int_page_read_user": 65,
"int_page_read_count": 86,
"ori_page_read_user": 6,
"ori_page_read_count": 8,
"share_user": 1,
"share_count": 1,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 65,
"int_page_from_session_read_count": 86,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
}
]#ATFP_CLOSE_Translate_span#,
"url": "https://mp.weixin.qq.com/s?__biz=mzixnjcymzkZoq==&amp;mid=22 47483782&amp;idx=1&amp;sn=06aa625b6f4b908a91776bf2e9a8c00e#rd"
},
{
"ref_date": "2020-11-13",
"msgid": "2247483782_2",
"title": "22222",
"user_source": 0,
"details":[
{
"stat_date": "2020-11-13",
"target_user": 356,
"int_page_read_user": 21,
"int_page_read_count": 25,
"ori_page_read_user": 0,
"ori_page_read_count": 0,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 21,
"int_page_from_session_read_count": 25,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-14",
"target_user": 356,
"int_page_read_user": 30,
"int_page_read_count": 37,
"ori_page_read_user": 0,
"ori_page_read_count": 0,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 30,
"int_page_from_session_read_count": 37,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-15",
"target_user": 356,
"int_page_read_user": 31,
"int_page_read_count": 39,
"ori_page_read_user": 0,
"ori_page_read_count": 0,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 31,
"int_page_from_session_read_count": 39,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-16",
"target_user": 356,
"int_page_read_user": 31,
"int_page_read_count": 39,
"ori_page_read_user": 0,
"ori_page_read_count": 0,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 31,
"int_page_from_session_read_count": 39,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-17",
"target_user": 356,
"int_page_read_user": 32,
"int_page_read_count": 40,
"ori_page_read_user": 0,
"ori_page_read_count": 0,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 32,
"int_page_from_session_read_count": 40,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 0,
"int_page_from_other_read_count": 0,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
}
]#ATFP_CLOSE_Translate_span#,
"url": "https://mp.weixin.qq.com/s?__biz=mzixnjcymzkZoq==&amp;mid=22 47483782&amp;IDX=2&amp;SN=AD6130AFFC4EBFFF8D7A95D89F8B6C7#RD"
},
{
"ref_date": "2020-11-13",
"msgid": "2247483783_1",
"title": "Happy Weekend No. 3",
"user_source": 0,
"details":[
{
"stat_date": "2020-11-13",
"target_user": 356,
"int_page_read_user": 98,
"int_page_read_count": 121,
"ori_page_read_user": 9,
"ori_page_read_count": 11,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 97,
"int_page_from_session_read_count": 120,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 1,
"int_page_from_other_read_count": 1,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-14",
"target_user": 356,
"int_page_read_user": 118,
"int_page_read_count": 147,
"ori_page_read_user": 10,
"ori_page_read_count": 12,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 117,
"int_page_from_session_read_count": 146,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 1,
"int_page_from_other_read_count": 1,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-15",
"target_user": 356,
"int_page_read_user": 119,
"int_page_read_count": 150,
"ori_page_read_user": 10,
"ori_page_read_count": 12,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 118,
"int_page_from_session_read_count": 149,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 1,
"int_page_from_other_read_count": 1,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-16",
"target_user": 356,
"int_page_read_user": 119,
"int_page_read_count": 150,
"ori_page_read_user": 10,
"ori_page_read_count": 12,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 118,
"int_page_from_session_read_count": 149,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 1,
"int_page_from_other_read_count": 1,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
},
{
"stat_date": "2020-11-17",
"target_user": 356,
"int_page_read_user": 120,
"int_page_read_count": 151,
"ori_page_read_user": 10,
"ori_page_read_count": 12,
"share_user": 0,
"share_count": 0,
"add_to_fav_user": 0,
"add_to_fav_count": 0,
"int_page_from_session_read_user": 119,
"int_page_from_session_read_count": 150,
"int_page_from_hist_msg_read_user": 0,
"int_page_from_hist_msg_count": 0,
"int_page_from_feed_read_user": 0,
"int_page_from_feed_read_count": 0,
"int_page_from_friends_read_user": 0,
"int_page_from_friends_read_count": 0,
"int_page_from_other_read_user": 1,
"int_page_from_other_read_count": 1,
"feed_share_from_session_user": 0,
"feed_share_from_session_cnt": 0,
"feed_share_from_feed_user": 0,
"feed_share_from_feed_cnt": 0,
"feed_share_from_other_user": 0,
"feed_share_from_other_cnt": 0
}
]#ATFP_CLOSE_Translate_span#,
"url": "https://mp.weixin.qq.com/s?__biz=mzixnjcymzkZoq==&amp;mid=22 47483783&amp;idx=1&amp;sn=4946a8fb35caa4c29aa2232eb51f8bb1#rd"
}
]
}

7. Statistics of the first article of the task of obtaining the application of WeChat public account. In the end, you can try to simulate the effect similar to Douyin (although you can’t get the latest reading count, you can only get the number of readings after the release at most 7 days). The maximum time span refers to the time range of the maximum data that can be obtained when an interface is called. Get the number of readings based on the article ID. The problem may be that the date range is not accurate enough, because the value of the record is the time of the creation of this record, and the time that should be published on the WeChat platform should be taken. subsequent optimizations. The code is as follows

&lt;?php

namespace console\services;

use yii;
use yii\helpers\arrayHelper;
Use Yii\Web\ServerErrorHttpException;

Class WXAppTaskService extends \Common\Services\WxAppTaskService
{
/**
* Statistics of the first article in the first article of the task of obtaining the application of WeChat public account
* @param object $wxapptask The task of the application of WeChat public account
* @param string $accesstoken access token
;
* @return array
* The format is as follows:
;
;[ // 最后一个统计日期
;STAT_DATE:2020-05-29, // Statistical date, in the getArticleTotal interface, ref_date refers to the date of the article group is issued, and stat_date is the data statistics date
;target_user: 387, // The number of people delivered, generally equal to the total number of fans
;int_page_read_user: 86, // The number of readers of the picture page (click the page to enter the group posting picture and text card)
;int_page_read_count: 111, // Reading times for pictures and text pages
;ORI_PAGE_READ_USER: 11, // The number of readers of the original page (click the page "read the original text" to enter the text page), if there is no original page, the data here is 0
;ori_page_read_count: 12, // Reading times of the original page
;share_user: 1, // Number of people to share
;share_count: 1, // The number of times to share
;ADD_TO_FAV_USER: 0, // The number of people to collect
;add_to_fav_count: 0, // the number of favorites
;int_page_from_session_read_user: 85, // The number of readers of the public account conversation
;int_page_from_session_read_count: 109, // The number of reading times of the public account conversation
;int_page_from_hist_msg_read_user: 0, // The number of readers of the historical message page
;int_page_from_hist_msg_read_count: 0, // The number of readings of the historical message page
;int_page_from_feed_read_user: 0, // The number of readers in the circle of friends
;int_page_from_feed_read_count: 0, // The number of readings of the circle of friends
;int_page_from_friends_read_user: 0, // Friends forward the number of readers
;int_page_from_friends_read_count: 0, // Friends retweeted the number of reading times
;int_page_from_other_read_user: 1, // Number of readers in other scenarios
;int_page_from_other_read_count: 1, // Reading times for other scenes
;feed_share_from_session_user: 0, // The public account conversation forwards the number of people in the circle of friends
;feed_share_from_session_cnt: 0, // The number of public account conversations forwarded to the circle of friends
;feed_share_from_feed_user: 0, // The number of people forwarded to the circle of friends
;feed_share_from_feed_cnt: 0, // The number of times forwarded to the circle of friends
;feed_share_from_other_user: 0, // Forward the number of people in the circle of friends in other scenarios
;feed_share_from_other_cnt: 0, // For other scenarios, the number of times forwarded to the circle of friends
* ]#atfp_close_translate_span#
;
* @Throws ServerErrorHttpException
*/
public static function getCounts($wxAppTask, $accessToken)
{
$date = date(Y-M-D, $wxapptask-&gt;created_at);
// http request, get the total data of graphic and text mass sending
$HttpGetArticleTotalData =[
accessToken=&gt; $accessToken,
begindate=&gt; $date,
enddate=&gt; $date,
]#atfp_close_translate_span#;
$ArticleTotal = wxDataCubService::HttpGetArticleTotal($HttpGetArticleTotalData);

// Rebuild the array index, the key name: msgid
$list = arrayHelper::index($articletotal['list'],msgid);
$msgid = $wxapptask-&gt;msg_data_id ._1;
$counts =[];
if (isset($list)[$msgid])) {
// get the last key value of an array
$lastkey = array_key_last($list[$msgid]['details']);
$counts = $list[$msgid]['details'][$lastKey];
}

return $counts;
}
}

The practice of obtaining the reading number of articles on the WeChat public account (the request parameter does not support the article ID)

You may also like...

Leave a Reply Cancel reply

The practice of obtaining the reading number of articles on the WeChat public account (the request parameter does not support the article ID)

You may also like...

In Windows 10, Yii2.0, and MySQL, the unique index of the combination is realized, and the process of data repeated writing in high concurrent situations is solved.

Modular Example Implementation in Laravel 8

Error in Yii 2.0: php warning: strpos(): empty needle in Analysis of e:\wwwroot\pcs-api\vendor\yiisoft\yii2\log\target.php on line 243

Leave a Reply Cancel reply