Is there a trick to querying the Google Search Console on a keyword where the keyword contains an apostrophe (')? I’ve tried escaping with %27 but that doesn’t change the error.
- In cell A2:
bachelor's degree - In cell B2:
=Dump(Connector("GoogleSearchConsole.SearchAnalytics","https://domain.com/","2019-05-26","2019-08-25","query=="&A2&" country==USA","web",0,"Query,Country,Clicks,Impressions,Ctr,Position",TRUE,1000)) - Result:
#VALUE!
Rich