What goes in a local SEO report

Per location: organic rank for 5-10 branded queries · local-pack rank · review count + average rating · Google Business Profile completeness.

The template

Set up 3 Livescraper schedules: SERP runs (Mondays 09:00), Reviews scrape (Mondays 09:30), Maps refresh (Mondays 10:00). Each writes to a Google Sheet. Looker Studio reads from the sheet directly.

Auto-emailed report

Looker Studio → Schedule email delivery → every Monday at noon. Clients get a branded PDF without you opening Excel.

Cost

~50 queries × ~5 cities × 4 weeks = 1,000 SERP rows = $5/month. + Reviews ~ $2/month. ~$7/month per client report. Bill at $200. Agency playbook →

Try it free

500 free rows every month, no credit card. Same data described in this article.

Start free