Data Transformation

Lookup Values from a Google Sheet

Learn how to use a rule to replace values using lookup from a google sheet

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

Written by Ouday Youzbashi
Updated over a week ago

Funnel built-in fields

Written by Ouday Youzbashi
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

Written by Gustav Karlsson
Updated over a week ago

How does currency conversion in Funnel work?

How you can manage currency conversions in Funnel automatically or manually

Written by Nina Holtz
Updated over a week ago

Create a Fiscal calendar in Funnel from a Google Sheet

Fiscal calendar, Fiscal year, Fiscal period, Fiscal Week

Written by Daniel Norén
Updated over a week ago

Custom dimensions explained - The Basics

What are custom dimensions?

Written by Ross
Updated this week

Create your first Custom Dimension

Learn how to segment your data by setting up a simple custom dimension

Written by Sven Hamberg
Updated this week

Working with custom dimension rule results

There are a number of ways to set and manipulate the results of your dimension rules.

Written by Mark Tombs
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

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

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

Written by Robert Åman
Updated this week

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

Written by Nina Holtz
Updated this week

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.

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.

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

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".

Written by Simon Kalicinski
Updated this week

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.

Written by Simon Kalicinski
Updated over a week ago

How do I create a dimension rule whose values are all text found between two specific characters?

Learn how to use regular expressions to extract a string found after one occurrence of a specific character and before its next occurrence.

Written by Simon Kalicinski
Updated over a week ago

What are the differences between a rule metric and a formula metric?

Learn the differences between custom metrics based on rules vs formulas

Written by Emma Bertilsson
Updated over a week ago

Creating a Custom Metric

Learn how to create your own metrics

Written by Peter Lundberg
Updated over a week ago

How are custom metrics calculated?

Understand more detail on when and how formula and rules are evaluated

Written by Peter Lundberg
Updated over a week ago

How can I calculate Cost from other metrics?

It is possible to use Custom Metrics that build on other metrics to build your monetary metric

Written by Peter Lundberg
Updated over a week ago

Create a metric from a dimension row & value

How to pivot/transpose metrics in Funnel

Written by Erik Lilja
Updated over a week ago

Why can I not calculate CPC in a rule?

Written by Peter Lundberg
Updated over a week ago

Renaming Fields

How to change the names of metrics and dimensions in Funnel

Written by Nina Holtz
Updated over a week ago

Funnel's standard metric rules

Default behaviour for Cost, Clicks and Impressions

Written by Peter Lundberg
Updated over a week ago

What are non-aggregatable metrics?

Learn about what we mean when talking about non-aggregatable metrics.

Written by Gustav Karlsson
Updated over a week ago

What happened to "Ad platform basic" metrics?

Funnel's Cost, Impressions, Clicks, CPC, CTR, CPM are upgraded to allow overriding these calculations

Written by Simon Fransson
Updated over a week ago