Treat an aggregate transformation as a data-flow step that groups input rows and calculates summary values. In a marketing-impressions flow, it calculates average bid price and CPM after dates are rolled up. section 6.3.2
Use the transformation when a summarized result is more useful than individual source rows:
- Read impressions from marketing.Impressions. section 6.3.2
- Normalize EventTime to a date before aggregation. section 6.3.2
- Calculate average bid price and CPM, then insert or update reporting.ImpressionAggregates. section 6.3.2
Marketing impressions
A Merge Aggregates data flow converts timestamped impressions into daily reporting rows. Its upsert destination inserts a new grouped result or updates an existing key combination. section 6.3.2
Figure 6.11 Aggregate Transformation Editor
Inspect the Aggregate Transformation Editor to follow the transformation’s configuration in the data flow. section 6.3.2
