How to get these dimensions and metrics in your workspace? | What do you need? |
Submit a data request. See Request new data in Funnel. |
|
Grant Funnel access to your database
To allow Funnel to connect and retrieve data from your database, grant access to our service account:
Service Account:
funnel-customs-account@funnel-customs.iam.gserviceaccount.comRequired Role:
BigQuery Job User(includes thebigquery.jobs.createpermission)
If your system requires IP allow listing, reach out via support.
This will allow Funnel to securely connect to and query your database.
Share access details securely
Once access has been granted, share the following information via your data request:
Confirmation that the Funnel service account has access
The SQL query you’d like to run
Any additional connection or authentication details (if applicable)
You can securely provide these details by visiting your data request Status page and selecting Add Credentials for your request.
Example SQL query:
SELECT campaign_id, campaign_name FROM `dataset.table`
Avoid using SELECT * — specifying only the required fields ensures better performance and clarity.
Confirmation and testing
Once we’ve received your details and verified access, our team will:
Test the connection to your database
Validate your query and data structure
Set up your data request
Each SQL query you provide will be treated as its own data source within Funnel. If you require multiple datasets, submit a separate query for each one.