Google Ads

Extract your Google Ads performance data and seamlessly load it into your preferred data warehouse with Renta. This integration simplifies the centralization of your marketing metrics, enabling advanced analytics and custom attribution modeling without manual intervention.

Authentication

To guarantee maximum security, Renta utilizes the standard OAuth 2.0 protocol for integrations. This establishes a secure connection without requiring you to expose your sensitive account passwords, granting Renta solely the permissions needed to retrieve your data.

Connect Google Ads source

Setting up the Google Ads integration takes just a few minutes. Follow this guide to authorize the connector and prepare your integration.

Go to Sources and add a new connectionStep 1

In the left sidebar, open Connections > Sources. Click + Add source in the top-right corner to open the catalog. Alternatively, go directly to Connections > Catalog.

Select Google Ads from the catalogStep 2

In the catalog, open the Sources tab and expand Advertising. Click the Google Ads card to start adding a new connection.

Authorize with your Google accountStep 3

On the Add a new Google Ads connection page, ensure the Configure tab is active. Read the notice that Renta requires limited access and that credentials will be encrypted. Click Log in to your Google Ads account to open the Google sign-in flow.

Add a new Google Ads connection page with Log in button

Choose your Google accountStep 4

On the Google sign-in screen, select the Google account that has access to the Google Ads manager or individual accounts you need. If your account is not listed, use Use another account.

Allow access to Google Ads dataStep 5

Review the requested permissions—Renta will be able to see, edit, create, and delete your Google Ads accounts and data for reporting. Click Allow to grant access.

Renta wants to access your Google Account

Name the source and saveStep 6

You will return to Renta with the connection authorized. Provide the following details:

Source name.
Enter a descriptive name for this connection (for example, your account or campaign name). This name is only used in the Renta interface.
Save connection.
Click Save to finish. The connector is ready to use in your data pipelines.

Set up your Google Ads connection - Source name and Save

Pipeline configuration

When creating a pipeline with the Google Ads source, you will need to configure the following settings:

Ad accounts

Choose one or more Google Ads accounts to extract data from. The available accounts are retrieved directly from the Google Ads API, including those accessible via manager accounts (MCC).

Report Types

Select the type of report, which determines the level of detail and the available fields (attributes, segments, and metrics).

Renta fully supports all reporting resources available in the official Google Ads API. This provides extensive analytical capabilities, giving you unrestricted access to the entire array of raw data without limitations.

Common report types include:

Report Type	Description
Ad Group Ad	Data at the ad level within ad groups.
Campaign	Data at the campaign level.
Ad Group	Data at the ad group level.
Customer	Data at the client account level.
Ad Group Criterion	Data for keywords and targeting criteria.
Keyword View	Performance data for keywords.
Geographic View	Performance data segmented by geographic location.

Parameters

Specify the exact fields (metrics, segments, and attributes) you want to include in your destination table. Your dataset structure is defined entirely by the parameters you select here.

The segments.date parameter is critical if you want to enable partitioning (keyed by segments_date) in your destination and for supporting incremental data loading.

Google Ads API returns cost metrics in micro-units. To get the actual currency amount for fields like metrics.cost_micros, you must divide the value by 1,000,000 in your analytical queries.

Date Range

Select the data extraction period. Renta allows you to extract historical data for any chosen timeframe without limitations.

Overwrite period

Specify the number of days to overwrite during an incremental load. This ensures data consistency and updates any late-arriving conversions.

This configuration setting is only available when the segments.date parameter is selected and partitioning is enabled.

Sync scheduling

Renta supports automatic scheduling, API triggers, and integration with external orchestrators such as Airflow, Dagster, and Prefect. See scheduling documentation for details.

Sync strategy

The following table describes the synchronization strategies used by Renta for Google Ads:

Strategy	Description
Incremental load	Renta will continuously synchronize your data incrementally as long as the `segments.date` field is selected in your parameters. Supported reports: Any report (with `segments.date` selected).
Full overwrite	Renta reloads the entire dataset during each sync since these reports represent configuration snapshots without temporal properties like dates, or lack a date parameter entirely. Supported reports: Any report (when `segments.date` is not selected).

Ready to get started?

Build your data pipeline today or get a personalized demo. Start free!

Need help?

Get expert support to ensure your project succeeds. We're here to help!

Feature requests?

Help shape our product! Share your ideas for new features and integrations.