How to make a simple query?
Don't you know how to start making simple queries with Dataslayer yet? Once you have downloaded Dataslayer, you can make simple queries in a few seconds. Learn how to do it with this video below!Very popularHow to report an issue with a query in Google Sheets?
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:
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), bVery popularWhere is Dataslayer.ai?
You have already downloaded Dataslayer but can’t find it? Don’t worry, Dataslayer is an add-on of Google Sheets. Open it and learn where is Dataslayer here. You will be able to find and start using it to automate all your PPC reports in minutes.Very popularHow to migrate queries to the new Google Ads API
See this brief video tutorial to see how to use our migration tool. It’s as easy as select “Migrate Google Ads queries” in the sidebar and decide if you want to create a backup copy of the DataslayerQueries’ hidden sheet.
Once your queries are migrated, make sure if any of them have had an error, by opening the copy of DataslayerQueries’ sheet and looking at the last_status column.
You will received an email with all the migration detailsVery popularDataslayer.ai advanced options
Don’t you know all the advanced options that Dataslayer has yet? Learn all about them in the next video. With these advanced options you will be able to personalize how your data are shown to help you create automate PPC reports much faster.
There are more advanced options now! Come see the last options we have incorporated:
“Combine new with old results”
${youtube}[Advanced options](PopularDo 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 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.
[Some readersHow to schedule report refresh?
Don't you know how to schedule report refresh with Dataslayer yet?
Once you have made a query you are able to program the data refresh so you don't have to do it manually.
To schedule report refresh in your queries, you need to select the icon on the top of the Datalsayer.ai add-on. Then a pop up window will come up where you can select how often do you want your query to be refreshed, and also if you want to receive an email once the refresh has donSome readersHow to import your queries from Supermetrics
Do you want to import queries from Supermetrics to Dataslayer but don't want to do all your queries again from scratch?
Don't worry, with this migration tool you will be able to have all your Supermetrics queries in Dataslayer within seconds. Watch the video above to learn more!Some readersHow 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 yet? Watch this video to learn about it:
You can find this option in the add-on, in “Options”, and it works by automatically accumulating the information of your old data with the new ones when you modify, refresh or schedule your queries. It is very useful because old data is no longer overwritten, it is accumulated.
If you don’t know about the otheSome readersHow 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 query from scratch for every client, we have developed the functionality to duplicate queries for another account.
It's as simple as opening the Add-on tab on Google Sheets and clicking “Duplicate this file” on the Dataslayer’s menu. Select the new account you want to duplicate the query for and, in a few minutes, it will open in a new document, saving you lots ofSome readersHow 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 Dataslayer using, go to “settings” in the spreadsheet, as you can see below.Some readersI 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 add-on so we can receive your queries info and see what the problem is.Few readersHow 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 the dropdown opens, click on “Template gallery“
Choose the template you wantFew readersHow 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 changes” and the query is going to be modified, as you can see below.Few readersWhat 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 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:
– Adwords, Analytics and Facebook use the timezone specified in the account from which data is collected.
– DCM: Default timezone is “America/LosAngeles” and cannot beFew readersDoes the Dataslayer add-on not work?
If the Dataslayer add-on does not work correctly, for example the refresh 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 havingFew readersHow 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 appear in the add-on. If you click on “show params”, the query sheet will open in a new tab.
If you open the hidden sheet “DataslayerQueries”, which is generated automatically. If you don’t know how to open hidden sheets, you can click here for more information.
[ by dragging the wished dimension and dropping it in the “row” field.
Once you have selected your new date range, click where you want to put it on your Google Sheet and click “Generate Table”.
[![](https://storage.crisp.chat/users/helpdesk/website/5134c19968aFew readersHow 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.Few readersCan I create a pivot table?
Dataslayer has an add-on of Google Sheets, so 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 youFew readersCan 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 in the same tab.Few readersDo Google Sheets have a limited cells number?
Does this error about the limit of the cells appear in Dataslayer?
By default Google Sheets have a limit of 5,000,000 cells, so it’s not a Dataslayer.ai limit.Few readersDoes 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.Few readersCan 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 people who are using an account.Few readersHow to use filters in Dataslayer
Don’t you know how to add filters in the Dataslayer add-on yet? Watch this brief video-tutorial to learn how you can do it. You just have to click on the “filters” button and “+add filter”. It’s as easy as that!Few readersCan I refresh or modify queries from another user?
Yes! You can refresh queries from another user in Dataslayer. 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.Few readersIs it possible to create your own calculate metrics?
Yes, since Dataslayer works on Google Sheets you can create and calculate any metric you want.Few readersHow to build a report using the drag and drop?
To use the drag and drop function in Dataslayer as you can see in the GIF above, select the metric or dimension you want, drag it to the corresponding field and then drop it.
You can also click once in the metric or dimension you want and it will appear automatically.Few readersHow to download Dataslayer.ai?
Learn how to easily download Dataslayer from our web page or from Google’s Marketplace in less than a minute and start enjoying all its advantages!Few readersHow 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 boxes. You can see how in this short video below.Few readersHow 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 in your Google Sheets spreadsheet from our Dataslayer Template Gallery and you will have your PPC report within seconds! It’s as easy as click on the template you want and load your accounts… That’s all! Isn’t it amazing?Few readersHow to monitor all your scheduled refreshes
We have just introduced a new feature in our website! It allows you to easily control all the scheduled updates of your Dataslayer queries. It will also allow you to access your Google Sheets documents easily.
You just have to login in our website and click on "My GS Schedules" tab. As easy as that!
"My GS Schedules" tab
See how it works in this video below:
${youtube}[Monitor all yoFew readersCan I modify queries created by other user?
Due to how the code works internally, you can only modify queries if you have access to the same credentials with which they were created, but there is a method to trick the code and be able to modify queries even if you do not have the credentials.
To do this you must follow these steps:
Go to the hidden sheet "DataslayerQueries" by clicking on the "all sheets" button.
In the "AL" column, change the emailFew readers
