Using Airtable as an Analytics Hub
By Melanie E Magdalena Tagged: analytics, airtable 2 min read
How I built my analytics dashboard with Airtable for Twitter, LinkedIn, and more.
Why? I honestly don't know (yet)... but it's cool! And built with Airtable of course.
One table aggregates the various network stats from a series of other tables. I started with tweets and LinkedIn posts.
Twitter is the easy one.
Download 2 (or 4 if you post videos) CSVs from the analytics page in monthly intervals. Upload to the respective table with the CSV Import app. I add a CSV app for each one so that I don't have to remap the columns every time.
LinkedIn is tricksy. Unless the posts are on a company page you manage, your stats are stuck on the actual post...
Airtable's web clipper can speed this up! When you post, clip the thing so you can pull your stats whenever you remember to go do that.
See this quick video (it has no audio) of how the web clipper works.
When you do remember, clip it again! And use an automation to update the source record.
Why a source record? Because LinkedIn doesn't list the post date on the post. So we need to use a "Created Time" in Airtable or input the date manually for our record keeping.
Regardless of which post date system you decide is less of a headache, an automation will track down the original record and plug in the new clipped stats.
Tada, you have personal LinkedIn post stats!
Here's a brief video illustrating this process and how I have configured my automation.
Put it all together! I wrote a little formula that trims the tweet/post date down to YYYY-MM. This gets calculated for every record automagically.
An automation copies that value and pastes it into a linked record field to the Report table.
And that's it! Now I have a ridiculous amount of views to see all my nifty numbers to really rub in how infrequently I actually post things on the internet. Perhaps it will serve as inspiration to actually post things... we shall see.
Now I just need my Twitch stats; also, Loom has folder-level stat exports...
Thanks for reading! If this helped or you learned something, Buy Me A Coffee.