Each week I collect social media metrics from Instagram and Tiktok and share them with my department. I’ve been doing this for 2 months and I’m certain I’m doing it in the worst way possible. To date I’ve been creating new tables for each week then displaying them as charts. They look nice but they are not aggregating to a main table and I can’t display them in a way that allows the CEO to see week over week, month over month progress.
Is there a way I can inject numbers each week and then display them in a way that would be beneficial to show grown or regression over time? Btw, I’m ok with manually entering the stats.
Hey Dustin, happy to help out here; I’m the social media manager at Coda and do quite a bit of this.
Are you collecting daily data every week, or weekly data (last 7 days-ish)? Is your method to scroll through the profile analytics and logging information like impressions, engagement stats, etc.?
The way I generally do this is with a button like below. You can set it up to where it’ll log the date of data capture, and you can set that to a consistent week date with today() - today().weekday + 2 (for the Monday of the week).
Happy to share more if you think it’ll be helpful!
Interesting…this leads me to believe I have my Instagram table configured all wrong. Below is the table I’ve been recreating for which mirror the analytics they provide.
I believe your suggestion would work with the table I use for TikTok since it consists of one row per week, again this formatting was guided by the metrics they provide.
To @Piet_Strydom’s earlier point, I think you can actually have different rows for different content types, just add the week column.
I’m doing it similarly, but I’m just splitting Stories and Posts into two separate tables; I am usually reporting monthly so it’s fairly easy to find all ‘July’ posts and stories.
Regarding Packs, are you asking if it would be helpful being piped into each platform in order to pull metrics? If that is the case, I think it would be more of a want rather than a need. As it stands the manual entry only takes me a few minutes, I’m more concerned about adding the context of time to our numbers.
Yep, leave set values alone. But hit the toggle on “Open row for editing.” It’ll activate the row and let you enter info for all the columns at one time.
I was thinking about this… because you have interactions combined with # of posts, it’s a bit more complex. You could definitely do a stacked area chart for all of the interactions metrics, or a line chart. That might make it easier to read as growth of a certain metric over time.
The posts is the outlier; the way I generally do this is to create a view, show only post count, and drop it under the other chart with the same time series.
