Question 1

How to make a simple query?

Accepted Answer

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.

![](https://storage.crisp.chat/users/helpdesk/website/5134c19968a6bc0

Question 2

How to make a simple Dashboard?

Accepted Answer

Google Data Studio is very intuitive and visual. In the next video you can see how easy it is to create a simple dashboard with one of our connectors. Try it and start creating amazing dashboards to impress your boss and clients.

${youtube}Create a simple dashboard

Question 3

Where is Dataslayer.ai?

Accepted Answer

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"

Done! You can start using Dataslayer and making reports in minutes!

| Important: If you don't see Dataslayer in the Extensions menu, make sure you have installed it and then refresh the page.

Question 4

How API calls works in Looker Studio

Accepted Answer

In Looker Studio, the API calls works differently than the Google Sheets' API calls

An API call is generated each time one of our connectors calls the data source API to get information.

| In general, in Looker Studio each chart, widget or table is equivalent to 1 API call. Every time you add, refresh or edit one of them, API calls will be consumed (depending on how many elements you have on the page, it may consume more or less API calls).

However, there are some times that 1 widget is NOT equivalent to 1 API call:

||| Depending on the chart you've selected, Looker Studio can consume more than 1 API call per widget. There are some charts (like the "table with heat map" chart) that needs more API calls to work and show the data the way you want.

||| The Grand total row, the Blend data connector, the filters and the comparison dates options add + 1 more API call to any graph.

||| If you share the document with your clients, every time they refresh the data or change an option in a control, the API calls associated with the Dataslayer account that manages the document will be consumed.

Please note that Looker Studio's refresh and update system depends on Google, not Dataslayer. That's why our plans for Looker Studio include more API calls than Google Sheets.

Finally, remember that if a query returns an error, *

Question 5

What is an API call?

Accepted Answer

| In Dataslayer we want to base our pricing on usage, as we offer unlimited data sources, unlimited accounts per data source and unlimited users. The way we measure the usage of the tool is through API calls (on our Google Sheets and Looker Studio products). That's why our plans are differentiated by the number of daily API calls that can be made.

API calls in Google Sheets

An API call is every time our extension needs to “call” the connector chosen (Facebook, Google Analytics, Google Ads…) to bring data into your spreadsheet. Therefore, every time you make a query or refresh it, you are consuming 1 API call, no matter how many accounts, metrics or dimensions you have selected.

For example, if you have a spreadsheet with 3 queries (tables) of different data sources like Facebook, Google Ads and Instagram and it is set up to automatically refresh twice a day, it will make 6 API daily calls.

You can check how many API calls you are consuming, as well as your daily limit, in My Activity section on our website, or at the end of the extension:

API calls in Google Looker Studio

For more information, please refer to this article

In general, in Looker Studio each chart, widget or table is equivalent to 1 API call. Every time you add, refresh o

Question 6

How to reauthenticate or remove a Data Studio connector

Accepted Answer

Reauthenticate or remove a Google Data Studio connector

Sometimes the Data Studio connectors can have connection issues logging in or maybe you can have an error message with the connector connection. Reauthenticating a data source refreshes your connection to it. This can be helpful also if you need to make changes to your connected accounts.

* Your Google Data Studio dashboard and data won't be affected by this process.

There are two ways to reauthenticate a connector:

| By editing the connector configuration

Open Data Studio and click on the connector you want to reauthenticate. If you are already working on a report, click on Resource -> Manage added data sources and click on Edit.
Click on Edit connection on the left side.
Click on the following URL in order to revoke the connector credentials:
Click on the following URL in orden to reconnect your account:
Authenticate your data source accounts again (make sure you are [accepti

Frequently Read Articles

Browse All Categories