Google Ads Source

Renta supports data export from Google Ads to the following destinations:

  • Snowflake

  • Google BigQuery

  • Amazon S3

  • Clickhouse

  • SQL Server

  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Go to the 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 the necessary configuration:

Customer accounts

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

Report type

The report type consists of the unique set of parameters and metrics available for uploading to DWH. Each Report Type has its own parameters and metrics collection.

Parameters

Parameters contain the list of parameters and metrics available for export. Specify the parameters required for uploading.

As a result, Renta will create the table that will contain the selected parameters data. The order of the selected parameters in the Rentas interface will match to the order of the table columns.

Date range type

Choose the inserting period. You can specify any historical time interval.
To select the necessary time, enter the date from which you want to start uploading data in the "From" field, then enter the end date in the "To" field.
If you want the data in the table to be updated daily and supplemented with new days, then enter “Yesterday” in the “To” field.
Detailed instructions for working with a date range.

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.

The integration name is displayed on the Integration List page.

Table name

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

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

Update time

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

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

Integrations are updated according to the time zone selected in your profile settings.

Overwrite period

The data overwrite period is a retrospective data update for the selected period.
For instance, if 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 have been chosen.

Integration creating in Google Spreadsheets

Take advantage of the free extension available in the Google Workspace Marketplace.
To do it:

  1. Install the extension Renta Spreadsheets Add-on.

  2. Then go to Google Sheets and in the Tools tab select Renta

  3. Press the Run button.

After that, a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.