How to move your website data from Matomo to Google Sheets

Are you struggling with moving your Matomo data to Google Sheets? In this blog post, we will guide you through the process of moving your Matomo data to Google Sheets using the Catchr.io Add-on. This will simplify your marketing analysis and make it easier for you to create custom reports. Catchr.io is a powerful SaaS solution designed to move data from various marketing sources, including Matomo, to Google Sheets.

Create a New Query

To begin, open Google Sheets and click on "Catchr" in the menu. Then, click on "New Query" to create a new query that will help move your Matomo data.

Select Your Data Source

In the query tab, you can choose the source that you want to use – in this case, Matomo. If the account is not provided in the source list, you can easily add a new source by clicking on the "+" button.

Select Your Account(s).

Navigate to the "Select account(s)" tab and choose the Matomo account(s) that you want to import data from.

Choose Metrics and Dimensions

Next, go to the "Metrics" and "Dimensions" tabs to select the specific data points you want to include in your query. Here are some examples of metrics and dimensions you may find useful:

Metrics :

• ‍Pageviews: The number of times a page was viewed. ‍
• Unique Pageviews: The number of unique visitors that have viewed a specific page. ‍
• Bounce Rate: The percentage of single-page sessions where the user left without interacting further.

Dimensions :

• ‍Country: The country from which the visitor accessed your website.‍
• Device Type: The type of device used by the visitor (e.g., desktop, mobile, tablet). ‍
• Browser: The web browser used by the visitor (e.g., Chrome, Safari, Firefox).

Remember to choose metrics and dimensions that are relevant to your analysis and reporting needs. 

Set Date Range

After selecting your metrics and dimensions, move to the "Date Range" tab. Catchr.io offers preset date ranges like "Last month" and "This year", but you can also select custom start and end dates for your data import.

Apply Filters

If you want to narrow down your data even further, you can apply filters in the "Filters" tab. To add a filter, fill in the following three fields:

1. ‍Field: The field name (e.g., country) ‍
2. Operator: The operator (e.g., equals) ‍
3. Value: The value (e.g., United States)

For example, if you want to see data only for visitors from the United States, you would set up a filter with Field = Country, Operator = Equals, and Value = United States.

Schedule & Customize Data Refreshness

Lastly, go to the "Options" tab to schedule automatic data refreshes for your query. You can also activate options like "Appends rows," which adds new rows at the end of the query range, or "Combine rows," which updates all rows in the range.

Examples of Data Reports You Can Build with Catchr and Google Sheets:

With Catchr.io and Google Sheets, you can build a wide variety of data reports to analyze and optimize your marketing efforts. Some examples include:

Traffic analysis: Evaluate your website's traffic by analyzing metrics like visits, unique visitors, and bounce rate, segmented by dimensions such as country, device type, and referral source.

Page performance: Assess the performance of individual pages on your site by analyzing metrics like page views, average time on page, and exit rate, organized by dimensions like page URL and page title.

Conversion tracking: Monitor your site's conversion rate by combining Matomo data with WooCommerce sales data to identify trends and opportunities for improvement.

Transferring your Matomo data to Google Sheets with Catchr.io can help you streamline your reporting process and gain valuable insights into your website's performance. By following the step-by-step guide outlined in this blog post, you'll be well on your way to creating robust, data-driven reports that drive informed decision-making for your business.