Best Practices

Recommended setup

Use verified locations only

Only verified locations will export data. If you're adding new locations, verify them in Google Business Profile first. This prevents failed runs and missing data.

Split high-volume flows

If you manage 100+ locations, create separate data flows by location group (e.g., North region, South region) or limit each flow to 50 locations. This prevents timeouts and rate-limiting.

Match report type to your use case

Use Daily metrics for performance trends, Search keywords for SEO insights, and Reviews for sentiment. Don't pull all three if you only need one—it uses unnecessary API quota.

Data refresh and scheduling

Schedule after 2 AM PT

GBP metrics finalize after ~2 AM PT each day. Schedule your refreshes for 3–4 AM PT to ensure you're pulling complete, finalized data. Morning runs (before 2 AM) will have incomplete metrics.

Stagger multiple flows

If you have multiple GBP data flows, space them out by 10–15 minutes. Running them all at once can trigger Google's rate limits. Example: 3:00 AM, 3:15 AM, 3:30 AM.

Use date macros for consistency

Instead of manual date ranges, use macros like `{{yesterday}}` or `{{30daysago}}` for daily or rolling metrics. This keeps your data consistent and reduces the risk of accidentally pulling the same date twice.

Performance optimization

Narrow your date range

Pulling 90 days of data is slower than 30 days. Use the minimum date range you need. For weekly reports, pull just 7 days at a time rather than monthly.

Reviews: pull in separate flows if at scale

Reviews queries are data-heavy. If you have 50+ locations with thousands of reviews, reviews often timeout. Create a dedicated reviews flow separate from metrics flows.

Common pitfalls

Don't run data flows before 2 AM PT. GBP metrics are finalized overnight. If you run at midnight, you'll get incomplete or stale data. Wait until after 2 AM PT.

Don't pull unverified locations. Only verified GBP locations return data. If a location is pending verification, the data flow will fail. Verify first in Google Business Profile, then reconnect.

Do

• Use Append to combine data from multiple report runs into one table

• Create separate flows for reviews if you have 100+ locations

• Use a Join to match search keywords with their corresponding daily metrics

• Test with a small date range first (e.g., 7 days) before running large pulls

Don't

• Run multiple flows simultaneously without staggering them

• Pull data before 2 AM PT when metrics are still finalizing

• Use Viewer-only GBP access; you need Manager or Admin permissions

• Expect data older than ~90 days; GBP doesn't retain older historical data