Turn Web Traffic into Sales Signals — Without Leaving Google Sheets

You’ve got a list of prospects… but are they actually active?
Is their site getting real traffic — or is it just a static brochure?
Should you reach out — or move on?

With Similarweb Insight inside Derrick App, you instantly detect signs of life (or weakness) from any website — directly in your Google Sheet.
No extension. No code. No Similarweb API key required.

🔍 Feature used in this playbook

• Similarweb Insight — Enriches each domain with traffic metrics, rankings, acquisition channels & more
• Sheets Native — Automatically adds data next to your URLs inside Google Sheets

→ Try Derrick for free →

💡 What Derrick auto-generates

Derrick automatically enriches each row with the following columns:

• siteName — domain name
• siteTitle — Similarweb page title
• siteDescription — site’s meta description
• globalRank, countryRank, categoryRank — global, country, and industry rankings
• category — industry classification (Similarweb)
• monthlyVisits — estimated total traffic
• bounceRate — bounce rate
• pagesPerVisit — average pages per visit
• timeOnSite — average visit duration
• directTraffic, searchTraffic, socialTraffic, referralTraffic — traffic source breakdown
• topCountries — main countries by traffic share
• topKeywords — top organic & paid search keywords
• similarweb_status — shows if enrichment succeeded (useful for filtering errors)

🎯 Use Case #1: Prioritize high-traffic, high-engagement sites

Easily find top leads by filtering:

• monthlyVisits > 10,000
• bounceRate < 40%
• pagesPerVisit > 3

This gives you a shortlist of companies with an active, engaging website — likely in growth mode.

🆘 Use Case #2: Spot struggling websites

Running a Growth or SEO agency?
Use traffic trends or spot high traffic with low timeOnSite to find poorly optimized but high-potential websites.

Prospecting prompt:

“I saw your site gets an estimated 50k monthly visits — but average session time is quite low. We help B2B companies turn that traffic into revenue through better content & structure. Want to chat?”

🚀 Tips to get the most from Similarweb Insight

✅ Filter by category to create industry-specific campaigns
✅ Combine with LinkedIn enrichment to add context to the persona
✅ Use topKeywords to match your cold emails to their audience language
✅ Sort by countryRank to find local leaders
✅ Create alerts when traffic drops — and offer a free audit

🎬 In Summary

✅ No code
✅ Fully in Google Sheets
✅ Works out of the box, right now

With Similarweb Insight, you go from guessing to data-driven prospecting — in seconds.

👉 Try Derrick App for free today →