How to make a simple query?

Don't know how to start making simple queries with Dataslayer yet? We are going to explain it to you in this article.

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 by following these steps:

1. Open a Google Sheets document and click on extensions.


2. Go to the Dataslayer extension, and click on Launch sidebar to open it.


3. Now that you have the Dataslayer add-on opened, you have to select the data source you want to work with.

  • For this example, we will select Google Ads.


4. After that, you have to select the account you want to extract data from.

You can select as many as you want!


5. Next, you have to select the date range that you want to work with and the metrics and dimensions you want to upload.

  • In this case, we will select this month to date.

You can type the words "today" or "yesterday" in the date field. Learn more about custom date tricks here.


For the metrics we will select "clicks" and "impressions", and for dimensions "date", for example.

6. Now, select the cell where you want to insert your data and click on generate table.


And that's it!, in a few seconds you will have all your data in Google Sheets so you can work with it.

If you want to modify the query once it has been created, you only have to click anywhere on the data table, and in the add you will see several editing options. In this FAQ we explain it further.

Learn everything you need to know to use the Dataslayer extension correctly here.

Also, if you want to automate the query you can learn how in this FAQ.


Still in doubt? Watch this video where we explain it step by step.

Dataslayer for Google Sheets - Getting Started


As always, please contact us via our website chat or through our email if you still have doubts or questions. We are happy to help!