Skip to main content
All Collections
Data Transformation

Data Transformation

Learn more about working with the data in your Funnel account

How to use views in Data ExplorerYou can save your selections in Data Explorer as a view. Allow your team members to get back to it at any time.
Track follower metric across social organic platformsHow to track total and net new followers using Data Studio
How to add your budget data to FunnelAdd marketing budget/target to Funnel using templates
Schedule a google sheet function to run on a time intervalGoogle sheet troubleshooting
How to avoid double-countingLearn how to use custom dimensions to avoid inflated metric values when working with multiple data sources from the same origin in Funnel.
Lookup Values from a Google SheetLearn how to use a rule to replace values using lookup from a google sheet
How to use lookup tables when creating custom fieldsLearn how to look up values for custom dimensions and metrics
Funnel built-in fields
How to copy a dimension or metricHow to create a new dimension or metric based on one of your existing ones
Renaming FieldsHow to change the names of metrics and dimensions in Funnel
How does currency conversion in Funnel work?How you can manage currency conversions in Funnel automatically or manually
How to use naming conventions in FunnelThis article describe how to work with Funnels naming conventions feature.
Custom Dimensions

Custom dimensions explained - The BasicsWhat are custom dimensions?
Working with custom dimension rule resultsThere are a number of ways to set and manipulate the results of your dimension rules.
Create a Fiscal calendar in Funnel from a Google SheetFiscal calendar, Fiscal year, Fiscal period, Fiscal Week
What are "Dimensions" and how can I use them?
Campaign dimensions in FunnelThis article describes the main campaign dimensions that exist in Funnel and how they are commonly used
Different types of custom field rulesLearn about the different types of custom field rules that exist in Funnel and when to use them
How to force Ad Campaign names into lowercase to match Google AnalyticsMatch GA and ad platform data on a campaign level by forcing all campaign names into lowercase
How to use Text SplittingExamples of how to use text splitting to match delimited dimension values in your data and extract specific fragments from those values.
How to use regex matchesExamples how to use regular expression to find matching rows in your data or extract and capture specific parts or patterns.
How do I create a custom dimension based on dates?Learn how to group data by custom date ranges using the Date dimension as a foundation.
How do I use regex to capture a fixed amount of characters from dimension values?Learn how to specify a certain number of characters to be returned from native dimensions as values in a custom dimension
How do I build a custom metric for Facebook Ads based on click or view attribution only?Learn how to build a rules-based custom metric that makes use of the native Facebook Ads (by Meta) metric "Attribution window".
How do I use regex to identify dimension values that contain two specific sets of characters?Learn how to match or capture a dimension's values only if they contain two different strings at the same time.