What is an API call?
We wanted to base our pricing on usage instead of number of users, data sources or accounts. And the way to measure the usage of the tool is by API calls, that is why our plans are limited by the daily API calls done. But, what is an API call?
API calls in Google Sheets
An API call is everytime our add-on needs to “call” the data source chosen (Facebook, Google Analytics, Criteo…) to bring data into your spreadsheet. Therefore, everytime you make a query or refresh it, you are consuming 1Very popularAdd users to a company in Dataslayer
Dataslayer.ai has the COMPANY option! Add users and share your API calls with your colleagues! Without hidden costs! See this brief video to learn how to do it:
If the user you want to add is already registered in Dataslayer they will receive this email and will be able to start sharing the plan immediately:
On the other hand, if the user is not registered, heVery popularHow to report an issue from the Dataslayer web
Have you got any issues with your queries in Dataslayer? Did you write us on our live chat and we told you that if you please could report your query? This is the way to do it!
It’s as easy as select your product, the data source you were using and give us as much information as you can! Screenshots or videos are welcome!
IMPORTANT: If you have a problem with a query, please indicate all its parameters so that we can review it.
Report froVery popularShopify: Authentication guide
This guide will walk you through how to authenticate or reauthenticate Shopify in Dataslayer for Google Sheets, Google Data Studio, BigQuery, and the Dataslayer API.
To connect Dataslayer to Shopify, you need a Shopify store owner account or a Shopify staff account.
Open our Google Sheets add-on, our Google Data Studio connector, our Dataslayer API Query Manager or our Dataslayer for BigQuery product.
Select our Shopify integSome readersFacebook Insights: "invalid parameters combination" solution
“Invalid parameters combination” error solution.
This error is unrelated to Dataslayer, and is due to the limitations of the Facebook Api.
The error occurs when a query is made with 2 or more connectors, and at least 2 of them are considered incompatible by the Facebook Api.
But how can we tell which connectors are compatible with each other and which are not?
Well, although the Facebook API is updated from time to time and this can cause the results to vary, there are some general consideSome readersSolution to the error "there are too many scripts running simultaneously for this Google user account"
The error "there are too many scripts running simultaneously for this Google user account" is a Google issue that happens when a Google account is used simultaneously by different people or is open in different browsers, add-ons or services at the same time.
Too many scripts error
Since Google works with quota limits, you may just need to wait a while for the quota to be reset and try the query again. IfSome readersApple Search Ads: Authentication guide
This post is to introduce you on how to authenticate or reauthenticate Apple Search Ads with Google Sheets, Google Data Studio, Dataslayer API and BigQuery.
To connect Dataslayer to Apple Search Ads, you need:
API Account Manager access. Any other access level will not work.
An API user can be generated by a user with Account Admin access.
Before you can authenticate Apple Search Ads in DataslayeSome readersHow to create new Criteo credentials
To create your new Criteo credentials to use them in Dataslayer you only have to follow these steps:
Go to https://account.criteo.com/ and log into your account.
Click the “Developer Portal” card.
At the top-right, click on “Create a new app”.
Write a Name and Description for your app.
Click “Create App”.
Scroll down to the “Service” section. Make sure that “Marketing solutions” is selected and click “Save”.
Scroll down againFew readersConnect Google Sheets with Google Data Studio
Learn how to use Google Sheets as a data source to make awesome PPC reports in Google Data Studio. Make a query with Dataslayer.ai and go to Data Studio to import the spreadsheet where the query is.
In this brief video-tutorial you can see how to connect your Dataslayer queries with Google Data Studio in a few simple steps!Few readersIf I refresh my data, does it count as an API call?
Dataslayer.ai charges on API calls per day. If you refresh your query Dataslayer.ai needs to make an API call. For example, a spreadsheet that is set up refresh daily and report on Adwords, Google Analytics and Facebook data will make 3 API calls per day.
So yes, when you refresh your data it counts as an API call. If you don’t know how Dataslayer works with our plans and the API calls, learn more here.Few readersWhat is Dataslayer.ai?
Dataslayer imports all your digital marketing data into different places so you can easily build your own dashboards and automate PPC reports. With our add-on you can forget about copy pasting all your campaign’s data. It has a lot of functionalities that help you save time like the update function to have real-time data with just one click, or the option to schedule the updates and have the new data sent to your email so you don’t even need to open Dataslayer.ai to see it.
Current destinatFew readersHow do I know how many queries I have left per day?
Google Sheets
The number of queries available per day depend on the pricing plan you’ve got. It goes from 10 API calls per day with our FREE plan, up to 1,000 API calls per day with our Large plan. To know how many API calls have you performed so far you just need to look at the bottom of our add-on where the number of queries per day will appear.
If you don’t know how the API calls work, click [here]Few readersIs Dataslayer.ai safe?
Dataslayer is safe
You can check all the security details of our privacy policy page but these are the most important points:
We do not store your data on our servers, nor your campaign’s data, performance, or any data you are pulling using Dataslayer.
Dataslayer employees neither have any access to the data. The only access permitted is upon request by the userFew readersCan I upload Google Ads Experiment campaign data?
Yes, when you choose the Google Ads datasource and the campaigns metric in Dataslayer, the data from the campaign experiments implemented in Google Ads Experiment will also be loaded.Few readersWhere can I see my daily API calls and number of rows?
Here you can see your daily API calls and number of rows.
To see your daily API calls and number of rows, you have to login via our website. You have there a lot of information about your account. Select “My Activity” in the header menu and you will see a table with your daily API calls and number of rows per product.
![Header menu when you login in Dataslayer](https://storage.crisp.chat/users/helpdesk/website/5134c199Few readersHow Facebook Ads "Result" and "Cost per result" fields work in Dataslayer
The Facebook API and the Facebook Ads Manager console work in a different way, that's why sometimes the process to show the same information is different.
Unlike the Facebook Ads Manager console, the Facebook API does not have the "Result" and "Cost per result" metrics, since these metrics are created only in the Facebook Ads Manager to show the main results of each campaign.
Therefore, if a campaign has, for example, "Post engagement" as a goal, the "Result" field will show the result equivalFew readers“Internal Datasource error: Maximun quota exceeded”
Does the message “Internal Datasource error: Maximum quota exceeded” appear while you were using Dataslayer.ai?
This error comes from the data source, it is not a Dataslayer error. This error usually appear with Google Analytics, Google Search Console, YouTube... basically, Google data sources.
If you have been using your data source account to get a lot of data from another platform ( like Data Studio oFew readersI can’t find the metric or dimension I need
Please, tell us with what datasource you are working, through the Dataslayer chat button enable on the right low corner of the add-on or in our website.Few readersWhen do my daily API calls reboot?
Dataslayer‘s daily API calls reboot at 00:00 UTC time. Please check the current UTC time here to see at what time your daily API calls are going to reboot in your time zone.Few readersWhat happens if I change the Owner of My Company?
When changing the company owner in Dataslayer, only the ownership of the company will be transferred, and the Dataslayer plan will remain associated with the account with which it was paid, as for security reasons licenses and payments cannot be transferred automatically.
Therefore, the company owner's plan will be the one that applies to the rest of the company's components, regardless of whether any of its users have another plan purchased.
For this reason, it is important that the accouFew readersHow to create a company in Dataslayer
How do I create a company in Dataslayer?
To create a company, first log in to Dataslayer and go to "My Company" option.
Once there, you will see a box in which you must enter the name you want for your company and designate the owner (administrator) of your company.
Once you have filled all, click on "create" and you wFew readersHow to use external APIs with the JSON connector?
How to use external APIs with the JSON connector?
First, select the JSON/CSV/XML connector in Dataslayer.
Next, find the API you want to use at this link: https://dataslayer.ai/list-of-public-apis (you can also use other public APIs if you have the link).
For this example we will use the CoinStats API. Inside the Dataslayer, in the URL field, copy the "base endpoint" link, (in this case, https://api.coinstats.app/).
![](https://storage.crisp.chat/users/helpdesk/website/5134c19968a6bc00/imaFew readersWhy can't I login to Shopify?
Why can't I login to Shopify?
If when you try to connect to Shopify you get an error like this or similar:
it is most likely due to a misspelled store name, as Shopify URLs are not always spelled exactly the same as the store name.
The solution to this error is to write only the store name without the .myshopify.com extension, without spaces and without special characters.
To find out what you need tFew readersSolution to data discrepancy on Twitter
If you find large differences when comparing the data from the Twitter Ads platform with the Dataslayer data, it is possible that you have not included the audience data in the query settings.
To fix this problem, select the "Include Twitter Audience Data" option in the Dataslayer options section.
If the data discrepancy is still noticeable, please follow these steps: [I don’t get the same data, why is itFew readersHow do I accept permissions to view all my Google and Facebook accounts, pages and data sources in Dataslayer?
How do I accept permissions to view all my Google and Facebook accounts, pages and data sources in Dataslayer?
If when you run a query in Dataslayer there are pages or data from some accounts that you do not see, it is most likely because you did not accept all permissions when you added them.
To check if you have accepted all permissions, you must first log out of Dataslayer (don't worry, you won't lose your data). To do this, log out if you are using Google Sheets or revoke the connector iFew readers
