Skip to main content

Allocation Tier End Date

Tracks when a contact's allocation tier assignment ended, with current assignments defaulting to 2050-12-31 for easier database queries.

Updated over 2 weeks ago

Platform: Enolytics DTC

Summary:

What it is: Allocation Tier End Date shows when a contact's allocation tier assignment ended, with current tier assignments defaulting to 2050-12-31 to make database queries easier.

How to use it:
β€’ Track the lifecycle of your allocation program by analyzing when customers moved out of different tiers
β€’ Create reports showing allocation tier changes over time to understand program dynamics and customer progression

Tip: The 2050 default date for current allocations makes it simple to filter for active tier members using standard date range filters.

Note: Parts of this article were generated with AI and may not be perfect. If something looks off or could be better, click the 😞 below β€” it opens a quick chat so you can let us know.


Quick Stats:

  • Type: date


πŸ“ Description

Date when the contact's allocation tier assignment ended. Defaults to 2050-12-31 for current tiers to simplify BETWEEN joins.


βš™οΈ Technical Details

Type: date

Format: mm/dd/yyyy


ℹ️ Additional Details

  • Created: 2026-03-01T15:59:22Z

  • Key: [dimension].[Allocation Tier End Date]

  • ID: 8927e791-2d9c-549b-81ba-7e52571492a5


🏷️ Tags

  • Allocation Tier

  • Allocation Tier End Date

Did this answer your question?