What is an API call?
API calls in Google Sheets An API call is every time our extension needs to “call” the connector chosen (Facebook, Google Analytics, GooglePopular"Community Connector Error: Service Invoked Too Many Times for One Day"
In this article you will find the solution to the following Community Connector Error: Service invoked too many times This is a Google error related to the Google account you have connected to Looker Studio or Google Sheets. Each Google account has a daily quota for services. You can check the specific limits available per Google account at this link (https://developers.google.comPopularAdd users to a company in Dataslayer
Do you want to share your Dataslayer subscription with other users? You can share your plan with as many users as you want without additional costs You just have to follow these steps: To be able to add more users to your plan, you first need to create a company in Dataslayer. If you already have it, you can skip this step. Sign in with the account that created the Company on our website (httpPopularHow 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! Go to our website, select the tab "My issues" and click on ""Submit issue". Select the product, the data source you were using, and give us as much information as you can. OnPopularI 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? There are several reasons why there may be discrepancies. Before reporting the error, check the time zones, and if they are correct, also check the following: If you are using Facebook, check attribution settings. If you are usingSome 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 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 ➞ Request had insufficient authentication scopes In both scenarios, it is most likely not all necessary permissions were accepted when connecting to that data soSome 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. 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 readersI can’t find the metric or dimension I need
Are you looking for a metric or dimension in one of our connectors but can't find it? In this article we give you all the information about it and explain how to request it. The APIs and the data source consoles are different and independent products, soFew 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://developers.criteo.com/ and log into your account. Click the “Developer Portal” card (if needed). 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” iFew 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 readersHow to create a company in Dataslayer
Do you want to share your Dataslayer subscription with other users? You can share your license with unlimited users creating a Company! How to create a Company in Dataslayer Log in to our website with the email address that you want to be the Owner of the Company. A Company Owner is the only account that can manage and see statistics of the Company. This user should be the one that buys the license (which will be applied to all the CompanFew 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 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 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 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 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 to report a discrepancy in Dataslayer?
Please share the following screenshots with the support member that you are in contact with: The results of the query in Dataslayer. The Dataslayer query configuration (metrics, dimensions, date ranges, options...). The results of the same data from the original data source (showing the correct data). TFew 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 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 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 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 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 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 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 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 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 readersAttribution Settings for Facebook in Dataslayer
Learn how Facebook Attribution Settings work and the benefits of selecting the same settings in both Facebook and Dataslayer. What Facebook Attribution Settings are Attribution settings are a limited period of time for which conversions can be attributed to your ads and used to determine how to optimize the campaign. You can take a closer look at what it is and how it works here. Configure Attribution SettiFew readersHow does Shopify work in Dataslayer and how can I avoid discrepancies?
How does Shopify work in Dataslayer? The Shopify API and the Shopify console are different products, so they work differently in some aspects. What are the differences between Shopify API and Shopify Console? The main difference is that Shopify's API only returns data at an ORDERS level. In the Shopify's cFew 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 readersInformation about error code 429 in Google Trends
Have you ever experienced this error when using the Google Trends connector? Don't worry, here we explain everything you need to know about it. Google does not give much information about the causes of this error, since it sends directly from its servers the message that is displayed to the user when trying to make tFew readersHow do I update my credit card on Dataslayer?
Changing the credit card in Dataslayer is very simple. To do so, follow these steps: Go to our website and log in with your Dataslayer subscription account. Go to "My Subscriptions" section. If you are purchasing a plan for the first time, you will automatically be prompted for your card information. If you already have a purchased plan, click on "card details" to edit them. (https://storage.crisp.chat/usersFew readersLinkedIn Pages API field changes from February 2023
In February 2023, certain fields in our LinkedIn Pages data source will be discontinued and new fields will be added In June 2022, LinkedIn introduced API Versioning and new Content APIs to make it easier for developers to build with ease and manage API changes with predictability. With the new APIs, LinkedIn plan to sunset the unversioned APIs and legacy Content APIs (Shares API, UGC API) on February 28, 2023. You can learn more about API versioning at LinkedIn and the new Content APIsFew 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 readersHow can I request a metric or dimension in Dataslayer?
Can I request a metric or dimension I need? If you find a metric or dimension that is available in the datasource console but not in Dataslayer, and you want to know if it can be added, send us a screenshot of that metric or dimension in the original datasource and write to us via our web chat or via our email (mailto:info@dataslayeFew 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 readersWhat is sampling in Google Analytics?
What is data sampling in Google Analytics? In data analysis, sampling is the practice of analyzing a subset of all data in order to uncover the meaningful information in the larger data set. If you are analyzing a large data set, it can be difficult or expensive to uncover meaningful information from the entire dataset. Therefore, to make the process faster, easier, and more effective, Google Analytics will take a subset of your data for analysis through Data Sampling.Few readersSolution to Facebook error: Unsupported get request. Object with ID ' does not exist
Solution to Facebook error: Unsupported get request. Object with ID ' does not exist Have you ever got an error with the following text when making your queries on Facebook? Unsupported get request. Object with ID ' does not exist, cannot be loaded due to missing permissions, or does not support this operation. Please read the Graph API documentation at https://developers.facebook.com/docs/graph-api What causes this error? ThiFew readersUnderstanding Custom Metrics in Facebook Ads - Custom Conversions VS Custom Events
Are you working with Facebook Ads and want to know where to find custom conversions and custom events? When we work in the Facebook console we can see the custom conversions and custom events. Custom conversions and custom events on Facebook console But, where we can find this custom metrics on Dataslayer? Custom ConvFew readersWhat is an Early Access connector?
If you check the 40+ connectors we have available, you will see that some of them are in Early Access. What does this mean? At Dataslayer we want to give priority to our users so that you can be the first to use the new connectors.Few readersUnderstanding filters in Dataslayer
Do you have doubts about how filters work? Don't worry, in this FAQ you will learn the meaning of each filter. Google Sheets Filters Google Sheets Filters You will always start selecting the parameter you want to filter, in this case, we have selected the "Year" dimension but you can select any field (metrics or dimensions)Few readersBing Ads: Permissions issues guide
If you have you experienced a problem with the login in Bing ads or have gotten the error "The API is trying to access a service that your organization lacks a service principal for" and don't know how to proceed, this article will help you. Due to some changes in the authentication processes implemented in Microsoft in mid-2021, some users have had problems with the authentication process with the connector in Dataslayer. Example of a common error (https://storage.crisp.chat/users/heFew readersHow to set up an Account Admin
As an Owner of your company's plan, you can choose a user of your company to be an Account Admin. The Account Admin can also manage the company users and see their activity. What is the role of an Account Admin? As you may know, a Company Owner is the account that can manage and see statistics of the Company and manages the payment of the subscription (which is applied to all the Company), there can be only 1 Owner per Company. The Admin Account will have the same role as the OwFew readersUnderstanding the LinkedIn Pages new behavior
Have you noticed that you are missing data when using the "Date" metric, or any other strange behavior with the LinkedIn Pages connector? Since February 2023, LinkedIn Pages has changed its behavior and added new metrics and dimensions. See more info about this here. How does the new LinkedIn Pages connector work? Learn how this integration works and some things about it that you may not know yet.Few readersUnderstanding Youtube channels in Dataslayer
Have you added more users to manage your Brand Account channel but it does not appear when you log in on Dataslayer? Please take into account that our login in Youtube is made with the Google official login. What is a Brand Account in Youtube? It's an account specifically for your brand and different of your personal account that YouTube provides to those who want multiple people managing the channel in a company. It's also helpful to those who have multiple channels. You can learn mFew readersWhich accounts can be displayed in Instagram Public Data?
As you may know, in Dataslayer we use only the official APIs of each data source. Which accounts can I visualize with the official Instagram Public Data connector? The official Instagram Public Data API displays data from all business accounts. Instagram Public Data cannot display data from accounts thatFew readersUnderstanding the new behavior of Twitter Insights connector
As you may know, Twitter changed its API pricing policies and this affected Dataslayer's Twitter Insights connector. Because of that we made some changes on that connector, causing it to behave in a different way than you may be familiar with. But don't worry! Keep reading to understand all you need to know about the new behavior of this connector. How does the Twitter Insights connector work now?Few readersHow to create and set up a Twitter Ads account for Twitter Insights
As you may know, Twitter changed its API pricing policies and this affected Dataslayer's Twitter connectors. Because of that, in order to use our Twitter Insights connector, you will need to have a Twitter Ads account. But don't worry! Keep reading to learn how to set up a Twitter Ads account step by step. Creating and setting up a Twitter Ads account The first thing you have to do it's to complete your Twitter account profile. There are a few requirements that your account musFew readers