Google Ads Source

Renta supports data export from Google Ads to following destinations:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets

Integration creating in data warehouse

  1. Go to integrations catalog;
  2. Select Google Ads;
  3. Add a Google Ads account that has the necessary data;
  4. Choose the added Google Ads account;
  5. Specify the destination you want to import the data into;
  6. Go to the settings screen and set necessary configuration:
  • Customer accounts

If there are many advertising accounts available, then you can choose the necessary one here.

  • Report type

Each Report Type has its own parameters and metrics collection.

Report type Description
Campaign performance

Contains stats about Criteo Dynamic Remarketing.
The complete list of parameters and metrics is available in the data structure section.

Transaction ID

Contains stats about all transactions
The complete list of parameters and metrics is available in the data structure section.

Facebook DPA

Contains stats from Facebook Dynamic Ads.
The complete list of parameters and metrics is available in the data structure section.

  • Parameters

Parameters are the dimensions and metrics that are available in Google Ads API. You should specify parameters that are necessary for inserting.

Renta will create the table, which will automatically update by the given update settings.

The order of the chosen parameters in Rentas interface will be equal to tables column sequence.

  • Data range type

Choose the inserting period. You can specify any historical time interval.

In order to choose the required time, enter the date you want to start uploading data from in the “From” field, then enter the end date in the “To” field.

If you want the data in the table to update daily and be complemented by new days, you can set “yesterday” in the “To” field.

  • Integration name

There is an auto generated name for your integration and here you can edit it as much as you like.

Both Cyrillic and Latin are permitted, but not more than 100 symbols.

  • Table name

There is an auto generated name for your table and here you can edit it as much as you like.

Only Latin is permitted, numbers and “_” symbol.

Data Updating

Following updating settings are available for Google Ads:

  • Update time

You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.

In that case your integration will update in period from 5 AM to 6 AM.

  • Overwrite period

Overwrite period means rewriting historical data for a specified period of time.

For instance you choose the overwrite period “Last 7 days” – it means that all data for the last 7 days will be deleted and inserted once again with updated data.

Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.

Data Structure

Report type Campaign performance

Parameters Description Type Data type
Impressions

Number of times your Criteo ad is displayed to a user on publishers’ websites.

Dimension INTEGER
Clicks Parameters description Dimension String
cost Parameters description Dimension Int
Currency Parameters description Dimension Int

Sales Pc

Parameters description Dimension String

Same Sales Pc

Parameters description Metrics Int

Sales Pc Nd

Products identificator appropriate to
ERP-system and
product feed
Dimension Array
For Google Sheets,
SQL Server: string

Какой-то репорт-тайп: 

[adwords_docs]

Report type TransactionID

Parameters Description Type Data type
Day Parameters description Dimension String
Campaign Name Parameters description Dimension String
Transaction date Parameters description Dimension Int

Report type Facebook DPA

Parameters Description Type Data type
Day Parameters description Dimension String
Clicks Parameters description Dimension Int

Quotes and limits

Important note: Renta doesn’t provide any restrictions like amount of accounts, connectors, integrations or inserting date range.

But different resources have their own quotes and limits that don’t depend on Renta.

Limits for Google Ads:

  • Paginated Requests – 10,000 rows per page
  • All with Basic Access – 15,000 API operations per day
  • Get Requests – 1,000 requests per day
  • Mutate Requests – 5,000 operations per request
  • Planning Service Requests – 1 QPS
  • Conversion Upload Service Requests – 2,000 conversions per request
  • Billing and Account Budget Service Requests – 1 operation per mutate request

Link to the official documentation:

https://developers.google.com/google-ads/api/docs/best-practices/quotas

_______________________________________________
If you have any questions – please contact us!