Prerequisites
Before you get started please ensure that you have Data Studio admin permissions and an active Funnel subscription.
Setup in Funnel
Configure dimensions / metrics (optional)
Setup the Data Warehouse Export
Once your sources are connected and you're happy with the dimensions and metrics (step 1 and 2), head to the 'Data Warehouse' section and click on 'New export':
Data Warehouse setup
Please follow the links below to learn how to configure your desired data warehouse export in Funnel:
If you choose to use the AWS S3 or Azure Blob Storage export, you might want to setup a transfer to a data warehouse, intoRedshiftfor example.
Generate the LookML code
Once you've scheduled your data warehouse export, you can generate LookML code based on the schema of your Funnel export. This gives you a great starting point for your Data Studio setup.
You can find it by going into your export setup in Funnel and clicking on 'Details' and then choosing LookML in the drop down menu 'Show fields as'
The generated LookML will match the dimensions, metrics and header options you've selected for your export.
You can read more about LookMLhere.
Setup in Data Studio
Head to the 'New connection' section of Data Studio and follow the instructions to configure the connection to your data warehouse:
