This banner can be used to inform vistors of something important.
Learn more
You can easiliy create a Matomo report following this step :
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.
Welcome to our step-by-step tutorial on how to connect your Matomo source to Looker Studio ( formerly Google Data Studio)! This guide is specifically designed for those who may not be tech-savvy, so we'll be breaking down the process into simple, easy-to-follow steps. By the end of this tutorial, you'll be able to visualize and analyze your Matomo data in Google Data Studio like a pro. Let's get started!
Before we dive into the process, let's make sure you have everything you need:
Now that you are ready, let's see what you need to do to setup the Matomo connector with Catchr.
Log in to your Google account and go to https://lookerstudio.google.com/. You'll reach your Looker dashboard.
On your dashboard, click the "+ Blank Report" button in the bottom-right corner to create a new report. An empty canvas will appear, and a panel on the bottom will display a list of connectors.
In the search bar at the top, type "Catchr" and press Enter. You'll see the "Matomo" connector appear in the search results. Click on it to start configuring the connection.
Click Authorize to log in or create an account on Catchr.
Click Authorize again to connect Catchr and your Google account.
And click Authorize to link Matomo Looker Studio and Catchr.
A new window will open, asking for your Matomo URL and your Consumer Key. Paste the API token you copied earlier into the "Consumer Key" field. For the "URL of your Matomo analytics" field, enter the URL of your Matomo instance (e.g., https://yourdomain.matomo.cloud/).
Click the "Next" button and wait for the source to connect. When it's done, click on the "Continue" button. The window then indicates that the action is a success. You can close it.
You can now choose the account you want by selecting it from the dropdown "Select your account".
Click on the Add button in the bottom right corner
Now you've completed all the necessary configuration steps, you can start constructing your dashboard.
For now, your new report is empty and contains only your data source. If you don't know every section of the Looker studio interface, take a look at this brief article.
For a Matomo account, it's crucial to track each phase of the user journey, starting from the entry point page they arrive at, through every event they trigger, and finally to the exit page where they conclude their exploration of your website. You have 2 categories of KPIs: Metrics, containing values, and dimensions, breaking down those values.
Here's a list of metrics KPIs:
Here's a list of dimensions KPIs:
Here's how to display these KPIs (with a GIF for better comprehension):
For example, create a table to have more details on the metrics by country.
Caution: only one dimension at a time is allowed in Matomo API. If you have any conflicts with fields, you should have an error like below.
You can set up this table with all dimensions you want if they support the associated metrics.
Feel free to explore the fields in the right-hand column. A better comprehension of these fields and their association will automatically provide you with faster dashboard creation and better data presentation when building it. Don't hesitate to make tests by switching between dimensions and adding/removing/replacing metrics into your chart.
You now know a bit more about using charts for presenting data, and you have a better comprehension of the structure of the Matomo API fields. However, to enhance your report's aesthetics, even with additional cards or tables, you need to take it a step further.
To craft an eye-catching dashboard, we'll adjust the dimensions, incorporate a header, place a rectangular background behind the cards, and add colors to our table.
NClick on the "Theme and Layout" button and select the "Layout" tab. The section "Canvas Size" allows you to change the disposition and dimensions of the canvas. Attribute the value of 2000 to the height. You will now have enough space for all tables you will need in this tutorial.
Please note that this action will set these configurations to all new pages you will add to the report. If you want to override this global configuration for a specific page, you can go to the "Page" -> "Current Page Settings", and select the "Style" tab. The "Canvas Size" category will allow you to make changes to the page currently selected.
Looker Studio provides two options to add some shapes: Rectangles and circles. To use them, you can click on the Shape button, represented by a square in the shortcut bar, and select the desired shape. You now can click anywhere within the report to make your shape appear.
We'll begin by adding a square at the top of the page. Next, resize it to span the entire width of the page. Finally, change its color using the Style menu.
Next, create a new text field to provide a title for your report:
Additionally, you can include images in PNG format, such as your company logo or your client's logo:
Some specifics needs require to add some shape to the background of any other item you'll insert in your report. To perform this, insert a new Rectangle, right-click on it, and use the "Order" -> "Send to back." menu.
Every Looker Studio component has a "Style" tab that permits you to setup its visual appearance. For example, let's change the header's color of a table.
Tip: You can apply the style of one element to another by following these steps: Copy the component whose style you want to reuse, right-click on the target component, and select "Paste Special" -> "Paste Style Only."
Alignment Tips: When you select multiple elements and right-click on them, you'll find three options that can help you achieve pixel-perfect layouts:
Shape Tips: Although Looker Studio can only draw two shapes, it accepts all PNG files. You can use Google Draw to create custom shapes tailored to your needs and download them as PNGs for your reports.
There are various methods to tailor your report to your needs. For instance, you can filter your data by date or campaign or compare KPIs to a previous period.
Additionally, you can provide your viewers with dynamic filters, allowing them to interact with and explore the data more thoroughly.
Now, the viewer can filter the entire report by campaign name.
You can also use the "Fixed-size List" and the "Advanced Filter" to achieve the same outcome with a different appearance.
For every component, there's a section called "Comparison Date Range." If activated, Looker Studio will compare the data to the previously selected period.
To enable this feature:
.png)
