Agency growth
Pitch e-commerce clients with the audit already done
For Web design, development and CRO agencies
The problem
Agency outreach fails because it is generic. "We build great e-commerce sites" is indistinguishable from every other agency email. What converts is arriving with a specific, verifiable problem the prospect did not know they had.
How the data solves it
Filter for shops with measured defects. A mobile Lighthouse score under 40, a failing Core Web Vitals verdict, missing meta descriptions across the catalogue, or no structured data at all. Now your first line is a finding, not a claim about yourself.
The filter set this maps to
Every field below exists in the shop schema. This is the query, not an illustration.
- Performance (Mobile)
- < 40
- CrUX Verdict
- poor
- SEO completeness %
- < 60
- Products
- > 100 (revenue to justify the fee)
Build it
Four steps to this list
Every column named here exists in the schema, and the request below runs as written.
- 1Set lh_perf <= 40 to find shops failing the mobile Lighthouse score.
- 2Add crux_verdict = poor for shops failing Core Web Vitals with real users.
- 3Add products >= 100 so there is revenue to justify your fee.
- 4Export with seo_completeness and meta_desc_length so the audit is in the CSV.
The same query through the API
POST this to /api/v1/search for a count, or /api/v1/rows for the shops themselves.
{
"filters": [
{
"kind": "numeric",
"col": "lh_perf",
"op": "lte",
"max": 40
},
{
"kind": "dropdown",
"col": "crux_verdict",
"values": [
"poor"
]
},
{
"kind": "numeric",
"col": "products",
"op": "gte",
"min": 100
}
]
}Playbook
What to do once you have the list
A list is not a campaign. These are the three things that decide whether it converts.
Open with the number, not the offer
"Your mobile score is 34 and your LCP is 4.8 seconds" outperforms any description of your agency. It is checkable in ten seconds, which is what makes it credible.
Attach the evidence
Export the performance and SEO columns and paste the row into the email. You have done the audit before the first call.
Filter by country and language
Match prospects to the markets you can actually service, so you are not pitching in a language your team does not write.
Outcome
What you end up with
Prospect lists where every account has a named, measured problem
Opening lines built on real numbers rather than flattery
Segments sized to your retainer: catalogue size proxies for budget
Questions
Agencies: frequently asked
Is the performance data real, or estimated?
It is measured. Lighthouse scores come from Google PageSpeed Insights runs against the shop, and the Core Web Vitals figures are field data from the Chrome UX Report: real Chrome users, not a simulation. Roughly 940,000 shops carry measured scores.
Can I filter for shops missing structured data?
Yes. The JSON-LD types field records the structured-data types detected on the storefront, so you can find shops with none at all: a concrete, demonstrable SEO gap.
How do I size a prospect before I pitch them?
Catalogue size is the most reliable proxy available without private data. Product count, collections and shop categories together tell you whether this is a side project or a merchandising operation, and domain age tells you how long it has been trading. A shop with 2,000 products on an eight-year-old domain is a different conversation from one with 15 products registered last spring.
Every shop I find is slow. Which do I contact first?
Sort by the gap between the defect and the size of the business, not by the defect alone. A 30-product shop with a mobile score of 28 has a problem it cannot afford to fix. A 3,000-product shop with the same score is losing real money daily. Order by product count inside your performance filter and work down.
Can I avoid pitching shops another agency has just rebuilt?
Partly, and the limit is worth stating. Theme and installed apps show what the storefront runs today, so a recently rebuilt shop on a current premium theme with a full app stack usually looks different from a neglected one. What the data cannot tell you is who did the work, or when their contract ends.
Start finding better e-commerce leads today
Free trial with the full dataset and every filter, and the allowance resets daily rather than expiring.