Using Google Search Console Metrics and Dimensions in Custom Reports
When you have integrated Google Search Console with Piwik PRO, you can use metrics and dimensions coming from the search console to build custom reports. Obviously, you can gain lots of insights by looking at the ready-made Google Search Console report. But if you fancy creating a report that has different data combined together, you are free to do it using Custom Reports. In this article, we’ll explain how.
Before you start
Here are some things to know before you start working with Google Search Console metrics and dimensions:
- Google aggregates Search Console data, therefore we can’t match data to a particular session.
- You can create a report combining Google Search Console data with analytics data only when using matching dimensions: device type, continent, country, session entry URL, or date.
- If you use the dimension of a search engine keyword, you can combine it only with Google Search Console metrics like impressions (search engine), clicks (search engine), CTR (search engine), or average position (search engine). It’s because this dimension doesn’t match any dimension in Piwik PRO.
- If you see zeros in your report, it means that you have used the dimension that doesn’t match the dimension from Google Search Console.
- If you’re not familiar with Custom Reports, read our guiding article “Creating a report.“
Creating a custom report with Google Search Console data
To create a custom report that will contain Google Search Console data, follow these steps:
- Go to Menu > Analytics (new).
- Navigate to Custom Reports.
- Click Add new report.
- Choose the type of report: flat table, explorer, bar chart, or line chart.
- Name the report.
- Choose Visibility of the report.
- On the right, click Dimensions.
- Scroll down until you see Google Search Console and click the drop-down.
- Pick the dimension that you want to use in the report. If you want to combine data with analytics data, choose one of these dimensions:
- Device type
- Session entry URL
- Clicks (search engine)
- Impressions (search engine)
- CTR (search engine)
- Average position (search engine)
These metrics are all marked with a side note
(search engine). This way you can distinguish them from analytics metrics.
source/medium is google/organic. It’s a good idea to add this filter because then you will see data for analytics metrics narrowed down to only the ones that come from the Google search.