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

**URL:** https://matillioncommunity.discourse.group/t/how-to-add-more-than-one-extra-dimensions-and-metrics-from-google-analytics-how-to-loop-over-dimensions/1166
**Category:** Matillion ETL
**Created:** [August 18, 2020, 8:03am UTC](https://matillioncommunity.discourse.group/t/how-to-add-more-than-one-extra-dimensions-and-metrics-from-google-analytics-how-to-loop-over-dimensions/1166 "2020-08-18T08:03:30Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![VM879619](https://avatars.discourse-cdn.com/v4/letter/v/8797f3/32.png) [@VM879619](https://matillioncommunity.discourse.group/u/VM879619)
#### Post date: [August 18, 2020, 8:03am UTC](https://matillioncommunity.discourse.group/t/how-to-add-more-than-one-extra-dimensions-and-metrics-from-google-analytics-how-to-loop-over-dimensions/1166/1 "2020-08-18T08:03:30Z")

</div>

Based on the article [here](https://documentation.matillion.com/docs/2775303) 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.

&nbsp;

So really I have two questions:

&nbsp;

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](https://documentation.matillion.com/docs/2235537) and [table](https://documentation.matillion.com/docs/2235537) iterators) seem to be about iterating over numeric values rather than string values

&nbsp;

Any support on this is very much appreciated!

---

<div class="post-metadata">

### Author: ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)
#### Post date: [August 19, 2020, 11:49am UTC](https://matillioncommunity.discourse.group/t/how-to-add-more-than-one-extra-dimensions-and-metrics-from-google-analytics-how-to-loop-over-dimensions/1166/2 "2020-08-19T11:49:22Z")

</div>

Hey [@VM879619](https://matillioncommunity.discourse.group/u/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

---

<div class="post-metadata">

### Author: ![JB273428](https://avatars.discourse-cdn.com/v4/letter/j/7ba0ec/32.png) [@JB273428](https://matillioncommunity.discourse.group/u/JB273428)
#### Post date: [January 18, 2021, 10:05pm UTC](https://matillioncommunity.discourse.group/t/how-to-add-more-than-one-extra-dimensions-and-metrics-from-google-analytics-how-to-loop-over-dimensions/1166/3 "2021-01-18T22:05:20Z")

</div>

Has this question been answered? Wondering the same thing.

---

<div class="post-metadata">

### Author: ![LauraMatillionProductManager](https://avatars.discourse-cdn.com/v4/letter/l/c0e974/32.png) [@LauraMatillionProductManager](https://matillioncommunity.discourse.group/u/LauraMatillionProductManager)
#### Post date: [January 19, 2021, 8:42am UTC](https://matillioncommunity.discourse.group/t/how-to-add-more-than-one-extra-dimensions-and-metrics-from-google-analytics-how-to-loop-over-dimensions/1166/4 "2021-01-19T08:42:39Z")

</div>

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

&nbsp;

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.
