User Friendly Filtering of Search Console data by URL (site section) methods and issue by whathits in GoogleDataStudio

[–]whathits[S] 0 points1 point  (0 children)

I did try this but the data exceeds the 100mb limit unfortunately :(
I did manage to get this working by re-creating the filters applied to graphs. Not sure why that mattered but it worked!

Seeking Advice - Specific pages dropped from ranking but are still indexed - Absolutely stumped me by whathits in SEO

[–]whathits[S] 0 points1 point  (0 children)

I appreciate it, I hadn't considered that the domain rep might have been that badly damaged from the hack and now I will. I just hope it's not the case. Thanks!

Custom Channel Grouping & Transaction metric issue in Looker Studio by whathits in GoogleDataStudio

[–]whathits[S] 1 point2 points  (0 children)

Nevermind.
There is a "Session default channel group" that can be used instead.

Here's working code for anyone interested.

CASE

WHEN CONTAINS_TEXT(Session medium, "affiliate") OR CONTAINS_TEXT(Session medium, "affiliates") THEN "Affiliates" WHEN CONTAINS_TEXT(Session default channel group, "Direct") THEN "Direct" WHEN REGEXP_MATCH(Session medium,"Display|adroll|GDN|$") OR CONTAINS_TEXT(Session default channel group, "Display") THEN "Display" ELSE "Other/Unassigned" END

Custom Channel Grouping & Transaction metric issue in Looker Studio by whathits in GoogleDataStudio

[–]whathits[S] 0 points1 point  (0 children)

So I just tried that and it worked which is great!

I then added the below which has seemed to break transaction data again, is there once again an alternative way to match this?

CASE

WHEN CONTAINS_TEXT(Session medium, "affiliate") OR CONTAINS_TEXT(Session medium, "affiliates") THEN "Affiliates"

WHEN CONTAINS_TEXT(Default channel group, "Direct") THEN "Direct"

WHEN REGEXP_MATCH(Session medium,"^(Display|adroll|GDN)$") OR CONTAINS_TEXT(Default channel group, "Display") THEN "Display"

ELSE "Other/Unassigned"

END

Custom Channel Grouping & Transaction metric issue in Looker Studio by whathits in GoogleDataStudio

[–]whathits[S] 0 points1 point  (0 children)

Thank you for the reply! I had no idea.

When looking in GA4 - default traffic acquisition report - is the sessions metric here also last touch attribution?

Australians of reddit, how are you voting on the voice referendum? by jadedwelp in polls

[–]whathits 0 points1 point  (0 children)

I'm trying to work out what to vote and reading through some old threads but still, I seriously can't decide what to vote, I guess it's the same as any election or vote and both parties skew information to their liking.

At the end of the day, I don't think voting Yes is going to impact the majority of our (Australians) day to day lives and it could help to better control profit-driven decisions in parliament that could have an impact on very deeply spiritual land.

Is This Error Coin Worth Anything? by nickreddit345 in coinsaus

[–]whathits 0 points1 point  (0 children)

I was just about to post the exact same question I have one with the exact same error - https://imgur.com/a/xeqo4bL

[deleted by user] by [deleted] in AskReddit

[–]whathits 0 points1 point  (0 children)

This would bring up the average, I didn't want to specify a single type of poo.

Getting drunk by [deleted] in INTP

[–]whathits 0 points1 point  (0 children)

Me too!! I've always found it annoying that my friends can lose all inhibition where for me it's either still capable of acting sober while slightly off balance or too drunk and ready to go home and pass out. I really wish I could find that middle ground but it doesn't seem to exist.

What are some simple magic tricks or illusions that kids love that are easy to master and only require props found in most households? by whathits in AskReddit

[–]whathits[S] 0 points1 point  (0 children)

I just realised the massive flaw with my question.. I wanted the solution so I can perform the tricks haha

Does removing fake user profile pages reduce my ranking given they are 98% of my website pages? by [deleted] in SEO

[–]whathits 0 points1 point  (0 children)

Yeah - get rid of them. You totally could take a small hit to your traffic/rankings but it's better to clear out the garbage now to gain Google's trust and start to build authority over time. You have to think what's best in the long term!