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.
Not sure that I have the full context, but it could be as simple as adding a column to identify the week.
Could you share a copy of the doc, with examples of the charts you want to see. (Anonymized is good.)
After a quick search I was not able to find how to share an anonymized doc. I feel like this is super basic but I’ve yet to share an anonymous doc.
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.?
Yes, I collect analytics every 7 days by scrolling profile impression info.
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.
Would Packs be helpful for your use-case?
Should I leave “set values” alone?
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.
Thank you Brian!!! The tik tok table is looking great and the button is a nice addition. Now I have to tackle the instagram tables.
Looks great! Love the charts!
Thanks, I’m always open to suggestions in case you would display this info in any other way.
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.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.