Ascent360 Aggregates

The Ascent360 Platform calculates Customer Aggregates from your source system data. These fields can be extremely valuable for marketing! These "aggregated fields" are re-calculated each night with any new data that enters the system. 

Definition of Ascent360 Aggregates

Individual Aggregate: An individual aggregate is a derived field that is built at the individual level based upon other data related to that individual.

This is best explained through the following example: Sample customer  buys twice from your store and once from your eCommerce site. The first purchase was for $50 on January 1st, 2018. The second purchase was for $100 on January 15th, 2018, and the third purchase was for $200 on December 1, 2019. In total, John has made 3 purchases. Ascent360 would derive the following aggregates:

AggregateValue1
Total Lifetime Spend$350
Average Order Value
$116
Number of Purchases
3
Last Purchase Date01/01/2018
First Purchase Date12/01/2018


List of Standard Derived Variables and Aggregates

Below is a list of standard Derived Variables and Aggregates. Most of these will be implemented "Out of the Box" with every customer implementation. Some of these are industry specific such as "Count of Lift Scans This Season", which is exclusive to resorts that scan passes.

Alias Name (Friendly Name in the Ascent360 CDP)Description and NotesData Type
Days IndividualNumber of Days between Individual Create Date and Today.Integer or Number
Days CustomerThis is the difference between the Customer Create Date (the date of first attributed purchase) and today in days.Integer or Number
Days Customer LapseDays since the Last Implied Purchase Date.Integer or Number
Days Since Last PurchaseThe number of days since the Last Financial Purchase Date including self-reported dollars.Integer or Number
Average Order ValueThis is the Average Order Value of transactions including self-reported dollars.numeric
Average Order Value VerifiedThis is the Average Order Value of transactions of all verified transactions.numeric
Count of Lift Scans This SeasonThis is the total count of lift scans for a customer in the current season.Integer or Number
Count Custom Product PurchasedCount Custom Product Purchased.Integer or Number
Lapsed CustomerThis is a flag set to yes if the days since last purchase > 730 (2 years).Text
Likelihood to RecommendThis is the 0-10 value of likely to recommend (or NPS Score). This field requires a connected data source that provides back individuals' scores.Integer or Number
Last StoreThe last store where the customer made a transaction.Text
Preferred StoreThe store that the customer prefers shopping at -- determined by the most number of purchases at a store.Text
Birthday This YearAllows query of birthdays occurring this year.Date or Date with Timestamp
RFM additionThe addition of recency-frequency-monetary values. The highest score is "15".Integer or Number
Customer Create DateThe date an individual became a Customer (aka an individual's first purchase date)Date or Date with Timestamp
First Customer SourceThe source of an individual's first purchase.Text
Customer StatusStatus of either customer or prospect using financial transaction and implied purchases.Text
Resort LifestageLifestage person has because of their age group. Defined as the following:
  • 17 or Younger: age 17 or younger
  • Younger years: age 18 to 34
  • Family years: age 35 to 50
  • Mature years: age 51 to 99
  • Unknown: No age given

This field is not available for all client types.

Text
Resort Customer TypeResort customer type based off season pass bought in three years. This field is not available for all client types.Text
First Email Delivered DateThis is the date at which AscentCRM first sent email by client to the specific individual.Date or Date with Timestamp
Last Email Click DateThis is the date at which an email was last clicked by the individual.Date or Date with Timestamp
Last Email Delivered DateThis is the date at which an email was sent to the individual.Date or Date with Timestamp
Last Email Opened DateThis is the date at which an email was last opened by the individual.Date or Date with Timestamp
Number of Emails Clicked - Past 12 MonthsThis is the total number of emails Clicked by an individual over the past 12 months.Integer or Number
Number of Emails Clicked - LifetimeThe total number of emails clicked by an individual.Integer or Number
Number of Emails Opened - Past 12 MonthsThis is the total number of emails Opened on by an individual over the past 12 months.Integer or Number
Number of Emails Opened - LifetimeThe total number of emails opened by an individual.Integer or Number
Number of Emails Sent - Past 12 MonthsThe total number of emails sent to an individual over the past 12 months.Integer or Number
Number of Emails Sent LifetimeThe total number of emails sent to an individual.Integer or Number
Unsubscribe Date from EmailThe date at which the individual unsubscribed from email from any source.Date or Date with Timestamp
Individual Create DateThis is the first date an individual was created in the database.Date or Date with Timestamp
First SourceAn individual's first source.Text
Last Interaction DateThe last date an individual has "interacted" via email or transaction.Date or Date with Timestamp
Last Source DateLast Source Date (the last date an individual entered the database)Date or Date with Timestamp
Last SourceThe last source system an individual came into the database from.Text
Last Financial Purchase DateThe date the customer last made a purchase -- including self-reported purchases (i.e. product registration)Date or Date with Timestamp
Last Purchase Date VerifiedThe date the customer last made a purchase -- NOT including self-reported purchases (i.e. product registration)Date or Date with Timestamp
Last Implied Purchase DateSimilar to the Last Financial Purchase Date, but includes implied purchases.Date or Date with Timestamp
Number of Financial PurchasesA count of all purchases and self-reported purchases for an individual.Integer or Number
Number Transactions VerifiedA count of verified transactions for an individual.Integer or Number
Number of Implied PurchasesA count of implied purchases for an individual.Integer or Number
Frequency Score20% buckets of frequent customers. The best score is a "5".Integer or Number
Monetary Score20% bucket of top spend. The best score is a "5".Integer or Number
Recency Score20% buckets of recent customers. The best score is a "5".Integer or Number
RFM ScoreRFM scores in one field. The best score is a "555".Integer or Number
Spend in the Past 30 DaysTotal Spent by the customer over  the past 30 days.numeric
Spend in Past 12 MonthsTotal Spent by the customer over the past 12 months.numeric
Spend in the Past 60 DaysTotal Spent by the customer over the past 60 days.numeric
Spend in the Past 90 DaysTotal Spent by the customer over the past 90 days.numeric
Spend in Current Calendar YearTotal Spent by the customer in the current calendar year.numeric
Total Spent LifetimeThis is the sum of all known spend from all sources including self-reported purchases. Also called "LTV" (lifetime value) in marketing.numeric
Total Spent Lifetime VerifiedTotal spent by the customer on all verified transactions.numeric
Spend in Prior Calendar Year Total Spent by the customer in the previous calendar year.numeric

If you have any questions on aggregates, please contact us!