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. (https://storage.crisp.chat/users/helpdesk/wePopularWhere 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" (https://storage.crisp.chat/users/helpdesk/websPopularHow 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 the extension menu This is the easiest way, you only have to click the message icon under the query in the extension. A pop-up window will open where you can explain the probPopularDataslayer.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 SheetsPopularHow 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. (https://storage.crisp.chat/users/helpdPopularHow 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 migrationSome readersAI 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 thSome readersHow to use the “Combine new with old results” option
How the “Combine new with old results” advanced option works in Dataslayer? You can find this option in the Dataslayer extension, below the OPTIONS tab. 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 verSome 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 the pencil icon of the query you want to modify. Make the changes you want on the query aSome readersHow to monitor all your scheduled refreshes
The schedule refresh helps us save lots of time keeping all our marketing data updated, but did you know you can also monitor your schedules from our website? This feature in the Dataslayer web allows you to easily control all the scheduled updates of your Dataslayer queries, and it also allows you to access your Google Sheets documentSome readersHow to mass duplicate queries from one sheet to another in the same document
With Dataslayer you can mass duplicate queries from one sheet to another in the same document! 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 allSome readersDo you see the whole sidebar blank?
Is your sidebar blank or are you getting this error? Don't worry, here's how to fix it. 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 logSome readersHow to use the Google Sheets templates
We have developed different templates so that you can save time when creating your reports with Dataslayer! We have a wide variety of templates at your disposal! Take a look at this link. Use our templates is very ease. You just have to: Open a new document in Google Sheets Click on “Extensions” Then click on “DatasSome 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 quSome 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 abSome 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" sectioSome 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 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 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 (https://help.dataslayer.ai/en/article/why-shouFew 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 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 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 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.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 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 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 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 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 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 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 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 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 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 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 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 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 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 readersUnderstanding the Dataslayer Manage Queries view
We have changed our user interface in our Google Sheets extension. Now managing queries is much easier and faster! But if you are a bit lost or if don't understand well the meaning of each of the icons and their functions, don't worry! Keep reading to find out more about our amazing and super-intuitive Manage Queries menu. First, in Google Sheets, open the Dataslayer extension. (https://storageFew readersHow to use the "Include ChatGPT analysis" option in Dataslayer
The "Include ChatGPT analysis" option is a very useful and powerful feature to get a quick analysis created by ChatGTP artificial intelligence! What this option does is that will help you to see how your campaigns are working in order to understand it better and based on that look at what actions you can do to improve or enhance them.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 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 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 readersSolution to the error: "We're sorry, a server error occurred while reading from storage. Error code INTERNAL."
Have you ever got this message in the Dataslayer sidebar? Don't worry, here's why it happens and how to fix it. What causes this error? This message appears when the Dataslayer sidebar has been open for a long time. It is a message that Google sends after a certain amount of time has passed. How do I fix itFew readers