Data Transformation

Learn more about working with the data in your Funnel account

Sven Hamberg avatar Nina Holtz avatar Peter Lundberg avatar +13
36 articles in this collection
Written by Sven Hamberg, Nina Holtz, Peter Lundberg and 13 others

How to use views in Data Explorer

You can save your selections in Data Explorer as a view. Allow your team members to get back to it at any time.
Daniel Vinntreus avatar
Written by Daniel Vinntreus
Updated today

Track follower metric across social platforms

How to track total and net new followers using Data Studio
Ishan Shekhar avatar
Written by Ishan Shekhar
Updated over a week ago

How to add your budget data to Funnel

Add marketing budget/target to Funnel using templates
Daniel Norén avatar
Written by Daniel Norén
Updated over a week ago

Schedule a google sheet function to run on a time interval

Google sheet troubleshooting
Ishan Shekhar avatar
Written by Ishan Shekhar
Updated over a week ago

How to create a data model to deduplicate data and avoid double-counting

Learn how to use custom dimensions for working with multiple data sources in Funnel representing the same origin source.
Sven Hamberg avatar
Written by Sven Hamberg
Updated over a week ago

Lookup Values from a Google Sheet

Learn how to use a rule to replace values using lookup from a google sheet
Daniel Vinntreus avatar
Written by Daniel Vinntreus
Updated over a week ago

How to use lookup tables when creating custom fields

Learn how to look up values for custom dimensions and metrics
Ouday Youzbashi avatar
Written by Ouday Youzbashi
Updated over a week ago

Funnel built-in fields

Ouday Youzbashi avatar
Written by Ouday Youzbashi
Updated over a week ago

Funnel is updating rules on custom dimensions and metrics with standard rules

Emma Bertilsson avatar
Written by Emma Bertilsson
Updated over a week ago

How to copy a dimension or metric

How to create a new dimension or metric based on one of your existing ones
Gustav Karlsson avatar
Written by Gustav Karlsson
Updated over a week ago

Renaming Fields

How to change the names of metrics and dimensions in Funnel
Nina Holtz avatar
Written by Nina Holtz
Updated over a week ago

How does currency conversion in Funnel work?

How you can manage currency conversions in Funnel automatically or manually
Nina Holtz avatar
Written by Nina Holtz
Updated over a week ago
Custom Dimensions

Custom dimensions explained - The Basics

What are custom dimensions?
Ross avatar
Written by Ross
Updated over a week ago

Working with custom dimension rule results

There are a number of ways to set and manipulate the results of your dimension rules.
Mark Tombs avatar
Written by Mark Tombs
Updated over a week ago

Create a Fiscal calendar in Funnel from a Google Sheet

Fiscal calendar, Fiscal year, Fiscal period, Fiscal Week
Daniel Norén avatar
Written by Daniel Norén
Updated over a week ago

Create your first Custom Dimension

Learn how to segment your data by setting up a simple custom dimension
Sven Hamberg avatar
Written by Sven Hamberg
Updated over a week ago

Funnel's standard custom dimension rules

The default behavior of the Traffic source, Media type, Campaign and Paid/Organic dimension rules
Simon Fransson avatar
Written by Simon Fransson
Updated over a week ago

Campaign dimensions in Funnel

This article describes the main campaign dimensions that exist in Funnel and how they are commonly used
Gustav Karlsson avatar
Written by Gustav Karlsson
Updated over a week ago

Different types of custom field rules

Learn about the different types of custom field rules that exist in Funnel and when to use them
Robert Åman avatar
Written by Robert Åman
Updated over a week ago

How to force Ad Campaign names into lowercase to match Google Analytics

Match GA and ad platform data on a campaign level by forcing all campaign names into lowercase
Nina Holtz avatar
Written by Nina Holtz
Updated over a week ago

How to use Text Splitting

Examples of how to use text splitting to match delimited dimension values in your data and extract specific fragments from those values.
John Johansson avatar
Written by John Johansson
Updated over a week ago

How to use regex matches

Examples how to use regular expression to find matching rows in your data or extract and capture specific parts or patterns.
Peter Lundberg avatar
Written by Peter Lundberg
Updated over a week ago

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.
Simon Kalicinski avatar
Written by Simon Kalicinski
Updated over a week ago

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
Simon Kalicinski avatar
Written by Simon Kalicinski
Updated over a week ago

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 metric "Attribution window".
Simon Kalicinski avatar
Written by Simon Kalicinski
Updated over a week ago

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.
Simon Kalicinski avatar
Written by Simon Kalicinski
Updated over a week ago