Filters - Excluding data with filters

unread,

Jan 30, 2017, 8:07:45 PM1/30/17

to google-analytics-spreadsheet-add-on

Hi,

I made a query : ga:sourcemedium , and I want to exclude facebook sources such as "facebook.com / referral".

How do I proceed.

Thanks

unread,

Jan 31, 2017, 1:48:20 AM1/31/17

to google-analytics-spreadsheet-add-on

Hi.

Your query add filters this. "-ga:sourcemedium==facebook.com / referral"

thanks.

2017년 1월 31일 화요일 오전 10시 7분 45초 UTC+9, Joff 님의 말:

unread,

Jan 31, 2017, 2:35:52 AM1/31/17

to google-analytics-spreadsheet-add-on

Thanks for your answer.

Here's what I got :

Traffic referral test: Invalid value 'ga:sourcemedium=~referral;-ga:sourcemedium=~facebook.com' for filters parameter.

...

unread,

Jan 31, 2017, 7:20:41 AM1/31/17

to google-analytics-spreadsheet-add-on

In the filter, add ga:source!@facebook

unread,

Jan 31, 2017, 4:13:05 PM1/31/17

to google-analytics-spreadsheet-add-on

What I type in filters : ga:sourcemedium=~referral,ga:source!@facebook

What I get : All the sources ...

unread,

Feb 1, 2017, 4:03:18 AM2/1/17

to google-analytics-spreadsheet-add-on

If anyone wonders :

2 queries for 2 different rows works when 1 for 2 doesn't.

ga:medium=~referral;ga:source!~facebook ------> WORKING

ga:sourcemedium=~referral;ga:sourcemedium!~facebook ------> NOT WORKING

Reply all

Reply to author

Forward