Relax! ItвЂ™s super easy! Using functionality in GSheets via the add-on itвЂ™s pretty much the same as using it in the GA interface, with a little added syntax. Relax! ItвЂ™s just RegEx: Using Filters to Customize Data ga:medium=~^organic$ ga:dayOfWeekName=~^Tuesday$ ga:country!~^United States$ ga:deviceCategory=~^mobile$.Continuing with the example above, hereвЂ™s what that Regex filter would look like if we queried the sessions metric: You can string multiple requests for data together in the filter parameter by using commas and semicolons to include or exclude certain search parametersДepending upon what data youвЂ™re pulling (metrics, dimensions, and/or a combination of the two), that can define how your filters work. Layering multiple inquiries, for instance: вЂњI want to find organic sessions that landed on my blog on a Tuesday, from users outside the US, on mobile devices.Doing a deep data dive over a long period of time.It can help you easily obtain the data you need when:

Whenever youвЂ™re trying to pull highly customized data from GA, this is your best friend. RegEx in the GA API Google Sheet add-on filter parameter works best in very focused use cases, particularly when youвЂ™re taking your data a step further and beyond вЂњsimpleвЂќ aggregate metrics. NOTE: Just to be clear, weвЂ™re talking about filters applied to data within the UI, not filters applied to views (one of my colleagues discusses filters over here )! What Are Some Use Cases Where RegEx Filters Can Help? Get a handle on the basics first and then come back to this post to really ramp up your GA reporting skills!) ( Tip: If you havenвЂ™t yet worked with the GA addon for Sheets and are a little intimidated - donвЂ™t be!Д¬heck out this post that demystifies the process and youвЂ™ll be on your way to using the GA API sheet to simplify your reporting life. ItвЂ™s quick, easy, and leaves you more time to interpret your data and use it to drive real conversations rather than unloading a full-blown data puke on your clients. The GA API sheets integration can help automate your reporting, cutting back on hours of tedious data pulling. Like rainbows and unicorn farts, the Google Analytics add-on for Google Sheets is a truly magical thing.

Or using a more advanced search filter with multiple criteria like this:ДonвЂ™t worry вЂ“ there is a way to do it! WeвЂ™re going to use RegEx to accomplish this. If you have previously worked with the Google Analytics API and Google Sheets integrations, you may have wondered how you can filter your data on an ad-hoc basis like you do in the interface with this search box:

Data toolbar regex filter