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 →