My client is a leading digital/social media agency with blue-chip Australian consumer brands with active Facebook presences.
There are approximately 25 clients each month require a report summarising their social media activity. This is largely drawn from exported Facebook Insights & Advertising excel files which you will be provided with.
Also attached will be a Facebook macro spreadsheet similar to Analytics Edge Facebook connector. This macro will then convert the Facebook Insights data to You can see explanation of this spreadsheet at below link and also attached in the excel file.
A powerpoint or keynote template file will be provided and there will be 11 tables, graphs or charts listed below to enter in the powerpoint, which once completed will be sent back.
Excel Tables x 3
i. Page Analytics Table
ii. Post Analytics Table: Number & Reach of Posts; Engaged Users & Rate; Likes, Comments
iii. Top Posts: Rate top 5 posts...