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.
To start exporting your matomo data to Google Sheets, you need to install the Catchr add-on. You currently have two options :
Option A: Via the marketplace:
Option B: Directly within a Google Sheets:
Once you have installed the add-on, you can start making requests.
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.
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.
Navigate to the "Select account(s)" tab and choose the Matomo account(s) that you want to import data from.
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:
Remember to choose metrics and dimensions that are relevant to your analysis and reporting needs.
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.
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:
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.
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.
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.