Old one but a good one that I've not shared before. Probably my highest response rate campaign ever. Very small numbers - super personalised and tailored targeting MSSP partnerships for a cyber SaaS company. 24% response rate average - and 10% booking rate to meetings. This was enriched in Clay + some custom scripts and human validation in sheets then run out of Apollo with custom fields. The client had previously run cold email en-masse and had a response rate of less than 0.1%. The campaign had to get paused multiple times as a new team was built around this.
Could you share more about what went into the campaign design?
Its pretty difficult to find MSSPs - there's no company category or SIC code. So the first step was a massive SERP scrape, then enrich. The next was to verify that they were in fact a MSSP - custom script to crawl and check the site (google apps script in sheets) Next - claygent to pull "focus area" of the MSSP - e.g. public sector, healthcare, legal etc For contacts - finding the most senior with the right persona. Enriching their city and the company HQ city. The offer had to get worked to be of value to them. In this case the client had a lot of low quality/smb enquiries that they didn't have the bandwidth for. The assumption was that the MSSP would be interested. So instead of framing it as a partnership, the framing was needing help with serving a <match enquiry location with either contact/hq location> <match focus area> SMB - and if interested maybe there could be a partnership. Extensive cleanup and validation before running. Very short, sweet and human. Sent from a c-suite contact matching the persona of the recipient so its peer-to-peer with colloquial language.
Can you explain more about the Google apps script part? You wrote a script that crawls the website in order to just verify whether the company is MSSP, do I get that right?
Daniel K. yep - was run in Apollo
Georgi B. yep, it would have been insane on credits to check all the results - so used google sheets to fetch pages and match keywords - to quickly prune down the list
That is awesome - interesting use case of google scripts to use the free script to save on credits. Love that as a use case, gonna have to try that
Indeed, as the MSPs have very specific keywords to detect. Smart move!
are there any other use cases youβve found that google scripts is better, or more cost saving to utilizing instead of a claygent. Of course it has itβs place and time, just curious if you have any other specific cases itβs worked well for!?
Anytime you're doing something simple that can be determined from a homepage / have a very large dataset - much better. I typically just have chatgpt write the appscript (not a developer) and iterate till it does what I need. For this project I had 3 functions - fetch page/check if MSP/MSSP by keyword. For undeterminable, I had Groc/llama3 check. Also did a contact pull with Apollo with a batch delay due to api limitations (clay doesn't do this at the mo). Used clay to fill the gaps. Dataset was huge. Doing all of this in clay would've cost probably a couple hundred thousand credits.
here's a quick sheets script if you want to play with ai in google sheets for small bits and bobs. Just needs a free key from https://console.groq.com/playground usage: =ai("prompt",CELL,"prompt") etc. Has its limitations but a fun little exercise.
the above runs into rate limits, so a neat way to learn is to feed the script to gpt + ask to add batch functionality etc