All Collections
Data Connectors
How to connect to…
Connect the same source twice, with different dimensions
Connect the same source twice, with different dimensions

e.g. connect a Facebook Ad Account (by Meta) and analyze both by age and region but avoid double-counting spend

Ilona Norman avatar
Written by Ilona Norman
Updated over a week ago

Some data sources do not allow Funnel to collect data by any combination of dimensions. There may be only a certain number of pre-defined "reports" available in the API, or there may be limitations enforced in how dimensions may be combined.

One example of this is Facebook Ads, which allows looking at numbers by Age or by Region, but not by age and region in the same table.

These limitations are also reflected in the options when you connect the source to Funnel. Again using Facebook as an example, it may look like this.

Multiple connections to the same source

While Funnel will never be able to offer data granularity that does not exist at the source, you may create multiple connections to the same data, using different configurations. E.g., connect to the same Facebook Ad Account first with an Age breakdown, and then again with a Region breakdown. 

WATCH OUT!

The current default in Funnel is to always aggregate data for all sources unless explicitly told not to do so. This means you will get duplicate numbers if you connect the same source twice to the same Funnel Workspace, without explicitly filtering the data when you use it.

Strategies to avoid duplicate numbers / double-counting metrics

The following are some ways to work with multiple connections to the same source, with different dimensions/breakdowns.

1. Use separate Funnel Workspaces

By separating the different views of the data into different Funnel Workspaces you will not get duplicate numbers.

2. Toggle sources on/off
For ad hoc exploration of data, you can toggle the "Use in Funnel" switch, to make sure only one view of each source is active at any point in time

3. Filter on Custom Dimensions
If you still want export the data from a single Funnel Workspace you will have to create explicit filters to avoid duplicate numbers. One way of doing this is to create a Custom Dimension in Funnel for each breakdown and set the value to "Yes" only for the sources that contain this breakdown. E.g. create a Custom Dimension named "HasRegionData" and a dimension rule similar to this:

For a more comprehensive walkthrough of how to do this, see the article How to create a data model to deduplicate data and avoid double-counting.

Exporting the data

For exports to Data Warehouses, Google Sheets, create the Dimension as above and make sure it is part of the exported columns. You will then have to take the value of this dimension into account when filtering or running your queries against the data, or create filtered Views in your Data Warehouse.

Did this answer your question?