How many new fans were added yesterday? What is the age group of the fans? How many people read and retweeted yesterday's content? These commonplace data indicators often "harass" me but also indispensable, especially when a company operating several accounts at the same time, then the weekly report will waste a lot of time, the effect is very low, overtime has become the norm. A few days ago with a friend to do new media operations chat, she told me about their own "miserable experience": she worked in a public relations company, specifically responsible for the company's several microblogging number and a few customers microblogging number, in addition to every day need to rack their brains to think about the release of the contents of the weekly data, the most painful thing for her than! The weekly report.

1, you need to summarize the data situation of each microblog;

2, you need to summarize the microblog data situation of different customers, some customers only have one microblog, while some customers have more than one.

3, need to put all the microblogging data situation to summarize and organize;

The same content but need to be repeated many times to produce, every Friday to work overtime to put these reports to organize, so that she had a headache. So I suggested that she use tools to accomplish this, and recommended BDP to her, which worked pretty well, and she decided to share the process of making it.

1, all the data in the background of the microblogging can be seen, the first step we need to do is to export all the data: log in to the microblogging account, enter the management center, in turn, the data will be exported to a fixed folder, Using BDP's local synchronization function, the microblogging background of the future data updates, the file data here will also be automatically updated, and that corresponding to the analysis of the chart data will also be automatically updated. The data from the analyzer charts will also be updated automatically, which is a great feature. The newest feature is the ability to synchronize your data with the Internet, which can be used for any number of different purposes, but it is also a great way for you to get the most out of your data!

2, and then log in to the data tool, in the "worksheet" category, select the upload data (you can support batch upload Oh, a maximum of 5 excel/csv table).

3, after uploading the data, we need to process the data, which is simply to merge similar items. For example, I uploaded two microblogging data to the tool, so there are two tables, I need to merge the same type into one table, before merging, you need to distinguish between different microblogging names, that is, in the original table, add a new text field called "microblogging name", the button can be found in the upper right corner.

After adding the names of the tweets, you can append the table (i.e., merge similar items). Click Create Merge Table to select the Append Merge function, and merge tables with the same name into one table, and you're done with all the data.

4, finally, just in accordance with the way you need to present the data on it. It should be noted that the tool can realize the global filter, if I only want to see the data of a microblogging, the global filter (in the upper right corner of the dashboard Oh ~) this function is very appropriate ~

After this treatment, you want to see the data of which microblogging just need to make a choice in the filter, and all the data of the charts will be changed!