Marketing Agency Clay Table- Customize on latest posts
If you are running a marketing agency and on the lookout for new clients, try this custom workflow I built in Clay to help find high level execs and filter based on activity on LinkedIn. You can use this workflow to personalize your subject lines
Here’s how we did it:
Firmographic targeting: We started by narrowing our search based on company size, location, industry, and job title. These are essential filters when you're building an Ideal Customer Profile (ICP) for B2B campaigns.
Once we had a qualified lead list, we built custom agents using features built right into Clay.
Using Clay’s LinkedIn Post Finder, we pulled the most recent posts from each target’s LinkedIn account. You can also do this for the company.
We then used custom agents to:
Summarize the post and use it as an icebreaker for cold email
Analyse how long it had been since they last posted. This gave us helpful LinkedIn engagement insights
We filtered for people who hadn’t posted in several months but still had a post history. That signal of being previously active helped us find qualified prospects who would be more likely to engage with a personalized message.
We used that information to craft outreach messages that landed. The response rates were excellent.
This same Clay automation workflow is now being used across several client campaigns and continues to perform well.
The key to making it work was breaking the message into three parts:
A personalized opener summarizing their latest post
A reference to the time since their last LinkedIn activity
A relevant offer tailored to their role or industry
This structure keeps the message tight and avoids common errors that happen when everything is jammed into one chunk.
I think a lot of this custom prompting in Clay will eventually be replaced as multi-agent platforms (MCPs) mature. They’ll handle multiple tasks with one agent. But right now, you still need to be intentional with your prompts to get the best results.
If you want the entire Clay table template or want to run a manual LinkedIn campaign to review prospect post history, feel free to DM me or drop a comment. We can take a look together.
Here are the prompts if you want rebuild this for your Clay LinkedIn outreach workflow I along with a link to the Template: