Getting started Dataslayer for Google Sheets
Search FAQs and Tutorials
Do you see the whole sidebar blank?
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 […]Read more >
Can several people use the same login?
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 […]Read more >
I don’t get the same data, why is it and how to solve it?
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 […]Read more >
How can I report an issue with my queries?
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 […]Read more >
I can’t find the metric I need
Please, tell us with what datasource you are working, through the Dataslayer chat buttom enable on the ritgh low corner of the add-on.Read more >
What time zone does Dataslayer use?
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 […]Read more >
Can you schedule refresh each query individually?
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 […]Read more >
Does my computer need to be on so the queries are refreshed properly?
No, the refreshes run on our servers so you don’t need to have your computer on in order for them to work.Read more >
How to maintain the cell’s format when data is refreshed
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. Three […]Read more >
Is it possible to create your own calculate metrics?
Yes, since Dataslayer works on Google Sheets you can create and calculate any metric you want.Read more >
Can I create a pivot table?
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 […]Read more >
How can I see specific number of rows?
By default queries show the maximum number of rows, but you can change it in the option “# of rows” under the Rows and Columns […]Read more >
Can I upload Google Ads Experiment campaign data?
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 […]Read more >
Do Google Sheets have a limited cells number?
Does this error about the limit of the cells appear in Dataslayer.ai? By default Google Sheets have a limit of 5000000 cells, so it’s not […]Read more >
Can I refresh or modify queries from another user?
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 […]Read more >
If I refresh my data, does it count as an API call?
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 […]Read more >
“Internal Datasource error: Maximun quota exceeded”
Does the message “Internal Datasource error: Maximun quota exceeded” appear while you were using Dataslayer.ai? This error comes from the data source, it is not […]Read more >
Does the Dataslayer.ai add-on not 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, […]Read more >
How do I connect to Database?
In order to connect to your Database in Dataslayer.ai, you must accept connections from the IP address 184.108.40.206 for the connection to work.Read more >
When do my daily API calls reboot?
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 […]Read more >
How to create new Criteo credentials
To create your new Criteo credentials to use them in Dataslayer you only have to follow these steps: Go to https://account.criteo.com/ and log into your […]Read more >
How to use the Google Sheets templates
To use our templates you have to: Open a new document in Google Sheets Click on “Extensions” Then click on “Dataslayer” at the bottom When […]Read more >
What happen if I don’t have a valid Tax ID?
When you are going to fill all the boxes in “Billing info”, all the information required in red must be filled in. You can left […]Read more >
What is Dataslayer.ai?
Dataslayer imports all your digital marketing data into different places so you can easily build your own dashboards and automate PPC reports. With our add-on […]Read more >
Is Dataslayer.ai safe?
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 >
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 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 >
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 >
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 >
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 >
Apple Search Ads: Authentication guide
This post is to introduce you on how to authenticate or reauthenticate Apple Search Ads with Google Sheets, Google Data Studio, Dataslayer API and BigQuery. […]Read more >
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 >