Analytics
1.8K members online now
1.8K members online now
Ask questions about filter set-up and issues with using filters in Google Analytics reports
 
Guide Me
star_border
Reply

Google Analytic Spreadsheet Add on - Filter

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello everyone,

 
Please suggest me how to get only organic traffic from GA to Google sheets using Google Analytic Spreadsheet Add on and that too date wise
 
I have done
 
Metrics ga:sessions
Dimensions ga:medium ga:date
Sort
Filters ga:medium==organic
 
But this setting is giving error " Invalid Dimension or Metric"
1 Expert replyverified_user

Re: Google Analytic Spreadsheet Add on - Filter

Top Contributor
# 2
Top Contributor
Try a comma between the dimensions:
Dimensions ga:medium,ga:date
Mike Sullivan, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

Re: Google Analytic Spreadsheet Add on - Filter

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

This didn't seem to work for me - is there any other solution for filters? I can't seem to get any filter to work without receiving an error.

 

**EDIT: I was trying to filter the ga:country dimension (I have both country and region dimensions, separated by a line return) by the United States and I was unsure how to address the space. I tried ga:country==UnitedStates and the html version ga:country==United%20States but this just came back with a blank data sheet. The only solution I've found so far was to do an AND statement to filter words that contain "united" and "states" (ga:country=@united;ga:country=@states). Is there an easier way to write this filter?