(If you get a 404 error, it’s because you’re not logged in to Google Analytics. If you’d like to include this report in your own reports, you can use this custom report I created. BUT the data is such a red-hot mess, you have to do some cleanup to get it all into nice, neat buckets. The data from these plugins populates to your Google Analytics account. To illustrate it, I’ll use an example from a chart I include in client dashboards** where they use the AddThis or ShareThis WordPress plugin. But, for now, this is what we have to work with. What Excel really needs is a CONTAINS function, so we don’t have to do these mental acrobats. Update: Based on questions I’ve received, I added the Misc Notes section to the end of this post.Ĭontinuing with our #FunctionFriday series, today we’re going to explore how to use the IF, SEARCH, and ISNUMBER functions together to find text (aka a string) inside other text for classification purpose.
