Standardise Gmail addresses 📧

Danny Roden
Danny Roden Administrator
edited December 2023 in Functions library

Standardise Gmail addresses [Cleansing]

This function is used to help standardise Gmail addresses for matching purposes. The function creates a normalised version of the input email address to help aid matching processes.

See below for a screenshot showing the logic definition and some sample output results:

As you can see, this function takes into account the 2x different methods users of Google's email service can use to create different email addresses associated to the same account (i.e. the use of dots / full stops before the '@' and also the use of the '+' suffix which some users use for email management).

The function also helps match individuals across the 'Googlemail' and 'Gmail' domains.

For further information on this function please check out @Akshay Davis's original post here (note the screenshots and attachment on the linked page relate to an earlier version of Data Studio).


This function is compatible with all instances of Data Studio from v2.1.11 onwards.