Google Search Console data into your data warehouse in minutes
Collect Google Search Console data into your data warehouse or ours. The Matatika pipelines will take care of the data collection and preparation for your analytics and BI tools.
Automate Google Search Console from a single space with no code
Meltano Tap Google Search Console is a Singer tap for extracting Google Search Console performance data into Meltano Cloud for reporting, modelling, and downstream analysis.
It helps you collect organic search performance data from Google Search Console in a repeatable pipeline so you can analyse clicks, impressions, click-through rate, ranking position, pages, queries, devices, and countries alongside data from your other business systems.
Use this connector when you want to:
- centralise Google Search Console data in your warehouse
- monitor organic search performance over time
- analyse which queries and pages drive search traffic
- compare search performance by device or country
- combine search visibility data with analytics, advertising, or revenue data
Setup
- Identify the property you want to extract data for by domain name (e.g.
meltano.com)
In Meltano Cloud:
- Login and connect with your Google account
- Enter the property domain name, prefixed with
sc-domain:(e.g.sc-domain:meltano.com) as the Site URL - Choose a start date for extraction
Streams
The tap provides the following default streams:
performance_report_country
Search performance by country and date.
Properties
| Name | Description |
|---|---|
site_url |
Dimension. The Search Console property identifier for the site. |
date |
Dimension. The reporting date for the row. |
country |
Dimension. The three-letter country code associated with the search activity. |
clicks |
Metric. The number of clicks from Google Search results. |
impressions |
Metric. The number of times the site appeared in Google Search results. |
ctr |
Metric. The click-through rate for the row. |
position |
Metric. The average search result position for the row. |
performance_report_date
Search performance aggregated by date.
Properties
| Name | Description |
|---|---|
date |
Dimension. The reporting date for the row. |
site_url |
Dimension. The Search Console property identifier for the site. |
clicks |
Metric. The number of clicks from Google Search results. |
impressions |
Metric. The number of times the site appeared in Google Search results. |
ctr |
Metric. The click-through rate for the row. |
position |
Metric. The average search result position for the row. |
performance_report_device
Search performance by device and date.
Properties
| Name | Description |
|---|---|
date |
Dimension. The reporting date for the row. |
device |
Dimension. The device category, such as desktop, mobile, or tablet. |
site_url |
Dimension. The Search Console property identifier for the site. |
clicks |
Metric. The number of clicks from Google Search results. |
impressions |
Metric. The number of times the site appeared in Google Search results. |
ctr |
Metric. The click-through rate for the row. |
position |
Metric. The average search result position for the row. |
performance_report_keys
Search performance with the raw keys array returned by the Search Console API.
Properties
| Name | Description |
|---|---|
site_url |
Dimension. The Search Console property identifier for the site. |
date |
Dimension. The reporting date for the row. |
keys |
Dimension. The raw "keys" array returned by the Google Search Console API. |
clicks |
Metric. The number of clicks from Google Search results. |
impressions |
Metric. The number of times the site appeared in Google Search results. |
ctr |
Metric. The click-through rate for the row. |
position |
Metric. The average search result position for the row. |
performance_report_page
Search performance by landing page and date.
Properties
| Name | Description |
|---|---|
date |
Dimension. The reporting date for the row. |
page |
Dimension. The page URL that appeared in Google Search results. |
site_url |
Dimension. The Search Console property identifier for the site. |
clicks |
Metric. The number of clicks from Google Search results. |
impressions |
Metric. The number of times the site appeared in Google Search results. |
ctr |
Metric. The click-through rate for the row. |
position |
Metric. The average search result position for the row. |
performance_report_query
Search performance by search query and date.
Properties
| Name | Description |
|---|---|
date |
Dimension. The reporting date for the row. |
query |
Dimension. The search query that generated the impression or click. |
site_url |
Dimension. The Search Console property identifier for the site. |
clicks |
Metric. The number of clicks from Google Search results. |
impressions |
Metric. The number of times the site appeared in Google Search results. |
ctr |
Metric. The click-through rate for the row. |
position |
Metric. The average search result position for the row. |
Settings
Site URL
The site you want to retrieve metrics for, prefixed with sc-domain: (e.g. sc-domain:meltano.com)
Start Date
The earliest record date to sync
Include Freshest Data
Include freshest data, as detailed here
Backfill Days
Used to backfill the last n days when using fresh data, to ensure corrections are applied
View source code
Google Search Console data you can trust
Extract, Transform, and Load Google Search Console data into your data warehouse or ours.
