Google Search Console Connector and Apostrophes

#1

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

#2

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

Eg: bachelor\'s degree

R

1 Like