Data Studio template
Search Console + Google Ads
By Ivan Palii
PPC / Paid Media $149
Best for: Agencies/consultants reporting on paid + organic together
Overview
This template blends Google Ads search-campaign data and Search Console performance by search query and landing page to find keywords that are converting (proof of value) and those closest to the top spot but not there yet (low-hanging fruit).
Who it's for
Agencies/consultants reporting on paid + organic together
What's inside
2 report pages:
1Blending data by search queries
2Blending data by landing pages
Key features
- Two custom metrics: Keyword Conversion Potential and Landing Page Conversion Potential
- Data blending from two sources
- Conditional-formatting tables
- Scatter charts
- Filterable by Query and Final URL
- Filterable by landing-page performance
Set it up in minutes
- After buying, use it without copying — just choose the Google Ads account and Search Console property to analyse and all data and filters update.
- To customise, copy the template and connect the proper datasets: for GSC (query) connect Site Impression; for GSC (url) connect URL Impression.
