Social Media Analytics Template

Log post-level reach, engagement and conversions per channel and roll them up into follower and engagement trends.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Marketing

Tables

Channels, Posts

Fields

27

Views

grid, dashboard, calendar

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Channels

12 fields · 4 sample rows

  • Channels (Grid)
  • Channel report (Dashboard)
ChannelTextHandleTextProfile URLURLFollowersNumberFollower GoalNumberGoal ProgressFormulaPostsLink to another tablePost CountCountTotal ReachRollupTotal EngagementsRollupAvg Engagement RateRollupConversionsRollup
Instagram@brewhouse.inhttps://instagram.com/brewhouse.in48,20060,00080%Latte art in 30 seconds, New single-origin: Chikmagalur, Behind the roastery31,19,00010,0506.3%104
LinkedInBrewhouse Coffeehttps://linkedin.com/company/brewhouse9,10012,00076%We’re hiring baristas in Pune115,5008785.7%0
YouTube@BrewhouseCoffeehttps://youtube.com/@BrewhouseCoffee15,60025,00062%Founder story: from farm to cup138,0003,4509.1%23
X@brewhousehttps://x.com/brewhouse5,3006,00088%Cold brew giveaway112,0001,0708.9%9
Field details
Channel · Text
Handle · Text
Profile URL · URL
Followers · Number
Follower Goal · Number
Goal Progress · Formula
IF({Follower Goal}, {Followers} / {Follower Goal}, BLANK())
Posts · Link to another table
Links to Posts
Post Count · Count
Total Reach · Rollup
sum of Reach via Posts
Total Engagements · Rollup
sum of Engagements via Posts
Avg Engagement Rate · Rollup
avg of Engagement Rate via Posts
Conversions · Rollup
sum of Conversions via Posts

Posts

15 fields · 6 sample rows

  • All posts (Grid)
  • Calendar (Calendar)
  • Post performance (Dashboard)
PostTextChannelLink to another tablePosted OnDateFormatSingle selectImpressionsNumberReachNumberLikesNumberCommentsNumberSharesNumberSavesNumberLink ClicksNumberConversionsNumberEngagementsFormulaEngagement RateFormulaPost URLURL
Latte art in 30 secondsInstagram7 Nov 2026Reel / short98,00072,0005,400210640980320417,23010.0%
New single-origin: ChikmagalurInstagram13 Nov 2026Carousel41,00033,0002,10095120410280562,7258.3%
We’re hiring baristas in PuneLinkedIn10 Nov 2026Image22,00015,5006408815005408785.7%
Founder story: from farm to cupYouTube30 Oct 2026Video61,00038,0002,9003402100190233,4509.1%
Cold brew giveawayX16 Nov 2026Text18,00012,000430260380015091,0708.9%
Behind the roasteryInstagram18 Nov 2026Story15,00014,000035600957950.7%
Field details
Post · Text
Channel · Link to another table
Links to Channels
Posted On · Date
Format · Single select
Reel / short, Carousel, Image, Video, Text, Story, Live
Impressions · Number
Reach · Number
Likes · Number
Comments · Number
Shares · Number
Saves · Number
Link Clicks · Number
Conversions · Number
Engagements · Formula
{Likes} + {Comments} + {Shares} + {Saves}
Engagement Rate · Formula
IF({Reach}, {Engagements} / {Reach}, BLANK())
Post URL · URL

Social Media Analytics Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates