Databases

Google BigQuery

A web service that enables interactive analysis of massively large datasets.

Explore tons of pre-built templates

Start automating common business processes immediately with tons of prebuilt templates.
You can use them as they are or customize them to suit your needs

Supported
Triggers, Searches, Filters, and Actions

Search

Find Campaign by Name

Finds a Google Ads Campaign whose names matches the provided input

Search

Find Customer List

Finds a customer list by name.

Trigger

New Campaign

Triggers whenever a new campaign is created in Google Ads.

Action

Remove Contact from Customer List

Removes a contact from a customer list.

Action

Add Contact to Customer List

Adds a contact to a customer list. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Action

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.

Action

Create Customer List

Creates a customer list in Google Ads Audience Manager.

Action

Create Customer List

Creates a customer list in Google Ads Audience Manager.

Action

Set Campaign Status

Sets the status of a Google Ads campaign.

Action

Add Contact to Customer List with Email

Adds a contact to a customer list using their email address. Note: It takes 6 to 12 hours for the customer list to be populated with contacts.

Available Datasets

Query

Runs a BigQuery SQL query and returns results if the query completes.

Table Data

Retrieves table data.

Table Information

Gets the specified table resource by table ID. This method does not return the data in the table, it only returns the table resource, which describes the structure of this table.

Frequently Asked Questions

What kind of credentials do I need to power up this connector?

You need the service account key JSON of your Google BigQuery Service Account.

How often can the data be updated?

As often as needed.

Are there any API limits that I need to be aware of?

None

How is the page size determined?

The Max Results parameter, set in the Details section of the connector, is the maximum number of rows of data to return per page of results. Setting Max Results to a smaller value, such as 1000, then paging through results, may improve reliability when the query result set is large. In addition to Domo's Max Results row limit, Google imposes a byte limit of 10 MB per page of results. If your row values contain a lot of data, you may have fewer rows per page returned in order to come under the byte limit.

Can I get my data from the selected locations?

You can specify the processing location in your Query report for storing your BigQuery data when you create a dataset. After you create the dataset, the location cannot be changed. Queries that run in a specific location may only reference data in that location. There are two types of locations: a regional location and a multi-regional location. For more information, visit Dataset locations.

My dataset returns an error "Too large to run." How can I retrieve large results for my query?

If you are expecting large results for your query, go to the Details section of the dataset. Select ALLOW LARGE RESULTS = Yes, and select the dataset name. Note: Your Google account must have Table creation permissions enabled in order to set ALLOW LARGE RESULTS to Yes.

Alternative Connectors

Ready to start automating?

Getting started with Easyflow is simple, secure and there's no installation required.

1. Choose your apps

Select and authorize the apps you want to sync.

2. Connect

Hundreds of prebuilt templates

3. Let it start!

Set it and forget it, Easyflow will take over from here!