Segmentation
These tables define segment rules, predictive modeling parameters, field aliases, and offline event queue processing.
| Tables | Description |
|---|---|
| cdpcampaignuseridentifier | Stores campaign user identifier data |
| dmpfliproutes | Stores flip routes |
| dmpnbamapping | Stores mapping of dmp and nba |
| dmpofflineeventqueue | Stores offline event queue info |
| dmppredictivesegment | Informs whether the segment is predictive or not, product associated with the segment and the model key |
| dmprtspredictiveparams | Stores rts predictive params |
| dmpsegment | Contains the rule associated with a segment and the query to
determine the number of users satisfying this rule. It also
stores the last published timestamp
(PublishedOn), the last user count refresh
timestamp (UserCountRefreshedOn), the
associated event IDs (DetectEventIds), and an
AI-generated segment description
(MaxAISegmentDescription). The
QueryType field supports additional values
including funnelSegment and
rtsd. |
| fieldaliastable | Contains the name of the field which need to be displayed on UI, the data point associated with UI field, data type of UI field. |
| segment | Provides information related to specific segment. This information includes Campaign ID associated with the segment, whether segment is active or not, whether segment is DMP or not |
| SegmentAggregateMapping | Stores the mapping between a segment's aggregate data and a
specific campaign. Contains segmentId,
aggregateName, and
campaignId. |
| PublishedAudienceCount | Records segment audience counts for a given segment
(SegmentId) at a specific date
(AudienceTrendsDate), with one record per
segment per calendar day. |