Update Category Count
- Ben Clark
As we gather Category Information in a rule we should be saving the information against an individual so we can proactively use this to optimise decisions in the future.
This Public Template takes a Timestamp, the Alterian CXID and the Category Identifier and uses this to store information for use in the future by the following rules:
Read Category Access
Read Category Count
Read top Category count
It will also output the information directly into the Rule in which it is used.
This Public Template is available to all customers but must be used in conjunction with the Category Lookup rule and Get CXID. To use it, pull the Public Template into your Rule after you have created your Category Lookup Rule.
This rule simply uses any Category recieved from the Category Lookup Rule and the CXID from the Get CXID Public Template togather with our standard Timestamp field to store Category interactions against a user.
Input Data
Field | Description | Example |
|---|---|---|
Category | What Category was returned as the result of the Category Lookup. | Family |
AlterianCX_cxid | CXID Identifier provided by the Get CXID tile |
|
TimeStamp | This is created in almost every rule and should automap. Provides the Rule with the exact time this event occured to allow it to accurately increment the counts. |
|
Output Fields
Field | Description | Example |
|---|---|---|
Hour Count | How many times has the CXID been exposed to this Category in the last hour | 12 |
Hour Engagement Score | What’s the total engagement score generated by expose to this Category over the last hour | 50 |
Day Count | How many times has the CXID been exposed to this Category in the last 24 hours | 54 |
Day Engagement Score | What’s the total engagement score generated by expose to this Category over the 24 hours | 250 |
Total Count | How many times has the CXID been exposed to this Category in total | 452 |
Categories | What Category has this CXID been exposed to, viewed in frequency of order of view. In this example they have been to Default first, then Family and then Business. | default|family|business |
Top Total Count | When looking at the Top Total Category how many times was the Category Interacted with. | 253 |
Top Total Category | Which Category was interacted with most often over all time. The total number of interactions is Top Total Count. | Business |
Top Day Count | What’s the highest number of interactions against a single Category over the last 24 hours. | 23 |
Top Day Category | Which Category was interacted with most often over the last 24 hours. The total number of interactions is Top Day Count. | Family |
Top Hour Count | What’s the highest number of interactions against a single Category over the last hour. | 6 |
Top Hour Category | Which Category was interacted with most often over the last hour. The total number of interactions is Hour Day Count. | Terms and Conditions |