Need help with Excel Formula Syntax

#1

I'm trying to use the formula for search console to get clicks, impressions, etc. for bunch of queries in a specific column. I would like drag the formula down and get all the data that way.

However, when I input
=Dump(Connector("GoogleSearchConsole.SearchAnalytics","https://www.mywebiste.com/","2020-01-01","2020-12-31","query=A1
","web",0,"Clicks,Impressions,Ctr,Position",TRUE,1))
it is looking for the query "A1" instead of using the value in the cell A1.

What is the proper syntax so it uses the value in cell A1?

#2

Try:

=Dump(Connector("GoogleSearchConsole.SearchAnalytics","https://www.mywebiste.com/","2020-01-01","2020-12-31","query == " & A1
,"web",0,"Clicks,Impressions,Ctr,Position",TRUE,1))
#3

yes, that works. Thanks!