Learn How to Use Regular Expressions (RegEx) to Create Filters in GA API Sheets

If you have previously worked with the GA 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:

Or using a more advanced search filter with multiple criteria like this:

Don’t worry – there is a way to do it!…

http://ift.tt/2pl2lLp

Comments

Post a Comment

Popular posts from this blog

Google at 20: Journeys, AI-driven results and visual search

Image
It’s hard to imagine a life without a search engine that knows what it’s doing. I remember the days of AltaVista and co, search engines that just dump random pages on you for every given query. I was so excited to see Google enter the scene and immediately do everything right — the results were great, it was fast and it had no ads. Didn’t take long before I was hooked. But a lot has happened in the past twenty years and a lot will happen in the next. Starting today, Google is looking to change search for the next twenty years. Google’s Future of Search Event On Monday, Google held a small event to celebrate its 20th anniversary and it took the opportunity to offer a sneak peek at the coming years. Google introduced three paradigm shifts in how it sees search in the future: A shift from answers to journeys A shift from queries to providing a queryless way to get information Plus a shift from text to a more visual way of finding information I’ll dive into this below. Changing how...
Read more

Yoast in 2017: Events we attended

Image
2018 is approaching rapidly. Time to look back at yet another awesome year at Yoast. A year in which we attended quite the number of conferences. In this post, we’ll give you an impression of a few of the conferences we have been to, cities we’ve visited and friends we’ve made! So, without further ado, these are the events we attended in 2017. Bring on 2018! Optimize your site for search & social media and keep it optimized with Yoast SEO Premium » $89 - Buy now » Info Kicking off the year As always, the new year hasn’t really started until we had our infamous Yoast New Year party. Turning the office into a dance hall, we partied with our closest friends as only Yoasters can party! There ain’t no party like a Yoast party! As always, the first conference of the season was PHPBenelux in Antwerp. We’re regulars at this conference because it always offers excellent talks by renowned speakers, amazing socials, and a unique theme. This year our developers when into ‘space’...
Read more

Google Patent on Structured Data Focuses upon JSON-LD

Image
In a search engine that answers questions based upon crawling and indexing facts found within structured data on a site, that search engine works differently than a search engine which looks at the words used in a query, and tries to return documents that contain the same words as the ones in the query; hoping that such a matching of strings might contain an actual answer to the informational need that inspired the query in the first place. Search using Structured Data works a little differently, as seen in this flowchart from a 2017 Google patent: In Schema, Structured Data, and Scattered Databases such as the World Wide Web , I talked about the Dipre Algorithm in a patent from Sergey Brin, as I described in the post, Google’s First Semantic Search Invention was Patented in 1999 . That patent and algorithm described how the web might be crawled to collect pattern and relations information about specific facts. In that case, about books. In the Google patent on structured data, we s...
Read more