Skip to main content

Programmers reference for Google Ads Reader

In TQL, the adapter is referenced in the Global namespace as Global.GoogleAdsReader.

Google Ads Reader properties

Property

Type

Default value

Notes

Auto token renewal

Boolean

True

Automatically refreshes the OAuth access token. When set to False, provide Access token manually.

Access token

Password

Only used when Auto token renewal is False.

Client ID

String

Required for OAuth authentication.

Client secret

Password

Required for OAuth authentication.

Refresh token

Password

Required for OAuth authentication.

Client customer ID

String

A single ID or comma-separated list of Google Ads customer IDs to read.

Manager ID

String

ID of the MCC when access is inherited from a manager account; not required for direct user access.

Tables

String

Semicolon-delimited list of report views to read; supports % wildcards. Do not modify when recovery is enabled.

Mode

Select list

  • Initial load

  • Incremental load

  • Automated

Automated performs an initial load and then incremental loads.

Sync type

Select list

  • Resync

  • Last position

Last position

Resync re-reads the full dataset at each poll. Last position resumes from the last saved checkpoint based on the incremental marker.

Incremental load marker

String

Date

Unique, strictly non-decreasing column used for incremental reads.

Start position

String

Initial checkpoint value. Use Table=Value per-table or %=Value to apply to all.

Polling interval

String

1d

Interval as integer+unit (d, h, m, s). Controls how often the reader polls for new data.

Thread pool count

String

0

Number of parallel threads. 0 specifies single-threaded operation.

The ThreadPoolCount value must be less than the number of available processors. For example, if the system has eight processors, set ThreadPoolCount to 7 or lower.

Connection pool size

String

20

Maximum number of active HTTP client connections.

Migrate schema

Boolean

False

When enabled during initial load, creates target tables based on the source schema.

Supported objects

The reader supports Google Ads “report” views (for example, CampaignStatsReport, AdGroupStatsReport, AudienceStatsReport, CustomerSearchTermInsight, KeywordStatsReport, AssetGroup%). Use the Tables property (with optional % wildcard) to select the required set.

Behavior & operations

  • Initial load reads historical data up to “now”, then stops.

  • Incremental load reads new data continuously using the Date marker.

  • Automated performs initial load, then switches to incremental.

  • The reader emits insert operations; configure the target for merge/upsert to handle late/recovered rows.