Social Media Report for Airtel
Social Media Report for Airtel,weekly digest. Airtel being one of the top Telecom Brands in India,has many number of fans among Indian consumers.
Four section in the above Power BI report:
- FAN/PTAT Distribution
- Page Analysis
- Post Analysis
- User Analysis
Engagement = Likes + Shares +Comments
Total Fans = Total number of fans
Total PTAT = All Stories +Activities in the page
Following are some detailed note on Metrics and examples:
1.Total Page fans:
Facebook fans are analysed with the help of Graph API and using Insights we can drive at metrics like total fans.
Engagement score is defined as Like+share+comment for given post on a given time frame.Calculating the likes and comments are little tricky as facebook does not provide any direct ways to do so.Hence one should use looping query to get the fact properly
Engagement rate is defined as Like+Share+Comment for given post and its tracked as % of overall posts on given time period.
4.PTAT : People Talking About That
This metric is quite confusing as it takes in account of any activity which includes sharing the page,any share in other networks,mentions etc.
This metric is derived using Twitter API and widely used as measure to find number of tweets,mentions and Retweets
6.Sample of the Summary Reports(Benchmark Example)
|Distribution of fans||Most of the fans are from X Region
Very less number of fans about 3k
|Most of the fans are from Y Region
300k+ fan base.
|Growth of fans||Average growth of fans for April 2013.
But is low compared to competitor.
|Good growth of fans for April 2013|
|Engagement distribution||Though photos are powerful mode, there is a need to entertain users by different types of posts such as links, votes, ,promotions ,status, video etc.||Is aggressive in engaging more with fans.|
|Engagement rate with fans||Engagement rate very low (0.03%) compared to industry standard.
Average engagement rate can be improved by devising various methods – offers, discounts, coupons etc.
|Engagement rate with fans quite high close to 4% of the Industry standard.|
|Collaboration||Insight on users indicates that Retailer representative / admin collaborates well with users – providing responses, comments, Q&A etc. Also user interactivity between the users is average||Quite the same.|
7.Top Influencer reports