Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Creating a custom metric or dimension ======

In certain scenarios such as
  * Slicing campaign names
  * Using different conversion events from different platforms
  * Currency conversions
Will require you to add calculated metrics or new dimensions in data Studio

Here are two samples. One how to create a custom dimension and a second on how to create a custom metric.



==== Creating a custom metric ====

In this example we will do a currency conversion to have the costs all in the same format.

Click on ADD A FIELD

{{ :google_data_studio:add_a_field_datastudio.png?nolink&600 |}}


Then enter your formula

{{ :google_data_studio:custom_metric_google_data_studio.png?nolink&600 |}}

This sample multiplies the media costs by 0.77 to convert the accounts which are not in the default currency to the default.



<code>
CASE WHEN
Source in ("snapchat","google","bing","pinterest") then Amount Spent*0.77
ELSE Amount Spent
END
</code>



==== Creating a custom dimension ====

In this example we will do a new custom channel grouping. 

Click on ADD A FIELD

{{ :google_data_studio:add_a_field_datastudio.png?nolink&600 |}}


Then enter your formula

{{ :google_data_studio:custom-dimension-channel-grouping-data-studio.png?nolink&600 |}}

This sample checks the name of the source and then checks medium or campaign for certain patterns using a regular expression. If the regular expression is matched, the string is assigned. More information on [[https://support.google.com/datastudio/answer/7064476?hl=en|regular expressions]] in Data Studio



<code>
CASE
  WHEN source = "facebook" AND REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "Facebook - Remarketing"
  WHEN source = "facebook" AND REGEXP_MATCH(Campaign,"((?i).*Remarketing).*") THEN "Facebook - Remarketing"
  WHEN source = "facebook" AND REGEXP_MATCH(Medium,"((?i).*Cold).*") THEN "Facebook - Cold"
  WHEN source = "facebook" AND NOT REGEXP_MATCH(Campaign,"((?i).*Remarketing).*") THEN "Facebook - Cold"
  WHEN source = "facebook" AND REGEXP_MATCH(Medium,"((?i).*Cold).*") THEN "Facebook - Cold"
  WHEN source = "facebook" AND REGEXP_MATCH(Campaign,"((?i).*Cold).*") THEN "Facebook - Cold"
  WHEN source = "facebook" AND NOT REGEXP_MATCH(Campaign,"((?i).*Remarketing).*") AND NOT REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "Facebook - Cold"
  WHEN source = "google" AND REGEXP_MATCH(Campaign,"((?i).*Brand).*") AND REGEXP_MATCH(Campaign,"((?i).*Search).*") THEN "Google Ads - Search - Brand"
  WHEN source = "google" AND NOT REGEXP_MATCH(Campaign,"((?i).*Brand).*") AND REGEXP_MATCH(Campaign,"((?i).*Search).*") THEN "Google Ads - Search - Non - brand"
  WHEN source = "google" AND REGEXP_MATCH(Campaign,"((?i).*Youtube).*") AND REGEXP_MATCH(Campaign,"((?i).*Cold).*") THEN "Youtube - Cold"
  WHEN source = "google" AND REGEXP_MATCH(Campaign,"((?i).*Youtube).*") AND REGEXP_MATCH(Campaign,"((?i).*Remarketing).*") THEN "Youtube - Remarketing"
  WHEN source = "google" AND REGEXP_MATCH(Campaign,"((?i).*GDN).*") AND REGEXP_MATCH(Campaign,"((?i).*Cold).*") THEN "google - Display - Cold"
  WHEN source = "google" AND REGEXP_MATCH(Campaign,"((?i).*GDN).*") AND REGEXP_MATCH(Campaign,"((?i).*Remarketing).*") THEN "google - Display - Remarketing"
  WHEN source = "google" AND REGEXP_MATCH(Campaign,"((?i).*Shopping|Pla).*") THEN "Google Ads - Shopping"
  WHEN source = "snapchat" AND REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "Snapchat - Remarketing"
  WHEN source = "snapchat" AND NOT REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "Snapchat - Cold"
  WHEN source = "pinterest" AND REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "Pinterest - Remarketing"
  WHEN source = "pinterest" AND NOT REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "Pinterest - Cold"
  WHEN source = "tiktok" AND REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "TikTok - Remarketing"
  WHEN source = "tiktok" AND NOT REGEXP_MATCH(Medium,"((?i).*Remarketing).*") THEN "TikTok - Cold"
  WHEN source = "bing" AND REGEXP_MATCH(Campaign,"((?i).*Brand).*") THEN "Bing Ads - Brand"
  WHEN source = "bing" AND REGEXP_MATCH(Campaign,"((?i).*Shopping|Pla).*") THEN "Bing Ads - Shopping"
  ELSE "Other"
END
</code>


==== Further reading ====

The [[https://support.google.com/datastudio/answer/6299685?hl=en|Google Data Studio Help]] also lists further examples and has an explainer video:

{{ youtube>suAa8QtPBJY?large }}
Knowledge Base

User Tools

Site Tools

Page Tools
