Combine Facebook Referrals to One Row

Many analysts’ headache is Facebook referrals in Google Analytics. For some reason, Facebook has multiple referring domains that make no particular sense for an analyst. Instead of single facebook / referral in source / medium reports there are usually three rows for l.facebook, m.facebook and facebook.com:

facebook sources mess

There is a simple trick to combine them in a single row if you do not need such a detailed view. All you need is just a ‘Search and Replace’ filter in your view. Select Campaign Source as a Filter Field and replace all the sub-domains values with plain facebook.com.

Easy salvation

I didn’t manage to find the author of this trick so if you know where it originates from please share in a comment.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.