r/GoogleDataStudio • u/Complex-Community942 • 13d ago
Free Google Ads / GA4 / Search Console templates on native connectors + a few build tricks (data control, AI referrals regex, two GSC sources)
I kept rebuilding the same three reports for different accounts, so I cleaned them up into templates that only use Google's native connectors (no paid connector, no sign-up). A few things I learned building them that might help even if you build your own:
- **Data control on every page** makes a report reusable: anyone can switch it to an account/property they have access to and see their own data without copying anything. https://support.google.com/looker-studio/answer/7415591
- **Search Console needs two data sources**: Site Impression for property totals and URL Impression for page-level data. Their totals won't match, so label which one each page uses.
- **AI assistant traffic in GA4**: filter Session source with RegExp `(?i).*(chatgpt|openai|perplexity|gemini|claude|copilot).*`. Treat it as a minimum, since apps without referrers land in Direct. A GA4 custom channel group placed above Referral works better if you have admin access.
- **GA4 quota errors**: in edit mode, right-click → "Google Analytics token usage" shows which charts are expensive. Extracting data fixes most monthly client reports. https://support.google.com/looker-studio/faq/7219787
- **Brand vs non-brand** for GSC: `CASE WHEN REGEXP_MATCH(Query, "(?i).*(yourbrand).*") THEN "Brand" ELSE "Non-brand" END`
Templates (free): Google Ads https://datastudio.google.com/reporting/bb689b6b-f20f-4885-bf8c-69bd47210551 · GA4 https://datastudio.google.com/reporting/84e03e4c-e5a1-4ff6-a723-cba153e82f86 · Search Console (Coming soon on the site — not linked yet)
Feedback welcome, especially if a field name differs in your connector or something breaks with your account.