Cell reference in using Dump GoogleAnalytics

Support
#1

Hello guys,

I am trying to use SEO tools to set up automated reports, in particular to retrieve data from GA. I used the dump function which works perfectly fine if the neccessary info is inserted "by hand". Using cell references, the application gets a lot nicer in automation. However, I haven't figured out how to use the filter parameter as this seems to be limited to insert an entire string only:

Example:
Dump(GoogleAnalytics($A$2;"ga:transactions";$C2;$D$2$;"";"gaid::-1";"ga:campaign==CR-01-15-10-29";"";1;TRUE;TRUE;"DEFAULT"))

As account and dates are nicely referenced to another cell, I want to do the same for the filter, e.g. having the info in cell F2. Unfortunately, something as "ga:campaign==$F$2" does not provide any results. Is this limited to string only? Does anyone know a way to solve it?

I am thankful for all ideas and appreciate your help.

Regards,
Matthias

#2

Hi Matthias,

I found I could use the concatenate & outside of the quotes but still between the commas on filters like this:

   "ga:campaign=="&$F$2,

I'm stuck though on combining that with further filters. I've tried the following with no success:

"ga:campaign=="&$F$2&";ga:pagePath==/whatever/",
1 Like
#3

Actually, I've found my problem is specifically with using named cell references (like [@[Page Path]]) but using actual cell references works.

#4

Thank you very much for your quick suggestion. Helped me a lot. I could set up my sheet in the way in wanted to. Using the direct cell reference works perfect for me.

So far, I have only tried single filter in the dump. I assume multiple filters to work similar multiple dimensions. In this, I used ',' to separete instead of ';' but this might be due to that I use Excel in German...