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.

Browser template (16)-1

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

image_e4gp9

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.

image_r7yojw

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

The number of accounts you can select depends on your plan. To learn more, please check out this article.

image_njo1h2

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.

image_18sj613

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

6. Finally, set some advanced options if needed, select the cell where you want to insert your data and click on generate table.

Learn more about our advanced options in this article.

image_m91m3u

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 our extension, 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!