Dataslayer
  • English
  • Spanish
Go to website
Back
Articles on:Google Sheets
Ideal for data-driven report analysis

Categories

  • General questions
  • Dataslayer Billing & Pricing
  • Google Sheets
  • Google Data Studio
  • Dataslayer API
  • Google BigQuery
  • 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!Popular
  • Where 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.pnPopular
  • How 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 cannotPopular
  • Dataslayer.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 onePopular
  • How 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 readers
  • How 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 readers
  • How 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 readers
  • How 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 readers
  • How 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 readers
  • How 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 readers
  • How 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 readers
  • 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 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 readers
  • How 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 readers
  • How 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 readers
  • 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 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 readers
  • How 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 readers
  • 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 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 readers
  • How 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 readers
  • 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 Dataslayer using, go to “settings” in the spreadsheet, as you can see below.Few readers
  • How 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 readers
  • Make 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 readers
  • Can 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
  • 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.Few readers
  • 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 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 readers
  • Do 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 readers
  • Does 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 readers
  • How 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 readers
  • How 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 readers
  • Can 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 readers
  • 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 people who are using an account.Few readers
  • 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.Few readers
  • Can 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 readers
  • 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.Few readers
  • Why 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 readers
  • How 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 readers
  • How 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 readers
  • What 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 readers
  • How 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 readers
  • How 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

Not finding what you are looking for?

Chat with us or send us an email.

  • Chat with us
  • Send us an email
© 2023DataslayerWe run on Crisp Knowledge.