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!PopularWhere is Dataslayer.ai?
You have already installed Dataslayer but can’t find it? Don’t worry, here you can see how to open it. Dataslayer is a Google Sheets add-on. To open the sidebar, follow these steps: Go to Extensions Go to Dataslayer sub-menu (https://storage.crisp.chat/users/helpdesk/website/5134c19968a6bc00/imagelor90n.pnPopularHow 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 from our Google Sheets extension. Let's see how: A pop-up window will open where you can explain the problem you are having with your query. You have to make sure that your query parameters are loaded in the add-on (metrics and dimensions in rows and columns), because if not, we cannotPopularDataslayer.ai advanced options
Are you familiar with Dataslayer's advanced options? With them you will be able to customize the way your data will be displayed, which will help you create automated reports much faster. You can find them in the "Options" section at the bottom of the settings. Let's take a look at the most common onePopularHow to use the “Combine new with old results” option
How the “Combine new with old results” advanced option works in Dataslayer? It works by automatically accumulating the information of your old data with the new one when you modify, refresh or schedule your queries. It is very useful since old data is no longer overwritten, it is accumulated.Some readersHow to schedule report refresh?
With Dataslayer you can schedule an automatically refresh of the sheets you want! Don't you know how to schedule report refresh yet? To schedule report refresh in your queries, you have to click on the "Schedule" button at the top of the extension. A pop-up window will appear where you can select how often do you want your sheets to be refreshed (hourly, daily, weekly, monthly..Some 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 wantSome readersHow to import your queries from Supermetrics
Learn how to import queries from Supermetrics to Dataslayer without doing all your queries again from scratch! With this migration tool you will be able to have all your Supermetrics queries in Dataslayer within seconds. What we do is to copy-paste all your queries from the SupermetricsQueries sheet to the DataslayerQueries sheet. Once you refresh all the queries from Dataslayer, the migration will be completed! Follow these steps or watch the video above to learn more: Open the documeFew readersHow 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 laststatus column. You will received an email with all the migration detailsFew readersHow can I modify a pre existing query?
How can I modify an existing query? Have you just made a query and realized that you are missing something, want to change the order of the metrics or sort the dimensions? To modify your query, you have to follow these steps: Click on any cell inside the table you want to modify. A pop-up menu will appear inside the sidebar. (httFew 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 readersDo 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.Few readersHow to use filters in Dataslayer
How to use filters in Dataslayer.ai Do you want to go one step further with your Google Sheets queries? With our filtering options you can add custom rules to show only the information you want to see. How do I add a filter? It's very simple. First, go to our sidebar and create or modify a query. Then select the "filters" option. Next, select the parameter you are going to filter by (iFew readersHow to download Dataslayer.ai?
Downloading and starting Dataslayer is so easy! To do so, follow these steps: Register on our website clicking here. Select "Open google Sheets" in "My Subscriptions" section and follow the instructions. Open a new Google Sheets document. Go to Extensions ➞ DataslFew 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 ofFew readersHow to find the query sheet?
The "DataslayerQueries" sheet is a hidden sheet that is automatically generated when using Dataslayer in Google Sheets. This sheet stores all the information related to your Dataslayer queries, so it is very important not to modify or edit anything inside this sheet. If you want to know more information about this sheet, you can click here. You have three differeFew 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 readersHow can I see specific number of rows?
How can I see a specific number of rows? Many times we only want to see part of the information, either because we only need a certain number of rows or because we want to reduce the loading time on large queries. By default queries show the maximum number of rows (unless you are using the free plan which is limited to 1,000 rows). (https://stFew 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.Few readersHow to mass duplicate queries from one sheet to another in the same document
With Dataslayer you can now mass duplicate queries from one sheet to another in the same document! Want to know how? Imagine we have a document with separated sheets: one sheet per month. Every month we want to duplicate the same queries we had in our other sheets, but with the new date range. It's easy! You can use the duplicate option on our add-on, and build every query individually, or you can mass duplicate all the queries from that sheet. Let's see the steps: Make sure that you have rFew readersMake the most of Google Sheets with Dataslayer
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 so you can be the best in your area. Here we show you a few functionalities that Google Sheets offers you to make PPC reports of your campaigns. With Dataslayer.ai you have your data in seconds so you can be as creative as you want. Create a graph in moments, be able to modify it with predesignedFew 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 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 readersHow 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 date selection. Then, select the new date range and change the row dimensions accordingly (in this case by month) 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 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 10,000,000 cells, so it’s not a Dataslayer.ai limit.Few 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 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 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 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 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 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 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 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 readersWhy should I not modify the "DataslayerQueries" sheet and what is it for?
When using Dataslayer in Google Sheets, the hidden sheet "DataslayerQueries" is the place where all the query information and data needed for Dataslayer to work is stored. Therefore, it is very important that the user NEVER modifies or deletes anything from this sheet (including deleting the first header row), as this could cause failures in Dataslayer and other related problems. In case you have made any modification to the "DataslayerQueries" sheet and Dataslayer or any of its queries arFew readersHow to add formulas to the backend in Dataslayer
Did you know that Dataslayer allows formulas to be used on its backend? This is a very useful functionality if you have to quickly change a date range or some filters. Imagine not having to open the extension to modify date ranges or filters in an already created query... Dream granted! Important: Columns from A to L, from AD to AM and AO in the DataslayerQueries sheet don't support formulas. If you have put a formula in any field, for example in the dates, you shoFew readersHow to make date comparisons queries with time dimensions
As you may know, in Dataslayer’s extension for Google Sheets you can make time comparisons. You can use this function from the "Dates" menu: If you are going to make comparisons with time dimensions, keep in mind that the dimension must always be of a lower rank, for example: if your time range is “last month” and you put "month" as a time dimension, it is not going to brinFew readersWhat syntax should I use in the BigQuery connector to avoid errors in my queries?
Have you ever experienced any of these errors when trying to run your query in BigQuery? These errors indicate that BigQuery does not recognize the syntax you are using, or that there is some error in it. So, how should I write the syntax of my queries? For this purpose, we give you some recommendations that you should keep in mind to avoid errors:Few readersHow to check if my schedules are executing well?
How to check if my schedules are executing well? Scheduled refreshes are a very useful option for the users who use Dataslayer in Google Sheets, as it allows you to refresh the data automatically without you having to do anything. If you don't know how to create a scheduled refresh, here's how. But is there any way to verify if the refresh has been done correctly? Yes, there are 3 ways. We explFew readersHow to access the query editing menu
How to access the query editing menu? It is very simple. In Google Sheets, open the Dataslayer sidebar from the Extensions menu → Dataslayer → Launch sidebar. Click on an empty cell Then click on a cell that belongs to a query The Dataslayer sidebar will open the selected query's edit menu: (https://storage.crisp.chat/users/helpdesk/website/5134c19968a6bc00/image19ni3mo.pngFew readers