Profile Aggregations are statistics related to a Profile that are automatically created & maintained by Omneo. Below are the available aggregations for a Profile record:
| Field | Description | |
| Id | A unique identifier assigned automatically upon record creation by Omneo. [String, foreign key (Profiles table)] e.g. 8ad465ea-4b2c-4d2a-bace-87b3a45f76a1 |
|
| Dimension Channel | Defined set of values to record the channels the Profile has shopped at - namely: CF = Freestanding locations only CO = Online store only CM = Multichannel, both freestanding & online. [Enum, system generated] |
|
| Dimension Frequency | Defined set of values to record the frequency of the Profiles shopping behaviour - namely: F0 = Never shopped F1 = Shopped once F2 = Shopped twice FL = Shopped +3 times & frequency between shops is greater than 30 days FH = Shopped +3 times & frequency between shops is less than 30 days [Enum, system generated] |
|
| Dimension Join | Defined set of values to record the Profiles join lifecycle stage: JN = New, where join date is less than or equal to 90 days ago JC = Current, where join date is greater than 90 days but less than or equal to 365 days ago J1 = represents 1 year, where join date is greater than 365 days but less or equal to 730 days J2 = represents 2 years, where join date is greater than 730 days but less or equal to 1095 days J3, J4, etc [Enum, system generated] |
|
| Dimension Recency | Defined set of values to record the recency of the Profiles shopping behaviour - namely: RO = Never shopped RC = Last shopped less than 3 months ago RS = Last shopped between 3 & 6 months ago RA = Last shopped between 6 & 12 months ago RI = Last shopped more than 12 months ago [Enum, system generated] |
|
| Join Hour | Hour of the day that the Profile joined/signed up converted to UTC hour. [Integer, system generated] e.g. 5 |
|
| Join Day | Day of the week that the Profile joined/signed up based on UTC timezone options of MON, TUE, WED, THU, FRI, SAT or SUN. [Enum, system generated] |
|
| Join Week | Week of the year that the Profile joined/signed up converted to UTC timezone. [Integer, system generated] e.g. 12 |
|
| Join Year | Year that the Profile joined/signed up converted to UTC timezone. [Integer, system generated] e.g. 2018 |
|
| Most Transacted Location ID | Represents the ID of the Location that the Profile has shopped the most in the last 2 years. If there are no transactions in the last 2 years then the aggregation assesses all Transactions. [Integer, system generated, foreign key (Locations table)] e.g. 112 |
|
| Shop Count | A count of the Profiles total transactions, where the transactions total value is greater than $0, thus removing return or exchange transactions. [Integer, system generated] e.g. 6 |
|
| Shop Days | Calculates the Profiles average number of days between transactions. [Integer, system generated] e.g. 64 |
|
| Spend 12 Months | Calculates the Profiles total spend in the last 12 months. [Decimal, system generated] e.g. 598.20 |
|
| Spend All | Calculates the Profiles total lifetime spend [Decimal, system generated] e.g. 2265.85 |
|
| Spend ATV 12 Months | Calculates the Profiles Average Transaction Value in the last 12 months. [Decimal, system generated] e.g. 121.40 |
|
| Spend ATV All | Calculates the Profiles lifetime Average Transaction Value in the last 12 months. [Decimal, system generated] e.g. 105.90 |
|
| Spend First Date | Records the date of the Profiles first transaction converted to UTC timezone. [Timestamp, system generated] e.g. 2017-03-31 22:28:32 |
|
| Spend Last Date | Records the last date of the Profiles transacted converted to UTC timezone. [Timestamp, system generated] e.g.2018-08-01 14:29:19 |
|
| Created At | The UTC date & time the Profile record was last updated in ISO 8601 format. [Timestamp, system generated] e.g. 2018-07-03 05:02:13 |
|
| Updated At | The UTC date & time the Profile record was last updated in ISO 8601 format. [Timestamp, system generated] e.g. 2002-01-31 13:43:41 |