Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by Offer Performance | Interactive Channel by Offer Performance Summary | Offer ID | decimal | identifier | [Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Offer ID] |
Offer Name | characterLength16 | attribute | [Interactive Channel by Offer Performance Summary Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Interactive Channel by Offer Performance Summary Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Interactive Channel ID | decimal | identifier | [Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interactive Channel] |
Interaction Point ID | decimal | identifier | [Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Interaction Point] |
Presented | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Number of Times Presented][Interact Model].[Interactive Channel by Offer Number of Times Presented].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Elig Opps][Interact Model].[Interactive Channel by Offer Elig Opps].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance Summary Star Schema].[Interactive Channel by Offer Response History][Interact Model].[Interactive Channel by Offer Response History].[Rejected]) |
Interactive Channel by Offer Performance Last 14 Days | Offer ID | decimal | identifier | [Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Offer ID] |
Offer Name | characterLength16 | attribute | [Interactive Channel by Offer Performance by Day Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Interactive Channel by Offer Performance by Day Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Interactive Channel ID | decimal | identifier | [Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interactive Channel] |
Interaction Point ID | decimal | identifier | [Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Interaction Point] |
Actual Date | dateTime | attribute | [Interactive Channel by Offer Performance by Day Star Schema].[Calendar][Interact Model].[Calendar].[Actual Date] |
Presented | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Number of Times Presented by Day][Interact Model].[Interactive Channel by Offer Number of Times Presented by Day].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Elig Opps by Day][Interact Model].[Interactive Channel by Offer Elig Opps by Day].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Day Star Schema].[Interactive Channel by Offer Response History by Day][Interact Model].[Interactive Channel by Offer Response History by Day].[Rejected]) |
Interactive Channel by Offer Performance by Hour | Offer ID | decimal | identifier | [Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Offer ID] |
Offer Name | characterLength16 | attribute | [Interactive Channel by Offer Performance by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Interactive Channel by Offer Performance by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Interactive Channel ID | decimal | identifier | [Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Interaction Point] |
Hour | int64 | attribute | [Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Hour] |
Actual Date | dateTime | attribute | [Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Actual Date] |
Presented | float64 | fact | IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Number of Times Presented by Hour][Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour].[Presented Random]) |
Accepted | float64 | fact | IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by Offer Performance by Hour Star Schema].[Interactive Channel by Offer Respone History by Hour][Interact Model].[Interactive Channel by Offer Respone History by Hour].[Rejected]) |
Interactive Channel by Segment Performance | Interactive Channel by Segment Performancy Summary | Interactive Channel ID | decimal | identifier | [Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Interaction Point] |
Segment ID | decimal | identifier | [Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Segment ID] |
Segment | characterLength16 | attribute | [Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Segment] |
Presented | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Number of Times Presented][Interact Model].[Interactive Channel by Segment Number of Times Presented].[Presented Random]) |
Defaulted | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Times Defaulted][Interact Model].[Interactive Channel by Segment Times Defaulted].[Defaulted] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Times Defaulted][Interact Model].[Interactive Channel by Segment Times Defaulted].[Defaulted]) |
Accepted | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by Segment Summary Star Schema].[Interactive Channel by Segment Response History][Interact Model].[Interactive Channel by Segment Response History].[Rejected]) |
Interactive Channel by Segment Performance by Day | Interactive Channel ID | decimal | identifier | [Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point] |
Segment ID | decimal | identifier | [Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] |
Segment | characterLength16 | attribute | [Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Segment] |
Actual Date | dateTime | identifier | [Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] |
Presented | float64 | fact | IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Number of Times Presented by Day][Interact Model].[Interactive Channel by Segment Number of Times Presented by Day].[Presented Random]) |
Accepted | float64 | fact | IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Day Star Schema].[Interactive Channel by Segment Response History by Day][Interact Model].[Interactive Channel by Segment Response History by Day].[Rejected]) |
Interactive Channel by Segment Performance by Hour | Interactive Channel ID | decimal | identifier | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Interaction Point] |
Segment ID | decimal | identifier | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Segment ID] |
Segment | characterLength16 | attribute | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Segment] |
Hour | int64 | identifier | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Hour] |
Actual Date | dateTime | identifier | [Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Actual Date] |
Presented | float64 | fact | IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Number of Times Presented by Hour][Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour].[Presented Random]) |
Accepted | float64 | fact | IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by Segment by Hour Star Schema].[Interactive Channel by Segment Response History by Hour][Interact Model].[Interactive Channel by Segment Response History by Hour].[Rejected]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Cumulative Interactive Channel by Segment by Day
 | Cumulative Interactive Channel by Segment Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day] |
Cumulative Interactive Channel by Segment Response History by Day | | (shortcut) | | [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day] |
Last 14 Days Calendar | | (shortcut) | | [Interact Model].[Last 14 Days Calendar] |
|
Interactive Channel by Interaction Point Performance | Interactive Channel by Interaction Point Performance Summary | Interactive Channel ID | decimal | identifier | [Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point] |
Presented | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Number of Times Presented][Interact Model].[Interactive Channel by IP Number of Times Presented].[Presented Random]) |
Defaulted | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Times Defaulted][Interact Model].[Interactive Channel by IP Times Defaulted].[Defaulted] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Times Defaulted][Interact Model].[Interactive Channel by IP Times Defaulted].[Defaulted]) |
Accepted | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by IP Summary Star Schema].[Interactive Channel by IP Response History][Interact Model].[Interactive Channel by IP Response History].[Rejected]) |
Interactive Channel by Interaction Point Performance Last 7 Days | Interactive Channel ID | decimal | identifier | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point] |
Actual Date | dateTime | identifier | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Actual Date] |
Presented | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random]) |
Accepted | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected]) |
Interactive Channel by Interaction Point Performance Last 24 Hours | Interactive Channel ID | decimal | identifier | [Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Interaction Point] |
Hour | float64 | identifier | [Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Hour] |
Actual Date | dateTime | identifier | [Interactive Channel by IP by Hour Star Schema].[Interactive Channel - Last 24 Hours Lookup][Interact Model].[Interactive Channel - Last 24 Hours Lookup].[Actual Date] |
Presented | float64 | fact | IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Number of Times Presented by Hour][Interact Model].[Interactive Channel by IP Number of Times Presented by Hour].[Presented Random]) |
Accepted | float64 | fact | IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Hour Star Schema].[Interactive Channel by IP Response History by Hour][Interact Model].[Interactive Channel by IP Response History by Hour].[Rejected]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Dashboard | Dashboard Interactive Channel by Interaction Point Performance Last 7 Days | Interactive Channel ID | decimal | identifier | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Interaction Point] |
Actual Date | dateTime | identifier | [Interactive Channel by IP by Day Star Schema].[InteractiveChannelToCalendar][Interact Model].[InteractiveChannelToCalendar].[Actual Date] |
Presented | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Number of Times Presented by Day][Interact Model].[Interactive Channel by IP Number of Times Presented by Day].[Presented Random]) |
Accepted | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Accepted Random]) |
Rejected | float64 | fact | IF([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected] is missing)
THEN(0)
ELSE([Interactive Channel by IP by Day Star Schema].[Interactive Channel by IP Response History by Day][Interact Model].[Interactive Channel by IP Response History by Day].[Rejected]) |
|
Campaign by Cell Performance | Campaign Cell Performance Summary | Campaign ID | decimal | identifier | [Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Cell Performance Summary Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Cell Performance Summary Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Cell ID | decimal | identifier | [Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Cell Performance Summary Star Schema].[Cells][Interact Model].[Cells].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Cell Performance Summary Star Schema].[Cells][Interact Model].[Cells].[Cell Code] |
Presented | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Random] is missing)
THEN (0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Number of Times Presented][Interact Model].[Campaign Cell Performance Number of Times Presented].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Elig Opps][Interact Model].[Campaign Cell Performance Elig Opps].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted] is missing)
THEN(0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Rejected] is missing)
THEN(0)
ELSE([Campaign Cell Performance Summary Star Schema].[Campaign Cell Performance Response History][Interact Model].[Campaign Cell Performance Response History].[Rejected]) |
Campaign Cell Performance by Last 7 Days | Campaign ID | decimal | identifier | [Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Cell ID | decimal | identifier | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Code] |
Actual Date | dateTime | identifier | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Actual Date] |
Presented | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected]) |
Campaign Cell Performance by Last 24 Hours | Campaign ID | decimal | identifier | [Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Cell ID | decimal | identifier | [Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Cell Code] |
Hour | float64 | identifier | [Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Hour] |
Actual Date | dateTime | identifier | [Campaign Cell Performance by Hour Star Schema].[Cell - Last 24 Hours Lookup][Interact Model].[Cell - Last 24 Hours Lookup].[Actual Date] |
Presented | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected]) |
Campaign Cell Performance by Hour | Campaign ID | decimal | identifier | [Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Cell ID | decimal | identifier | [Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Cells][Interact Model].[Cells].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Cell Performance by Hour Star Schema].[Cells][Interact Model].[Cells].[Cell Code] |
Actual Date | dateTime | identifier | [Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Actual Date] |
Hour | int64 | identifier | [Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Hour] |
Presented | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Number of Times Presented by Hour][Interact Model].[Campaign Cell Number of Times Presented by Hour].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Elig Opps by Hour][Interact Model].[Campaign Cell Performance Elig Opps by Hour].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Hour Star Schema].[Campaign Cell Performance Response History by Hour][Interact Model].[Campaign Cell Performance Response History by Hour].[Rejected]) |
Campaign Cell Performance by Last 14 Days | Campaign ID | decimal | identifier | [Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Cell ID | decimal | identifier | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Cell Code] |
Actual Date | dateTime | identifier | [Campaign Cell Performance by Day Star Schema].[CellToCalendar][Interact Model].[CellToCalendar].[Actual Date] |
Presented | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Number of Times Presented by Day][Interact Model].[Campaign Cell Number of Times Presented by Day].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Elig Opps by Day][Interact Model].[Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected] is missing)
THEN(0)
ELSE([Campaign Cell Performance by Day Star Schema].[Campaign Cell Performance Response History by Day][Interact Model].[Campaign Cell Performance Response History by Day].[Rejected]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Cumulative Campaign Cell Performance by Day
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Cumulative Campaign Cell Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day] |
Cumulative Campaign Cell Performance Response History by Day | | (shortcut) | | [Interact Model].[Cumulative Campaign Cell Performance Response History by Day] |
Last 14 Days Calendar | | (shortcut) | | [Interact Model].[Last 14 Days Calendar] |
|
Campaign by Cell by Offer Performance | Campaign by Cell by Offer Performance Summary | Campaign ID | decimal | identifier | [Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Cell by Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Cell by Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Cell ID | decimal | identifier | [Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Cell by Offer Performance Star Schema].[Cells][Interact Model].[Cells].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Cell by Offer Performance Star Schema].[Cells][Interact Model].[Cells].[Cell Code] |
Offer ID | decimal | identifier | [Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Offer ID] |
Offer Name | characterLength16 | attribute | [Campaign Cell by Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Campaign Cell by Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Presented | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Number of Times Presented][Interact Model].[Campaign Cell by Offer Number of Times Presented].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Elig Opps][Interact Model].[Campaign Cell by Offer Elig Opps].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted] is missing)
THEN(0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Random] is missing)
THEN (0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Rejected] is missing)
THEN(0)
ELSE([Campaign Cell by Offer Performance Star Schema].[Campaign Cell by Offer Response History][Interact Model].[Campaign Cell by Offer Response History].[Rejected]) |
Campaign by Cell by Interaction Point Performance | Campaign Cell by Interaction Point Summary | Campaign ID | decimal | fact | [Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Cell by IP Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Cell by IP Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Cell ID | decimal | identifier | [Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Cell by IP Star Schema].[Cells][Interact Model].[Cells].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Cell by IP Star Schema].[Cells][Interact Model].[Cells].[Cell Code] |
Interaction Point ID | decimal | identifier | [Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Interaction Point] |
Presented | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Number of Times Presented][Interact Model].[Campaign Cell by IP Number of Times Presented].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Elig Opps][Interact Model].[Campaign Cell by IP Elig Opps].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Rejected] is missing)
THEN(0)
ELSE([Campaign Cell by IP Star Schema].[Campaign Cell by IP Response History][Interact Model].[Campaign Cell by IP Response History].[Rejected]) |
Campaign by Offer Performance | Campaign by Offer Performance Summary | Campaign ID | decimal | identifier | [Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Offer Performance Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Offer ID | decimal | identifier | [Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Offer ID] |
Offer Name | characterLength16 | attribute | [Campaign Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Campaign Offer Performance Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Presented | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Number of Times Presented][Interact Model].[Campaign Offer Number of Times Presented].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Elig Opps][Interact Model].[Campaign Offer Elig Opps].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Rejected] is missing)
THEN(0)
ELSE([Campaign Offer Performance Star Schema].[Campaign Offer Response History][Interact Model].[Campaign Offer Response History].[Rejected]) |
Campaign by Offer Performance by Last 7 Days | Campaign ID | decimal | identifier | [Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Offer by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Offer by Day Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Offer ID | decimal | identifier | [Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer ID] |
Offer Name | characterLength16 | attribute | [Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Offer Code 1] |
Actual Date | dateTime | identifier | [Campaign Offer by Day Star Schema].[OfferToCalendar][Interact Model].[OfferToCalendar].[Actual Date] |
Presented | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented])
|
Presented Model-Driven | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Number of Times Presented by Day][Interact Model].[Campaign Offer Number of Times Presented by Day].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Elig Opps by Day][Interact Model].[Campaign Offer Elig Opps by Day].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Rejected] is missing)
THEN(0)
ELSE([Campaign Offer by Day Star Schema].[Campaign Offer Response History by Day][Interact Model].[Campaign Offer Response History by Day].[Rejected]) |
Campaign by Offer Performance by Last 24 Hours | Campaign ID | decimal | identifier | [Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Offer ID | decimal | identifier | [Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer ID] |
Offer Name | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Offer Code 1] |
Hour | float64 | identifier | [Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Hour] |
Actual Date | dateTime | identifier | [Campaign Offer by Hour Star Schema].[Offer-Last 24 Hours Lookup][Interact Model].[Offer-Last 24 Hours Lookup].[Actual Date] |
Presented | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected]) |
Campaign by Offer Performance by Hour | Campaign ID | decimal | identifier | [Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Offer ID | decimal | identifier | [Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Offer ID] |
Offer Name | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Campaign Offer by Hour Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Hour | int64 | identifier | [Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Hour] |
Actual Date | dateTime | identifier | [Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Actual Date] |
Presented | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Number of Times Presented by Hour][Interact Model].[Campaign Offer Number of Times Presented by Hour].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Elig Opps by Hour][Interact Model].[Campaign Offer Elig Opps by Hour].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected] is missing)
THEN(0)
ELSE([Campaign Offer by Hour Star Schema].[Campaign Offer Response History by Hour][Interact Model].[Campaign Offer Response History by Hour].[Rejected]) |
Campaign by Offer by Cell Performance | Campaign by Offer by Cell Performance Summary | Campaign ID | decimal | identifier | [Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Offer Cell Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Offer Cell Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Offer ID | decimal | identifier | [Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Offer ID] |
Offer Name | characterLength16 | attribute | [Campaign Offer Cell Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Campaign Offer Cell Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Cell ID | decimal | identifier | [Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Cell ID] |
Cell Name | characterLength16 | attribute | [Campaign Offer Cell Star Schema].[Cells][Interact Model].[Cells].[Cell Name] |
Cell Code | characterLength16 | attribute | [Campaign Offer Cell Star Schema].[Cells][Interact Model].[Cells].[Cell Code] |
Presented | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Number of Times Presented][Interact Model].[Campaign Offer by Cell Number of Times Presented].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Elig Opps][Interact Model].[Campaign Offer by Cell Elig Opps].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Rejected] is missing)
THEN(0)
ELSE([Campaign Offer Cell Star Schema].[Campaign Offer by Cell Response History][Interact Model].[Campaign Offer by Cell Response History].[Rejected]) |
Campaign by Offer by Interaction Point Performance | Campaign by Offer by Interaction Point Summary | Campaign ID | decimal | identifier | [Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Campaign Offer by Interaction Point Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Campaign Offer by Interaction Point Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Offer ID | decimal | identifier | [Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Offer ID] |
Offer Name | characterLength16 | attribute | [Campaign Offer by Interaction Point Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Campaign Offer by Interaction Point Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Interaction Point ID | decimal | identifier | [Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Interaction Point] |
Presented | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented]) |
Presented Model-Driven | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Model-Driven]) |
Presented Random | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Random] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Number of Times Presented][Interact Model].[Campaign Offer by IP Number of Times Presented].[Presented Random]) |
Eligible Opportunities | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Eligible Opportunities] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Elig Opps][Interact Model].[Campaign Offer by IP Elig Opps].[Eligible Opportunities]) |
Accepted | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted]) |
Accepted Model-Driven | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Model-Driven] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Model-Driven]) |
Accepted Random | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Random] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Accepted Random]) |
Rejected | float64 | fact | IF([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Rejected] is missing)
THEN(0)
ELSE([Campaign Offer by Interaction Point Star Schema].[Campaign Offer by IP Response History][Interact Model].[Campaign Offer by IP Response History].[Rejected]) |
Campaign Interactive Offer Learning Details | Interactive Offer Learning Details | Campaign ID | decimal | identifier | [Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Interactive Offer Learning Star Schema].[Treatment Rule Inventory Campaign to Offer][Interact Model].[Treatment Rule Inventory Campaign to Offer].[Campaign Code] |
Offer ID | decimal | identifier | [Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Offer ID] |
Offer Name | characterLength16 | attribute | [Interactive Offer Learning Star Schema].[Offer][Interact Model].[Offer].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Interactive Offer Learning Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Attribute Name | characterLength16 | attribute | [Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Attribute Name] |
Attribute Value | characterLength16 | attribute | [Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Attribute Value] |
Likelyhood of Response | float64 | fact | [Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Likelyhood of Response] |
Predictability | int64 | attribute | [Interactive Offer Learning Star Schema].[Interactive Offer Learning][Interact Model].[Interactive Offer Learning].[Predictability] |
Channel_Campaign - Interactive Channel Deployment History | Interactive Channel Campaign - Interactive Channel Deployment History | Interactive Channel ID | decimal | identifier | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Interactive Channel ID] |
Campaign ID | decimal | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Campaign][Interact Model].[Campaign].[Campaign Code] |
Session ID | decimal | identifier | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Session ID] |
Session Name | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Session Name] |
Flowchart ID | decimal | identifier | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart ID] |
Flowchart Name | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart Name] |
Flowchart Deployment Type | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Flowchart Deployment Type][Interact Model].[Flowchart Deployment Type].[Flowchart Deployment Type] |
Audience Level | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Audience Level] |
Deployment ID | decimal | identifier | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment ID] |
Deployment Deploy Type ID | int64 | attribute | [Interact Model].[Interactive Channel Deployment History].[Deployment Deploy Type ID] |
Deployment Destination | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Destination] |
Deployment Server Group | int64 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Server Group] |
Production Group | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[isProduction][Interact Model].[isProduction].[Production Group] |
Deployment Type | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Deploy Type][Interact Model].[Deployment Type].[Deployment Type] |
StrategyID | decimal | identifier | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[StrategyID] |
Strategy Name | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Strategy Name] |
Deployment Owner | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Deployment Owner] |
Time of Deployment | dateTime | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Time of Deployment] |
Strategy Tab URL | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Strategy Tab URL] |
Flowchart Tab URL | characterLength16 | attribute | [Interactive Channel Deployment Star Schema].[Interactive Channel Deployment History][Interact Model].[Interactive Channel Deployment History].[Flowchart Tab URL] |
Channel Treatment Rule Inventory | Treatment Rule Inventory Summary | Treatment Rule ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Treatment Rule ID] |
Deployment ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Deployment ID] |
Interactive Channel ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Interactive Channel] |
Cell ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Cell ID] |
Cell Name | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Cell Name] |
Cell Code | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Cells][Interact Model].[Cells].[Cell Code] |
Zone ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone ID] |
Zone | characterLength16 | attribute | IF ([Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone] is NULL)
THEN ([Interact Model].[Treatment Rule Inventory].[All Zones] )
ELSE([Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Zone] ) |
Strategy ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Strategy ID] |
Strategy Name | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Strategy Name] |
Offer ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Offer ID] |
Offer Name | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Offer Name] |
Offer Code 1 | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Offer][Interact Model].[Offer].[Offer Code 1] |
Campaign ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign ID] |
Campaign Name | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign Name] |
Campaign Code | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Campaign Code] |
Segment ID | decimal | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Segment ID] |
Segment | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Segment] |
Marketing Score | int64 | fact | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Marketing Score] |
Enable State ID | int64 | identifier | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Enable State ID] |
Predicate State | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Predicate State][Interact Model].[Predicate State].[Predicate State] |
Predicate | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Predicate] |
Last Update Date | dateTime | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[Last Update Date] |
StrategyTab URL | characterLength16 | attribute | [Treatment Rule Inventory Star Schema].[Treatment Rule Inventory][Interact Model].[Treatment Rule Inventory].[StrategyTab URL] |
Interactive Channel Event Activity | Event Activity Peak Day All | | (shortcut) | | [Peak and Slow All].[Peak Day All] |
Event Activity Slow Day All | | (shortcut) | | [Peak and Slow All].[Slow Day All] |
Event Activity Peak Hour All | | (shortcut) | | [Peak and Slow All].[Peak Hour All] |
Event Activity Slow Hour All | | (shortcut) | | [Peak and Slow All].[Slow Hour All] |
Interactive Channel Event Activity | Channel Event Listing | Interactive Channel ID | int32 | identifier | [Interact Model].[Event Common].[Interactive Channel ID] |
Interactive Channel Name | characterLength16 | attribute | [Interact Model].[Event Common].[Interactive Channel Name] |
Category ID | int32 | identifier | [Interact Model].[Event Common].[Category ID] |
Category Name | characterLength16 | attribute | [Interact Model].[Event Common].[Category Name] |
Event ID | int32 | identifier | [Interact Model].[Event Common].[Event ID] |
Event Name | characterLength16 | attribute | [Interact Model].[Event Common].[Event Name] |
Total Occurrences | int32 | fact | IF ([Interact Model].[Event Common].[Occurrences] is missing)
THEN (0)
ELSE ([Interact Model].[Event Common].[Occurrences]) |
Channel Event Activity 7 Days | Interactive Channel ID | int32 | identifier | [Interact Model].[Event Common by Day].[Interactive Channel ID] |
Interactive Channel Name | characterLength16 | attribute | [Interact Model].[Event Common by Day].[Interactive Channel Name] |
Category ID | int32 | identifier | [Interact Model].[Event Common by Day].[Category ID] |
Category Name | characterLength16 | attribute | [Interact Model].[Event Common by Day].[Category Name] |
Event ID | int32 | identifier | [Interact Model].[Event Common by Day].[Event ID] |
Event Name | characterLength16 | attribute | [Interact Model].[Event Common by Day].[Event Name] |
Actual Date | date | attribute | [Interact Model].[Event Common by Day].[Actual Date] |
Occurrences | int32 | fact | IF ([Interact Model].[Event Activity Day].[Occurrences] is missing)
THEN (0)
ELSE ([Interact Model].[Event Activity Day].[Occurrences]) |
Peak Day | date | attribute | [Interact Model].[Peak Day].[Peak Day] |
Max Occurrences | int32 | fact | [Interact Model].[Peak Day].[Max Occurrences] |
Slowest Day | date | attribute | [Interact Model].[Slow Day].[Slowest Day] |
Min Occurrences | int32 | fact | [Interact Model].[Slow Day].[Min Occurrences] |
Channel Event Activity 24 Hrs | Interactive Channel ID | decimal | identifier | [Interact Model].[Event Common by Hour].[Interactive Channel ID] |
Interactive Channel Name | characterLength16 | attribute | [Interact Model].[Event Common by Hour].[Interactive Channel Name] |
Category ID | decimal | identifier | [Interact Model].[Event Common by Hour].[Category ID] |
Category Name | characterLength16 | attribute | [Interact Model].[Event Common by Hour].[Category Name] |
Event ID | decimal | identifier | [Interact Model].[Event Common by Hour].[Event ID] |
Event Name | characterLength16 | attribute | [Interact Model].[Event Common by Hour].[Event Name] |
Actual Date | date | attribute | [Interact Model].[Event Common by Hour].[Actual Date] |
Hour | float64 | attribute | [Interact Model].[Event Common by Hour].[Hour] |
Occurrences | float64 | fact | IF ([Interact Model].[Event Activity HR].[Occurrences] is missing)
THEN (0)
ELSE ([Interact Model].[Event Activity HR].[Occurrences]) |
Peak Day | date | attribute | [Interact Model].[Peak Hour].[Peak Day] |
Peak Hour | int64 | attribute | [Interact Model].[Peak Hour].[Peak Hour] |
Max Occurrences | float64 | fact | [Interact Model].[Peak Hour].[Max Occur] |
Slowest Day | date | attribute | [Interact Model].[Slow Hour].[Slowest Day] |
Slowest Hour | int64 | attribute | [Interact Model].[Slow Hour].[Slowest Hour] |
Min Occurrences | float64 | fact | [Interact Model].[Slow Hour].[Min Occur] |
Common Views | Campaign View | | (shortcut) | | [Interact Model].[Campaign] |
Calendar View | | (shortcut) | | [Interact Model].[Calendar] |
Time View | | (shortcut) | | [Interact Model].[Time] |
Last 24 Hours View | | (shortcut) | | [Interact Model].[Last 24 Hours Lookup] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Common | Campaign | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CAMPAIGN].[CAMPAIGNID] |
Campaign Name | characterLength16 | attribute | [InteractDTDS].[UARI_CAMPAIGN].[NAME] |
Description | characterLength16 | attribute | [InteractDTDS].[UARI_CAMPAIGN].[DESCRIPTION] |
Campaign Code | characterLength16 | attribute | [InteractDTDS].[UARI_CAMPAIGN].[CAMPAIGNCODE] |
Objectives | characterLength16 | attribute | [InteractDTDS].[UARI_CAMPAIGN].[OBJECTIVES] |
Last Run Date | dateTime | attribute | [InteractDTDS].[UARI_CAMPAIGN].[LASTRUNDATE] |
Initiative | characterLength16 | attribute | [InteractDTDS].[UARI_CAMPAIGN].[INITIATIVE] |
Created Date | dateTime | attribute | [InteractDTDS].[UARI_CAMPAIGN].[CREATEDATE] |
Start Date | dateTime | attribute | [InteractDTDS].[UARI_CAMPAIGN].[STARTDATE] |
End Date | dateTime | identifier | [InteractDTDS].[UARI_CAMPAIGN].[ENDDATE] |
Offer | Offer ID | decimal | identifier | [InteractDTDS].[UARI_OFFER].[OFFERID] |
Offer Name | characterLength16 | attribute | [InteractDTDS].[UARI_OFFER].[NAME] |
Offer Description | characterLength16 | attribute | [InteractDTDS].[UARI_OFFER].[DESCRIPTION] |
Offer Code 1 | characterLength16 | attribute | [InteractDTDS].[UARI_OFFER].[OFFERCODE1] |
Offer Code 2 | characterLength16 | attribute | [InteractDTDS].[UARI_OFFER].[OFFERCODE2] |
Offer Code 3 | characterLength16 | attribute | [InteractDTDS].[UARI_OFFER].[OFFERCODE3] |
Offer Code 4 | characterLength16 | attribute | [InteractDTDS].[UARI_OFFER].[OFFERCODE4] |
Offer Code 5 | characterLength16 | attribute | [InteractDTDS].[UARI_OFFER].[OFFERCODE5] |
Cells | Cell ID | decimal | identifier | [InteractDTDS].[UARI_CELLS].[CELLID] |
Cell Name | characterLength16 | attribute | [InteractDTDS].[UARI_CELLS].[CELLNAME] |
Cell Code | characterLength16 | attribute | [InteractDTDS].[UARI_CELLS].[CELLCODE] |
Control Cell ID | decimal | identifier | [InteractDTDS].[UARI_CELLS].[CONTROLCELLID] |
Is Control | int64 | attribute | [InteractDTDS].[UARI_CELLS].[ISCONTROL] |
Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CELLS].[CAMPAIGNID] |
Eligible Stat | Sequence Number | decimal | identifier | [InteractRTDS].[UARI_ELIGSTAT].[SEQNUM] |
Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_ELIGSTAT].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractRTDS].[UARI_ELIGSTAT].[ICNAME] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_ELIGSTAT].[OFFERID] |
Offer Name | characterLength16 | attribute | [InteractRTDS].[UARI_ELIGSTAT].[OFFERNAME] |
Time ID | decimal | fact | [InteractRTDS].[UARI_ELIGSTAT].[TIMEID] |
Date ID | decimal | fact | [InteractRTDS].[UARI_ELIGSTAT].[DATEID] |
Cell ID | decimal | fact | [InteractRTDS].[UARI_ELIGSTAT].[CELLID] |
Cell Name | characterLength16 | attribute | [InteractRTDS].[UARI_ELIGSTAT].[CELLNAME] |
Cell Code | characterLength16 | attribute | [InteractRTDS].[UARI_ELIGSTAT].[CELLCODE] |
Interaction Point ID | decimal | fact | [InteractRTDS].[UARI_ELIGSTAT].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractRTDS].[UARI_ELIGSTAT].[IPNAME] |
Eligible Opportunities | decimal | fact | [InteractRTDS].[UARI_ELIGSTAT].[ELIGIBLEOPPS] |
Defaulted Stat | Sequence Number | decimal | identifier | [InteractRTDS].[UARI_DEFAULTEDSTAT].[SEQNUM] |
Time ID | decimal | identifier | [InteractRTDS].[UARI_DEFAULTEDSTAT].[TIMEID] |
Date ID | decimal | identifier | [InteractRTDS].[UARI_DEFAULTEDSTAT].[DATEID] |
Segment ID | decimal | identifier | [InteractRTDS].[UARI_DEFAULTEDSTAT].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractRTDS].[UARI_DEFAULTEDSTAT].[SEGMENTNAME] |
Interaction Point ID | decimal | identifier | [InteractRTDS].[UARI_DEFAULTEDSTAT].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractRTDS].[UARI_DEFAULTEDSTAT].[IPNAME] |
Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_DEFAULTEDSTAT].[ICID] |
Defaulted | decimal | fact | [InteractRTDS].[UARI_DEFAULTEDSTAT].[OCCURRENCES] |
Treatment Rule Inventory Campaign to Offer | Offer ID | decimal | identifier | [InteractDTDS].[UARI_TRI_CAMP_OFF].[OFFERID] |
Offer Name | characterLength16 | attribute | [InteractDTDS].[UARI_TRI_CAMP_OFF].[OFFERNAME] |
Campaign ID | decimal | identifier | [InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNID] |
Campaign Name | characterLength16 | attribute | [InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNNAME] |
Campaign Code | characterLength16 | attribute | [InteractDTDS].[UARI_TRI_CAMP_OFF].[CAMPAIGNCODE] |
Localization Lookup | Lookup ID | int64 | fact | [InteractDTDS].[UARI_LOOKUP].[LKUP_ID] |
Lookup Code | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LKUP_CODE] |
Lookup Type | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LKUP_TYPE] |
Description | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[DESCRIPTION] |
Locale | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LOCALE] |
Localized String | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LOCALIZED_STRING] |
Calendar | Date ID | decimal | identifier | [InteractDTDS].[UARI_CALENDAR].[DATEID] |
Year | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[YEAR] |
Fiscal Year | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[FISCALYEAR] |
Quarter | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[QUARTER] |
Fiscal Quarter | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[FISCALQUARTER] |
Month | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[MONTH] |
Week of Year | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[WEEKOFYEAR] |
Week of Month | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[WEEKOFMONTH] |
Day of Year | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[DAYOFYEAR] |
Day of Month | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[DAYOFMONTH] |
Day of Week | int64 | attribute | [InteractDTDS].[UARI_CALENDAR].[DAYOFWEEK] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] |
First Day of Week | dateTime | attribute | [InteractDTDS].[UARI_CALENDAR].[FIRSTDAYOFWEEK] |
Last Day of Week | dateTime | attribute | [InteractDTDS].[UARI_CALENDAR].[LASTDAYOFWEEK] |
Time | Time ID | decimal | identifier | [InteractDTDS].[UARI_TIME].[TIMEID] |
Hour | int64 | identifier | [InteractDTDS].[UARI_TIME].[HOUR] |
Minute | int64 | identifier | [InteractDTDS].[UARI_TIME].[MINUTE] |
Last 14 Days Calendar | Date ID | decimal | identifier | [Interact Model].[Calendar].[Date ID] |
Year | int64 | attribute | [Interact Model].[Calendar].[Year] |
Fiscal Year | int64 | attribute | [Interact Model].[Calendar].[Fiscal Year] |
Quarter | int64 | attribute | [Interact Model].[Calendar].[Quarter] |
Fiscal Quarter | int64 | attribute | [Interact Model].[Calendar].[Fiscal Quarter] |
Month | int64 | attribute | [Interact Model].[Calendar].[Month] |
Week of Year | int64 | attribute | [Interact Model].[Calendar].[Week of Year] |
Week of Month | int64 | attribute | [Interact Model].[Calendar].[Week of Month] |
Day of Year | int64 | attribute | [Interact Model].[Calendar].[Day of Year] |
Day of Month | int64 | attribute | [Interact Model].[Calendar].[Day of Month] |
Day of Week | int64 | attribute | [Interact Model].[Calendar].[Day of Week] |
Actual Date | dateTime | identifier | [Interact Model].[Calendar].[Actual Date] |
First Day of Week | dateTime | attribute | [Interact Model].[Calendar].[First Day of Week] |
Last Day of Week | dateTime | attribute | [Interact Model].[Calendar].[Last Day of Week] |
Last 24 Hours Lookup | Hour | decimal | attribute | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Summary | Interactive Channel by Offer Number of Times Presented | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_OCH].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_OCH].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_OCH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_OCH].[IPNAME] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_ICP_OCH].[OFFERID] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_OCH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_OCH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_OCH].[NUM_PRES_RANDOM] |
Interactive Channel by Offer Elig Opps | Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_ICP_OES].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractRTDS].[UARI_ICP_OES].[ICNAME] |
Interaction Point ID | decimal | identifier | [InteractRTDS].[UARI_ICP_OES].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractRTDS].[UARI_ICP_OES].[IPNAME] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_ICP_OES].[OFFERID] |
Eligible Opportunities | float64 | fact | IF([InteractRTDS].[UARI_ICP_OES].[ELIGIBLEOPPS] is missing)
THEN(0)
ELSE([InteractRTDS].[UARI_ICP_OES].[ELIGIBLEOPPS]) |
Interactive Channel by Offer Response History | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_ORH].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_ORH].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_ORH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_ORH].[IPNAME] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_ICP_ORH].[OFFERID] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_ORH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_ORH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_ORH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_ORH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by Offer Performance Summary Star Schema
 | Offer | | (shortcut) | | [Interact Model].[Offer] |
Interactive Channel by Offer Number of Times Presented | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Number of Times Presented] |
Interactive Channel by Offer Elig Opps | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Elig Opps] |
Interactive Channel by Offer Response History | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Response History] |
|
By Day | Interactive Channel by Offer Number of Times Presented by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_OCH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_OCH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_OCH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_OCH_DY].[IPNAME] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_ICP_OCH_DY].[OFFERID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_OCH_DY].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_OCH_DY].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_OCH_DY].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_OCH_DY].[NUM_PRES_RANDOM] |
Interactive Channel by Offer Elig Opps by Day | Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_ICP_OES_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractRTDS].[UARI_ICP_OES_DY].[ICNAME] |
Interaction Point ID | decimal | identifier | [InteractRTDS].[UARI_ICP_OES_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractRTDS].[UARI_ICP_OES_DY].[IPNAME] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_ICP_OES_DY].[OFFERID] |
Actual Date | dateTime | identifier | [InteractRTDS].[UARI_ICP_OES_DY].[ACTUALDATE] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_ICP_OES_DY].[ELIGIBLEOPPS] |
Interactive Channel by Offer Response History by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_ORH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_ORH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_ORH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_ORH_DY].[IPNAME] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_ICP_ORH_DY].[OFFERID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_ORH_DY].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_DY].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_DY].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_DY].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_DY].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by Offer Performance by Day Star Schema
 | Offer | | (shortcut) | | [Interact Model].[Offer] |
Interactive Channel by Offer Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Number of Times Presented by Day] |
Interactive Channel by Offer Elig Opps by Day | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Elig Opps by Day] |
Interactive Channel by Offer Response History by Day | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Response History by Day] |
Calendar | | (shortcut) | | [Interact Model].[Calendar] |
|
By Hour | Interactive Channel by Offer Number of Times Presented by Hour | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_OCH_HR].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_OCH_HR].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_OCH_HR].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_OCH_HR].[IPNAME] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_ICP_OCH_HR].[OFFERID] |
Hour | int64 | identifier | [InteractDTDS].[UARI_ICP_OCH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_OCH_HR].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_OCH_HR].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_OCH_HR].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_OCH_HR].[NUM_PRES_RANDOM] |
Interactive Channel by Offer Respone History by Hour | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_ORH_HR].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_ORH_HR].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_ORH_HR].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_ORH_HR].[IPNAME] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_ICP_ORH_HR].[OFFERID] |
Hour | int64 | identifier | [InteractDTDS].[UARI_ICP_ORH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_ORH_HR].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_HR].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_HR].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_HR].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_ORH_HR].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by Offer Performance by Hour Star Schema
 | Offer | | (shortcut) | | [Interact Model].[Offer] |
Interactive Channel by Offer Number of Times Presented by Hour | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Number of Times Presented by Hour] |
Interactive Channel by Offer Respone History by Hour | | (shortcut) | | [Interact Model].[Interactive Channel by Offer Respone History by Hour] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Segment Summary | Interactive Channel by Segment Number of Times Presented | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGCH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH].[SEGMENT_NAME] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH].[NUM_PRES_RANDOM] |
Interactive Channel by Segment Times Defaulted | Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_ICP_SEGDS].[ICID] |
Interaction Point ID | decimal | identifier | [InteractRTDS].[UARI_ICP_SEGDS].[IPID] |
Segment ID | decimal | identifier | [InteractRTDS].[UARI_ICP_SEGDS].[SEGMENTID] |
Defaulted | float64 | fact | [InteractRTDS].[UARI_ICP_SEGDS].[NUM_OF_OCCURRENCES] |
Interactive Channel by Segment Response History | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGRH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH].[SEGMENT_NAME] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by Segment Summary Star Schema
 | Interactive Channel by Segment Number of Times Presented | | (shortcut) | | [Interact Model].[Interactive Channel by Segment Number of Times Presented] |
Interactive Channel by Segment Times Defaulted | | (shortcut) | | [Interact Model].[Interactive Channel by Segment Times Defaulted] |
Interactive Channel by Segment Response History | | (shortcut) | | [Interact Model].[Interactive Channel by Segment Response History] |
|
Segment by Day | Interactive Channel by Segment Number of Times Presented by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_DY].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENT_NAME] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM] |
Interactive Channel by Segment Response History by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_DY].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENT_NAME] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by Segment by Day Star Schema
 | Interactive Channel by Segment Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Interactive Channel by Segment Number of Times Presented by Day] |
Interactive Channel by Segment Response History by Day | | (shortcut) | | [Interact Model].[Interactive Channel by Segment Response History by Day] |
|
Segment by Hour | Interactive Channel by Segment Number of Times Presented by Hour | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH_HR].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_HR].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGCH_HR].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_HR].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH_HR].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_HR].[SEGMENT_NAME] |
Hour | int64 | identifier | [InteractDTDS].[UARI_ICP_SEGCH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_SEGCH_HR].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_SEGCH_HR].[NUM_PRES_RANDOM] |
Interactive Channel by Segment Response History by Hour | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH_HR].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_HR].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGRH_HR].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_HR].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH_HR].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_HR].[SEGMENT_NAME] |
Hour | int64 | identifier | [InteractDTDS].[UARI_ICP_SEGRH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_SEGRH_HR].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_SEGRH_HR].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by Segment by Hour Star Schema
 | Interactive Channel by Segment Number of Times Presented by Hour | | (shortcut) | | [Interact Model].[Interactive Channel by Segment Number of Times Presented by Hour] |
Interactive Channel by Segment Response History by Hour | | (shortcut) | | [Interact Model].[Interactive Channel by Segment Response History by Hour] |
|
Cumulative Segment by Day | Cumulative Interactive Channel by Segment Number of Times Presented by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_DY].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGCH_DY].[SEGMENT_NAME] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_SEGCH_DY].[ACTUALDATE] |
Presented | float64 | fact | IF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_TIMES_PRES]) |
Presented Model-Driven | float64 | fact | IF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_MODELDRVN]) |
Presented Random | float64 | fact | IF([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_ICP_SEGCH_DY].[NUM_PRES_RANDOM]) |
Cumulative Presented | float64 | fact | running-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ) |
Cumulative Presented Model-Driven | float64 | fact | running-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented Model-Driven] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ) |
Cumulative Presented Random | float64 | fact | running-total([Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Presented Random] AT [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day].[Interactive Channel ID] ) |
Cumulative Interactive Channel by Segment Response History by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_DY].[IPNAME] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_SEGRH_DY].[SEGMENT_NAME] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_SEGRH_DY].[ACTUALDATE] |
Accepted | float64 | fact | IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIMES_ACCP]) |
Accepted Model-Driven | float64 | fact | IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_MODELDRVN]) |
Accepted Random | float64 | fact | IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_ACCP_RANDOM]) |
Rejected | float64 | fact | IF([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_ICP_SEGRH_DY].[NUM_TIME_REJ]) |
Cumulative Accepted | float64 | fact | running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) |
Cumulative Accepted Model-Driven | float64 | fact | running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted Model-Driven] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) |
Cumulative Accepted Random | float64 | fact | running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Accepted Random] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) |
Cumulative Rejected | float64 | fact | running-total([Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Rejected] AT [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Segment ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interaction Point ID] ,[Interact Model].[Cumulative Interactive Channel by Segment Response History by Day].[Interactive Channel ID] ) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Cumulative Interactive Channel by Segment by Day Star Schema
 | Cumulative Interactive Channel by Segment Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Cumulative Interactive Channel by Segment Number of Times Presented by Day] |
Cumulative Interactive Channel by Segment Response History by Day | | (shortcut) | | [Interact Model].[Cumulative Interactive Channel by Segment Response History by Day] |
Last 14 Days Calendar | | (shortcut) | | [Interact Model].[Last 14 Days Calendar] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interaction Point Summary | Interactive Channel by IP Number of Times Presented | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_IPCH].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPCH].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_IPCH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPCH].[IPNAME] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH].[NUM_PRES_RANDOM] |
Interactive Channel by IP Times Defaulted | Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_ICP_IPDS].[ICID] |
Interaction Point ID | decimal | identifier | [InteractRTDS].[UARI_ICP_IPDS].[IPID] |
Defaulted | float64 | fact | [InteractRTDS].[UARI_ICP_IPDS].[NUM_OF_OCCURRENCES] |
Interactive Channel by IP Response History | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_IPRH].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPRH].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_IPRH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPRH].[IPNAME] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by IP Summary Star Schema
 | Interactive Channel by IP Number of Times Presented | | (shortcut) | | [Interact Model].[Interactive Channel by IP Number of Times Presented] |
Interactive Channel by IP Times Defaulted | | (shortcut) | | [Interact Model].[Interactive Channel by IP Times Defaulted] |
Interactive Channel by IP Response History | | (shortcut) | | [Interact Model].[Interactive Channel by IP Response History] |
|
Interaction Point by Day | Interactive Channel by IP Number of Times Presented by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_IPCH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPCH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_IPCH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPCH_DY].[IPNAME] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_IPCH_DY].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH_DY].[NUM_PRES_RANDOM] |
Interactive Channel by IP Response History by Day | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_IPRH_DY].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPRH_DY].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_IPRH_DY].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPRH_DY].[IPNAME] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_IPRH_DY].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_DY].[NUM_TIME_REJ] |
InteractiveChannelToCalendar | Date ID | decimal | identifier | [InteractDTDS].[UARI_CALENDAR].[DATEID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] |
Interactive Channel ID | decimal | identifier | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by IP by Day Star Schema
 | Interactive Channel by IP Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Interactive Channel by IP Number of Times Presented by Day] |
Interactive Channel by IP Response History by Day | | (shortcut) | | [Interact Model].[Interactive Channel by IP Response History by Day] |
InteractiveChannelToCalendar | | (shortcut) | | [Interact Model].[InteractiveChannelToCalendar] |
|
Interaction Point by Hour | Interactive Channel by IP Number of Times Presented by Hour | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_IPCH_HR].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPCH_HR].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_IPCH_HR].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPCH_HR].[IPNAME] |
Hour | int64 | identifier | [InteractDTDS].[UARI_ICP_IPCH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_IPCH_HR].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_ICP_IPCH_HR].[NUM_PRES_RANDOM] |
Interactive Channel by IP Response History by Hour | Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_ICP_IPRH_HR].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPRH_HR].[ICNAME] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_ICP_IPRH_HR].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_ICP_IPRH_HR].[IPNAME] |
Hour | int64 | identifier | [InteractDTDS].[UARI_ICP_IPRH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_ICP_IPRH_HR].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_ICP_IPRH_HR].[NUM_TIME_REJ] |
Interactive Channel - Last 24 Hours Lookup | Hour | float64 | attribute | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] |
Interactive Channel ID | decimal | identifier | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel ID] |
Interactive Channel | characterLength16 | attribute | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interactive Channel] |
Interaction Point ID | float64 | identifier | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point ID] |
Interaction Point | characterLength16 | attribute | [Interact Model].[Interactive Channel by IP Number of Times Presented].[Interaction Point] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel by IP by Hour Star Schema
 | Interactive Channel by IP Number of Times Presented by Hour | | (shortcut) | | [Interact Model].[Interactive Channel by IP Number of Times Presented by Hour] |
Interactive Channel by IP Response History by Hour | | (shortcut) | | [Interact Model].[Interactive Channel by IP Response History by Hour] |
Last 24 Hours | | (shortcut) | | [Interact Model].[Last 24 Hours Lookup] |
Interactive Channel - Last 24 Hours Lookup | | (shortcut) | | [Interact Model].[Interactive Channel - Last 24 Hours Lookup] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell Summary | Campaign Cell Performance Number of Times Presented | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH].[CELLID] |
Presented | float64 | fact | [InteractDTDS].[UARI_CCP_CH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_CH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_CCP_CH].[NUM_PRES_RANDOM] |
Campaign Cell Performance Elig Opps | Campaign ID | int64 | identifier | [InteractRTDS].[UARI_CCP_ES].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractRTDS].[UARI_CCP_ES].[CELLID] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_CCP_ES].[ELIGIBLEOPPS] |
Campaign Cell Performance Response History | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH].[CELLID] |
Accepted | float64 | fact | [InteractDTDS].[UARI_CCP_RH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_RH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_CCP_RH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_CCP_RH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell Performance Summary Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Campaign Cell Performance Number of Times Presented | | (shortcut) | | [Interact Model].[Campaign Cell Performance Number of Times Presented] |
Campaign Cell Performance Elig Opps | | (shortcut) | | [Interact Model].[Campaign Cell Performance Elig Opps] |
Campaign Cell Performance Response History | | (shortcut) | | [Interact Model].[Campaign Cell Performance Response History] |
|
Campaign Cell by Day | Campaign Cell Number of Times Presented by Day | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH_DY].[CELLID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CCP_CH_DY].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM] |
Campaign Cell Performance Elig Opps by Day | Campaign ID | int64 | identifier | [InteractRTDS].[UARI_CCP_ES_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractRTDS].[UARI_CCP_ES_DY].[CELLID] |
Actual Date | dateTime | identifier | [InteractRTDS].[UARI_CCP_ES_DY].[ACTUALDATE] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS] |
Campaign Cell Performance Response History by Day | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH_DY].[CELLID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CCP_RH_DY].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ] |
CellToCalendar | Date ID | decimal | identifier | [InteractDTDS].[UARI_CALENDAR].[DATEID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] |
Cell ID | decimal | identifier | [Interact Model].[Cells].[Cell ID] |
Cell Name | characterLength16 | attribute | [Interact Model].[Cells].[Cell Name] |
Cell Code | characterLength16 | attribute | [Interact Model].[Cells].[Cell Code] |
Control Cell ID | decimal | identifier | [Interact Model].[Cells].[Control Cell ID] |
Is Control | int64 | attribute | [Interact Model].[Cells].[Is Control] |
Campaign ID | decimal | identifier | [Interact Model].[Cells].[Campaign ID] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell Performance by Day Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Campaign Cell Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Campaign Cell Number of Times Presented by Day] |
Campaign Cell Performance Elig Opps by Day | | (shortcut) | | [Interact Model].[Campaign Cell Performance Elig Opps by Day] |
Campaign Cell Performance Response History by Day | | (shortcut) | | [Interact Model].[Campaign Cell Performance Response History by Day] |
CellToCalendar | | (shortcut) | | [Interact Model].[CellToCalendar] |
|
Campaign Cell by Hour | Campaign Cell Number of Times Presented by Hour | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH_HR].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH_HR].[CELLID] |
Hour | int64 | identifier | [InteractDTDS].[UARI_CCP_CH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CCP_CH_HR].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_CCP_CH_HR].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_CH_HR].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_CCP_CH_HR].[NUM_PRES_RANDOM] |
Campaign Cell Performance Elig Opps by Hour | Campaign ID | int64 | identifier | [InteractRTDS].[UARI_CCP_ES_HR].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractRTDS].[UARI_CCP_ES_HR].[CELLID] |
Hour | int64 | identifier | [InteractRTDS].[UARI_CCP_ES_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractRTDS].[UARI_CCP_ES_HR].[ACTUALDATE] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_CCP_ES_HR].[ELIGIBLEOPPS] |
Campaign Cell Performance Response History by Hour | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH_HR].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH_HR].[CELLID] |
Hour | int64 | identifier | [InteractDTDS].[UARI_CCP_RH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CCP_RH_HR].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_CCP_RH_HR].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_RH_HR].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_CCP_RH_HR].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_CCP_RH_HR].[NUM_TIME_REJ] |
Cell - Last 24 Hours Lookup | Hour | float64 | attribute | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] |
Cell ID | decimal | identifier | [Interact Model].[Cells].[Cell ID] |
Cell Name | characterLength16 | attribute | [Interact Model].[Cells].[Cell Name] |
Cell Code | characterLength16 | attribute | [Interact Model].[Cells].[Cell Code] |
Control Cell ID | decimal | identifier | [Interact Model].[Cells].[Control Cell ID] |
Is Control | int64 | attribute | [Interact Model].[Cells].[Is Control] |
Campaign ID | decimal | identifier | [Interact Model].[Cells].[Campaign ID] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell Performance by Hour Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Campaign Cell Number of Times Presented by Hour | | (shortcut) | | [Interact Model].[Campaign Cell Number of Times Presented by Hour] |
Campaign Cell Performance Elig Opps by Hour | | (shortcut) | | [Interact Model].[Campaign Cell Performance Elig Opps by Hour] |
Campaign Cell Performance Response History by Hour | | (shortcut) | | [Interact Model].[Campaign Cell Performance Response History by Hour] |
Cell - Last 24 Hours Lookup | | (shortcut) | | [Interact Model].[Cell - Last 24 Hours Lookup] |
|
Cumulative Campaign Cell by Day | Cumulative Campaign Cell Number of Times Presented by Day | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_CH_DY].[CELLID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CCP_CH_DY].[ACTUALDATE] |
Presented | float64 | fact | IF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_TIMES_PRES]) |
Presented Model-Driven | float64 | fact | IF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_MODELDRVN]) |
Presented Random | float64 | fact | IF([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_CCP_CH_DY].[NUM_PRES_RANDOM]) |
Cumulative Presented | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ) |
Cumulative Presented Model-Driven | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented Model-Driven] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ) |
Cumulative Presented Random | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Presented Random] AT [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day].[Cell ID] ) |
Cumulative Campaign Cell Performance Elig Opps by Day | Campaign ID | decimal | identifier | [InteractRTDS].[UARI_CCP_ES_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractRTDS].[UARI_CCP_ES_DY].[CELLID] |
Actual Date | dateTime | identifier | [InteractRTDS].[UARI_CCP_ES_DY].[ACTUALDATE] |
Eligible Opportunities | float64 | fact | IF([InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS] is missing)
THEN(0)
ELSE([InteractRTDS].[UARI_CCP_ES_DY].[ELIGIBLEOPPS]) |
Cumulative Eligible Opportunities | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Eligible Opportunities] AT [Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Elig Opps by Day].[Cell ID] ) |
Cumulative Campaign Cell Performance Response History by Day | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_RH_DY].[CELLID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CCP_RH_DY].[ACTUALDATE] |
Accepted | float64 | fact | IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIMES_ACCP]) |
Accepted Model-Driven | float64 | fact | IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_MODELDRVN]) |
Accepted Random | float64 | fact | IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_ACCP_RANDOM]) |
Rejected | float64 | fact | IF([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ] is missing)
THEN(0)
ELSE([InteractDTDS].[UARI_CCP_RH_DY].[NUM_TIME_REJ]) |
Cumulative Accepted | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ) |
Cumulative Accepted Model-Driven | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted Model-Driven] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ) |
Cumulative Accepted Random | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Accepted Random] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ) |
Cumulative Rejected | float64 | fact | running-total([Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Rejected] AT [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Actual Date] FOR [Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Campaign ID] ,[Interact Model].[Cumulative Campaign Cell Performance Response History by Day].[Cell ID] ) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Cumulative Campaign Cell Performance by Day Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Cumulative Campaign Cell Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Cumulative Campaign Cell Number of Times Presented by Day] |
Cumulative Campaign Cell Performance Response History by Day | | (shortcut) | | [Interact Model].[Cumulative Campaign Cell Performance Response History by Day] |
Last 14 Days Calendar | | (shortcut) | | [Interact Model].[Last 14 Days Calendar] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell by Offer Summary | Campaign Cell by Offer Number of Times Presented | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_OCH].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_OCH].[CELLID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_CCP_OCH].[OFFERID] |
Presented | float64 | fact | [InteractDTDS].[UARI_CCP_OCH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_OCH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_CCP_OCH].[NUM_PRES_RANDOM] |
Campaign Cell by Offer Elig Opps | Campaign ID | int64 | identifier | [InteractRTDS].[UARI_CCP_OES].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractRTDS].[UARI_CCP_OES].[CELLID] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_CCP_OES].[OFFERID] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_CCP_OES].[ELIGIBLEOPPS] |
Campaign Cell by Offer Response History | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_ORH].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_ORH].[CELLID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_CCP_ORH].[OFFERID] |
Accepted | float64 | fact | [InteractDTDS].[UARI_CCP_ORH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_ORH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_CCP_ORH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_CCP_ORH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell by Offer Performance Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Offer | | (shortcut) | | [Interact Model].[Offer] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Campaign Cell by Offer Number of Times Presented | | (shortcut) | | [Interact Model].[Campaign Cell by Offer Number of Times Presented] |
Campaign Cell by Offer Elig Opps | | (shortcut) | | [Interact Model].[Campaign Cell by Offer Elig Opps] |
Campaign Cell by Offer Response History | | (shortcut) | | [Interact Model].[Campaign Cell by Offer Response History] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell by Interaction Point Summaries | Campaign Cell by IP Number of Times Presented | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_IPCH].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_IPCH].[CELLID] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_CCP_IPCH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_CCP_IPCH].[IPNAME] |
Presented | float64 | fact | [InteractDTDS].[UARI_CCP_IPCH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_IPCH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_CCP_IPCH].[NUM_PRES_RANDOM] |
Campaign Cell by IP Elig Opps | Campaign ID | int64 | fact | [InteractRTDS].[UARI_CCP_IPES].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractRTDS].[UARI_CCP_IPES].[CELLID] |
Interaction Point ID | decimal | identifier | [InteractRTDS].[UARI_CCP_IPES].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractRTDS].[UARI_CCP_IPES].[IPNAME] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_CCP_IPES].[ELIGIBLEOPPS] |
Campaign Cell by IP Response History | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_CCP_IPRH].[CAMPAIGNID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_CCP_IPRH].[CELLID] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_CCP_IPRH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_CCP_IPRH].[IPNAME] |
Accepted | float64 | fact | [InteractDTDS].[UARI_CCP_IPRH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_CCP_IPRH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_CCP_IPRH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_CCP_IPRH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Cell by IP Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Campaign Cell by IP Number of Times Presented | | (shortcut) | | [Interact Model].[Campaign Cell by IP Number of Times Presented] |
Campaign Cell by IP Elig Opps | | (shortcut) | | [Interact Model].[Campaign Cell by IP Elig Opps] |
Campaign Cell by IP Response History | | (shortcut) | | [Interact Model].[Campaign Cell by IP Response History] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer Summary | Campaign Offer Number of Times Presented | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_CH].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_CH].[OFFERID] |
Presented | float64 | fact | [InteractDTDS].[UARI_COP_CH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_CH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_COP_CH].[NUM_PRES_RANDOM] |
Campaign Offer Elig Opps | Campaign ID | float64 | identifier | [InteractRTDS].[UARI_COP_ES].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_COP_ES].[OFFERID] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_COP_ES].[ELIGIBLEOPPS] |
Campaign Offer Response History | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_RH].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_RH].[OFFERID] |
Accepted | float64 | fact | [InteractDTDS].[UARI_COP_RH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_RH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_COP_RH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_COP_RH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer Performance Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Offer | | (shortcut) | | [Interact Model].[Offer] |
Campaign Offer Number of Times Presented | | (shortcut) | | [Interact Model].[Campaign Offer Number of Times Presented] |
Campaign Offer Elig Opps | | (shortcut) | | [Interact Model].[Campaign Offer Elig Opps] |
Campaign Offer Response History | | (shortcut) | | [Interact Model].[Campaign Offer Response History] |
|
Campaign Offer by Day | Campaign Offer Number of Times Presented by Day | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_CH_DY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_CH_DY].[OFFERID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_COP_CH_DY].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_COP_CH_DY].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_CH_DY].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_COP_CH_DY].[NUM_PRES_RANDOM] |
Campaign Offer Elig Opps by Day | Campaign ID | float64 | identifier | [InteractRTDS].[UARI_COP_ES_DY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_COP_ES_DY].[OFFERID] |
Actual Date | dateTime | identifier | [InteractRTDS].[UARI_COP_ES_DY].[ACTUALDATE] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_COP_ES_DY].[ELIGIBLEOPPS] |
Campaign Offer Response History by Day | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_RH_DY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_RH_DY].[OFFERID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_COP_RH_DY].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_COP_RH_DY].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_RH_DY].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_COP_RH_DY].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_COP_RH_DY].[NUM_TIME_REJ] |
OfferToCalendar | Date ID | decimal | identifier | [InteractDTDS].[UARI_CALENDAR].[DATEID] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_CALENDAR].[ACTUALDATE] |
Offer ID | decimal | identifier | [Interact Model].[Offer].[Offer ID] |
Offer Name | characterLength16 | attribute | [Interact Model].[Offer].[Offer Name] |
Offer Description | characterLength16 | attribute | [Interact Model].[Offer].[Offer Description] |
Offer Code 1 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 1] |
Offer Code 2 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 2] |
Offer Code 3 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 3] |
Offer Code 4 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 4] |
Offer Code 5 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 5] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer by Day Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Campaign Offer Number of Times Presented by Day | | (shortcut) | | [Interact Model].[Campaign Offer Number of Times Presented by Day] |
Campaign Offer Elig Opps by Day | | (shortcut) | | [Interact Model].[Campaign Offer Elig Opps by Day] |
Campaign Offer Response History by Day | | (shortcut) | | [Interact Model].[Campaign Offer Response History by Day] |
OfferToCalendar | | (shortcut) | | [Interact Model].[OfferToCalendar] |
|
Campaign Offer by Hour | Campaign Offer Number of Times Presented by Hour | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_CH_HR].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_CH_HR].[OFFERID] |
Hour | int64 | identifier | [InteractDTDS].[UARI_COP_CH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_COP_CH_HR].[ACTUALDATE] |
Presented | float64 | fact | [InteractDTDS].[UARI_COP_CH_HR].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_CH_HR].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_COP_CH_HR].[NUM_PRES_RANDOM] |
Campaign Offer Elig Opps by Hour | Campaign ID | float64 | identifier | [InteractRTDS].[UARI_COP_ES_HR].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_COP_ES_HR].[OFFERID] |
Hour | int64 | identifier | [InteractRTDS].[UARI_COP_ES_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractRTDS].[UARI_COP_ES_HR].[ACTUALDATE] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_COP_ES_HR].[ELIGIBLEOPPS] |
Campaign Offer Response History by Hour | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_RH_HR].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_RH_HR].[OFFERID] |
Hour | int64 | identifier | [InteractDTDS].[UARI_COP_RH_HR].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[UARI_COP_RH_HR].[ACTUALDATE] |
Accepted | float64 | fact | [InteractDTDS].[UARI_COP_RH_HR].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_RH_HR].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_COP_RH_HR].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_COP_RH_HR].[NUM_TIME_REJ] |
Offer-Last 24 Hours Lookup | Hour | float64 | attribute | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[HOUR] |
Actual Date | dateTime | identifier | [InteractDTDS].[LAST_24_HOURS_LOOKUP].[ACTUALDATE] |
Offer ID | decimal | identifier | [Interact Model].[Offer].[Offer ID] |
Offer Name | characterLength16 | attribute | [Interact Model].[Offer].[Offer Name] |
Offer Description | characterLength16 | attribute | [Interact Model].[Offer].[Offer Description] |
Offer Code 1 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 1] |
Offer Code 2 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 2] |
Offer Code 3 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 3] |
Offer Code 4 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 4] |
Offer Code 5 | characterLength16 | attribute | [Interact Model].[Offer].[Offer Code 5] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer by Hour Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Offer | | (shortcut) | | [Interact Model].[Offer] |
Campaign Offer Number of Times Presented by Hour | | (shortcut) | | [Interact Model].[Campaign Offer Number of Times Presented by Hour] |
Campaign Offer Elig Opps by Hour | | (shortcut) | | [Interact Model].[Campaign Offer Elig Opps by Hour] |
Campaign Offer Response History by Hour | | (shortcut) | | [Interact Model].[Campaign Offer Response History by Hour] |
Offer-Last 24 Hours Lookup | | (shortcut) | | [Interact Model].[Offer-Last 24 Hours Lookup] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer by Cell Summary | Campaign Offer by Cell Number of Times Presented | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_CCH].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_CCH].[OFFERID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_COP_CCH].[CELLID] |
Presented | float64 | fact | [InteractDTDS].[UARI_COP_CCH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_CCH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_COP_CCH].[NUM_PRES_RANDOM] |
Campaign Offer by Cell Elig Opps | Campaign ID | int64 | identifier | [InteractRTDS].[UARI_COP_CES].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_COP_CES].[OFFERID] |
Cell ID | decimal | identifier | [InteractRTDS].[UARI_COP_CES].[CELLID] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_COP_CES].[ELIGIBLEOPPS] |
Campaign Offer by Cell Response History | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_CRH].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_CRH].[OFFERID] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_COP_CRH].[CELLID] |
Accepted | float64 | fact | [InteractDTDS].[UARI_COP_CRH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_CRH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_COP_CRH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_COP_CRH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer Cell Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Offer | | (shortcut) | | [Interact Model].[Offer] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Campaign Offer by Cell Number of Times Presented | | (shortcut) | | [Interact Model].[Campaign Offer by Cell Number of Times Presented] |
Campaign Offer by Cell Elig Opps | | (shortcut) | | [Interact Model].[Campaign Offer by Cell Elig Opps] |
Campaign Offer by Cell Response History | | (shortcut) | | [Interact Model].[Campaign Offer by Cell Response History] |
|
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer by Interaction Point Summary | Campaign Offer by IP Number of Times Presented | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_IPCH].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_IPCH].[OFFERID] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_COP_IPCH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_COP_IPCH].[IPNAME] |
Presented | float64 | fact | [InteractDTDS].[UARI_COP_IPCH].[NUM_TIMES_PRES] |
Presented Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_IPCH].[NUM_PRES_MODELDRVN] |
Presented Random | float64 | fact | [InteractDTDS].[UARI_COP_IPCH].[NUM_PRES_RANDOM] |
Campaign Offer by IP Elig Opps | Campaign ID | int64 | identifier | [InteractRTDS].[UARI_COP_IPES].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractRTDS].[UARI_COP_IPES].[OFFERID] |
Interaction Point ID | decimal | identifier | [InteractRTDS].[UARI_COP_IPES].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractRTDS].[UARI_COP_IPES].[IPNAME] |
Eligible Opportunities | float64 | fact | [InteractRTDS].[UARI_COP_IPES].[ELIGIBLEOPPS] |
Campaign Offer by IP Response History | Campaign ID | decimal | identifier | [InteractDTDS].[UARI_COP_IPRH].[CAMPAIGNID] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_COP_IPRH].[OFFERID] |
Interaction Point ID | float64 | identifier | [InteractDTDS].[UARI_COP_IPRH].[IPID] |
Interaction Point | characterLength16 | attribute | [InteractDTDS].[UARI_COP_IPRH].[IPNAME] |
Accepted | float64 | fact | [InteractDTDS].[UARI_COP_IPRH].[NUM_TIMES_ACCP] |
Accepted Model-Driven | float64 | fact | [InteractDTDS].[UARI_COP_IPRH].[NUM_ACCP_MODELDRVN] |
Accepted Random | float64 | fact | [InteractDTDS].[UARI_COP_IPRH].[NUM_ACCP_RANDOM] |
Rejected | float64 | fact | [InteractDTDS].[UARI_COP_IPRH].[NUM_TIME_REJ] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer by Interaction Point Star Schema
 | Campaign | | (shortcut) | | [Interact Model].[Campaign] |
Offer | | (shortcut) | | [Interact Model].[Offer] |
Campaign Offer by IP Number of Times Presented | | (shortcut) | | [Interact Model].[Campaign Offer by IP Number of Times Presented] |
Campaign Offer by IP Elig Opps | | (shortcut) | | [Interact Model].[Campaign Offer by IP Elig Opps] |
Campaign Offer by IP Response History | | (shortcut) | | [Interact Model].[Campaign Offer by IP Response History] |
|
|
|
Interactive Channel Deployment | Interactive Channel Deployment History | Deployment ID | decimal | identifier | [InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYMENTID] |
Deployment Deploy Type ID | int64 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYDEPTYPEID] |
Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_DEPLOYMENT].[ICID] |
Campaign ID | decimal | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[CAMPAIGNID] |
Campaign Name | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[CAMPAIGNNAME] |
StrategyID | decimal | identifier | [InteractDTDS].[UARI_DEPLOYMENT].[STRATEGYID] |
Strategy Name | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[STRATEGYNAME] |
Deployment Type ID | int64 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYTYPEID] |
Deployment Type | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[DEPLOYTYPE] |
Session ID | decimal | identifier | [InteractDTDS].[UARI_DEPLOYMENT].[SESSIONID] |
Session Name | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[SESSIONNAME] |
Flowchart ID | decimal | identifier | [InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHARTID] |
Flowchart Name | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHARTNAME] |
Flowchart Type ID | int64 | identifier | [InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHDEPLOYTYPEID] |
Flowchart Type | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[FLOWCHDEPLOYTYPE] |
Audience Level | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[AUDIENCELEVEL] |
Deployment Destination | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTDEST] |
Deployment Server Group | int64 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTSVRGRP] |
Deployment Owner | characterLength16 | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[DEPLMNTOWNER] |
Time of Deployment | dateTime | attribute | [InteractDTDS].[UARI_DEPLOYMENT].[TIMEDEPLMNT] |
Strategy Tab URL | characterLength16 | attribute | #sq($Environment{'Redirect URL'})# + 'strategy&id=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[StrategyID] , integer), varchar(10)) + '&campaignID=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Campaign ID] , integer), varchar(10)) |
Flowchart Tab URL | characterLength16 | attribute | #sq($Environment{'Redirect URL'})# + 'flowchart&id=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Flowchart ID] , integer), varchar(10)) + '&sessionID=' + cast(cast([Interact Model].[Interactive Channel Deployment History].[Session ID] , integer), varchar(10)) |
isProduction | Lookup ID | int64 | fact | [Interact Model].[Localization Lookup].[Lookup ID] |
Lookup Type | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Lookup Type] |
Description | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Description] |
Production Group | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Localized String] |
Deployment Type | Lookup ID | int64 | fact | [Interact Model].[Localization Lookup].[Lookup ID] |
Lookup Type | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Lookup Type] |
Description | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Description] |
Deployment Type | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Localized String] |
Flowchart Deployment Type | Lookup ID | int64 | fact | [Interact Model].[Localization Lookup].[Lookup ID] |
Lookup Type | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Lookup Type] |
Description | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Description] |
Flowchart Deployment Type | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Localized String] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Channel Deployment Star Schema
 | Interactive Channel Deployment History | | (shortcut) | | [Interact Model].[Interactive Channel Deployment History] |
isProduction | | (shortcut) | | [Interact Model].[isProduction] |
Deploy Type | | (shortcut) | | [Interact Model].[Deployment Type] |
Flowchart Deployment Type | | (shortcut) | | [Interact Model].[Flowchart Deployment Type] |
Campaign | | (shortcut) | | [Interact Model].[Campaign] |
|
Campaign Interactive Offer Learning | Interactive Offer Learning | Offer ID | decimal | identifier | [InteractLearningDS].[UARI_LEARNING].[OFFERID] |
Attribute Name | characterLength16 | attribute | [InteractLearningDS].[UARI_LEARNING].[ATTRIBUTENAME] |
Attribute Value | characterLength16 | attribute | [InteractLearningDS].[UARI_LEARNING].[ATTRIBUTEVALUE] |
Likelyhood of Response | float64 | fact | [InteractLearningDS].[UARI_LEARNING].[ACCEPTPERCENTAGE] |
Predictability | int64 | attribute | [InteractLearningDS].[UARI_LEARNING].[PREDICTABILITY] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Interactive Offer Learning Star Schema
 | Interactive Offer Learning | | (shortcut) | | [Interact Model].[Interactive Offer Learning] |
Offer | | (shortcut) | | [Interact Model].[Offer] |
Treatment Rule Inventory Campaign to Offer | | (shortcut) | | [Interact Model].[Treatment Rule Inventory Campaign to Offer] |
|
Treatment Rule Inventory Folder | Treatment Rule Inventory | Treatment Rule ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[TREATMENTRULEID] |
Deployment ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[DEPLOYMENTID] |
Interactive Channel ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[ICID] |
Interactive Channel | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[ICNAME] |
Cell ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[CELLID] |
Cell Name | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[CELLNAME] |
Zone ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[ZONEID] |
Zone | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[ZONENAME] |
Strategy ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[STRATEGYID] |
Strategy Name | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[STRATEGYNAME] |
Offer ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[OFFERID] |
Offer Name | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[OFFERNAME] |
Campaign ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNID] |
Campaign Name | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNNAME] |
Campaign Code | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[CAMPAIGNCODE] |
Segment ID | decimal | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[SEGMENTID] |
Segment | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[SEGMENTNAME] |
Marketing Score | int64 | fact | [InteractDTDS].[UARI_TRMTRULEINV].[MARKETINGSCORE] |
Enable State ID | int64 | identifier | [InteractDTDS].[UARI_TRMTRULEINV].[ENABLESTATEID] |
Predicate State | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[PREDICATESTATE] |
Predicate | characterLength16 | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[PREDICATE] |
Last Update Date | dateTime | attribute | [InteractDTDS].[UARI_TRMTRULEINV].[LASTUPDATE] |
StrategyTab URL | characterLength16 | attribute | #sq($Environment{'Redirect URL'})# + 'strategy&id=' + cast(cast([Interact Model].[Treatment Rule Inventory].[Strategy ID] , integer), varchar(10)) + '&campaignID=' + cast(cast([Interact Model].[Treatment Rule Inventory].[Campaign ID] , integer), varchar(10)) |
All Zones | characterLength16 | attribute | [Interact Model].[All Zones].[All Zones] |
All Zones | Lookup ID | int64 | fact | [Interact Model].[Localization Lookup].[Lookup ID] |
Lookup Code | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Lookup Code] |
Lookup Type | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Lookup Type] |
Description | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Description] |
Locale | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Locale] |
All Zones | characterLength16 | attribute | [Interact Model].[Localization Lookup].[Localized String] |
Predicate State | Lookup ID | int64 | fact | [InteractDTDS].[UARI_LOOKUP].[LKUP_ID] |
Lookup Code | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LKUP_CODE] |
Lookup Type | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LKUP_TYPE] |
Description | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[DESCRIPTION] |
Locale | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LOCALE] |
Predicate State | characterLength16 | attribute | [InteractDTDS].[UARI_LOOKUP].[LOCALIZED_STRING] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Treatment Rule Inventory Star Schema
 | Treatment Rule Inventory | | (shortcut) | | [Interact Model].[Treatment Rule Inventory] |
Offer | | (shortcut) | | [Interact Model].[Offer] |
Cells | | (shortcut) | | [Interact Model].[Cells] |
Predicate State | | (shortcut) | | [Interact Model].[Predicate State] |
|
Channel Event Activity | Last 24 Hours | | (shortcut) | | [Interact Model].[Last 24 Hours Lookup] |
Channel Event Activity | Event Common | Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_EV_ACT].[ICID] |
Interactive Channel Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT].[ICNAME] |
Category ID | decimal | identifier | [InteractRTDS].[UARI_EV_ACT].[CATEGORYID] |
Category Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT].[CATEGORYNAME] |
Event ID | decimal | identifier | [InteractRTDS].[UARI_EV_ACT].[EVENTID] |
Event Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT].[EVENTNAME] |
Occurrences | float64 | fact | [InteractRTDS].[UARI_EV_ACT].[NUM_OCCURRENCES] |
Event Common by Day | Interactive Channel ID | int32 | identifier | [Interact Model].[Event Common].[Interactive Channel ID] |
Interactive Channel Name | characterLength16 | attribute | [Interact Model].[Event Common].[Interactive Channel Name] |
Category ID | int32 | identifier | [Interact Model].[Event Common].[Category ID] |
Category Name | characterLength16 | attribute | [Interact Model].[Event Common].[Category Name] |
Event ID | int32 | identifier | [Interact Model].[Event Common].[Event ID] |
Event Name | characterLength16 | attribute | [Interact Model].[Event Common].[Event Name] |
Actual Date | dateTime | identifier | [Interact Model].[Last 7 Days Calendar].[Actual Date] |
Event Activity Day | Interactive Channel ID | int32 | identifier | [InteractRTDS].[UARI_EV_ACT_DY].[ICID] |
Interactive Channel Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT_DY].[ICNAME] |
Category ID | int32 | identifier | [InteractRTDS].[UARI_EV_ACT_DY].[CATEGORYID] |
Category Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT_DY].[CATEGORYNAME] |
Event ID | int32 | identifier | [InteractRTDS].[UARI_EV_ACT_DY].[EVENTID] |
Event Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT_DY].[EVENTNAME] |
Occurrences | int32 | fact | [InteractRTDS].[UARI_EV_ACT_DY].[NUM_OCCURRENCES] |
Actual Date | date | attribute | cast([InteractRTDS].[UARI_EV_ACT_DY].[ACTUALDATE], date) |
Last 7 Days Calendar | Date ID | int32 | identifier | [InteractDTDS].[UARI_CALENDAR].[DATEID] |
Year | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[YEAR] |
Fiscal Year | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[FISCALYEAR] |
Quarter | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[QUARTER] |
Fiscal Quarter | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[FISCALQUARTER] |
Month | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[MONTH] |
Week of Year | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[WEEKOFYEAR] |
Week of Month | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[WEEKOFMONTH] |
Day of Year | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[DAYOFYEAR] |
Day of Month | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[DAYOFMONTH] |
Day of Week | int32 | attribute | [InteractDTDS].[UARI_CALENDAR].[DAYOFWEEK] |
Actual Date | date | identifier | cast([InteractDTDS].[UARI_CALENDAR].[ACTUALDATE], date) |
First Day of Week | dateTime | attribute | [InteractDTDS].[UARI_CALENDAR].[FIRSTDAYOFWEEK] |
Last Day of Week | dateTime | attribute | [InteractDTDS].[UARI_CALENDAR].[LASTDAYOFWEEK] |
Event Common by Hour | Interactive Channel ID | decimal | identifier | [Interact Model].[Event Common].[Interactive Channel ID] |
Interactive Channel Name | characterLength16 | attribute | [Interact Model].[Event Common].[Interactive Channel Name] |
Category ID | decimal | identifier | [Interact Model].[Event Common].[Category ID] |
Category Name | characterLength16 | attribute | [Interact Model].[Event Common].[Category Name] |
Event ID | decimal | identifier | [Interact Model].[Event Common].[Event ID] |
Event Name | characterLength16 | attribute | [Interact Model].[Event Common].[Event Name] |
Actual Date | date | identifier | cast([Interact Model].[Last 24 Hours][Interact Model].[Last 24 Hours Lookup].[Actual Date], date) |
Hour | float64 | attribute | [Interact Model].[Last 24 Hours][Interact Model].[Last 24 Hours Lookup].[Hour] |
Event Activity HR | Interactive Channel ID | decimal | identifier | [InteractRTDS].[UARI_EV_ACT_HR].[ICID] |
Interactive Channel Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT_HR].[ICNAME] |
Category ID | decimal | identifier | [InteractRTDS].[UARI_EV_ACT_HR].[CATEGORYID] |
Cat Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT_HR].[CATEGORYNAME] |
Event ID | decimal | identifier | [InteractRTDS].[UARI_EV_ACT_HR].[EVENTID] |
Event Name | characterLength16 | attribute | [InteractRTDS].[UARI_EV_ACT_HR].[EVENTNAME] |
Occurrences | float64 | fact | [InteractRTDS].[UARI_EV_ACT_HR].[NUM_OCCURRENCES] |
Actual Date | date | attribute | cast([InteractRTDS].[UARI_EV_ACT_HR].[ACTUALDATE], date) |
Hour | int64 | attribute | [InteractRTDS].[UARI_EV_ACT_HR].[HR] |
Peak Day | Interactive Channel ID | decimal | identifier | [Interact Model].[Event Activity Day].[Interactive Channel ID] |
Category ID | decimal | identifier | [Interact Model].[Event Activity Day].[Category ID] |
Event ID | decimal | identifier | [Interact Model].[Event Activity Day].[Event ID] |
Peak Day | dateTime | attribute | [Interact Model].[Event Activity Day].[Actual Date] |
Max Occurrences | float64 | fact | maximum ([Interact Model].[Event Activity Day].[Occurrences] for [Interact Model].[Peak Day].[Interactive Channel ID], [Interact Model].[Peak Day].[Category ID],[Interact Model].[Peak Day].[Event ID] ) |
Slow Day | Interactive Channel ID | decimal | identifier | [Interact Model].[Event Activity Day].[Interactive Channel ID] |
Category ID | decimal | identifier | [Interact Model].[Event Activity Day].[Category ID] |
Event ID | decimal | identifier | [Interact Model].[Event Activity Day].[Event ID] |
Slowest Day | dateTime | attribute | [Interact Model].[Event Activity Day].[Actual Date] |
Min Occurrences | float64 | fact | minimum ([Interact Model].[Event Activity Day].[Occurrences] for [Interact Model].[Slow Day].[Interactive Channel ID], [Interact Model].[Slow Day].[Category ID],[Interact Model].[Slow Day].[Event ID] ) |
Peak Hour | Int Channel ID | decimal | identifier | [Interact Model].[Event Activity HR].[Interactive Channel ID] |
Cat ID | decimal | identifier | [Interact Model].[Event Activity HR].[Category ID] |
Event ID | decimal | identifier | [Interact Model].[Event Activity HR].[Event ID] |
Peak Day | dateTime | attribute | [Interact Model].[Event Activity HR].[Actual Date] |
Peak Hour | int64 | attribute | [Interact Model].[Event Activity HR].[Hour] |
Max Occur | float64 | fact | maximum ([Interact Model].[Event Activity HR].[Occurrences] for [Interact Model].[Peak Hour].[Int Channel ID] , [Interact Model].[Peak Hour].[Cat ID] , [Interact Model].[Peak Hour].[Event ID] ) |
Slow Hour | Int Channel ID | decimal | identifier | [Interact Model].[Event Activity HR].[Interactive Channel ID] |
Cat ID | decimal | identifier | [Interact Model].[Event Activity HR].[Category ID] |
Event ID | decimal | identifier | [Interact Model].[Event Activity HR].[Event ID] |
Slowest Day | dateTime | attribute | [Interact Model].[Event Activity HR].[Actual Date] |
Slowest Hour | int64 | attribute | [Interact Model].[Event Activity HR].[Hour] |
Min Occur | float64 | fact | minimum ([Interact Model].[Event Activity HR].[Occurrences] for [Interact Model].[Slow Hour].[Int Channel ID], [Interact Model].[Slow Hour].[Cat ID] ,[Interact Model].[Slow Hour].[Event ID] ) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Peak and Slow All | Peak Day All | Interactive Channel ID | decimal | identifier | [Peak and Slow All].[Channel Event Activity Day at IC Level].[Interactive Channel ID] |
Max Occurrences | float64 | fact | maximum ([Peak and Slow All].[Channel Event Activity Day at IC Level].[Occurrences] for [Peak and Slow All].[Peak Day All].[Interactive Channel ID] ) |
Peak Day All | dateTime | attribute | [Peak and Slow All].[Channel Event Activity Day at IC Level].[Actual Date] |
Slow Day All | Interactive Channel ID | decimal | identifier | [Peak and Slow All].[Channel Event Activity Day at IC Level].[Interactive Channel ID] |
Min Occurrences | float64 | fact | minimum ([Peak and Slow All].[Channel Event Activity Day at IC Level].[Occurrences] for [Peak and Slow All].[Slow Day All].[Interactive Channel ID]) |
Slowest Day All | dateTime | attribute | [Peak and Slow All].[Channel Event Activity Day at IC Level].[Actual Date] |
Peak Hour All | Interactive Channel ID | decimal | identifier | [Peak and Slow All].[Channel Event Activity HR at IC Level].[Interactive Channel ID] |
Max Occurrences | float64 | fact | maximum ([Peak and Slow All].[Channel Event Activity HR at IC Level].[Occurrences] for [Peak and Slow All].[Peak Hour All].[Interactive Channel ID] ) |
Peak Day All | dateTime | attribute | [Peak and Slow All].[Channel Event Activity HR at IC Level].[Actual Date] |
Peak Hour All | int64 | attribute | [Peak and Slow All].[Channel Event Activity HR at IC Level].[Hour] |
Slow Hour All | Interactive Channel ID | decimal | identifier | [Peak and Slow All].[Channel Event Activity HR at IC Level].[Interactive Channel ID] |
Min Occurrences | float64 | fact | minimum ([Peak and Slow All].[Channel Event Activity HR at IC Level].[Occurrences] for [Peak and Slow All].[Slow Hour All].[Interactive Channel ID] ) |
Slowest Day All | dateTime | attribute | [Peak and Slow All].[Channel Event Activity HR at IC Level].[Actual Date] |
Slowest Hour All | int64 | attribute | [Peak and Slow All].[Channel Event Activity HR at IC Level].[Hour] |
Channel Event Activity HR at IC Level | Interactive Channel ID | int64 | identifier | [InteractRTDS].[UARI_EV_ACT_IC_HR].[ICID] |
Occurrences | int64 | fact | [InteractRTDS].[UARI_EV_ACT_IC_HR].[NUM_OCCURRENCES] |
Actual Date | dateTime | attribute | [InteractRTDS].[UARI_EV_ACT_IC_HR].[ACTUALDATE] |
Hour | int32 | attribute | [InteractRTDS].[UARI_EV_ACT_IC_HR].[HR] |
Channel Event Activity Day at IC Level | Interactive Channel ID | int64 | identifier | [InteractRTDS].[UARI_EV_ACT_IC_DY].[ICID] |
Occurrences | int64 | fact | [InteractRTDS].[UARI_EV_ACT_IC_DY].[NUM_OCCURRENCES] |
Actual Date | dateTime | attribute | [InteractRTDS].[UARI_EV_ACT_IC_DY].[ACTUALDATE] |
|