ITC Hotels Fan Distribution

Social Media Reports for ITC Hotels

Social Media Reports for ITC Hotels

Social Media Reports for ITC Hotels,weekly digest. ITC Hotels being one of the top Hotel Brands in India,has many number of fans among Indian consumers.

Four section in the above Power BI report:

  1. FAN/PTAT Distribution
  2. Page Analysis
  3. Post Analysis
  4. User Analysis

Key Metrics:

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.

Social Media Reports for ITC Hotels
Social Media Reports for ITC Hotels

2.Engagement Score

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

3.Engagement Rate

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.

5.Total Tweets,Mentions

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)

Insights Famous Retailer Competition
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

Social Media Reports for ITC Hotels
Social Media Reports for ITC Hotels


Back to



/ by

Post Author: Ruchi