Sync Google Ads data into BigQuery with Jitsu

Google Ads

BigQuery

Get Jitsu

Jitsu.Cloud is the easiest way to try out Jitsu. Pricing is volume based
Jitsu Open-Source edition is free and can be deployed with any infrastructure provider

About Google Ads integration

The Google Ads connector pulls data from Google Ads API. The connector is highly configurable.
You can compose any number of reports using Query Builder by importing field lists to this source as separate streams.

Developer Token requirement

Standalone Open-Source instances of Jitsu require a special Developer Token to work with Google Ads API.
Please read the official documentation from Google: Obtain Your Developer Token

Attention:
Developer Token is an application secret. It must not be exposed to anyone outside of your company.
It is highly recommended to set Developer Token in Jitsu Server config instead of UI form.
as yaml config variable:
google_ads.developer_token: abc123
or as environment variable:
GOOGLE_ADS_DEVELOPER_TOKEN=abc123

Cloud Jitsu version has its own embed Developer Token – no extra actions is required.

About BigQuery

Google BigQuery is a fast, scalable, and easy-to-use data warehouse. Main advantages of Google BiqQuery are:
  • Serverless architecture.
  • Pay-as-you go
Jitsu can stream and batch data to Google BigQuery. Streaming will get data to BQ immediately, however Google charges for each streamed record, while batching is free. Streaming is the fastest way to get started, but batching will be cheaper for large volumes.
© Jitsu Labs, Inc

2261 Market Street #4109
San Francisco, CA 94114