This document is for anyone connecting a Wicked Reports account to the Google Looker Studio Integration and wants to ensure they use the correct FunnelVision View fields in their Google Looker Studio report
Looker Studio retrieves data from Wicked Report FunnelVision daily, allowing you to use a Date Picker in your reports. However, since the data is not aggregated over the entire date range, some field values may not align with those in the Wicked Reports UI. This can result in certain fields being omitted from the Looker Data Source or differing due to daily data retrieval.
Additionally, some calculated fields cannot be summed across multiple days to match the UI representation and will need to be recreated as calculated fields within Looker Studio.
The chart below outlines which fields are included in the Data Source results and which are not.
Field Mappings
When using the Looker Studio connector with Wicked Report FunnelVision, you might find discrepancies between field names in Looker Studio and what you expect. We’ve provided a detailed field mapping list below to assist with these differences.
Field Mappings For Summary Data
In this section, we will cover how to align Looker Studio fields with those in Wicked Reports when using the filter dataSet = summary
in your reports. The term dataSet = summary
is used as a filter condition within Looker Studio reports. It specifies that only data from the Funnel Vision "summary" data set should be included in your report instead of the "grid" data within your Funnel Vision Report.
Field Mappings For Summary Data (Viewing Options):
Field Mappings For Grid Data
In this section, we will cover how to align Looker Studio fields with those in Wicked Reports when using the filter dataSet = grid
in your reports. The term dataSet = grid
is used as a filter condition within Looker Studio reports. It specifies that only data from the Funnel Vision "grid" data set should be included in your report instead of the "summary" data within your Funnel Vision Report.
Field Mappings For Summary Data (Viewing Options):