How to add more than one extra dimensions and metrics from Google Analytics / how to loop over dimensions?

Matillion ETL
1

Based on the article here it's possible to add extra dimensions and metrics using the DefaultFilter in Connection Options. The issue is that it seems to only let you add one extra Dimension or Metric at a time. The article at the end mentions that if you want to add more dimensions, e.g. if I want to add Country and DeviceCategory to Events data, that I should use an iterator.

 

So really I have two questions:

 

  1. Is it possible to add extra dimensions/metrics without an iterator?
  2. If not, is there a guide on how to iterate over dimensions? A lot of the articles on this topic (e.g. loop and table iterators) seem to be about iterating over numeric values rather than string values

 

Any support on this is very much appreciated!

2

Hey @VM879619​

Thank you for posting a great question, would you like me to raise a support ticket on your behalf with our solution architects?

Let me know and I can arrange that for you.

Thanks Joe

3

Has this question been answered? Wondering the same thing.

4

There are two ways to add extra dimensions to your GA source:

  1. You can add them as comma separated in the Dimensions column. The example shown here only has one value, but you can put Dimensions="UserType,Year" and the output column will have comma separated values: https://documentation.matillion.com/docs/2775303
  2. You can add a whole new source with the dimensions and metrics you require: https://documentation.matillion.com/docs/7377063

 

Please note you'll always be limited to 7 dimensions and 10 metrics otherwise you'll have to use an iterator. Use a fixed iterator to iterate over values.