1. The new requirements are: the display of the number of articles that needs to realize the WeChat channel. as shown in 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
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
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
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
6. Post https://api.weixin.qq.com/datacube/GetArticleTotal?access_token={access_token} , the response is as follows, as shown in Figure 6
{
"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_read_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_read_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_read_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_read_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_read_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
}
],
"url": "https://mp.weixin.qq.com/s?__biz=MzIxNjcyMzkzOQ==&mid=2247483782&idx=1&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_read_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_read_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_read_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_read_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_read_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
}
],
"url": "https://mp.weixin.qq.com/s?__biz=MzIxNjcyMzkzOQ==&mid=2247483782&idx=2&sn=ad6130affc4ebffff8d7a95d89f8b6c7#rd"
},
{
"ref_date": "2020-11-13",
"msgid": "2247483783_1",
"title": "快乐周末三号",
"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_read_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_read_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_read_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_read_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_read_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
}
],
"url": "https://mp.weixin.qq.com/s?__biz=MzIxNjcyMzkzOQ==&mid=2247483783&idx=1&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
Leave a Reply