Getting started

How can we help you with?

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 […]

View 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 […]

View 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!

View 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 […]

View 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 […]

View 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 […]

View 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 […]

View 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 […]

View 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 […]

View 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 […]

View 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 […]

View 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 […]

View More
combine results
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 […]

View 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 […]

View More
filters
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 […]

View More
data studio
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 […]

View More
users
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 […]

View More

FAQs

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 […]

View 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 […]

View 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 […]

View More
How can I modify a pre existing 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 […]

View More
How can I report an issue with my queries?

To report an issue with one of your queries, you must do it in the add-on, when you click the refresh tab at the top, […]

View 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.

View 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 […]

View More
How do I know what time zone I have configured?

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 […]

View More
Can you schedule refresh each query individually?

No, right now you can only refresh them all together but we have add this functionality to our Roadmap for future upgrades.

View 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.

View 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 […]

View More
How do I know how many queries I have left per day?

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 […]

View 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.

View 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 […]

View More
I only see the first 100 rows; how can I see more?

By default queries only show 100 rows but you can change the number of rows visible on the option “# of rows to fetch” under […]

View 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 […]

View More
number of cells
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 […]

View More
resfresh queries
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 […]

View More
refresh
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 […]

View 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 […]

View More
reload add-on
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, […]

View More
database
How do I connect to Database?

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.

View More
reboot API calls
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 […]

View More

ANALYTICS

ads metrics
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 […]

View 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 […]

View More
Google Analytics for Google Data Studio

Google Analytics for Google Data Studio CONNECTOR BY Dataslayer.ai The Dataslayer Google Analytics‘ connector is now available in Google Data Studio! Now it’s in BETA so you […]

View More
Facebook Ads for Google Data Studio

Facebook Ads for Google Data Studio CONNECTOR BY Dataslayer.ai The Dataslayer Facebook Ads‘ connector is coming soon… Take a look at our Google Data Studio page to […]

View More
DV360 for Google Data Studio

DV360 for Google Data Studio CONNECTOR BY Dataslayer.ai The Dataslayer DV360 connector is now available in Google Data Studio! Now it’s in BETA so you […]

View More
Google Data Studio Adwords
Google Ads for Google Data Studio

Google Ads for Google Data Studio CONNECTOR BY Dataslayer.ai The Dataslayer Google Ads‘ connector is now available in Google Data Studio! Now it’s in BETA […]

View More