How to make a simple query?
Don't you know how to start making simple queries with Dataslayer yet? Don't worry, we are going to explain it to you. Once you have downloaded Dataslayer, you can make simple queries in a few seconds following these steps: Open a Google Sheets document and click on extensions. Go to the Dataslayer extension, and click onPopularWhere 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 Click on "Launch Sidebar" Done! You can start using Dataslayer and mPopularHow to report an issue with a query in Google Sheets?
Have you had an error and don't know how to report it? 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: 1. From Tools button Click on the "Tools" button at the top of the sidebar and then click on the option “Report an issue with a query”. A pop-up window will open where you can explain the problem you are having with your query.PopularDataslayer.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 in a more personalized way. You can find them in the "Options" section at the bottom of the settings. Options on Google Sheets Let's take a look at the most common ones: All connectors have 6 common options. Most commonPopularAI tools in Dataslayer
Introducing our AI tools functionality for Google Sheets! Are you working with your company's data and want to know if you are going to spend more money based on past expenses? Or do you want to know if your Reach, Impressions, Clicks, CPC, CTR, Conversions or ANY other metric you can think of will grow in the next few days based on your current data? From now on, Dataslayer can predict the future! Once you have downloaded the Dataslayer extension for Google Sheets (https://help.dataSome 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? 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 your reports follow these steps: Click on the Schedule button at the top of the extension. A pop-up window will appear where you can seleSome 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 documeSome readersHow can I modify a pre 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. (https://storage.crisp.chat/users/helpdesk/websSome readersHow 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 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 yoSome 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 readersDo you see the whole sidebar blank?
Is your sidebar blank or are you getting this error? What is the reason for this error? This error is not related to Dataslayer. It is a Google error that happens when you use different accounts in both your browser and Dataslayer. When this happens, please log out of all your Google accounts and try using Google Sheets with the same Google account you are loggSome 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. (https://storage.crisp.chat/users/helpdesk/website/5134c19968aSome readersCan I modify queries created by other user?
Do you have a query created by another user and you want to modify it or maybe you are getting the "Please try again to login into your data source" and you don't understand why? In theory, you can't modify a query from another user but we will explain to you how to do it. The only thing you need is to have access to the same data source accounts as the person who created the original query.Some 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 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 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 Extensions 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 lotsFew 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 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?
Several of the Dataslayer connectors, as well as the scheduled refresh functionality may be influenced by the time zone you have configured. To check which time zone is being used by Dataslayer, follow the steps below: In your Google Sheets sheet, go to the FiFew 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 are the data sorted in the queries and how do I change their order?
When you make a query in Dataslayer, the metrics and dimensions will appear in the order you have selected in the addon. To change this, you can drag the metrics to move them around. As for the data, it is sorted by default according to the metric with the highest numerical value. How do I change the order of my queries? (https://storage.crisp.chat/users/helpdesk/website/5134Few readersHow to reconnect data sources in Google Sheets
Are you experiencing a connection error with your data sources? Did you get an error similar to "Please try again to login in your data source"? Sometimes for a connector to work correctly it is necessary to re-login. You can reconnect the datasource by following these steps: Open Dataslayer extension in GSheets. (https://storage.crisp.chat/users/helFew readersDuplicating queries from one sheet to another in the same document
Want to have the same Dataslayer tables in different tabs, with different accounts or date ranges, but in the same document? With this tutorial, you will quickly learn how to duplicate sheets with Dataslayer tables created without breaking anything you have built before!Few readersSolution to the error "The number of columns in the data does not match the number of columns in the range"
Did you try to modify a query and got the error "The number of columns in the data does not match the number of columns in the range"? Don´t worry, this happens because you tried to modify a query with the "combine new with old results" option selected. Follow these steps to fix it: Click on Modify to modify the query (https://storage.crisp.chat/users/helpdeFew readersHow to store a follow-up of my Instagram stories
In this article you will find a trick to store a follow-up of your Instagram stories over time. We all now the benefits of Instagram Stories, but since they only last 24 hours, it is complicated to manage their reports. One solution for this issue could be to use the "Combine new with old results" option with a daily schedule (with the dimension date on the query) and yesterday as date range.Few readersHow to duplicate the document with my queries already done
Do you want to duplicate your queries to another document? It is very easy, just follow these steps: Once in the document you want to duplicate, click on Extensions, Dataslayer, and Duplicate this file. A pop-up window will appear and you will be able to select the account you want to duplFew readersWhat is #REF! in my DataslayerQueries sheet and how to solve it
Have you looked at the hidden DataslayerQueries sheet and seen REF! in one of the cells? Don't worry, this is a common error easy to solve. How a normal DataslayerQueries sheet has to look like Normally, the DataslayerQueries hidden sheet looks like the image below. There are no error messages and each column corresponds to its header. We also always inform you NOT to touch this sheet becausFew readers