How to Quickly Create Quality Social Media Reports

The end of month may become a nightmare for an SM marketer, because they need to prepare a detailed and neat report on the work done. This job can be simplified and optimized to spend less time and have no worries.

Social Media Report Contents and Structure

The report is needed not to scary the client or manager by tables with unclear figures, but to summarize the work and illustrate the results for an outsider.
A good SMM report is to be easily readable even by a person who doesn’t know the project’s essence and is new to the subject.

Before gathering data, decide what information you want to reflect in the Social Media report and what to emphasize.

Analyze Community Promotion

Results of targeted advertising and seeding will be likely to be of prime interest to the client, as they need to know how effective the ad costs are.

The promotion results for most of ad campaigns can be seen in two places:

  1. Social media’s ad dashboard.
  2. Analytical tools, Google Analytics or Yandex Metrica.

To compare the data, you’ll have to work in Excel, unless you pre-set collection of statistics from systems inside the analytical system.

Facebook

Facebook allows setting up automatic report generation and exporting data when necessary or analyzing them online.

How to create social media report on Facebook

Here you can set the appearance of your Social Media report: select metrics (all the ad data to be collected by Facebook) and breakdown. The report can be saved or exported.

An example of a SMM report on Facebook

Facebook and Instagram

Using Facebook’s Ads Manager, you can set up a report and regularly export it, updating only dates.
To do that, open Reporting section, set the required columns, select the companies and save the report.
To download the Social Media report, click Export.

VK

VK’s targeted ad statistics is collected in Export Statistics section of the ad dashboard:

Fast way of creating social media report on Vk

The Ads field is to set the type of statistics to export: 
1. All ads.
Export information on the budget spent, view count, click count, CTR.
2. Posts in communities.
Effectiveness of posts: total reach, subscriber reach, budget spent, group view and join counts, click-through count, complaints, hides, entire group hides.

Choose the parameters you need:

  • Ad dashboard for the client of interest.
  • Reporting period and dates.
  • Format (view in browser or download Excel spreadsheet).

MyTarget

Two types of statistics are available: normal statistics and Report Builder.

Example of report in graphical form in Mytarget

Ad effectiveness can be analyzed in a normal report. Select the metrics you need from Column Settings section. The result is exported to Excel.

Some options in Mytarget social media report

Report Wizard shows demographic data of the audience who engaged with the ads.

Additional options in Mytarget SMM report

 

Content Analysis

Evaluating the content is more difficult, since performance indicators are not obvious. SMM measures:

  • Subscriber count.
  • Post reach.
  • View count for a particular post.
  • ER (engagement rate).

In addition, post count or contest participation may be a separate KPI.

Social Media’s Internal Statistics

Part of this information can be found in social media’s internal statistics. For example, detailed statistics for a Fb group provides information for every post:

Sample statistics of group postings on Facebook

Using the Facebook Analytics tool, you can also analyze the audience’s interests and demography.

One drawback of systems’ internal statistics is that it takes time to compile all the exported data in a legible report.

Social Media Content Analysis Using Popsters

If you don’t have time for that work, Popsters analytical tool will help you out. You can use the tool to generate an Social Media report in five minutes:

  1. Paste the community URL to the search box and specify the reporting period in dates.
  2. To the right below the group’s avatar, you’ll see Table pushbutton. It summarizes statistics over the period for the number of posts, likes, shares, comments, as well as calculated ER.
  3. To export all the published posts, click X. You will get a document with the texts and links to media files of all the released posts.

How to do a social media content analysis