Overview

The Data Warehouse export to Google BigQuery automatically syncs the data in your Funnel account to Google BigQuery. All you have to do is connect your ad accounts to Funnel as usual, set up a BigQuery project with write access for Funnel and enable the export.

Export configuration

In Funnel, select "Data Warehouse" in the left hand side navigation and click the "New Export" button to setup a new export.

Choose Google BigQuery as the destination for your export and enter a name.

Google Cloud Project

You will need to grant Funnel access to your Google Cloud Project according to the article Google BigQuery Dataset configuration.

Funnel can automatically create a Dataset for you; this is enabled by default but can be configured. See linked article for more on this.

Enter the ID of your Google Cloud Project. 

Funnel will, by default, create a Dataset using the name of your account, so for instance with account name 'Showcase demo' the Dataset will be called  Funnel_export_showcase_demo.

Table options

Here you can select between multiple or single table export and change the name of the table(s) created.

We recommend using Single table when possible, read more in the article BigQuery Table_Options.

Test your BigQuery configuration

Once you have entered your details you should verify that everything is correctly set up by clicking the 'Test access' button.

Choose data to export

Next you should click the Choose fields... button in order to select which dimensions and metrics to include in your export. 

You can change the date range and restrict the data by changing the Date range and Filter data settings.

You can also choose to only export periods where the data has changed (recommended).

In the 'Choose currency' section you can decide if you want monetary values converted to a specific currency or use the original currency they are reported in. 

Finally choose a schedule for when the export should be run. When you are done, click 'Save’.

Enable the export

Once everything is set up you can review your configuration. If it looks good you need to toggle the Enabled switch in the top right hand corner. The first export will run according to the schedule you specified. In case you wish to verify that everything works as intended you can click the Run now button.

After a successful export, you can find your Funnel data in Google BigQuery.

Did this answer your question?