Prerequisites

Before you get started please ensure that you have Looker admin permissions and an active Funnel subscription. 

Setup in Funnel

1. Connect your data sources to Funnel

2. Configure dimensions / metrics (optional)

Once your sources are connected and you're happy with the dimensions and metrics, 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:

  1. Google BigQuery
  2. AWS S3
  3. Azure Blob Storage

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

  1. Head to the 'New connection' section of Looker and follow the instructions to  configure the connection to your data warehouse:
Did this answer your question?