This tutorial enables you to synchronise a tracking campaign and display the data directly in Google Data Studio.

In this article you will learn how to synchronise Myposeo data in Google Data Studio. Overview includes:

The first step is to synchronise your Myposeo account with Google Data Studio.

1. Within your Myposeo account

First step, retrieve your API Key, available via your configuration page https://account.myposeo.com/account/configuration/api

2. In your Google Data Studio account

You must create a data source by clicking on the CREATE button.

To do this, you will need to add the Myposeo connector, among the list of connectors tools available. In order to simplify your search, we advise you to use the search bar provided (see image).

Once you have added the Myposeo connector, you need to fill in your API Key, previously retrieved from your Myposeo account.

Before submitting your API key to Google Data Studio, we strongly recommend that you rename your data source to make it easier to find (example: MYP - Site Entity (daily) - Project Name).

At this stage, your synchronisation with Google Data Studio is theoretically done. To display your first data in the interface you will now have to setup a data source.
The next steps are as follows;

1. Select the entity from which you wish to collect data (site, keyword groups, keywords, detailed keywords, competitors, page tags, pages...).

2. Select the language (French or English) of the Myposeo indicators.

3. Choose the aggregation (day, week or month) on which you wish to display your data. Everything will depend on the expected result in your dataviz (choice of charts...). Be aware that this parameter is linked to the calendar that you find in the Myposeo interface (see image below).

Example: If you want to display data at the month level (January to December) then you will have to choose the month aggregation. Not the day or week aggregation, as the data calculations will be different and you will not have similar data.

4. You then need to select the Myposeo campaign (id) from which you want to collect the data (all your projects are listed automatically), retrieve the best positions or all positions and finally the website(s) to display.

5. If you need to display the data for your domain and those of your competitors, then we invite you to select more than one and to tick the checkbox to be able to display the data of different domains at the same time.

6. You can also breakdown your data by keyword groups. Please note that if you leave this field empty, then all keyword groups will be taken into account by default.

7.

Then click on "Connect".

Once the data source is created, you have two choices:

NOTE: This template was built on a daily basis campaign.

If your campaign collects data once a week, then the data sources to create afterwards will have to be aggregated on a weekly basis and not on a daily basis.
As for the monthly data sources, this does not change.

Example :
​MYP - Site Entity (daily) - DEMO SOURCE > MYP - Site Entity (week) - DEMO SOURCE

As a preamble, you need to create several data sources, as follows:

1. Site Entity

Example :

*In the creation of the data source, if you wish to take into account all the Keyword Groups, then you must leave the "Keyword Groups" field EMPTY.

2. Keywords Groups Entity

Example :

*In the creation of the data source, if you wish to take into account all the Keyword Groups, then you must leave the "Keyword Groups" field EMPTY.

3. Keywords Entity

Example :

*In the creation of the data source, if you wish to take into account all the Keyword Groups, then you must leave the "Keyword Groups" field EMPTY.

4. Pages Tags Entity

Example :

5. Pages Entity

Example :

*In the creation of the data source, if you wish to take into account all the Keyword Groups, then you must leave the "Keyword Groups" field EMPTY.

6. Site (competitors) Entity

Example :

*In the creation of the data source, if you wish to take into account all the Keyword Groups, then you must leave the "Keyword Groups" field EMPTY.

Once you have created all of them, you will have to go to our Google Data Studio template by clicking on this link.

On the interface, you will have to make a copy of our template...

By duplicating the template you will not have access to the original data sources (Unknown).
​
This will not allow you to sort your data sources in the right order. Yes the order of the data sources have an importance in the display of the data afterwards.

To fix this, please add them in this exact order:

...then you will have to click on the "Create Report" button

Once the copy of the report is done, don't hesitate to check your graphs, dimensions, metrics as well as the parameters Site, Keyword Groups... to detect any anomaly.