Re: Can Airtable pull social media engagement metrics?
Accepted Solutions
Hi @Plyke ,
(the Watch module does not fire because it gets triggered only once after the record gets created or in case of a view once the date selected is after the date, that Airtable used to check the view last time.)
I would do it a tad different though. I would use Search Records and dedicated view, since you will want to check the results over multiple days.
1) In my base I have a view for which pieces of content should be checked:
2) The scenario checks all records in that view and retrieves stats for each
Make sure you are using proper Post ID in format that will look like this urn:li:share:7025685928614510592
3) Finally since I want to have overview of how the reach changes over multiple days, I have a separate table for that:
That means that the last module, creates new records in Results table:
This way you can also get the stats on the Content table by using Roll-up getting the Max() value from the results history for given post.
I hope that helps, also thank you for motivation for me to start finally adding the stats to my own social media calendar 🤣
Your channel is great, I've subbed!
If I can ask for a brief hand here @Greg_F , I'm trying to setup Airtable and Make such that when I make a new post on LinkedIn, the URN is shared to Make, then Make takes that URN and runs a LinkedIn module which gets the statistics of the shares for the new post, then populates the data into an Airtable record (likes, impressions, etc...)
That's the ideal workflow but I'm struggling to piece it together, here's what I've got right now: I've got an event trigger for when a new record is created in Airtable, which then watches the "Link" column, which contains the URL of the LinkedIn post. Then I tried to get LinkedIn to take the data from that link and then create a new record in Airtable to plug the data into. I've got screenshots of this below. When I run this, nothing happens hahaha.
I know I can grab the shared statistics of specific LinkedIn posts through the LinkedIn module but what I want is a way for Make to automatically grab the data from the new posts.
Hi @Plyke ,
(the Watch module does not fire because it gets triggered only once after the record gets created or in case of a view once the date selected is after the date, that Airtable used to check the view last time.)
I would do it a tad different though. I would use Search Records and dedicated view, since you will want to check the results over multiple days.
1) In my base I have a view for which pieces of content should be checked:
2) The scenario checks all records in that view and retrieves stats for each
Make sure you are using proper Post ID in format that will look like this urn:li:share:7025685928614510592
3) Finally since I want to have overview of how the reach changes over multiple days, I have a separate table for that:
That means that the last module, creates new records in Results table:
This way you can also get the stats on the Content table by using Roll-up getting the Max() value from the results history for given post.
I hope that helps, also thank you for motivation for me to start finally adding the stats to my own social media calendar 🤣
This is perfect @Greg_F . The only issue I'm having now is that I'm getting this error, "The operation failed with an error. 400: Array parameter 'shares' value 'urn:li:activity:7006102683132538880' is invalid. Reason: Deserializing output 'urn:li:activity:7006102683132538880' failed"
I suspect that this is because mine reads, urn:li:activity instead of urn:li:share. When I change the URL to urn:li:share no post gets displayed. I also tried mapping it to the UGC section but that didn't work either.
I get the activity tag when I copy the link from LinkedIn on my desktop so I tried on my phone and on a friend's device and still no luck. Any ideas? 😅
