Percentage of Total Engagement by Post Tag Report

You can create a Percentage of Total Engagement by Post Tag report starting from the Post Report page by completing the following steps.

1. Go to Reports > Post.
2. Select the Reporting Date Range.
3. Select Select a Tag from the Post Tags dropdown menu.
4. Click Refresh.
5. Select Posts Combined with Members’ Channels report from the dropdown menu.
6. Click Download to retrieve the CSV report worksheet.
7. In the CSV worksheet, insert a new Post Tag column and add the post tag name to each row.
8. Repeat the steps above for each Post Tag, then combine all the worksheets into one by cutting and pasting
9. From the combined worksheet, insert a Pivot Table.
10. In the Pivot Table Rows region, select Post Tag.
11. In the Pivot Table Values region, select % of Total Sum of Shares, Impressions, Clicks and Reactions.