The Data Warehouse connector for 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.
Within a BigQuery Dataset, Funnel will create one table per calendar month. This structure has been chosen to support the BigQuery wildcard queries that should allow you to select all your Funnel data with a single query, or look at only a single month or year more efficiently.
Funnel can automatically create a view for you that combines the monthly data. See 'Export configuration' for more on this.
To get started 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 below for more on this.
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.
Enter the details of your Google Cloud Project.
Funnel will, by default, create a Dataset using the name of your account, so for instance with account name 'Demo' the Dataset will be called
Funnel_export_Demo . This can be configured in advanced settings.
Funnel will also create a view that combines the data in all the monthly tables. This view is called
all_funnel_data_view by default; this name can be changed or turned off in advanced settings:
You can also use advanced settings to change the name of the monthly tables.
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 dimensions and metrics... button in order to select which dimensions and metrics to include in your export.
By default data from 2015 is exported but 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.
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.