Google and their obfuscating keyword data

[FranticFish]

Am I the only one to notice that regular expressions have been broken in Analytics on the 'Acquisition > SEO > Queries' display for weeks now?
I have reported the issue on more than one account I manage. No reply, no action.

Now I find that you cannot edit out the (not set) data from a custom report.

At the risk of offending mods, would anyone care to share their favourite rank tracker tools and scrapers?

What methods to people use to join the dots when trying to work out what pages on their site bring traffic in and on what terms (you know, the stuff that any tuppeny-happeny free stats software used to do pretty well in the GOD)

[Robert Charlton]

FF - Regarding what pages on a site bring traffic and for what queries, I've found several articles that describe how to integrate analytics either with Excel or with Screaming Frog. I'm not sure whether this is what you're looking for, but here's a thread I have noted down which I believe has the latest information on using the new release of Screaming Frog. I have yet to try any of it. Please advise if it helps...

Issue on Integration of GSC and GA
Sept 2015
https://www.webmasterworld.com/google/4768686.htm [webmasterworld.com]

[FranticFish]

Thanks Robert, I'll check those out.

[JS_Harris]

If all you want is to know what keyword(s) are bringing traffic to which pages, and if it's from an image or web search, then go with Google's Webmaster Tools. The data is there anyway, you only need to sign in to see it, no tracking code required. Google is tracking your website with or without analytics.

In fact GWT has been upgraded of late, the new "compare" feature to show you the difference between your image traffic and web traffic is quite useful. I wouldn't go out and tear the analytics tracking code off your site(s) just yet though, if you rely on GWT you will get burned when they alter it further.

[FranticFish]

Problems with GSC:
1) you can filter on one text string, nothing even approaching a regular expression type query.
2) (not set) is not recorded at all.
3) you cannot set up scheduled / saved reports

Problems with Analytics
1) (not set) is at least included but you cannot filter it out using either the 'exactly matching' or 'containing' filters
2) all regular expressions return an error so now, when running reports, instead of one (or two) regular expression, I have to stack multiple 'includes' / 'excludes' filters.

They are both useful (as both have slightly different filtering options), but anything is more useful than nothing.

[Robert Charlton]

FranticFish... take a look at this current thread, which relates to my post above and may be helpful....

Unlocking Not-Provided Organic Keywords?
Jan 7, 2016
https://www.webmasterworld.com/google/4785309.htm [webmasterworld.com]

[FranticFish]

Thanks again Robert - I actually found that one already whilst browsing, and have BMd that and the linked article for further investigation.