Search Console + Google Ads — Data Studio template preview
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

  1. After buying, use it without copying — just choose the Google Ads account and Search Console property to analyse and all data and filters update.
  2. To customise, copy the template and connect the proper datasets: for GSC (query) connect Site Impression; for GSC (url) connect URL Impression.
Scroll to Top