4.5. What’s AUTO Aggregation in Looker Studio?

Auto aggregation happens when Looker Studio, or the data connector, decides the aggregation that should be applied to a field.

There are two instances when auto aggregation happens:

• When we use a data connector for a tool that has an API like Google Analytics
• When we use formulas that aggregate data on computed field level, Looker Studio applies auto aggregation on the resulting new field.

Auto aggregation saves us time since we don’t need to decide on how data should work in the background. But at the same time this removes the flexibility of transforming data since we cannot edit the aggregation method of an auto aggregated field.

We will be discussing some workarounds on auto aggregation in future lessons.

<aside> <img src="/icons/arrow-down-basic_blue.svg" alt="/icons/arrow-down-basic_blue.svg" width="40px" />

<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/f198202f-2d4c-4dd4-a450-58f6e3fb7a8b/abeb72bd-829f-44e6-b083-7e6fac3db8c7/icon-primary.svg" width="40px" /> Enroll in Looker Studio Masterclass →

</aside>

📩 Receive my weekly Looker Studio tips

🖇 Connect with me on LinkedIn

</aside>