Fetching unique pageviews with pagePath in column

#1

Hi, im trying to fetch unique pageviews for multiple URL:s but cant seem to figure out the formula.
All URL:s are in Column A, for example /ABC/.

Working formula: =Dump(GoogleAnalytics("ga:xxxx";"ga:uniquePageviews";"2019-03-21";"2019-03-27";;"gaid::-1";"ga:pagePath==/ABC/";;100;SANT;FALSKT;"DEFAULT"))
Mine that doesnt work: =Dump(GoogleAnalytics("ga:xxxxx";"ga:uniquePageviews";"2019-03-21";"2019-03-27";;"gaid::-1";"ga:pagePath==A2";;100;SANT;FALSKT;"DEFAULT"))

How do I get my formula to fetch the pagePath from Column A?

#2

Try:
=Dump(GoogleAnalytics("ga:xxxxx";"ga:uniquePageviews";"2019-03-21";"2019-03-27";;"gaid::-1";"ga:pagePath==" & A2;;100;SANT;FALSKT;"DEFAULT"))

#3

Works perfectly, thank you!