Google Search Console Connector and Apostrophes


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","","2019-05-26","2019-08-25","query=="&A2&" country==USA","web",0,"Query,Country,Clicks,Impressions,Ctr,Position",TRUE,1000))
  • Result: #VALUE!



Nevermind. The trick is to escape the apostrophe with a backslash:

Eg: bachelor\'s degree


1 Like