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 1 API call, no matter how many accounts, metrics or dimensions you have selected.

For example, if you have a spreadsheet with 3 queries 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 calls daily.

You can also check how many API calls you are consuming, as well as your daily limit, at the bottom of the add-on:

Api calls in the add-on

API calls in Google Data Studio

In Data Studio, every time the connector needs to call the data sources API, is when you add or change a dashboard with new metrics, dimensions, widgets… And when you refresh it, it will count 1 API call for each graph, control or data table you have. Also, if you share the dashboard with your clients, every time they refresh the data or change an option in a control, it will consume API calls.

* If a query returns an error it DOES NOT count as an api call.
Was this article helpful?
Thank you!