Getting started Dataslayer for Google Sheets

Search FAQs and Tutorials

FAQs

To create your new Criteo credentials to use them in Dataslayer you only have to follow these steps:

  1. Go to https://account.criteo.com/ and log into your account.
  2. Click the "Developer Portal" card.
  3. At the top-right, click on "Create a new app".
  4. Write a Name and Description for your app.
  5. Click "Create App".
  6. Scroll down to the "Service" section. Make sure that "Marketing solutions" is selected and click "Save".
  7. Scroll down again to the "Authorization section". Set every option to "Read". Click "Save".
  8. Scroll back up to the "App credentials" section. Click "Create new key".
  9. This will generate a new text file that the browser will download. Please open this to get your client_id and client_secret values that will be required to log into Dataslayer.
    Don't use them until you have finished all these steps.
  10. Scroll back up again to the top of the page and click "Activate app".
  11. Click "Activate" to confirm and finish the app setup process. Next you will need to generate consent URLs.
  12. In the top-right corner you should now see the button to "Generate new URL".
  13. Click the Generate new URL button. This will generate a single-use consent URL for your advertiser to approve.
  14. Please copy and send that URL to the person who manages the Advertiser you wish to report on. They will need to click on that link and follow the instructions. Note that the URL is single-use. It will expire once clicked.
  15. Once the Advertisers have completed the consent form from the URL, you should now be ready to log into the Dataslayer Criteo data source with the previous client_id and client_secret (steps 10-11).

Dataslayer's daily API calls reboot at 00:00 UTC time. Please check the current UTC time here to see at what time your daily API calls are going to reboot in your time zone.

In order to connect to your Database in Dataslayer.ai, you must accept connections from the IP address 3.131.4.67 for the connection to work.

If the Dataslayer.ai add-on does not work correctly, for example the resfresh or the modify queries functions do not load the metrics or dimensions selected, it might be caused by one of these reasons:

  • Changes in the subscription plan, like upgrading your current plan.
  • Changes or updates that we may have made to the add-on.

To solve this, you only have to reload the Google Sheets' page or reload the Dataslayer.ai add-on, by closing it and then opening it again.

However, if you continue having issues with the add-on you can contact us by our live chat or by email.

Does the message "Internal Datasource error: Maximun quota exceeded" appear while you were using Dataslayer.ai?

maximun quota exceeded

This error comes from the data source, it is not a Dataslayer error. This error usually appear with Google Analytics, Google Search Console and YouTube data sources.

If you have been using your data source account to get a lot of data from another platform ( like Data Studio or the proper data source) it may have reached the data source quota limit. That is what this error is saying. Most of the times, you just need to wait a little, try again and it should let you make the query.

Dataslayer.ai charges on API calls per day. If you refresh your query Dataslayer.ai needs to make an API call. For example, a spreadsheet that is set up refresh daily and report on Adwords, Google Analytics and Facebook data will make 3 API calls per day.

So yes, when you refresh your data it counts as an API call. If you don't know how Dataslayer works with our plans and the API calls, learn more here.

Now you can refresh queries from another user in Dataslayer.ai. If you have a shared Google Sheet document, when you make a query with any data source, the other users can refresh or modify it as those users have an active session in the same data source.

Does this error about the limit of the cells appear in Dataslayer.ai?

number of cells

By default Google Sheets have a limit of 5000000 cells, so it's not a Dataslayer.ai limit. If you don't know how to increase the number of rows, click here to learn more.

Yes, when you choose the Google Ads datasource and the campaigns metric in Dataslayer, the data from the campaign experiments implemented in Google Ads Experiment will also be loaded.

By default queries only show 100 rows but you can change the number of rows visible on the option “# of rows to fetch” under the Rows and Columns boxes. You can see how in this short video below:

[trp_language language="en_US"] https://youtu.be/ZYYVTJ4lxuU [/trp_language] [trp_language language="es_ES"] https://youtu.be/xyxsvBlEOf4 [/trp_language]

Because Dataslayer is an add-on of Google Sheets, it has all the functionalities and advantages the Google platform has. Therefore, once you have your data in your Google sheets spreadsheet, you can easily make pivot tables. IF you don’t know how you can make pivot tables in Google Sheets, this guide will help you: https://support.google.com/a/users/answer/9308944?hl

Yes, since Dataslayer works on Google Sheets you can create and calculate any metric you want.

The number of queries available per day depend on the pricing plan you’ve got. It goes from 10 API calls per day with our FREE plan, up to 1000 API calls per day with our Large plan. To know how many API calls have you performed so far you just need to look at the bottom of our add-on where the number of queries per day will appear.

If you don't know how the API calls work, click here to learn about it.

The following video will show you how to maintain the cell's format you have chosen for your reports after a manual or scheduled refresh.

[trp_language language="en_US"] https://youtu.be/6CSRpw0sbw0 [/trp_language] [trp_language language="es_ES"] https://youtu.be/lfACB2wygnA [/trp_language]

Three examples are shown:

  • Activate this option when you create a new query.
  • Activate it in one pre-existing query.
  • And activating it in all your pre-existing queries at once.

No, the refreshes run on our servers so you don’t need to have your computer on in order for them to work.

You can choose to refresh all the document or a specific tab but you can't choose only one query if it is with other queries in the same tab.

The time zone of each date is set in relation to the time zone of the Google Sheets, so to check what time zone is Dataslayer using, go to "settings" in the spread sheet, as you can see in the GIF above.

The timezone of each date is set in relation to the timezone of the Google Sheets. Therefore, if the words “yesterday” or “tomorrow” are written in the date range, it is going to be in accordance with the timezone in which each user is.With the following datasources, we cannot interact with the timezone they use to return data:

– AdwordsAnalytics and Facebook use the timezone specified in the account from which data is collected.

– DCM: Default timezone is “America/LosAngeles” and cannot be changed.

– Searchconsole: Default timezone is “UTC – 7:00/8:00” and cannot be changed.

For these 3 datasources we have to send them in each call the timezone setting in each spreadsheet:

– Bing: by default it uses the timezone “PacificTimeUSCanadaTijuana”, but can be changed in the call

– DV360: Uses the “America/NewYork” timezone by default, but can be changed in the call

– Criteo: Default timezone is “GMT”, but can be changed in the call

Please, tell us with what datasource you are working, through the Dataslayer chat buttom enable on the ritgh low corner of the add-on.

[trp_language language="en_US"] https://youtu.be/medv5EhoBb0 [/trp_language] [trp_language language="es_ES"] https://youtu.be/eb1fAHQnmMs [/trp_language]

There are two ways to report an issue with one of your queries. In both of them you must do it in the add-on. Let's see:

1. Click the refresh tab at the top and then click the option “Report an issue with a query”. A new window opens where you can explain the problem you are having with your query, as you can see in the video above.

You have to make sure that your query parameters are loaded in the add-on (metrics and dimensions in rows and colums), because if not, we can't see the query parameters and we can't find the issue.

To charge the parameters in a query already done, you only have to click on its data and then on "duplicate" (see the video). Now you can report your issue in the refresh button.

2. This way is easier, you only have to click on one cell in the query to bring up the menu in the add-on. Then click on “Report this query”. A new window opens where you can explain the problem you are having with your query.

report query

By clicking in the query a menu appears so you can click the "modify" option and make the changes you like. Then click on "confirm changes" and the query is going to be modified, as you can see in the GIF above.

It is probably an issue with the timezones, if you have checked the timezone and it is correct, please click on “report issue”, in the add-on so we can receive your queries info and see what the problem is.

Yes, Dataslayer doesn’t limit the sharing of the same login. Our plans are limited by the number of queries and not by the number of people who are using an account.

This error is totally unrelated to Dataslayer. When this happens to you please, logout from all Google accounts and try using Google Sheets logged in with just one account.

The Google Sheets' account must be the same as the default Chrome account. So due to this Google error, the best practise of our tool is to log out of all the accounts, and use Dataslayer with only one account.

TUTORIALS

What is Dataslayer.ai?

Dataslayer.ai is an add-on for Google Sheets that imports all your digital marketing data into one place so you can easily build your own dashboards […]

Read more >

Is Dataslayer.ai safe?

You can check all the security details of our privacy policy page but these are the most important points: We do not store your data […]

Read more >

How to download Dataslayer.ai?

Learn how to easily download Dataslayer.ai from our web page or from Google’s Marketplace in less than a minute and start enjoying all its advantages!

Read more >

Where is Dataslayer.ai?

You have already downloaded Dataslayer.ai but can’t find it? Don’t worry, Dataslayer.ai is an add-on of Google Sheets. Open it and with this simple GIF […]

Read more >

How to make a simple query?

Don’t you know how to start making simple queries with Dataslayer.ai yet? Once you have downloaded Dataslayer.ai, you can make simple queries in a few […]

Read more >

How to build a report using the drag and drop?

To use the drag and drop function in Dataslayer.ai as you can see in the GIF above, select the metric or dimension you want, drag […]

Read more >

How to import your queries from Supermetrics

Do you want to import queries from Supermetrics to Dataslayer.ai but don’t want to do all your queries again from scrach? Don’t worry, with this […]

Read more >

How to compare date range?

If you want to learn how to compare date range, you can create a new query based on a different date ranges by clicking on […]

Read more >

How to schedule report refresh?

Don’t you know how to schedule report refresh with Dataslayer.ai yet? Once you have made a query you are able to program the data refresh […]

Read more >

How to find the query sheet?

You have two different ways to find the query sheet: When you generate a table, you can click on the data and a menu will […]

Read more >

Dataslayer.ai advanced options

Don’t you know all the advanced options that Dataslayer.ai has yet? Learn all about them in the next video. With these advanced options you will […]

Read more >

Make the most of Google Sheets with Dataslayer.ai

Don’t you know how to make the most of Google Sheets yet? With this video you can quickly learn how to make awesome PPC reports […]

Read more >

ADS METRICS

Dataslayer.ai allows you to have all your campaign ads metrics in one place and create a report with just one click. At Dataslayer.ai we make […]

Read more >

WEB METRICS

With Dataslayer.ai you have all your web metrics in one place and you can create a report with just one click. At Dataslayer.ai we make […]

Read more >

How to use the “Combine new with old results” option

Don’t you know how to use the advanced option “Combine new with old results” in Dataslayer.ai yet? Watch this video to learn about it: You […]

Read more >

How to duplicate queries for another account

For us marketers, it’s common to have a standard query or template we use for different clients. So you don’t need to make the whole […]

Read more >

How to use filters in Dataslayer.ai

Don’t you know how to add filters in the Dataslayer.ai add-on yet? Watch this brief videotutorial to learn how you can do it. You just […]

Read more >

Connect Google Sheets with Google Data Studio

Learn how to use Google Sheets as a data source to make awesome PPC reports in Google Data Studio. Make a query with Dataslayer.ai and […]

Read more >

Add users to a company in Dataslayer.ai

Dataslayer.ai has the COMPANY option! Add users and share your API calls with your colleagues! Without hidden costs! See this brief video to learn how […]

Read more >

What metrics does Dataslayer have?

Dataslayer.ai is a Google Sheets add-on that import all your marketing data into a spreadsheet. These are the metrics we have into every data source: […]

Read more >

How to find and add a Dataslayer Template

Starting to use Dataslayer has never been so easy as now it is… Thanks to our new templates functionality! Now you can add a template […]

Read more >