Social media analytics is the core part of the digital marketing when it comes to measure the RoI.
To bring your work in the lime light is the necessity of every professional to present your work in the best possible way to your clients or boss. How you completed your journey from conception to execution depends on how you sum up everything in your report.
“Bad human communication leaves us less room to grow” Rowan D.Williams
Therefore, pivotTable reporting for Social media analytics has been shared here so that you can present your campaign reports easily for the non-technical audience. Though the data that has been taken for this report is quite small but for the understanding of a pivotTable concept, it will be really helpful.
Download all your data in a raw form any source such as Google Anlaytics, Google Adwords, Facebook ad manager, business intelligence or any CRM software.
Gather all the data at one place, you don’t have to delete any rows and columns as for the pivotTable, it’s all about the game of pick and choose. This will be explained below in detail.
Next step is to create one blank row at the top, and one column on right side in order to differentiate the table from other data (if there is any).
To create the pivotTable, you can use the shortcut key Alt+N+V ; else, you can go to ‘insert‘ option from the ribbon and select PivotTable.
Once you have done this, you will get the option to where you want to place the pivotTable, either on the existing sheet or on a new sheet. Select new sheet and press ok.
Now you are on the pivotTable sheet. You can see a field list on your right side.
Imagine what you want to focus, here we want to see the breakup of gender and their performing results, so put the placements option in the ‘row labels’. The 2nd item that you have to drag is age group so that you can be more specified about the gender.
In the ‘values’ field box, drag the item that you want to evaluate. For instance, we want to see the consumption of the impression and how many likes we got with respect to gender and Age group.
Simply drag the impression and likes in Values field and see the magic.
Now you will see a table having all the information you wanted to see. One thing to keep in mind that most of the time the values appear in ‘count’Double check that your value are showing as SUM not the COUNT, and you can view this from the ‘options’ tab.
You will see these total options at the end of the every column, if you want to keep it so its fine otherwise you can remove it.
To remove these totals, go to design tab and select sub totals> do not show sub totals. This will show the entire grand total at the end of the table instead of each segment.
To arrange the data in proper shape, to show your data in tabular form, so here is the option to present the data in tabular form.
Now, you have your final output ready. now it’s time for icing on the cake, you can go to design tab and select the option branded tab, where you can play around with branded rows, branded columns and with other default provided pivot table style options.
Random Checklist to get accurate data
- In raw data, do not add a line in between the table. By doing this, excel will consider the data only from above the broken line.
- If you have modified the raw data, don’t forget to refresh the pivot table sheet by selecting the OPTIONS tab.
- Don’t forget to delete the grand total coming at the end of row; otherwise, total figure will be reflected in the pivot table.
If you want to ask anything related to the pivotTable reporting, write your comments below or else contact me through email.