Skip to content
Logom2creates

Using Airtable as an Analytics Hub

  • 2 min read

Uses: Airtable

How I built my analytics dashboard with Airtable for Twitter, LinkedIn, and more.

Airtable Hub reports view
The Report table aggregates info from all the other tables.

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.

Airtable Hub and CSVs from Twitter
Use the CSV app to add your Twitter stat exports.
Airtable Hub Tweets
Use a table for every Tweet.
Airtable Hub Twitter aggregation
Use a table to aggregate daily Twitter stats.

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.

Airtable Hub web clipper for LinkedIn
Configure your web clipper to snatch the stats from a LinkedIn post.

See this quick video (it has no audio) of how the web clipper works.

Watch on YouTube

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.

Watch on YouTube

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.

Automate linked records
Use automations to create linked records between tables so that Rollups can do math for you.

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...

Loom folder-level stats
Loom folder-level stats are available in CSV format via "Export Insights".

Tags: analytics dashboard

Thanks for reading! If this helped or you learned something, Buy Me A Coffee.