Articles on: Google Sheets
This article is also available in:

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 on Lauch sidebar to open it.

Now that you have the Dataslayer add on opened, you have to select the datasource you want to work with.

For this example we will select Google Ads.

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

You can select as many as you want

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.

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 on 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.

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

Updated on: 14/09/2023

Was this article helpful?

Share your feedback


Thank you!