What is an API call?
In Dataslayer we want to base our pricing on usage, as we offer unlimited data sources, unlimited accounts and unlimited users. The way we measure the usage of the tool is through API calls. That's why our plans are differentiated by the number of daily API calls that can be made. 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,PopularAdd users to a company in Dataslayer
Do you want to share your subscription with other users? With Dataslayer it's very easy, you can share your plan with as many users as you want without additional costs Log in with that account on our website. Click on the "add user" button at the top, or go to the "my company" section and click on "nPopularHow 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 froPopularI don’t get the same data, why is it and how to solve it?
I don’t get the same data, why is it and how to solve it? To check if there is a data discrepancy, we need you to send us screenshots showing the following data: The results of the query in Dataslayer. The Dataslayer query configuration (metrics, dimensions, datSome readersShopify: 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 consideFew 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. IfFew 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 DataslayeFew 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 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 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 hereFew 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 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 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 readersHow to accept permissions on my data sources in Dataslayer?
Sometimes, when running a query, you might find that not all the accounts, pages or data showed up. You might also get an error message like the ones below: ➞ User has not accepted the required permissions when log-in ➞ Fail to authenticate, please check all permissions were accepted in Oauth2 screen In both scenarios, it is most likely not all necessary permissions were accepted when connecting to that data source.Few readersI can’t find the metric or dimension I need
Are you looking for a metric or dimension on one of our connectors but can't find it? Also, there are certain metrics which are called differently in the API and in the data source, since although they come from the same service, the API and the consoles are diFew 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 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 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 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 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: To find out whFew 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 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. (https://storage.crisp.chat/users/helpdesk/website/5134c199Few readersHow do the Reach and Frequency metrics work on Facebook?
Do you have discrepancies when calculating Reach or Frequency totals in your Facebook queries? It is possible that, if you sum the values of these metrics to get the total value, you will get something like this: Sum in Google Sheets: Results in Facebook Console:Few readersCustom Date Tricks in Dataslayer
Do you want to learn how to have more control over the time range in your queries? Here's how! If you use our tool for Google Sheets, API Query or BigQuery you probably know the option to define the date range of your query. You will see that there are 2 options to select the range: by calendar and by predefined fields. But did you know that there are also some hidden functions that our proFew readersGoogle My Business field changes in February 2023
In Feb 2023, certain fields in our Google My Business data source will be discontinued and new fields will be added. Some fields will also have slight changes in behavior. This is because Google is retiring some features of the Google Business Profile API (previously known as Google My Business) and dividing it into multiple new APIs. You can see more information about the changes in the official Google documentationFew readersBest TikTok Insights practices
Are you using our TikTok Insights connection but don't understand how it works at all? We are going to tell you how this integration works and some things about it that you may not know yet This means that, it doesn't matter the date range you've previously selected, every time you refresh your data, TikTok will return the current data you have at that moment for each metric.Few readers# Solution to the Woocomerce error: Unexpected Error Dictionary
Solution to the Woocomerce error: Unexpected Error Dictionary It is possible that when trying to add an account to our Woocomerce connector, you got the following error: Don't worry, we explain the solution here This error occurs because the store URL is not written in the correct format. You should not write the store URL in the format "store.com".Few readersWhy can't I see my Performance Max campaigns in Google Ads?
Why can't I see my Performance Max campaigns in Google Ads? Has it ever happened to you that when you make your queries in Google Ads or your Performance Max campaigns do not appear? Performance Max campaigns work differently than other campaigns in Google Ads. These campaigns are shown only if you make your query at campaign level. That is, if you add metrics or dimensions at the Ad Group or Ad level, Google wilFew readersHow does the "Media Reach" metric work in Instagram Insights?
How does the "Media Reach" metric work in Instagram Insights? The "Media Reach" metric in Instagram Insights works differently than other metrics, so you need to keep it in mind when generating your reports to avoid discrepancies. Why does this happen? It's a limitation of how Instagram's own API works, so it's something external to Dataslayer. Instagram only returns data per day, per week or per 28 days. With any oFew readersTwiter Insights: All you need to know
Twitter Insights has joined the Dataslayer connector team! Measure the organic performance of your tweets. Start analyzing your organic activities on Twitter or compare them with other social networks’ performance data. However, this connector has some particularities that you should know. Here we explain them so you can better understand how this connector works:Few readersInstagram Insights - How to solve the error “(#10) Application does not have permission for this action”
Instagram Insights - How to solve the error “(10) Application does not have permission for this action” Have you ever experienced this error when trying to add more accounts to Instagram Insights in Dataslayer? Don't worry, follow these steps to fix it: Log out from the connector and when you log in again click on “edit settings” and accept all pages. (https://storage.crisp.chat/users/helFew readers