All Collections
Data Transformation
Custom Dimensions
How to force Ad Campaign names into lowercase to match Google Analytics
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

If you use filters in Google Analytics to force all UTM-tags into lowercase you can do the same for your ad campaigns in Funnel to match the data on a campaign level.

To match the data from your ad platforms with the data from your Google Analytics account on a campaign level the ad campaign name needs to be exactly the same as the 'utm_campaign' tag. If you use a filter in Google Analytics to force all UTM-tags into lowercase the ad campaign name and the UTM-campaign tag will never match. To solve this you can select to force all the ad campaign names into lowercase.

Navigate to Dimensions (found under Data Mapping in the left list) and click the default dimension "Campaign". Then click Edit in the right corner. 

In order to override the existing Standard rules and force the Ad Campaign name into lowercase, create a new rule under "For all Data Sources" by clicking "+ Rule with condition".

The rule that you want to create should pull all the different values from 'Ad Campaign name' (when they exist) and set the Campaign to the value of 'Ad Campaign name'.

Note that your Funnel Workspace might not have an 'Ad campaign name' dimension. If that is the case you can create one from a template.

To force the Ad Campaign name into lowercase, click the '+ More steps' button to the right of the then rule:

Add choose 'convert', 'to lowercase'. You can also truncate the value if you want. The final rule will look like this:

When 'Ad campaign name' is not empty, then Campaign is the value of the 'Ad campaign name' lowercase. 

This rule applies to all Data Sources in your Funnel Workspace.

Lastly, click Save in the top right corner. 

Did this answer your question?