Is it possible to get the organic search query in web analytics when someone visits the page from Google search? As far as I know - not (even GA doesnt show it), but maybe you have a hack :P
Haha nice try
Unfortunately, I don’t have a hack. Google (as Facebook, as Twitter, etc) hides the URL the user clicked on before going to your website.
We still can count the amount of organic traffic from different platforms:
referrer_url SIMILAR TO '%https://(www.google.com|m.facebook.com|facebook.com|t.co)/%'
GROUP BY 1
Btw you still can see all the keywords stats in Google Search Console (Performance report > Queries):