Appends an AGGREGATION of all the append activities that happened BEFORE the primary activity occurred.

Aggregate Before

Appends an AGGREGATION of all the append activities that happened BEFORE the primary activity occurred.

Learn more in video demo

Useful when you want to...

  • Enrich your dataset with the COUNT of all Calls Submitted before a Started Subscription (How many calls does it take per subscription?) (dataset example)
  • Enrich your dataset with the COUNT DISTINCT of all Session ad sources before the first purchase (Is there a media mix before first purchase?) (dataset example)
  • Enrich your dataset with the SUM of the revenue before an upgrade (Does revenue affect likelihood to upgrade?)

‍

SQL Query