Loom folder-level stats are available in CSV format via "Export Insights". Now I just need my Twitch stats also, Loom has folder-level stat exports. Perhaps it will serve as inspiration to actually post things. Use automations to create linked records between tables so that Rollups can do math for you.Īnd 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. This gets calculated for every record automagically.Īn automation copies that value and pastes it into a linked record field to the Report table. Put it all together! I wrote a little formula that trims the tweet/post date down to YYYY-MM.
AIRTABLE REPORTING DASHBOARD UPDATE
Play: Using Airtable as an Analytics Hub: LinkedIn with Web Clipper & Automations - Update Post Stats Here's a brief video illustrating this process and how I have configured my automation. Tada, you have personal LinkedIn post stats! 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. So we need to use a "Created Time" in Airtable or input the date manually for our record keeping. Why a source record? Because LinkedIn doesn't list the post date on the post. When you do remember, clip it again! And use an automation to update the source record. Play: Using Airtable as an Analytics Hub: LinkedIn Web Clipper - New Post See this quick video (it has no audio) of how the web clipper works.
Configure your web clipper to snatch the stats from a LinkedIn post. Unless the posts are on a company page you manage, your stats are stuck on the actual post.Īirtable'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. Use a table to aggregate daily Twitter stats. Use the CSV app to add your Twitter stat exports.
I add a CSV app for each one so that I don't have to remap the columns every time. Upload to the respective table with the CSV Import app. I started with tweets and LinkedIn posts.ĭownload 2 (or 4 if you post videos) CSVs from the analytics page in monthly intervals.
AIRTABLE REPORTING DASHBOARD SERIES
One table aggregates the various network stats from a series of other tables. I can't for the life of me seem to find anyone having a template or having written about one. but it's cool! And built with Airtable of course. Hello, I'm wanting to take the timesheets we built out in airtable and create a dashboard in the Interface Designer for each member of the team so they can see an overview of their time, over under etc. The Report table aggregates info from all the other tables.
0 kommentar(er)
