Before you get started please ensure that you have Looker admin permissions and an active Funnel subscription.
Setup in Funnel
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, into Redshift for 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 Looker 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 LookML here.
Setup in Looker
- Head to the 'New connection' section of Looker and follow the instructions to configure the connection to your data warehouse: