Internet media number operation data monitoring method and system

By building data tables and obtaining media number permissions, the problem of the inability to count the operation data of multiple Internet media accounts in the existing technology is solved, and efficient monitoring effect is achieved.

CN118939703APending Publication Date: 2024-11-12GUANGDONG ELECTRIC SHOCK MEDIA TECH CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411015011.7
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-26
Publication Date
2024-11-12

AI Technical Summary

Technical Problem

The existing technology cannot realize the one-click statistics of operational data of multiple Internet media accounts, resulting in poor monitoring effects.

Method used

The data table is constructed including the user media number relationship table, manuscript table, media number total statistics table and media number increment statistics table. The media number permission is obtained through the user media number relationship table, and the manuscript information and media number are queried from these tables. Total information and media number incremental information.

Benefits of technology

It realizes one-click statistics on the operation data of multiple Internet media accounts, significantly improving the monitoring effect.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118939703A_ABST
    Figure CN118939703A_ABST
Patent Text Reader

Abstract

The invention discloses an internet media number operation data monitoring method and system, and the method comprises the steps: constructing a data table which comprises a user media number relation table, a manuscript table, a media number total amount statistical table and a media number increment statistical table, and carrying out the processing of to-be-queried internet media number information according to the user media number relation table, according to the method and the device, the authority corresponding to the media number is obtained, query is carried out from the manuscript table, the media number total quantity statistical table and the media number increment statistical table according to the authority corresponding to the media number, and corresponding manuscript information, media number total quantity information and media number increment information are generated, so that the effect of one-key statistics of operation data of a plurality of Internet media accounts can be realized; therefore, the monitoring effect is greatly improved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of media account operation data monitoring, and in particular to an Internet media account operation data monitoring method and system. Background Art

[0002] Internet media has become an important channel for information dissemination and promotion. Commercial companies, scientific research institutions, government agencies and individuals are all operating one or more Internet media accounts to disseminate and promote information. For an Internet media account, monitoring its operating data can effectively evaluate its ability to disseminate information or the quality of its operation, thereby helping account operators to accurately position themselves and identify operational problems. It can also help companies to more clearly understand the work results of the company's publicity department. However, in the existing technology, monitoring the operating data of Internet media accounts requires statistics for each account one by one, and it is impossible to achieve the effect of one-click statistics for multiple Internet media accounts, resulting in poor monitoring results. Summary of the invention

[0003] In view of this, the present invention proposes an Internet media account operation data monitoring method and system, which can solve the defect of the prior art that it is impossible to achieve the effect of one-click statistics of multiple Internet media accounts, resulting in poor monitoring effect.

[0004] The technical solution of the present invention is achieved in this way:

[0005] A method for monitoring operation data of an Internet media account, specifically comprising:

[0006] Constructing a data table, wherein the data table includes a user media number relationship table, a manuscript table, a media number total statistics table, and a media number increment statistics table;

[0007] Obtain the Internet media number information to be queried;

[0008] Process the Internet media number information to be queried according to the user media number relationship table to obtain the corresponding authority of the media number;

[0009] According to the authority corresponding to the media number, a query is performed from the manuscript table, the media number total statistics table and the media number increment statistics table to generate corresponding manuscript information, media number total information and media number increment information.

[0010] As a further optional scheme of the Internet media account operation data monitoring method, the user media number relationship table includes a user table, a user role table, a role table, a role data permission table and a media number table. The user table is used to record the login information of each account, the user role table is used to record the relationship between each account and role, the role table is used to record the permission chain of each role, the role data permission table is used to record the permissions of each role to the department-visible data, and the media number table is used to record the relationship between each media number and the department and third-party platform.

[0011] As a further optional solution of the Internet media account operation data monitoring method, the Internet media account information to be queried is processed according to the user media account relationship table to obtain the authority corresponding to the media account, specifically including:

[0012] The Internet media number information to be queried is judged based on the user table to determine whether the Internet media number information to be queried is recorded in the user table. If so, the corresponding role, role permission chain, department visible data permission of the role, and the relationship between each media number and department and third-party platform are obtained based on the user role table, role table, role data permission table and media number table. Otherwise, the page with no permission to query is returned.

[0013] As a further optional solution of the Internet media account operation data monitoring method, the query from the manuscript table, the media account total statistics table and the media account increment statistics table according to the corresponding authority of the media account to generate corresponding manuscript information, media account total information and media account increment information specifically includes:

[0014] According to the permissions corresponding to the media account, content production statistics are collected from the media account total statistics table to obtain the distribution volume and publication volume of the account;

[0015] Perform dissemination analysis and statistics from the total number statistics table of the media account according to the corresponding permissions of the media account to obtain the number of readings, likes, shares and comments of the account;

[0016] According to the permissions corresponding to the media account, growth statistics are performed from the media account incremental statistics table to obtain the account's reading growth, like growth, sharing growth, comment growth, user growth, distribution growth, and publication growth;

[0017] According to the authority corresponding to the media number, detailed content statistics are performed from the manuscript table to obtain the specific content of the manuscript of the account.

[0018] An Internet media account operation data monitoring system, comprising:

[0019] A construction module is used to construct a data table, wherein the data table includes a user media number relationship table, a manuscript table, a media number total statistics table, and a media number increment statistics table;

[0020] An acquisition module is used to acquire the Internet media number information to be queried;

[0021] A processing module, used to process the Internet media number information to be queried according to the user media number relationship table, and obtain the authority corresponding to the media number;

[0022] The query module is used to query from the manuscript table, the media number total statistics table and the media number increment statistics table according to the permissions corresponding to the media number, and generate corresponding manuscript information, media number total information and media number increment information.

[0023] As a further optional solution for the Internet media account operation data monitoring system, the user media number relationship table includes a user table, a user role table, a role table, a role data permission table and a media number table. The user table is used to record the login information of each account, the user role table is used to record the relationship between each account and role, the role table is used to record the permission chain of each role, the role data permission table is used to record the permissions of each role to the department-visible data, and the media number table is used to record the relationship between each media number and the department and third-party platform.

[0024] As a further optional solution of the Internet media account operation data monitoring system, the processing module includes:

[0025] A judgment module, used to judge the Internet media number information to be queried according to the user table, and judge whether the Internet media number information to be queried is recorded in the user table;

[0026] The execution module is used to obtain the corresponding role, role permission chain, the department visible data permissions owned by the role and the relationship between each media number and department and third-party platform based on the user role table, role table, role data permission table and media number table.

[0027] As a further optional solution of the Internet media account operation data monitoring system, the query module includes:

[0028] A first statistical module is used to perform content production statistics from a media account total statistics table according to the permissions corresponding to the media account, and obtain the distribution volume and publication volume of the account;

[0029] The second statistical module is used to perform dissemination analysis and statistics from the total number statistical table of the media accounts according to the permissions corresponding to the media accounts, and obtain the number of readings, likes, shares and comments of the account;

[0030] The third statistical module is used to perform growth statistics from the media account incremental statistical table according to the permissions corresponding to the media account, and obtain the account's reading growth, like growth, sharing growth, comment growth, user growth, distribution growth, and publication growth;

[0031] The fourth statistical module is used to perform detailed content statistics from the manuscript table according to the authority corresponding to the media number to obtain the specific content of the manuscript of the account.

[0032] A computing device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements any one of the steps of the above-mentioned Internet media account operation data monitoring method when executing the computer program.

[0033] A computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of any one of the above-mentioned methods for monitoring the operation data of an Internet media account.

[0034] The beneficial effects of the present invention are as follows: by constructing a data table, the data table includes a user media number relationship table, a manuscript table, a media number total statistics table and a media number increment statistics table, the Internet media number information to be queried is processed according to the user media number relationship table, and the corresponding authority of the media number is obtained, and the manuscript table, the media number total statistics table and the media number increment statistics table are queried according to the corresponding authority of the media number to generate the corresponding manuscript information, media number total information and media number increment information, which can achieve the effect of one-click statistics of multiple Internet media account operation data, thereby greatly improving the monitoring effect. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0036] Figure 1 A schematic diagram of a flow chart of a method for monitoring operation data of an Internet media account according to the present invention;

[0037] Figure 2 The present invention is a schematic diagram of the composition of an Internet media account operation data monitoring system. DETAILED DESCRIPTION

[0038] The technical solutions in the embodiments of the present invention are described clearly and completely below. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0039] refer to Figure 1-2 , a method for monitoring operation data of an Internet media account, specifically comprising:

[0040] Constructing a data table, wherein the data table includes a user media number relationship table, a manuscript table, a media number total statistics table, and a media number increment statistics table;

[0041] Obtain the Internet media number information to be queried;

[0042] Process the Internet media number information to be queried according to the user media number relationship table to obtain the corresponding authority of the media number;

[0043] According to the authority corresponding to the media number, a query is performed from the manuscript table, the media number total statistics table and the media number increment statistics table to generate corresponding manuscript information, media number total information and media number increment information.

[0044] In this embodiment, by constructing a data table, the data table includes a user media number relationship table, a manuscript table, a media number total statistics table and a media number incremental statistics table, the Internet media number information to be queried is processed according to the user media number relationship table, and the corresponding permissions of the media number are obtained. According to the permissions corresponding to the media number, the manuscript table, the media number total statistics table and the media number incremental statistics table are queried to generate the corresponding manuscript information, media number total information and media number incremental information, which can achieve the effect of one-click statistics of multiple Internet media account operation data, thereby greatly improving the monitoring effect.

[0045] Preferably, the user-media number relationship table includes a user table, a user role table, a role table, a role data permission table and a media number table, the user table is used to record the login information of each account, the user role table is used to record the relationship between each account and role, the role table is used to record the permission chain of each role, the role data permission table is used to record the permissions of each role for department-visible data, and the media number table is used to record the relationship between each media number and the department and third-party platform.

[0046] In this embodiment, the user table is used to record the login account, name, login password and mobile phone number; the user role table records the relationship between each account and role, including the account ID and role ID; the role table records the permission chain of each role; the role data permission table records whether each role has the permission to the department visible data, including the department ID and role ID; the media number table records the relationship between each media number and the department and platform, including the media number name, department ID, platform ID and the media number on the third-party platform ID.

[0047] Preferably, the processing of the Internet media number information to be queried according to the user media number relationship table to obtain the authority corresponding to the media number specifically includes:

[0048] The Internet media number information to be queried is judged based on the user table to determine whether the Internet media number information to be queried is recorded in the user table. If so, the corresponding role, role permission chain, department visible data permission of the role, and the relationship between each media number and department and third-party platform are obtained based on the user role table, role table, role data permission table and media number table. Otherwise, the page with no permission to query is returned.

[0049] Preferably, the querying from the manuscript table, the media number total statistics table and the media number increment statistics table according to the authority corresponding to the media number to generate corresponding manuscript information, media number total information and media number increment information specifically includes:

[0050] According to the permissions corresponding to the media account, content production statistics are collected from the media account total statistics table to obtain the distribution volume and publication volume of the account;

[0051] Perform dissemination analysis and statistics from the total number statistics table of the media account according to the corresponding permissions of the media account to obtain the number of readings, likes, shares and comments of the account;

[0052] According to the permissions corresponding to the media account, growth statistics are performed from the media account incremental statistics table to obtain the account's reading growth, like growth, sharing growth, comment growth, user growth, distribution growth, and publication growth;

[0053] According to the authority corresponding to the media number, detailed content statistics are performed from the manuscript table to obtain the specific content of the manuscript of the account.

[0054] In this embodiment, content production statistics are statistics on the distribution volume and publication volume of each account that meets the screening conditions, and support filtering results by department, platform, time period and other conditions. Content production includes data summary and data details. Data summary is based on the platform or department dimension, and the data is presented in the format of a chart. The data details can be viewed within a certain period of time, and the daily data of each account is counted, and batch data export is supported;

[0055] Communication analysis counts the reading volume, likes, shares, and comments of each account that meets the screening conditions. It supports filtering by department, platform, time period, and other conditions. Communication analysis includes data summary and data details. Data summary is based on the platform or department dimension, and the data is presented in the form of a chart. Data can be counted by date trend data and by platform department ranking. Data details refer to the statistics of daily data of each account within a certain period of time, and support batch export of data;

[0056] The content details are statistics of each article in each account. The statistics include the summary of the number of articles published in the three categories of pictures and texts, live broadcasts, and short videos, the number of readings, shares, comments, distributions, and likes of a single article, and display information such as the article content title, source media account, platform, type, release time, etc., and support batch export of content.

[0057] An Internet media account operation data monitoring system, comprising:

[0058] A construction module is used to construct a data table, wherein the data table includes a user media number relationship table, a manuscript table, a media number total statistics table, and a media number increment statistics table;

[0059] An acquisition module is used to acquire the Internet media number information to be queried;

[0060] A processing module, used to process the Internet media number information to be queried according to the user media number relationship table, and obtain the authority corresponding to the media number;

[0061] The query module is used to query from the manuscript table, the media number total statistics table and the media number increment statistics table according to the permissions corresponding to the media number, and generate corresponding manuscript information, media number total information and media number increment information.

[0062] Preferably, the user-media number relationship table includes a user table, a user role table, a role table, a role data permission table and a media number table, the user table is used to record the login information of each account, the user role table is used to record the relationship between each account and role, the role table is used to record the permission chain of each role, the role data permission table is used to record the permissions of each role for department-visible data, and the media number table is used to record the relationship between each media number and the department and third-party platform.

[0063] Preferably, the processing module comprises:

[0064] A judgment module, used to judge the Internet media number information to be queried according to the user table, and judge whether the Internet media number information to be queried is recorded in the user table;

[0065] The execution module is used to obtain the corresponding role, role permission chain, the department visible data permissions owned by the role and the relationship between each media number and department and third-party platform based on the user role table, role table, role data permission table and media number table.

[0066] Preferably, the query module includes:

[0067] A first statistical module is used to perform content production statistics from a media account total statistics table according to the permissions corresponding to the media account, and obtain the distribution volume and publication volume of the account;

[0068] The second statistical module is used to perform dissemination analysis and statistics from the total number statistical table of the media accounts according to the permissions corresponding to the media accounts, and obtain the number of readings, likes, shares and comments of the account;

[0069] The third statistical module is used to perform growth statistics from the media account incremental statistical table according to the permissions corresponding to the media account, and obtain the account's reading growth, like growth, sharing growth, comment growth, user growth, distribution growth, and publication growth;

[0070] The fourth statistical module is used to perform detailed content statistics from the manuscript table according to the authority corresponding to the media number to obtain the specific content of the manuscript of the account.

[0071] A computing device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements any one of the steps of the above-mentioned Internet media account operation data monitoring method when executing the computer program.

[0072] A computer-readable storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, implements the steps of any one of the above-mentioned methods for monitoring the operation data of an Internet media account.

[0073] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for monitoring operation data of an Internet media account, characterized in that: Specifically include: Constructing a data table, wherein the data table includes a user media number relationship table, a manuscript table, a media number total statistics table, and a media number increment statistics table; Obtain the Internet media number information to be queried; Process the Internet media number information to be queried according to the user media number relationship table to obtain the corresponding authority of the media number; According to the authority corresponding to the media number, a query is performed from the manuscript table, the media number total statistics table and the media number increment statistics table to generate corresponding manuscript information, media number total information and media number increment information.

2. According to claim 1, a method for monitoring Internet media account operation data is characterized in that: The user-media number relationship table includes a user table, a user role table, a role table, a role data permission table and a media number table. The user table is used to record the login information of each account, the user role table is used to record the relationship between each account and role, the role table is used to record the permission chain of each role, the role data permission table is used to record the permissions of each role on department-visible data, and the media number table is used to record the relationship between each media number and department and third-party platform.

3. A method for monitoring Internet media account operation data according to claim 2, characterized in that: The processing of the Internet media number information to be queried according to the user media number relationship table to obtain the authority corresponding to the media number specifically includes: The Internet media number information to be queried is judged based on the user table to determine whether the Internet media number information to be queried is recorded in the user table. If so, the corresponding role, role permission chain, department visible data permission of the role, and the relationship between each media number and department and third-party platform are obtained based on the user role table, role table, role data permission table and media number table. Otherwise, the page with no permission to query is returned.

4. A method for monitoring Internet media account operation data according to claim 3, characterized in that: The querying from the manuscript table, the media number total statistics table and the media number increment statistics table according to the authority corresponding to the media number to generate corresponding manuscript information, media number total information and media number increment information specifically includes: According to the permissions corresponding to the media account, content production statistics are collected from the media account total statistics table to obtain the distribution volume and publication volume of the account; Perform dissemination analysis and statistics from the total number statistics table of the media account according to the corresponding permissions of the media account to obtain the number of readings, likes, shares and comments of the account; According to the permissions corresponding to the media account, growth statistics are performed from the media account incremental statistics table to obtain the account's reading growth, like growth, sharing growth, comment growth, user growth, distribution growth, and publication growth; According to the authority corresponding to the media number, detailed content statistics are performed from the manuscript table to obtain the specific content of the manuscript of the account.

5. An Internet media account operation data monitoring system, characterized in that: include: A construction module is used to construct a data table, wherein the data table includes a user media number relationship table, a manuscript table, a media number total statistics table, and a media number increment statistics table; An acquisition module is used to acquire the Internet media number information to be queried; A processing module, used to process the Internet media number information to be queried according to the user media number relationship table, and obtain the authority corresponding to the media number; The query module is used to query from the manuscript table, the media number total statistics table and the media number increment statistics table according to the permissions corresponding to the media number, and generate corresponding manuscript information, media number total information and media number increment information.

6. The Internet media account operation data monitoring system according to claim 5, characterized in that: The user-media number relationship table includes a user table, a user role table, a role table, a role data permission table and a media number table. The user table is used to record the login information of each account, the user role table is used to record the relationship between each account and role, the role table is used to record the permission chain of each role, the role data permission table is used to record the permissions of each role on department-visible data, and the media number table is used to record the relationship between each media number and department and third-party platform.

7. The Internet media account operation data monitoring system according to claim 6, characterized in that: The processing module comprises: A judgment module, used to judge the Internet media number information to be queried according to the user table, and judge whether the Internet media number information to be queried is recorded in the user table; The execution module is used to obtain the corresponding role, role permission chain, the department visible data permissions owned by the role and the relationship between each media number and department and third-party platform based on the user role table, role table, role data permission table and media number table.

8. The Internet media account operation data monitoring system according to claim 7, characterized in that: The query module includes: A first statistical module is used to perform content production statistics from a media account total statistics table according to the permissions corresponding to the media account, and obtain the distribution volume and publication volume of the account; The second statistical module is used to perform dissemination analysis and statistics from the total number statistical table of the media accounts according to the permissions corresponding to the media accounts, and obtain the number of readings, likes, shares and comments of the account; The third statistical module is used to perform growth statistics from the media account incremental statistical table according to the permissions corresponding to the media account, and obtain the account's reading growth, like growth, sharing growth, comment growth, user growth, distribution growth, and publication growth; The fourth statistical module is used to perform detailed content statistics from the manuscript table according to the authority corresponding to the media number to obtain the specific content of the manuscript of the account.

9. A computing device, characterized in that The method comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of any one of the Internet media number operation data monitoring methods in claims 1-4 when executing the computer program.

10. A computer-readable storage medium, characterized in that: The storage medium stores a computer program, which, when executed by a processor, implements the steps of any one of the Internet media account operation data monitoring methods of claims 1-4.