Data Studio
2.2K members online now
2.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Filters - Trying to filter email data and it is not pulling a source

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

I am trying to filter a data source.  On this specific account, we use a 3rd party email provider called Robly.  Last year when that channel was recording traffic into analytics it was "Robly.com / email" when looking at source/medium.  This year we have changed it to lowercase "robly.com / email". When entering the filter criteria whether i set the filter to Include->source->contains->Robly it does not filter in the results from last year. It does bring in this year's data under "robly"  Therefore I can not do year over year comparisons in data studio because it will not filter last year's data.  Any help or suggestions on this would be greatly appreciated.

 

Thank you,

Chris

Filters - Trying to filter email data and it is not pulling a source

Explorer ✭ ✭ ✭
# 2
Explorer ✭ ✭ ✭

 

I would suggest using a RegExp Contains and make the clause not be case sensitive using the (?i) flag.

 

((?i)robly\.com \/ email)

Re: Filters - Trying to filter email data and it is not pulling a source

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Thank you for the response. I tried adding that in exactly and it did not
work. I tried Include->Source->RegExp Contains->((?i)robly) as well and
had not luck there. Any other suggestions? Thank You

--


*Chris MonkaitisDirector of Marketing828-333-5147 <828-333-5147> ext 23*



[image: Realtech Webmasters]

Extraordinary Sites • Amazing Results

Filters - Trying to filter email data and it is not pulling a source

Explorer ✭ ✭ ✭
# 4
Explorer ✭ ✭ ✭

Did it return any results at all?

 

May need to try this: ((?i).*robly.*)

Re: Filters - Trying to filter email data and it is not pulling a source

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭
Yes, it returned the lowercase results from the current year, but not last
year's when source was uppercase.

--


*Chris MonkaitisDirector of Marketing828-333-5147 <828-333-5147> ext 23*



[image: Realtech Webmasters]

Extraordinary Sites • Amazing Results

Filters - Trying to filter email data and it is not pulling a source

Explorer ✭ ✭ ✭
# 6
Explorer ✭ ✭ ✭

Regex is not my area of expertise, but I think this "should" work:   ((?i).*robly.*)

 

I use the same Regex parameters in a report I have for GA Pages that have lowercase and uppercase and is working for me.

Filters - Trying to filter email data and it is not pulling a source

Explorer ✭ ☆ ☆
# 7
Explorer ✭ ☆ ☆

Hi @Chris M. I'd try Source matches RegEx "Robly.com|robly.com". This should do Robly.com OR robly.com.