Sometimes data points that we are looking for aren't directly included in the data source, but can be found somewhere else within the values of other dimensions.
For example, let's imagine we'd like to report on Sessions per Affiliate ID, but we don't have the affiliate ID as a separate field in our data source.
- This could be any field, of course. I'm using Affiliate ID as an example.
However, we notice that there's an ?affid=1234 query parameter attached to the Landing Page URLs whenever the session was initiated by an affiliate. For example:
www.website.com/?affid=1234
In today's video, I'm going to show how to use Regular Expressions, or RegEx, to extract the Affiliate ID from the URL query parameter and store it in its own separate field in Looker Studio.
📩 Receive my weekly Looker Studio tips
🖇 Connect with me on LinkedIn