Funnel

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

1. <a href="https://help.funnel.io/connections-and-data/connect-your-advertising-data">Connect your data sources to Funnel</a>

2. Configure <a href="https://help.funnel.io/dimensions-and-metrics/dimensions/create-your-first-custom-dimension">dimensions</a> / <a href="https://help.funnel.io/dimensions-and-metrics/metrics/creating-a-custom-metric">metrics</a> (optional)

3. 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':

Please follow the links below to learn how to configure your desired data warehouse export in Funnel:

<a href="https://help.funnel.io/api-and-data-warehouse-connectors/google-bigquery-connector/export-data-to-google-bigquery">Google BigQuery</a>

<a href="https://help.funnel.io/api-and-data-warehouse-connectors/microsoft-azure-blob-storage-connector/microsoft-azure-blob-storage-configuration">Azure Blob Storage</a>

<a href="https://help.funnel.io/en/articles/3132650-how-to-export-data-to-snowflake">Snowflake</a>

1. <a href="https://help.funnel.io/api-and-data-warehouse-connectors/google-bigquery-connector/export-data-to-google-bigquery">Google BigQuery</a>
2. <a href="https://help.funnel.io/api-and-data-warehouse-connectors/amazon-s3-connector/export-data-to-amazon-s3">AWS S3</a>
3. <a href="https://help.funnel.io/api-and-data-warehouse-connectors/microsoft-azure-blob-storage-connector/microsoft-azure-blob-storage-configuration">Azure Blob Storage</a>
4. <a href="https://help.funnel.io/en/articles/3132650-how-to-export-data-to-snowflake">Snowflake</a>

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 <a href="https://help.funnel.io/api-and-data-warehouse-connectors/amazon-s3-connector/aws-lambda-function-for-redshift-import">Redshift</a> for example.

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.&nbsp;

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 <a href="https://docs.looker.com/data-modeling/learning-lookml/what-is-lookml" rel="nofollow noopener noreferrer" target="_blank">here</a>.

Head to the 'New connection' section of Looker and follow the instructions to  <a href="https://docs.looker.com/setup-and-management/connecting-to-db" rel="nofollow noopener noreferrer" target="_blank">configure the connection to your data warehouse</a>:

1. Head to the 'New connection' section of Looker and follow the instructions to  <a href="https://docs.looker.com/setup-and-management/connecting-to-db" rel="nofollow noopener noreferrer" target="_blank">configure the connection to your data warehouse</a>:

Prerequisites

Setup in Funnel

Data Warehouse setup

Generate the LookML code

Setup in Looker