Clay to find engagement of influencers’ LinkedIn posts
Google Sheets to compare influencer engagement in a pivot table
Partnering with influencers can significantly boost your brand reach on LinkedIn.
However, filtering the signal from the noise can be challenging. Vanity metrics like follower count don’t tell the full story. It’s far more useful to understand the actual engagement (reactions and comments) influencers generate on their posts.
In this Claybook, I’ll show you how to analyze influencer post engagement on LinkedIn to make smarter, more informed decisions.
What you can do with this Claybook:
- Add LinkedIn profiles of your influencers and see their most recent posts
- Sync that data to Google Sheets to analyze that information in more detail
- Compare the performance of each influencer to optimize your agreements
Steps
Step 1:
Copy this template
First, duplicate the template to add your influencers.
Step 2:
Add influencers LinkedIn profiles
Paste influencer LinkedIn profiles into the first column.
You’ll see details automatically enriched in Clay, such as number of followers, their recent posts, and average engagement per post.
Next, we’ll write each post into a new row on another table. We'll add your API key to enable this functionality.
Step 3:
Copy the posts template
Next, copy the posts template to your workspace.
Go back to the original table and select this new template from the dropdown. This will link the two Clay tables together.
Step 4:
Map columns between both tables
Now you’ll map the columns between the Influencers table and the Posts table.
Click the Play button after they’re mapped and watch the magic happen in Clay. 🪄
Now when you add a LinkedIn profile into the Influencer table, their most recent LinkedIn posts will automatically populate in the posts table.
Step 5:
Sync to Google Sheets
Finally, make a copy of this Google Sheet into your Google Drive account.
Copy the URL and paste into Clay. Then authorize your Google account.
Map your columns to the Google Sheet and your data will flow automatically into the pivot table for custom analysis.
Copy the template
Copy this template to analyze engagement from influencers automatically using Clay and Google Sheets.
Need help?
Ask for help in Slack or schedule time with a Clay expert.
I'm also personally available to help troubleshoot. You can send me, Scott Tousley, a message on LinkedIn.
Clay connects you with 75+ data providers
Learn with our resources
Check out Clay University, read our GTM blog, or try out our top templates to transform your growth ideas into outreach in minutes.
Clay University
Master Clay in a few core lessons. Uplevel your data enrichment, craft better outbound messages, and book more meetings.
Go-to-market blog
Our best content on growing your GTM motion, from outbound sales automation to AI lead generation.
Integrations
Browse through all the integrations you can connect to Clay in seconds and discover what you can do!
Clay Experts
Hire a Clay Enterprise expert or find a Clay partner to help with your next project.
Clay’s Chrome Extension
Clay’s Chrome Extension makes it wicked easy to find leads almost anywhere on the internet.