Skip to content
sandadocs
Console Start free trial

Google Ads

Connect Google Ads to sanda: what to prepare, the fields the connection form asks for, and how its data lands in your warehouse.

View as Markdown

Connect Google Ads

  1. Open the catalogue. In the console, go to Data · Connections and press New connection.
  2. Choose Google Ads. It is listed under marketing and analytics; you can also search for it by name.
  3. Fill in the form. Enter the fields below. Credentials go straight to sanda’s sync engine and are never stored in sanda’s database.
  4. Choose what to sync. Pick the streams you want, and a sync mode for each. See choose what to sync.
  5. Run the first sync. sanda tests the connection, then lands each stream as a table in your warehouse.

Configuration fields

What the connection form asks for. Required fields are marked; the rest are optional.

Field Type Required Description
Google Credentials object Yes
Customer ID(s) string No Comma-separated list of (client) customer IDs. Each customer ID must be specified as a 10-digit number without dashes.
Customer Statuses Filter array No A list of customer statuses to filter on.
Start Date string No UTC date in the format YYYY-MM-DD. Any data before this date will not be replicated. (Default value of two years ago is used if not set).
End Date string No UTC date in the format YYYY-MM-DD. Any data after this date will not be replicated. (Default value of today is used if not set).
Custom GAQL Queries array No
Conversion Window integer No A conversion window is the number of days after an ad interaction (such as an ad click or video view) during which a conversion, such as a purchase, is recorded in Google Ads. Default 14.
Number of Concurrent Threads integer No The number of concurrent threads to use for syncing. Increasing this value may speed up syncs for accounts with many customers or streams. Adjust based on your API usage and rate limits. Default 3.

Something unclear or out of date? Tell us, and we will fix the page.