Google Ads + Google BigQuery

Send new Google BigQuery rows to Google Ads as offline conversions

Optimize your Google Ads performance with this efficient workflow. When a new row appears in your Google BigQuery dataset, it will immediately trigger an offline conversion in Google Ads. This process assists in getting the most out of your ads by providing valuable conversion data, saving you time and improving your ROI.

When this happens...
New Row
Triggers when a new row is added to a table. We know when a new row is added whenthe table is sorted by a column and the latest row is different from the previous latest row.
TriggerScheduled
automatically do this!
Send Offline Conversion
Sends events from your customer systems (PoS, CRM, email service provider, etc) to connect Google Ad campaigns to offline activity and business impact.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- ProjectRequired
- Dataset
- Table
Trigger
Scheduled
Try It
- Project IDRequired
- Job IDRequired
- LocationRequired
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
Action
Write
- Project IDRequired
- SQL QueryRequired
- Location
Action
Write

- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
- LimitRequired
Action
Search

- ProjectRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search or write
- Use Google Ads as...Required
- Managed Account
- Lead FormRequired
Trigger
Scheduled
Try It
- Use Google Ads as...Required
- Managed Account
- Customer ListRequired
- Customer IdentifierRequired
- Message
Action
Write
- Use Google Ads as...Required
- Managed Account
- ResourceRequired
- Dates to IncludeRequired
- Limit
Action
Write
- Double Opt Message
- Use Google Ads as...Required
- Managed Account
- Multiple Identifier Note
- Conversion User Identifier SourceRequired
- Conversion ActionRequired
- TimestampRequired
- Value
- Currency
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Use Google As...Required
Action
Search
- NameRequired
- Description
- Message
Action
Search or write

- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By ColumnRequired
- Unique ColumnRequired
Trigger
Scheduled
Try It
- Project IDRequired
- DatasetRequired
- TableRequired
- Unique ColumnRequired
- IS Operator
Trigger
Scheduled
Try It
- ProjectRequired
- DatasetRequired
- TableRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- RowsRequired
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Where ColumnRequired
- Where ValueRequired
- Update ColumnsRequired
Action
Write
- Project IDRequired
- DatasetRequired
- TableRequired
- Sort By Column
- Sort Direction
- Where ClauseRequired
Action
Search
- Project IDRequired
- Job IDRequired
- LocationRequired
Action
Search
New Campaign
Triggers whenever a new campaign is created in Google Ads.
Trigger
Scheduled
Try It
- Use Google Ads as...Required
- Managed Account
- Customer ListRequired
- EmailRequired
- Message
Action
Write
- NameRequired
- Description
- Message
Action
Write
- Use Google Ads as...Required
- Managed Account
- Customer ListRequired
- Customer IdentifierRequired
- Message
Action
Write
- StatusRequired
Action
Write
- Use Google As...Required
Action
Search
- NameRequired
Action
Search

About Google Ads

Google Ads (formerly Google AdWords) is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.