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:

  1. Go to Menu > Analytics (new).
  2. Navigate to Custom Reports.
  3. Click Add new report.
  4. Choose the type of report: flat table, explorer, bar chart, or line chart.
  5. Name the report.
  6. Choose Visibility of the report.
  7. On the right, click Dimensions.
  8. Scroll down until you see Google Search Console and click the drop-down.
  9. 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
    •  Continent
    •  Country
    •  Session entry URL
    •  Date
  10. If you want to, add another nested dimension.
  11. On the right, click Metrics.
  12. Scroll down until you see Google Search Console and click the drop-down.
  13. Pick metrics that you want to use in the report. You can use four Google Search Console metrics:
    •   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.

  14. Pick analytical metrics that you want to use in the report.
  15. Add a filter to the report 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.
  16. When done, click Create report.
  17. View the report.
Was this article helpful?

Be the first to rate this article.

Technical Support

If you have any questions, drop us a line at support_SPC@piwik_SPC.pro.

We’re happy to help!