Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Common | User | User ID | float64 | fact | [MarketingOperationsDS].[uap_user].[USER_ID] |
Last Name | characterLength16 | attribute | IF ([MarketingOperationsDS].[uap_user].[LAST_NAME] is missing)
THEN ('')
ELSE ([MarketingOperationsDS].[uap_user].[LAST_NAME]) |
First Name | characterLength16 | attribute | IF ([MarketingOperationsDS].[uap_user].[FIRST_NAME] is missing)
THEN ('')
ELSE ([MarketingOperationsDS].[uap_user].[FIRST_NAME]) |
Email Address | characterLength16 | attribute | [MarketingOperationsDS].[uap_user].[EMAIL_ID] |
User Full Name - First Last | characterLength16 | attribute | IF ([MarketingOperationsMV].[User].[First Name] ='')
THEN ([MarketingOperationsMV].[User].[Last Name])
ELSE ([MarketingOperationsMV].[User].[First Name] + ' ' + [MarketingOperationsMV].[User].[Last Name]) |
User Full Name - Last, First | characterLength16 | attribute | IF ([MarketingOperationsMV].[User].[Last Name] ='')
THEN ([MarketingOperationsMV].[User].[First Name])
ELSE ([MarketingOperationsMV].[User].[Last Name] + ', ' + [MarketingOperationsMV].[User].[First Name]) |
Last Modified Date | dateTime | identifier | [MarketingOperationsDS].[uap_user].[LAST_MOD_DATE] |
Login ID | characterLength16 | attribute | [MarketingOperationsDS].[uap_user].[LOGIN_ID] |
Status Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_user].[STATUS_CODE] |
Member Type | Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_member_type].[mem_type_id] |
Member Type Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_member_type].[mem_name] |
Status | Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Template | Template ID | float64 | identifier | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_ID] |
Object Type | float64 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[OBJECT_TYPE] |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[TEMPLATE_NAME] |
Template Display | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[ACTUAL_DISPLAY] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TT_TEMPLATES].[DISPLAY] |
User Roles | role_id | float64 | identifier | [MarketingOperationsDS].[uap_user_roles].[ROLE_ID] |
sec_policy_id | float64 | identifier | [MarketingOperationsDS].[uap_user_roles].[SEC_POLICY_ID] |
user_id | float64 | identifier | [MarketingOperationsDS].[uap_user_roles].[USER_ID] |
Roles | role_id | float64 | identifier | [MarketingOperationsDS].[uap_roles].[ROLE_ID] |
role_name | characterLength16 | attribute | [MarketingOperationsDS].[uap_roles].[ROLE_NAME] |
role_desc | characterLength16 | attribute | [MarketingOperationsDS].[uap_roles].[ROLE_DESC] |
sec_policy_id | float64 | fact | [MarketingOperationsDS].[uap_roles].[SEC_POLICY_ID] |
Users Roles | user_id | float64 | identifier | [MarketingOperationsMV].[User Roles].[user_id] |
role_id | float64 | identifier | [MarketingOperationsMV].[User Roles].[role_id] |
role_name | characterLength16 | attribute | [MarketingOperationsMV].[Roles].[role_name] |
Team | Team ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAMS].[TEAM_ID] |
Team Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TEAMS].[NAME] |
Team Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TEAMS].[DESCRIPTION] |
Team Skillsets | characterLength16 | attribute | [MarketingOperationsDS].[UAP_TEAMS].[SKILLSETS] |
Team Status ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAMS].[STATUS] |
Team Member | Team ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[TEAM_ID] |
Team Member ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[USER_ID] |
Team Member Type ID | float64 | identifier | [MarketingOperationsDS].[UAP_TEAM_MEMBERS].[MEM_TYPE_ID] |
List Definitions | Vendor | Vendor ID | float64 | identifier | [MarketingOperationsDS].[uap_ml_vendor].[VENDOR_ID] |
Vendor Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_vendor].[CODE] |
Vendor Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_vendor].[NAME] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_vendor].[DISPLAY] |
Program Area | Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_prgm_area].[PRGM_AREA_ID] |
Program Area Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgm_area].[NAME] |
Cost Category | Cost Category ID | float64 | identifier | [MarketingOperationsDS].[uap_ml_cost_cat].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_cost_cat].[CODE] |
Cost Category Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_cost_cat].[NAME] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsDS].[uap_ml_cost_cat].[DISPLAY] |
Projects | Project User | | (shortcut) | | [MarketingOperationsMV].[User] |
Shortcut to Task | | (shortcut) | | [MarketingOperationsMV].[Task] |
Projects | Project | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PROJECT_ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[NAME] |
Project Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[PROJ_CODE] |
Project Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[DESCRIPTION] |
Project Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[START_DATE] |
Project End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[END_DATE] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE] |
Project Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[STATE_CODE] |
Project URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=project&id=' + cast(cast([MarketingOperationsMV].[Project].[Project ID], integer), varchar(10)) |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name] + ' (' + [MarketingOperationsMV].[Project].[Project Code] + ')' |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST] |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME] |
Project Requests | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PROJECT_ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[NAME] |
Project Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[PROJ_CODE] |
Project Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[DESCRIPTION] |
Project Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[START_DATE] |
Project End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[END_DATE] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_ST_DATE] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[ACTUAL_END_DATE] |
Project Request Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[STATE_CODE] |
Project Request URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=projectrequest&id=' + cast(cast([MarketingOperationsMV].[Project Requests].[Project ID], integer), varchar(10)) |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name] + ' (' + [MarketingOperationsMV].[Project Requests].[Project Code] + ')' |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[FLAG_PROJ_REQUEST] |
Project Request ID | float64 | identifier | [MarketingOperationsDS].[uap_projects].[PROJ_REQUEST_ID] |
Request Submit Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[REQ_SUBMIT_DATE] |
Request Complete Date | dateTime | identifier | [MarketingOperationsDS].[uap_projects].[REQ_COMP_DATE] |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_projects].[TEMPLATE_NAME] |
Project Owner | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[PROJECT_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID] |
Project Member | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[PROJECT_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_users].[MEM_TYPE_ID] |
Project Status | Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Project Approval | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID] |
Approval Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[NAME] |
Approval Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION] |
Approval Status Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE] |
Approval Date | dateTime | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE] |
Project ID | float64 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID] |
Workflow Task ID | float64 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP] |
Project Template | Template ID | float64 | identifier | [MarketingOperationsMV].[Template].[Template ID] |
Object Type | float64 | attribute | [MarketingOperationsMV].[Template].[Object Type] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Name] |
Template Display | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Display] |
Template Instance Display | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Instance Display] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Workflow
 | Task Parent Project | | (shortcut) | | [MarketingOperationsMV].[Project] |
Stage Parent Project | | (shortcut) | | [MarketingOperationsMV].[Project] |
Task User | | (shortcut) | | [MarketingOperationsMV].[User] |
Workflow | Task Status | Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Milestone | Milestone Type ID | float64 | identifier | [MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_TYPE] |
Milestone | characterLength16 | attribute | [MarketingOperationsDS].[uap_wf_milestone].[MILESTONE_DESC] |
Task | Task ID | float64 | identifier | [MarketingOperationsDS].[uap_workflow].[WF_NO] |
Task Number | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[DISPLAY_ID] |
Task Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[NAME] |
Status | characterLength16 | attribute | IF([MarketingOperationsDS].[uap_workflow].[STATUS_CODE]='' or [MarketingOperationsDS].[uap_workflow].[STATUS_CODE] is null)
THEN ('PENDING')
ELSE([MarketingOperationsDS].[uap_workflow].[STATUS_CODE]) |
% Complete | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PCNT_COMP] |
Forecast/Actual Start | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[FORECAST_ST] |
Forecast/Actual End | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[FORECAST_END] |
Duration | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[DURATION] |
Duration String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[DURATION_STR] |
Actual Duration | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION] |
Actual Duration String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[ACTUAL_DURATION_STR] |
Anchor? | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[FLAG_ANCHOR] |
Start Date | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[START_DATE] |
End Date | dateTime | attribute | [MarketingOperationsDS].[uap_workflow].[END_DATE] |
Milestone Type ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[MILESTONE_TYPE] |
Notes | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[NOTES] |
Project ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PROJECT_ID] |
Parent Stage ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PARENT_STAGE] |
Link? | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[FLAG_LINK] |
Link ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[LINK_ID] |
Link Object | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[LINK_OBJECT] |
Task Number Name | characterLength16 | attribute | [MarketingOperationsMV].[Task].[Task Number] + ' ' + [MarketingOperationsMV].[Task].[Task Name] |
Effort | float64 | fact | [MarketingOperationsDS].[uap_workflow].[EFFORT] |
Effort String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[EFFORT_STR] |
Forecast/Actual Effort | float64 | fact | [MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT] |
Forecast/Actual Effort String | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[ACTUAL_EFFORT_STR] |
Task URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=task&id=' + cast(cast([MarketingOperationsMV].[Task].[Task ID] ,integer),varchar(10)) |
Stage | Stage ID | float64 | identifier | [MarketingOperationsDS].[uap_workflow].[WF_NO] |
Stage Number | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[DISPLAY_ORDER] |
Stage Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_workflow].[NAME] |
Project ID | float64 | attribute | [MarketingOperationsDS].[uap_workflow].[PROJECT_ID] |
Task Member | Task ID | float64 | identifier | [MarketingOperationsDS].[uap_wf_users].[WF_NO] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_wf_users].[USER_ID] |
Project Budgets
 | Project Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Project Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Project Budgets | Project Line Item | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_cost].[PROJECT_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_ID] |
Version ID | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[VERSION_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_NO] |
Account ID | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_cost].[ACCOUNT_CODE] |
Forecast Amount | float64 | fact | [MarketingOperationsDS].[uap_proj_cost].[FORECAST_AMT] |
Committed Amount | float64 | fact | [MarketingOperationsDS].[uap_proj_cost].[COMMITTED_AMT] |
Expenditure Date | dateTime | attribute | [MarketingOperationsDS].[uap_proj_cost].[EXPENDITURE_DATE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_CAT_CODE] |
Item Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_cost].[COST_ITEM_DESC] |
Project Invoice Line Item | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] |
Cost Item Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] |
Source Object ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] |
Source Object Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] |
Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] |
Quantity | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] |
Unit Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] |
Item Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] |
Project Invoice Cost | Project ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Source Object ID] |
Invoice ID | float64 | identifier | [MarketingOperationsMV].[Project Invoice Line Item].[Invoice ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice Number] |
Invoice URL | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice URL] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Display] |
Expenditure Date | dateTime | identifier | if ([MarketingOperationsMV].[Invoice].[Paid Date] = null) THEN ([MarketingOperationsMV].[Invoice].[Due Date]) ELSE ([MarketingOperationsMV].[Invoice].[Paid Date] ) |
Cost Item ID | float64 | identifier | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Number] |
Cost Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Item Description] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Account ID] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Project Invoice Line Item].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Display] |
Item Cost | float64 | fact | [MarketingOperationsMV].[Project Invoice Line Item].[Item Cost] |
Quarter for Project Line Item | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Line Item].[Quarter Description]) - 1) |
Quarter for Project Invoice Cost | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter for Project Invoice Cost].[Quarter Description]) - 1) |
Project Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_budget].[BUDGET_ID] |
Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_budget].[PROJECT_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_proj_budget].[COMMITTED_TOTAL] |
Committed Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Committed Total] |
Forecast Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Forecast Total] |
Actual Remaining Amount | float64 | fact | [MarketingOperationsMV].[Project Budget].[Budget Total] - [MarketingOperationsMV].[Project Budget].[Actual Total] |
Project Metrics | Project Metric | Metric ID | characterLength16 | identifier | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_NAME] |
Display Order | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_ORDER] |
Units | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[UNITS] |
Input Method | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[INPUT_METHOD] |
Display Format | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[DISPLAY_FORMAT] |
Metric Value 1 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE1] |
Metric Value 3 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE3] |
Metric Value 2 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE2] |
Metric Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[DESCRIPTION] |
Formula | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[FORMULA] |
Metric Value 4 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE4] |
Metric Precision | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_PRECISION] |
Metric Value 5 | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_VALUE5] |
Metric Columns | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[METRIC_COLUMNS] |
Project ID | float64 | identifier | [MarketingOperationsDS].[uap_proj_metrics].[PROJECT_ID] |
Metric Group ID | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[GRP_ID] |
Metric NaN 1 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC1_NAN] |
Metric NaN 2 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC2_NAN] |
Metric NaN 3 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC3_NAN] |
Metric NaN 4 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC4_NAN] |
Metric NaN 5 | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[METRIC5_NAN] |
Planned Value | float64 | fact | [MarketingOperationsDS].[uap_proj_metrics].[PLANNED_VALUE] |
Planed NaN | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[PLANNED_NAN] |
Is Planned Value? | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[IS_PLANNED_VALUE] |
Show as Rollup? | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[SHOW_AS_ROLLUP] |
Is Visible? | characterLength16 | attribute | [MarketingOperationsDS].[uap_proj_metrics].[IS_VISIBLE] |
Project Metrics New | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Metric].[Project ID] |
Metric ID | characterLength16 | identifier | [MarketingOperationsMV].[Project Metric].[Metric ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric].[Metric Name] |
Display Order | float64 | fact | [MarketingOperationsMV].[Project Metric].[Display Order] |
Display Format | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric].[Display Format] |
Project Metric Column | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_metric_cols].[PROJECT_ID] |
Column Taborder | float64 | identifier | [MarketingOperationsDS].[uap_metric_cols].[COL_TABORDER] |
Column Display | characterLength16 | attribute | [MarketingOperationsDS].[uap_metric_cols].[COL_DISPLAY] |
Is Target? | characterLength16 | attribute | [MarketingOperationsDS].[uap_metric_cols].[FLAG_TARGET] |
Dimension Type | characterLength16 | attribute | [MarketingOperationsDS].[uap_metric_cols].[DIMENSION_TYPE] |
Project Metric Column Value | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Metric].[Project ID] |
Metric ID | characterLength16 | identifier | [MarketingOperationsMV].[Project Metric].[Metric ID] |
Metric Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric].[Metric Name] |
Display Format | characterLength16 | attribute | [MarketingOperationsMV].[Project Metrics New].[Display Format] |
Display Order | float64 | fact | [MarketingOperationsMV].[Project Metrics New].[Display Order] |
Column Display | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column].[Column Display] |
Metric Value | float64 | fact | if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 0) then ([MarketingOperationsMV].[Project Metric].[Metric Value 1] )
else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 1) then ([MarketingOperationsMV].[Project Metric].[Metric Value 3] )
else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 2) then ([MarketingOperationsMV].[Project Metric].[Metric Value 2] )
else if ([MarketingOperationsMV].[Project Metric Column].[Column Taborder] = 3) then ([MarketingOperationsMV].[Project Metric].[Metric Value 4] )
else ([MarketingOperationsMV].[Project Metric].[Metric Value 5] ) |
Is Target? | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column].[Is Target?] |
Dimension Type | characterLength16 | attribute | [MarketingOperationsMV].[Project Metric Column].[Dimension Type] |
Column Taborder | float64 | identifier | [MarketingOperationsMV].[Project Metric Column].[Column Taborder] |
Project Performance Summary Metrics | PROJECT ID | float64 | fact | |
DISPLAY FORMAT METRIC1 | characterLength16 | attribute | |
ACTUAL VALUE METRIC1 | float64 | fact | |
TARGET VALUE METRIC1 | float64 | fact | |
OPTIMISTIC VALUE METRIC1 | float64 | fact | |
PESSIMISTIC VALUE METRIC1 | float64 | fact | |
DISPLAY FORMAT METRIC2 | characterLength16 | attribute | |
ACTUAL VALUE METRIC2 | float64 | fact | |
TARGET VALUE METRIC2 | float64 | fact | |
OPTIMISTIC VALUE METRIC2 | float64 | fact | |
PESSIMISTIC VALUE METRIC2 | float64 | fact | |
DISPLAY FORMAT METRIC3 | characterLength16 | attribute | |
ACTUAL VALUE METRIC3 | float64 | fact | |
TARGET VALUE METRIC3 | float64 | fact | |
OPTIMISTIC VALUE METRIC3 | float64 | fact | |
PESSIMISTIC VALUE METRIC3 | float64 | fact | |
DISPLAY FORMAT METRIC4 | characterLength16 | attribute | |
ACTUAL VALUE METRIC4 | float64 | fact | |
TARGET VALUE METRIC4 | float64 | fact | |
OPTIMISTIC VALUE METRIC4 | float64 | fact | |
PESSIMISTIC VALUE METRIC4 | float64 | fact | |
DISPLAY FORMAT METRIC5 | characterLength16 | attribute | |
ACTUAL VALUE METRIC5 | float64 | fact | |
TARGET VALUE METRIC5 | float64 | fact | |
OPTIMISTIC VALUE METRIC5 | float64 | fact | |
PESSIMISTIC VALUE METRIC5 | float64 | fact | |
|
Programs | Program Project | | (shortcut) | | [MarketingOperationsMV].[Project] |
Program User | | (shortcut) | | [MarketingOperationsMV].[User] |
Programs | Program | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_programs].[PROGRAM_ID] |
Program Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[NAME] |
Program Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[PROGRAM_CODE] |
Program Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[DESCRIPTION] |
Program Start Date | dateTime | attribute | [MarketingOperationsDS].[uap_programs].[START_DATE] |
Program End Date | dateTime | attribute | [MarketingOperationsDS].[uap_programs].[END_DATE] |
Program Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[STATE_CODE] |
Program Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Program].[Program Name] + ' (' + [MarketingOperationsMV].[Program].[Program Code] + ')' |
Template Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_programs].[TEMPLATE_NAME] |
Program Project Ref | Project ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_project].[PROJECT_ID] |
Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_project].[PROGRAM_ID] |
Program Owner | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID] |
Program Member | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[PROGRAM_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[USER_ID] |
Member Type ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_users].[MEM_TYPE_ID] |
Program Template | Template ID | float64 | identifier | [MarketingOperationsMV].[Template].[Template ID] |
Object Type | float64 | attribute | [MarketingOperationsMV].[Template].[Object Type] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Name] |
Template Display | characterLength16 | attribute | [MarketingOperationsMV].[Template].[Template Display] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Program Budgets
 | Program Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Program Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Quarter for Program Invoice Cost | | (shortcut) | | [MarketingOperationsMV].[Quarter] |
Quarter for Program Line Item | | (shortcut) | | [MarketingOperationsMV].[Quarter] |
Program Budgets | Program Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_ID] |
Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_budget].[PROGRAM_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[COMMITTED_TOTAL] |
Allocation Total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_budget].[ALLOC_TOTAL] |
Finalized Date | dateTime | attribute | [MarketingOperationsDS].[uap_prgrm_budget].[FINALIZED_DATE] |
Program Invoice Line Item | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] |
Item Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] |
Source Object ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] |
Source Object Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] |
Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] |
Quantity | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] |
Unit Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] |
Item Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] |
Program Invoice Cost | Program ID | float64 | identifier | [MarketingOperationsMV].[Program].[Program ID] |
Invoice ID | float64 | identifier | [MarketingOperationsMV].[Program Invoice Line Item].[Invoice ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsMV].[Invoice].[Invoice Number] |
Vendor Display | characterLength16 | attribute | [MarketingOperationsMV].[Vendor].[Vendor Display] |
Expenditure Date | dateTime | attribute | [MarketingOperationsMV].[Invoice].[Paid Date] |
Cost Item ID | float64 | identifier | [MarketingOperationsMV].[Program Invoice Line Item].[Cost Item ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Cost Item Number] |
Item Description | characterLength16 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Item Description] |
Account ID | float64 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Account ID] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name (Code)] |
Cost Category ID | float64 | attribute | [MarketingOperationsMV].[Program Invoice Line Item].[Cost Category ID] |
Cost Category Display | characterLength16 | attribute | [MarketingOperationsMV].[Cost Category].[Cost Category Display] |
Item Cost | float64 | fact | [MarketingOperationsMV].[Program Invoice Line Item].[Item Cost] |
Program Line Item | Program ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_cost].[PROGRAM_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_ID] |
Version ID | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[VERSION_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_NO] |
Cost Item Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_ITEM_DESC] |
Account ID | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[ACCOUNT_CODE] |
Forecast Amount | float64 | fact | [MarketingOperationsDS].[uap_prgrm_cost].[FORECAST_AMT] |
Committed Amount | float64 | fact | [MarketingOperationsDS].[uap_prgrm_cost].[COMMITTED_AMT] |
Expenditure Date | dateTime | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[EXPENDITURE_DATE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_cost].[COST_CAT_CODE] |
Program Metrics | Program Metric | program_id | float64 | identifier | [MarketingOperationsDS].[uap_prgrm_metrics].[PROGRAM_ID] |
metric_id | characterLength16 | identifier | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ID] |
show_as_rollup | characterLength16 | identifier | [MarketingOperationsDS].[uap_prgrm_metrics].[SHOW_AS_ROLLUP] |
display_name | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_NAME] |
display_order | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_ORDER] |
input_method | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[INPUT_METHOD] |
formula | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[FORMULA] |
units | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[UNITS] |
display_format | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[DISPLAY_FORMAT] |
metric_precision | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_PRECISION] |
description | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[DESCRIPTION] |
metric_columns | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_COLUMNS] |
metric_value1 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE1] |
metric_value2 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE2] |
metric_value3 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE3] |
metric_value4 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE4] |
metric_value5 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_VALUE5] |
metric_rollup1 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP1] |
metric_rollup2 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP2] |
metric_rollup3 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP3] |
metric_rollup4 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP4] |
metric_rollup5 | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC_ROLLUP5] |
metric1_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC1_NAN] |
metric2_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC2_NAN] |
metric3_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC3_NAN] |
metric4_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC4_NAN] |
metric5_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[METRIC5_NAN] |
planned_value | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_VALUE] |
planned_nan | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[PLANNED_NAN] |
grp_id | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[GRP_ID] |
is_planned_value | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[IS_PLANNED_VALUE] |
alloc_total | float64 | fact | [MarketingOperationsDS].[uap_prgrm_metrics].[ALLOC_TOTAL] |
is_visible | characterLength16 | attribute | [MarketingOperationsDS].[uap_prgrm_metrics].[IS_VISIBLE] |
|
Plans | Plan Program | | (shortcut) | | [MarketingOperationsMV].[Program] |
Plan Program Area | | (shortcut) | | [MarketingOperationsMV].[Program Area] |
Plan User | | (shortcut) | | [MarketingOperationsMV].[User] |
Plans | Plan | Plan ID | float64 | fact | [MarketingOperationsDS].[uap_plans].[PLAN_ID] |
Plan Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[PLAN_CODE] |
Plan Name | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[NAME] |
Plan Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[DESCRIPTION] |
Plan Status Code | characterLength16 | attribute | [MarketingOperationsDS].[uap_plans].[STATE_CODE] |
Plan Fiscal Year | float64 | attribute | [MarketingOperationsDS].[uap_plans].[FISCAL_YEAR] |
Plan Business Area ID | float64 | attribute | [MarketingOperationsDS].[uap_plans].[BUS_AREA_ID] |
Start Date | dateTime | attribute | [MarketingOperationsDS].[uap_plans].[ACTUAL_ST_DATE] |
End Date | dateTime | attribute | [MarketingOperationsDS].[uap_plans].[ACTUAL_END_DATE] |
Plan Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Plan].[Plan Name] + ' (' + [MarketingOperationsMV].[Plan].[Plan Code] + ')' |
Plan Program Area Ref | Plan Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_parea].[PLAN_PAREA_ID] |
Plan ID | float64 | attribute | [MarketingOperationsDS].[uap_plan_parea].[PLAN_ID] |
Program Area ID | float64 | attribute | [MarketingOperationsDS].[uap_plan_parea].[PRGM_AREA_ID] |
Display Order | float64 | attribute | [MarketingOperationsDS].[uap_plan_parea].[DISPLAY_ORDER] |
Plan Program Ref | Plan ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_prgrm].[PLAN_ID] |
Program ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_prgrm].[PROGRAM_ID] |
Plan Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_prgrm].[PLAN_PAREA_ID] |
Plan Member | Plan ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_users].[PLAN_ID] |
Member Type ID | float64 | attribute | [MarketingOperationsDS].[uap_plan_users].[MEM_TYPE_ID] |
User ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_users].[USER_ID] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Plan Budgets
 | Plan Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Plan Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Program Area Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Program Area Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Plan Budgets | Plan Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_budget].[BUDGET_ID] |
Plan ID | float64 | identifier | [MarketingOperationsDS].[uap_plan_budget].[PLAN_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[COMMITTED_TOTAL] |
Allocated Total | float64 | fact | [MarketingOperationsDS].[uap_plan_budget].[ALLOC_TOTAL] |
Finalized Date | dateTime | attribute | [MarketingOperationsDS].[uap_plan_budget].[FINALIZED_DATE] |
Program Area Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_parea_budget].[BUDGET_ID] |
Plan Program Area ID | float64 | identifier | [MarketingOperationsDS].[uap_parea_budget].[PLAN_PAREA_ID] |
Budget Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[BUDGET_TOTAL] |
Forecast Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[FORECAST_TOTAL] |
Actual Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[ACTUAL_TOTAL] |
Committed Total | float64 | fact | [MarketingOperationsDS].[uap_parea_budget].[COMMITTED_TOTAL] |
Finalized Date | dateTime | attribute | [MarketingOperationsDS].[uap_parea_budget].[FINALIZED_DATE] |
|
Accounts | Parent Account | | (shortcut) | | [MarketingOperationsMV].[Account] |
Account Budget Amount | | (shortcut) | | [MarketingOperationsMV].[Budget Amount] |
Account Budget Reference | | (shortcut) | | [MarketingOperationsMV].[Budget] |
Accounts | Account | Account ID | float64 | identifier | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_CODE] |
Account Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_DESC] |
Parent Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[SRC_ACCOUNT_ID] |
Account Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_ACCOUNTS].[ACCOUNT_NAME] |
Account Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Account].[Account Name] + ' (' + [MarketingOperationsMV].[Account].[Account Code] + ')' |
Account Budget | Account ID | float64 | identifier | [MarketingOperationsDS].[UAP_ACT_BUDGET].[ACCOUNT_ID] |
Budget ID | float64 | identifier | [MarketingOperationsDS].[UAP_ACT_BUDGET].[BUDGET_ID] |
Sub-Account Budget Amount | Account ID | float64 | identifier | |
Quarter_ID | float64 | identifier | |
Year1 | float64 | identifier | |
Month1 | float64 | identifier | |
Budget_Amount | float64 | fact | |
Forecast_Amount | float64 | fact | |
Committed_Amount | float64 | fact | |
Actual_Amount | float64 | fact | |
Approvals | Approver User | | (shortcut) | | [MarketingOperationsMV].[User] |
Approvals | Approval | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_ID] |
Approval Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[NAME] |
Approval Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[DESCRIPTION] |
Approval Status Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[STATE_CODE] |
Approval Date | dateTime | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[APPROVAL_DATE] |
Source Object ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT_ID] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_OBJECT] |
Source Workflow Task ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVALS].[SRC_WF_STEP] |
Approval Item | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPR_ITEMS].[APPROVAL_ID] |
Approval Item Order | float64 | attribute | [MarketingOperationsDS].[UAP_APPR_ITEMS].[APPR_ITEM_SEQ] |
Approval Item Name | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPR_ITEMS].[ORIG_FILE_NAME] |
Approver | Approval ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVER_LIST].[APPROVAL_ID] |
Approver Status | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[STATUS_CODE] |
Approver Order | float64 | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[APPR_ORDER] |
User ID | float64 | identifier | [MarketingOperationsDS].[UAP_APPROVER_LIST].[USER_ID] |
Is Required? | characterLength16 | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[REQUIRED] |
Response Date | dateTime | attribute | [MarketingOperationsDS].[UAP_APPROVER_LIST].[RESP_DATE] |
Approval Status | Approval Status Code | characterLength16 | identifier | [MarketingOperationsDS].[uap_status].[STATUS_CODE] |
Approval Status | characterLength16 | attribute | [MarketingOperationsDS].[uap_status].[STATUS_DESC] |
Budgets | Budget Amount | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[MONTH] |
Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_budget_amt].[BUDGET_ID] |
Forecast Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[FORECAST_AMT] |
Committed Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[COMMITTED_AMT] |
Actual Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[ACTUAL_AMT] |
Budget Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[BUDGET_AMT] |
Allocated Amount | float64 | fact | [MarketingOperationsDS].[uap_budget_amt].[ALLOC_AMT] |
Committed Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Committed Amount] is null ) THEN
([MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Committed Amount] ) |
Forecast Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Forecast Amount] is null ) THEN
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Forecast Amount] ) |
Actual Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Actual Amount] is null) THEN
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Actual Amount] ) |
Allocated Remaining Amount | float64 | fact | IF ( [MarketingOperationsMV].[Budget Amount].[Allocated Amount] is null ) THEN
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] )
ELSE
( [MarketingOperationsMV].[Budget Amount].[Budget Amount] - [MarketingOperationsMV].[Budget Amount].[Allocated Amount] ) |
Quarter | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Quarter].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Quarter].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Quarter].[Quarter Description]) - 1) |
Fiscal Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Quarter].[Quarter Description] , 5,4) |
Budget | Budget ID | float64 | identifier | [MarketingOperationsDS].[uap_budgets].[BUDGET_ID] |
Invoices | Invoice | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_ID] |
Invoice Number | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_NO] |
Vendor ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[VENDOR_ID] |
PO Number | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PO_NO] |
Due Date | dateTime | identifier | [MarketingOperationsDS].[UAP_INVOICES].[DUE_DATE] |
Status Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[STATUS_CODE] |
State Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[STATE_CODE] |
Invoice Date | dateTime | identifier | [MarketingOperationsDS].[UAP_INVOICES].[SUBMIT_DATE] |
Notes | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[NOTES] |
Payment Terms | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PAYMENT_TERMS] |
Invoice Amount | float64 | fact | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_AMOUNT] |
Invoice Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICES].[INVOICE_CODE] |
Payable Date | dateTime | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PAYABLE_DATE] |
Paid Date | dateTime | attribute | [MarketingOperationsDS].[UAP_INVOICES].[PAID_DATE] |
Invoice URL | characterLength16 | attribute | #sq($[Environment]{'URL'})# + 'type=invoice&id=' + cast(cast([MarketingOperationsMV].[Invoice].[Invoice ID],integer),varchar(10)) |
Invoice Line Item | Invoice ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[INVOICE_ID] |
Cost Item ID | float64 | identifier | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_ID] |
Cost Item Number | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_NO] |
Item Description | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_ITEM_DESC] |
Source Object Type | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_TYPE] |
Source Object ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_ID] |
Source Object Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[SRC_OBJ_CODE] |
Account ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_ID] |
Account Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ACCOUNT_CODE] |
Cost Category ID | float64 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_ID] |
Cost Category Code | characterLength16 | attribute | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[COST_CAT_CODE] |
Quantity | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[QUANTITY] |
Unit Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[UNIT_COST] |
Item Cost | float64 | fact | [MarketingOperationsDS].[UAP_INVOICE_ITEMS].[ITEM_COST] |
Custom Attributes | Project Custom Attributes | Project ID | float64 | identifier | [MarketingOperationsDS].[DYN_PROJECTATTS].[PROJECT_ID] |
Initiative ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[INIT_TYPE_ID] |
Segment ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[SEGMENT_ID] |
Channel_Id | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[CHANNEL_ID] |
Business Unit ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[BUSINESS_UNIT_ID] |
Product Family ID | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[PROD_FAMILY_ID] |
Budget Period Id | float64 | fact | [MarketingOperationsDS].[DYN_PROJECTATTS].[BUDGET_PERIOD_ID] |
Business Unit | Business Unit ID | float64 | identifier | [MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_ID] |
Business Unit | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_BUSINESS_UNIT].[BUSINESS_UNIT_NAME] |
Initiative | Initiative ID | float64 | identifier | [MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_ID] |
Initiative | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_INITIATIVE].[INIT_TYPE_NAME] |
Product Family | Product Family ID | float64 | identifier | [MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_ID] |
Product Family | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_PROD_FAMILY].[PROD_FAMILY_NAME] |
Segment | Segment ID | float64 | identifier | [MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_ID] |
Segment | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_SEGMENTS].[SEGMENT_NAME] |
Project Performance Summary Custom Metrics | Project ID | float64 | fact | |
Total Revenue | float64 | fact | |
ResponseRateActual | float64 | fact | |
ResponseRateTarget | float64 | fact | |
Total Leads Generated (Actual) | float64 | fact | |
Total Leads Generated (Target) | float64 | fact | |
Total Cost Passed | float64 | fact | |
Channel | CHANNEL_ID | float64 | identifier | [MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_ID] |
CHANNEL_NAME | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_CHANNEL].[CHANNEL_NAME] |
Budget Period | budget_period_id | float64 | identifier | [MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_ID] |
budget_period_name | characterLength16 | attribute | [MarketingOperationsDS].[LKUP_BUDGET_PERIOD].[BUDGET_PERIOD_NAME] |
Dashboards | Requests Over Time | Project ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Code] |
Project Description | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Description] |
Project Start Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Start Date] |
Project End Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project End Date] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Actual Start Date] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Project Actual End Date] |
Project Request Status | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request Status] |
Project URL | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request URL] |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Name (Code)] |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Project Request Flag] |
Project Request ID | float64 | identifier | [MarketingOperationsMV].[Project Requests].[Project Request ID] |
Request Submit Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Request Submit Date] |
Request Complete Date | dateTime | identifier | [MarketingOperationsMV].[Project Requests].[Request Complete Date] |
Request Submit Month | int32 | identifier | extract(month, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] ) -1 |
Request Submit Year | int32 | identifier | extract (year, [MarketingOperationsMV].[Requests Over Time].[Request Submit Date] ) |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Project Requests].[Template Name] |
Projects Over Time | Project ID | float64 | identifier | [MarketingOperationsMV].[Project].[Project ID] |
Project Name | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name] |
Project Code | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Code] |
Project Description | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Description] |
Project Start Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Start Date] |
Project End Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project End Date] |
Project Actual Start Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Actual Start Date] |
Project Actual End Date | dateTime | identifier | [MarketingOperationsMV].[Project].[Project Actual End Date] |
Project Actual End Month | float64 | identifier | extract(month, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] ) -1 |
Project Actual End Year | float64 | identifier | extract(year, [MarketingOperationsMV].[Projects Over Time].[Project Actual End Date] ) |
Project Status Code | characterLength16 | identifier | [MarketingOperationsMV].[Project Status].[Status Code] |
Project Status | characterLength16 | attribute | [MarketingOperationsMV].[Project Status].[Status] |
Project URL | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project URL] |
Project Name (Code) | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Name (Code)] |
Project Request Flag | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Project Request Flag] |
Template Name | characterLength16 | attribute | [MarketingOperationsMV].[Project].[Template Name] |
Projects Quarter | Quarter ID | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[QUARTER_ID] |
Year | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[YEAR] |
Month | float64 | identifier | [MarketingOperationsDS].[uap_quarters].[MONTH] |
Quarter Description | characterLength16 | attribute | [MarketingOperationsDS].[uap_quarters].[DESCRIPTION] |
Quarter Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , position ( '(' , [MarketingOperationsMV].[Projects Quarter].[Quarter Description] ) + 1, 7) |
Month Year | characterLength16 | attribute | substring ( [MarketingOperationsMV].[Projects Quarter].[Quarter Description], 0, position('(', [MarketingOperationsMV].[Projects Quarter].[Quarter Description]) - 1) |
Fiscal Year | characterLength16 | attribute | substring ([MarketingOperationsMV].[Projects Quarter].[Quarter Description] , 5,4) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Projects and Requests Over Time Star Schema
 | Requests Over Time | | (shortcut) | | [MarketingOperationsMV].[Requests Over Time] |
Projects Over Time | | (shortcut) | | [MarketingOperationsMV].[Projects Over Time] |
Projects Quarter | | (shortcut) | | [MarketingOperationsMV].[Projects Quarter] |
|
Campaign Common | ControlCells | | (shortcut) | | [Model View].[Cell] |
Campaign Common | Campaign | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CAMPAIGN].[CAMPAIGNID] |
Campaign Name | characterLength16 | attribute | [CampaignDS].[UARC_CAMPAIGN].[NAME] |
Description | characterLength16 | attribute | [CampaignDS].[UARC_CAMPAIGN].[DESCRIPTION] |
Campaign Code | characterLength16 | attribute | [CampaignDS].[UARC_CAMPAIGN].[CAMPAIGNCODE] |
Objectives | characterLength16 | attribute | [CampaignDS].[UARC_CAMPAIGN].[OBJECTIVES] |
Last Run Date | dateTime | attribute | [CampaignDS].[UARC_CAMPAIGN].[LASTRUNDATE] |
Initiative | characterLength16 | attribute | IF ([CampaignDS].[UARC_CAMPAIGN].[INITIATIVE]=' ' OR [CampaignDS].[UARC_CAMPAIGN].[INITIATIVE] is missing)
THEN(' ')
ELSE([CampaignDS].[UARC_CAMPAIGN].[INITIATIVE]) |
Create Date | dateTime | attribute | [CampaignDS].[UARC_CAMPAIGN].[CREATEDATE] |
Update Date | dateTime | attribute | [CampaignDS].[UARC_CAMPAIGN].[UPDATEDATE] |
Start Date | dateTime | attribute | [CampaignDS].[UARC_CAMPAIGN].[STARTDATE] |
End Date | dateTime | attribute | [CampaignDS].[UARC_CAMPAIGN].[ENDDATE] |
CampaignURL | characterLength16 | attribute | #sq($[Environment]{'Redirect URL'})# + 'type=campaign&id=' + cast(cast([Model View].[Campaign].[Campaign ID] , integer), varchar(10)) |
Not Applilcable Calc | character | attribute | '-' |
Create By | int64 | attribute | [CampaignDS].[UARC_CAMPAIGN].[CREATEBY] |
Update By | int64 | attribute | [CampaignDS].[UARC_CAMPAIGN].[UPDATEBY] |
Run By | int64 | attribute | [CampaignDS].[UARC_CAMPAIGN].[RUNBY] |
Project ID | int64 | identifier | [CampaignDS].[UARC_CAMPAIGN].[PROJECTID] |
Creator Flag | int64 | attribute | [CampaignDS].[UARC_CAMPAIGN].[CREATORFLAG] |
Offer | Offer ID | decimal | identifier | [CampaignDS].[UARC_OFFER].[OFFERID] |
Offer Name | characterLength16 | attribute | [CampaignDS].[UARC_OFFER].[NAME] |
OfferURL | characterLength16 | attribute | #sq($[Environment]{'Redirect URL'})# + 'type=offer&id=' + cast(cast([Model View].[Offer].[Offer ID] , integer), varchar(10)) |
Offer Code1 | characterLength16 | attribute | [CampaignDS].[UARC_OFFER].[OFFERCODE1] |
Offer Code2 | characterLength16 | attribute | [CampaignDS].[UARC_OFFER].[OFFERCODE2] |
Offer Code3 | characterLength16 | attribute | [CampaignDS].[UARC_OFFER].[OFFERCODE3] |
Offer Code4 | characterLength16 | attribute | [CampaignDS].[UARC_OFFER].[OFFERCODE4] |
Offer Code5 | characterLength16 | attribute | [CampaignDS].[UARC_OFFER].[OFFERCODE5] |
Create Date | dateTime | attribute | [CampaignDS].[UARC_OFFER].[CREATEDATE] |
Create By | int64 | attribute | [CampaignDS].[UARC_OFFER].[CREATEBY] |
Update Date | dateTime | attribute | [CampaignDS].[UARC_OFFER].[UPDATEDATE] |
Update By | int64 | attribute | [CampaignDS].[UARC_OFFER].[UPDATEBY] |
Retired | int64 | attribute | [CampaignDS].[UARC_OFFER].[RETIRED] |
Cell | Cell ID | decimal | identifier | [CampaignDS].[UARC_CELL].[CELLID] |
Cell Name | characterLength16 | attribute | [CampaignDS].[UARC_CELL].[CELLNAME] |
Cell Code | characterLength16 | attribute | [CampaignDS].[UARC_CELL].[CELLCODE] |
Control Cell ID | decimal | attribute | [CampaignDS].[UARC_CELL].[CONTROLCELLID] |
Is Control | int64 | attribute | [CampaignDS].[UARC_CELL].[ISCONTROL] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_CELL].[CAMPAIGNID] |
CampToOffer | Offer ID | decimal | identifier | [CampaignDS].[UARC_CAMPTOOFFER].[OFFERID] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_CAMPTOOFFER].[CAMPAIGNID] |
Calendar | Date ID | decimal | identifier | [CampaignDS].[UARC_CALENDAR].[DATEID] |
Year | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[YEAR] |
Fiscal Year | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[FISCALYEAR] |
Quarter | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[QUARTER] |
Fiscal Quarter | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[FISCALQUARTER] |
Month | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[MONTH] |
Week of Year | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[WEEKOFYEAR] |
Week of Month | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[WEEKOFMONTH] |
Day of Year | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[DAYOFYEAR] |
Day of Month | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[DAYOFMONTH] |
Day of Week | int64 | attribute | [CampaignDS].[UARC_CALENDAR].[DAYOFWEEK] |
Actual Date | dateTime | identifier | [CampaignDS].[UARC_CALENDAR].[ACTUALDATE] |
First Day of Week | dateTime | attribute | [CampaignDS].[UARC_CALENDAR].[FIRSTDAYOFWEEK] |
Last Day of Week | dateTime | attribute | [CampaignDS].[UARC_CALENDAR].[LASTDAYOFWEEK] |
Calendar Month | Date ID | int64 | identifier | [Model View].[Calendar].[Date ID] |
Year | int32 | attribute | [Model View].[Calendar].[Year] |
Fiscal Year | int32 | attribute | [Model View].[Calendar].[Fiscal Year] |
Month | int32 | attribute | [Model View].[Calendar].[Month] |
Time | Time ID | decimal | identifier | [CampaignDS].[UARC_TIME].[TIMEID] |
Hour | int64 | identifier | [CampaignDS].[UARC_TIME].[HOUR] |
Minute | int64 | identifier | [CampaignDS].[UARC_TIME].[MINUTE] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Listing Star Schema
 | Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
CampToOffer | | (shortcut) | | [Model View].[CampToOffer] |
|
Campaign Custom Attributes | Campaign Cust Attributes | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CAMPEXTATTR].[CAMPAIGNID] |
Offer Custom Attributes | Offer ID | decimal | identifier | [CampaignDS].[UARC_OFFEREXTATTR].[OFFERID] |
Effective Date | dateTime | attribute | [CampaignDS].[UARC_OFFEREXTATTR].[EFFECTIVE_DATE] |
Expiration Date | dateTime | attribute | [CampaignDS].[UARC_OFFEREXTATTR].[EXPIRATION_DATE] |
Expiration Duration | float64 | fact | [CampaignDS].[UARC_OFFEREXTATTR].[EXPIRATION_DUR] |
Channel | characterLength16 | attribute | [CampaignDS].[UARC_OFFEREXTATTR].[CHANNEL] |
Cost Per Contact | float64 | fact | IF([CampaignDS].[UARC_OFFEREXTATTR].[COST_PER_CONTACT] is missing)
THEN (0)
ELSE
([CampaignDS].[UARC_OFFEREXTATTR].[COST_PER_CONTACT])
|
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_OFFEREXTATTR].[REVENUE_PER_RESP] is missing)
THEN (0)
ELSE
([CampaignDS].[UARC_OFFEREXTATTR].[REVENUE_PER_RESP]) |
Offer Fulfillment Cost | float64 | fact | IF([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FULFILL_COST] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FULFILL_COST]) |
Offer Fixed Cost | float64 | fact | IF ([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FIXED_COST] is missing)
THEN (0)
ELSE ([CampaignDS].[UARC_OFFEREXTATTR].[OFFER_FIXED_COST]) |
Cell Custom Attributes | Cell ID | decimal | identifier | [CampaignDS].[UARC_CELLEXTATTR].[CELLID] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Custom Attributes Star Schema
 | Campaign Cust Attributes | | (shortcut) | | [Model View].[Campaign Cust Attributes] |
Offer Custom Attributes | | (shortcut) | | [Model View].[Offer Custom Attributes] |
Cell Custom Attributes | | (shortcut) | | [Model View].[Cell Custom Attributes] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
CampToOffer | | (shortcut) | | [Model View].[CampToOffer] |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance Day | Campaign Contact History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCH_DY].[CAMPAIGNID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCH_DY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCH_DY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCH_DY].[NUM_OFF_VERS_CG] |
Campaign Offer Contact History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_COCH_DY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_COCH_DY].[OFFERID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_COCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_COCH_DY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_COCH_DY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_COCH_DY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_COCH_DY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_COCH_DY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_COCH_DY].[NUM_OFF_VERS_CG] |
Campaign Cell Contact History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCCH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCCH_DY].[CELLID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CCCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_DY].[NUM_OFF_VERS_CG] |
Campaign Response History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CRH_DY].[CAMPAIGNID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CRH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CRH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CRH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CRH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CRH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_DY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG] is missing)
THEN (0)
ELSE ([CampaignDS].[UARC_CRH_DY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE ([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CRH_DY].[GROSS_REVENUE_CG]) |
Campaign Offer Response History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CORH_DY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_CORH_DY].[OFFERID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CORH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CORH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CORH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CORH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CORH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG] IS MISSING)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_DY].[GROSS_REVENUE_CG]) |
Campaign Cell Response History by Day | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCRH_DY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCRH_DY].[CELLID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_CCRH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_DY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_DY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CCRH_DY].[GROSS_REVENUE_CG]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance by Day Star Schema
 | Campaign Contact History by Day | | (shortcut) | | [Model View].[Campaign Contact History by Day] |
Campaign Offer Contact History by Day | | (shortcut) | | [Model View].[Campaign Offer Contact History by Day] |
Campaign Cell Contact History by Day | | (shortcut) | | [Model View].[Campaign Cell Contact History by Day] |
Campaign Response History by Day | | (shortcut) | | [Model View].[Campaign Response History by Day] |
Campaign Offer Response History by Day | | (shortcut) | | [Model View].[Campaign Offer Response History by Day] |
Campaign Cell Response History by Day | | (shortcut) | | [Model View].[Campaign Cell Response History by Day] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
ControlCells | | (shortcut) | | [Model View].[Cell] |
Responder Rate Control Group by Cell by Day | | (shortcut) | | [Model View].[Responder Rate Control Group by Cell by Day] |
Calendar | | (shortcut) | | [Model View].[Calendar] |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Responder Rate Calculations by Day | Responder Rate by Cell by Day | Cell ID | decimal | identifier | [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Responder Rate | float64 | fact | IF([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients] is missing)
THEN(0)
ELSE([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients]) |
Responder Rate Control Group by Cell by Day | Cell ID | decimal | identifier | [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Campaign ID | decimal | identifier | [Campaign Performance by Day Star Schema].[Cell][Model View].[Cell].[Campaign ID] |
Responder Rate Control Group | float64 | fact | IF([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders Control Group] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients Control Group] is missing)
THEN(0)
ELSE([Campaign Performance by Day Star Schema].[Campaign Cell Response History by Day][Model View].[Campaign Cell Response History by Day].[Unique Responders Control Group] /[Campaign Performance by Day Star Schema].[Campaign Cell Contact History by Day][Model View].[Campaign Cell Contact History by Day].[Unique Recipients Control Group]) |
|
Campaign Performance by Month | Campaign Contact History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCH_MO].[CAMPAIGNID] |
Month | float64 | attribute | [CampaignDS].[UARC_CCH_MO].[MONTH] |
Year | float64 | attribute | [CampaignDS].[UARC_CCH_MO].[YEAR] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCH_MO].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCH_MO].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCH_MO].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCH_MO].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCH_MO].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCH_MO].[NUM_OFF_VERS_CG] |
Campaign Offer Contact History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_COCH_MO].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_COCH_MO].[OFFERID] |
Month | float64 | attribute | [CampaignDS].[UARC_COCH_MO].[MONTH] |
Year | float64 | attribute | [CampaignDS].[UARC_COCH_MO].[YEAR] |
Number of Offers | float64 | fact | [CampaignDS].[UARC_COCH_MO].[NUM_OF_OFFERS] |
Number of Offers Control Group | float64 | fact | [CampaignDS].[UARC_COCH_MO].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_COCH_MO].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_COCH_MO].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_COCH_MO].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_COCH_MO].[NUM_OFF_VERS_CG] |
Campaign Cell Contact History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCCH_MO].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCCH_MO].[CELLID] |
Month | float64 | attribute | [CampaignDS].[UARC_CCCH_MO].[MONTH] |
Year | float64 | attribute | [CampaignDS].[UARC_CCCH_MO].[YEAR] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_MO].[NUM_OFF_VERS_CG] |
Campaign Response History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CRH_MO].[CAMPAIGNID] |
Month | decimal | attribute | [CampaignDS].[UARC_CRH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_CRH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CRH_MO].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CRH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CRH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CRH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_MO].[GROSS_REVENUE_CG]) |
Campaign Offer Response History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CORH_MO].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_CORH_MO].[OFFERID] |
Month | decimal | attribute | [CampaignDS].[UARC_CORH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_CORH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CORH_MO].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CORH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CORH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CORH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_MO].[GROSS_REVENUE_CG]) |
Campaign Cell Response History by Month | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCRH_MO].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCRH_MO].[CELLID] |
Month | decimal | attribute | [CampaignDS].[UARC_CCRH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_CCRH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CCRH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_MO].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_MO].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_MO].[GROSS_REVENUE_CG]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance by Month Star Schema
 | Campaign Contact History by Month | | (shortcut) | | [Model View].[Campaign Contact History by Month] |
Campaign Offer Contact History by Month | | (shortcut) | | [Model View].[Campaign Offer Contact History by Month] |
Campaign Cell Contact History by Month | | (shortcut) | | [Model View].[Campaign Cell Contact History by Month] |
Campaign Response History by Month | | (shortcut) | | [Model View].[Campaign Response History by Month] |
Campaign Offer Response History by Month | | (shortcut) | | [Model View].[Campaign Offer Response History by Month] |
Campaign Cell Response History by Month | | (shortcut) | | [Model View].[Campaign Cell Response History by Month] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
ControlCells | | (shortcut) | | [Model View].[Cell] |
Responder Rate Control Group by Cell by Month | | (shortcut) | | [Model View].[Responder Rate Control Group by Cell by Month] |
Calendar Month | | (shortcut) | | [Model View].[Calendar Month] |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Responder Rate Calculations by Month | Responder Rate by Cell by Month | Cell ID | decimal | identifier | [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Responder Rate by Month | float64 | fact | IF([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients] is missing)
THEN(0)
ELSE([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients]) |
Responder Rate Control Group by Cell by Month | Cell ID | decimal | identifier | [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Campaign ID | decimal | identifier | [Campaign Performance by Month Star Schema].[Cell][Model View].[Cell].[Campaign ID] |
Responder Rate Control Group | float64 | fact | IF([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders Control Group] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients Control Group] is missing)
THEN(0)
ELSE([Campaign Performance by Month Star Schema].[Campaign Cell Response History by Month][Model View].[Campaign Cell Response History by Month].[Unique Responders Control Group] /[Campaign Performance by Month Star Schema].[Campaign Cell Contact History by Month][Model View].[Campaign Cell Contact History by Month].[Unique Recipients Control Group]) |
|
Campaign Performance Summary | Campaign Contact History Summary | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CCH_SUMMARY].[CAMPAIGNID] |
Number of Offers Given | int32 | fact | [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | int32 | fact | [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OF_OFFERS_CG] |
Unique Recipients | int32 | fact | [CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | int32 | fact | [CampaignDS].[UARC_CCH_SUMMARY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | int32 | fact | [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | int32 | fact | [CampaignDS].[UARC_CCH_SUMMARY].[NUM_OFF_VERS_CG] |
Campaign Response History Summary | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CRH_SUMMARY].[CAMPAIGNID] |
Response Transactions | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS] |
Response Transactions Control Group | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_TRANS_CG] |
Unique Responders | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | int32 | fact | [CampaignDS].[UARC_CRH_SUMMARY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | decimal | fact | IF([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRH_SUMMARY].[GROSS_REVENUE_CG]) |
Campaign Offer Contact History Summary | Campaign ID | decimal | identifier | [CampaignDS].[UARC_COCH_SUMMARY].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_COCH_SUMMARY].[OFFERID] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_COCH_SUMMARY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_COCH_SUMMARY].[NUM_OFF_VERS_CG] |
Campaign Offer Response History Summary | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CORH_SUMMARY].[CAMPAIGNID] |
Offer ID | int64 | identifier | [CampaignDS].[UARC_CORH_SUMMARY].[OFFERID] |
Response Transactions | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS] |
Unique Responders | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_AFTER_EXP_CG] |
Response Transactions Control Group | int32 | fact | [CampaignDS].[UARC_CORH_SUMMARY].[RESP_TRANS_CG] |
Revenue Per Response | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | decimal | fact | IF([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORH_SUMMARY].[GROSS_REVENUE_CG]) |
Campaign Cell Contact History Summary | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCCH_SUMMARY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCCH_SUMMARY].[CELLID] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCCH_SUMMARY].[NUM_OFF_VERS_CG] |
Campaign Cell Response History Summary | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CCRH_SUMMARY].[CAMPAIGNID] |
Cell ID | int64 | identifier | [CampaignDS].[UARC_CCRH_SUMMARY].[CELLID] |
Response Transactions | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS] |
Unique Responders | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_AFTER_EXP_CG] |
Response Transactions Control Group | int32 | fact | [CampaignDS].[UARC_CCRH_SUMMARY].[RESP_TRANS_CG] |
Revenue Per Response | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | decimal | fact | IF([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCRH_SUMMARY].[GROSS_REVENUE_CG]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Performance Summary Star Schema
 | Campaign Contact History Summary | | (shortcut) | | [Model View].[Campaign Contact History Summary] |
Campaign Response History Summary | | (shortcut) | | [Model View].[Campaign Response History Summary] |
Campaign Offer Contact History Summary | | (shortcut) | | [Model View].[Campaign Offer Contact History Summary] |
Campaign Offer Response History Summary | | (shortcut) | | [Model View].[Campaign Offer Response History Summary] |
Campaign Cell Contact History Summary | | (shortcut) | | [Model View].[Campaign Cell Contact History Summary] |
Campaign Cell Response History Summary | | (shortcut) | | [Model View].[Campaign Cell Response History Summary] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Cell | | (shortcut) | | [Model View].[Cell] |
ControlCells | | (shortcut) | | [Model View].[Cell] |
Responder Rate Control Group at Cell Level | | (shortcut) | | [Model View].[Responder Rate Control Group at Cell Level] |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Responder Rate Calculations Performance Summary | Responder Rate at Cell Level | Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Responder Rate | float64 | fact | IF([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients] is missing)
THEN(0)
ELSE([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients]) |
Responder Rate Control Group at Cell Level | Cell ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Cell ID] |
Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Cell][Model View].[Cell].[Campaign ID] |
Responder Rate Control Group | float64 | fact | IF([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group] is missing)
THEN(0)
ELSE([Campaign Performance Summary Star Schema].[Campaign Cell Response History Summary][Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] /[Campaign Performance Summary Star Schema].[Campaign Cell Contact History Summary][Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group]) |
Unique Recipients Control Group | float64 | fact | [Model View].[Campaign Cell Contact History Summary].[Unique Recipients Control Group] |
Unique Responders Control Group | float64 | fact | [Model View].[Campaign Cell Response History Summary].[Unique Responders Control Group] |
|
|
Campaign Detailed Response Breakout | Campaign Response Breakout | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CRBO].[CAMPAIGNID] |
Explore Count | int32 | fact | IF([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT]) |
Explore Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[EXPLORE_COUNT_CG]) |
Consider Count | int32 | fact | IF([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT]) |
Consider Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[CONSIDER_COUNT_CG]) |
Commit Count | int32 | fact | IF([CampaignDS].[UARC_CRBO].[COMMIT_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[COMMIT_COUNT]) |
Commit Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CRBO].[COMMIT_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[COMMIT_COUNT_CG]) |
Fulfill Count | int32 | fact | IF([CampaignDS].[UARC_CRBO].[FULFILL_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[FULFILL_COUNT]) |
Fulfill Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CRBO].[FULFILL_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[FULFILL_COUNT_CG]) |
Counts As Response (All) | int32 | fact | IF([CampaignDS].[UARC_CRBO].[ALL_COUNTS_AS_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[ALL_COUNTS_AS_RESP]) |
All Responses | int32 | fact | IF([CampaignDS].[UARC_CRBO].[ALL_RESPONSES] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[ALL_RESPONSES]) |
Usage Count | int32 | fact | IF([CampaignDS].[UARC_CRBO].[USAGE_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[USAGE_COUNT]) |
Usage Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CRBO].[USAGE_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CRBO].[USAGE_COUNT_CG]) |
Campaign Offer Response Breakout | Campaign ID | int64 | identifier | [CampaignDS].[UARC_CORBO].[CAMPAIGNID] |
Offer ID | int64 | identifier | [CampaignDS].[UARC_CORBO].[OFFERID] |
Explore Count | int32 | fact | IF([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT]) |
Explore Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[EXPLORE_COUNT_CG]) |
Consider Count | int32 | fact | IF([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT]) |
Consider Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[CONSIDER_COUNT_CG]) |
Commit Count | int32 | fact | IF([CampaignDS].[UARC_CORBO].[COMMIT_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[COMMIT_COUNT]) |
Commit Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CORBO].[COMMIT_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[COMMIT_COUNT_CG]) |
Fulfill Count | int32 | fact | IF([CampaignDS].[UARC_CORBO].[FULFILL_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[FULFILL_COUNT]) |
Fulfill Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CORBO].[FULFILL_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[FULFILL_COUNT_CG]) |
Counts As Response (All) | int32 | fact | IF([CampaignDS].[UARC_CORBO].[ALL_COUNTS_AS_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[ALL_COUNTS_AS_RESP]) |
All Responses | int32 | fact | IF([CampaignDS].[UARC_CORBO].[ALL_RESPONSES] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[ALL_RESPONSES])
|
Usage Count | int32 | fact | IF([CampaignDS].[UARC_CORBO].[USAGE_COUNT] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[USAGE_COUNT]) |
Usage Count Control Group | int32 | fact | IF([CampaignDS].[UARC_CORBO].[USAGE_COUNT_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CORBO].[USAGE_COUNT_CG]) |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer Response Breakout Star Schema
 | Campaign Response Breakout | | (shortcut) | | [Model View].[Campaign Response Breakout] |
Campaign Offer Response Breakout | | (shortcut) | | [Model View].[Campaign Offer Response Breakout] |
Campaign Response History Summary | | (shortcut) | | [Model View].[Campaign Response History Summary] |
Campaign Offer Response History Summary | | (shortcut) | | [Model View].[Campaign Offer Response History Summary] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
CampToOffer | | (shortcut) | | [Model View].[CampToOffer] |
Campaign Offer Response Breakout Star Schema | Campaign Contact History Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] |
Number of Offers Given | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offers Given Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Unique Recipients | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Unique Recipients Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offer Versions | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Campaign Offer Contact History Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] |
Offer ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] |
Number of Offers Given | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offers Given Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Unique Recipients | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Unique Recipients Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offer Versions | float64 | fact | total ( [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
|
Campaign Contact Statuses Breakout | Campaign Contact Status Breakout | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCSBO].[CAMPAIGNID] |
All Contacts | float64 | fact | [CampaignDS].[UARC_CCSBO].[ALL_CONTACTS] |
Counts As Contact (All) | float64 | fact | [CampaignDS].[UARC_CCSBO].[ALL_COUNTS_AS_CONT] |
Campaign Send Count | float64 | fact | [CampaignDS].[UARC_CCSBO].[CAMP_SEND_COUNT] |
Delivered Count | float64 | fact | [CampaignDS].[UARC_CCSBO].[DELIVERED_COUNT] |
Undelivered Count | float64 | fact | [CampaignDS].[UARC_CCSBO].[UNDELIVERED_COUNT] |
Control Count | float64 | fact | [CampaignDS].[UARC_CCSBO].[CONTROL_COUNT] |
Campaign Offer Contact Status Breakout | Campaign ID | decimal | identifier | [CampaignDS].[UARC_COCSBO].[CAMPAIGNID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_COCSBO].[OFFERID] |
All Contacts | float64 | fact | [CampaignDS].[UARC_COCSBO].[ALL_CONTACTS] |
Counts As Contact (All) | float64 | fact | [CampaignDS].[UARC_COCSBO].[ALL_COUNTS_AS_CONT] |
Campaign Send Count | float64 | fact | [CampaignDS].[UARC_COCSBO].[CAMP_SEND_COUNT] |
Delivered Count | float64 | fact | [CampaignDS].[UARC_COCSBO].[DELIVERED_COUNT] |
Undelivered Count | float64 | fact | [CampaignDS].[UARC_COCSBO].[UNDELIVERED_COUNT] |
Control Count | float64 | fact | [CampaignDS].[UARC_COCSBO].[CONTROL_COUNT] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Offer Contact Statuses Breakout Star Schema
 | Campaign Response History Summary | | (shortcut) | | [Model View].[Campaign Response History Summary] |
Campaign Offer Response History Summary | | (shortcut) | | [Model View].[Campaign Offer Response History Summary] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
CampToOffer | | (shortcut) | | [Model View].[CampToOffer] |
Campaign Contact Status Breakout | | (shortcut) | | [Model View].[Campaign Contact Status Breakout] |
Campaign Offer Contact Status Breakout | | (shortcut) | | [Model View].[Campaign Offer Contact Status Breakout] |
Campaign Offer Contact Statuses Breakout Star Schema | Campaign Contact History Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] |
Number of Offers Given | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offers Given Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Unique Recipients | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Unique Recipients Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offer Versions | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Contact History Summary][Model View].[Campaign Contact History Summary].[Campaign ID] ) |
Campaign Offer Contact History Summary | Campaign ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] |
Offer ID | decimal | identifier | [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] |
Number of Offers Given | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offers Given Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offers Given Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Unique Recipients | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Unique Recipients Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Unique Recipients Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offer Versions | float64 | fact | total ( [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
Number of Offer Versions Control Group | float64 | fact | total ([Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Number of Offer Versions Control Group] for [Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Campaign ID] ,[Campaign Performance Summary Star Schema].[Campaign Offer Contact History Summary][Model View].[Campaign Offer Contact History Summary].[Offer ID] ) |
|
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Offer Performance by Day | Offer Contact History by Day | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCH_DY].[OFFERID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_OCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_OCH_DY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_OCH_DY].[NUM_OF_OFFERS_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_OCH_DY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_OCH_DY].[NUM_OFF_VERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_OCH_DY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_OCH_DY].[UNIQUE_RECIP_CG] |
Offer Campaign Contact History by Day | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCCH_DY].[OFFERID] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_OCCH_DY].[CAMPAIGNID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_OCCH_DY].[ACTUALDATE] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_OCCH_DY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_DY].[NUM_OF_OFFERS_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_OCCH_DY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_DY].[NUM_OFF_VERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_OCCH_DY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_DY].[UNIQUE_RECIP_CG] |
Offer Campaign Response History by Day | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCRH_DY].[OFFERID] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_OCRH_DY].[CAMPAIGNID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_OCRH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[REVENUE_PER_RESP] |
Revenue Per Response Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[REV_PER_RESP_CG] |
Gross Revenue | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[GROSS_REVENUE] |
Gross Revenue Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_DY].[GROSS_REVENUE_CG] |
Offer Response History by Day | Offer Id | decimal | identifier | [CampaignDS].[UARC_ORH_DY].[OFFERID] |
Actual Date | dateTime | attribute | [CampaignDS].[UARC_ORH_DY].[ACTUALDATE] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_ORH_DY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_ORH_DY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_ORH_DY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_ORH_DY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_ORH_DY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_ORH_DY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_ORH_DY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | [CampaignDS].[UARC_ORH_DY].[REVENUE_PER_RESP] |
Revenue Per Response Control Group | float64 | fact | [CampaignDS].[UARC_ORH_DY].[REV_PER_RESP_CG] |
Gross Revenue | float64 | fact | [CampaignDS].[UARC_ORH_DY].[GROSS_REVENUE] |
Gross Revenue Control Group | float64 | fact | [CampaignDS].[UARC_ORH_DY].[GROSS_REVENUE_CG] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Offer Performance by Day Star Schema
 | Offer Contact History by Day | | (shortcut) | | [Model View].[Offer Contact History by Day] |
Offer Campaign Contact History by Day | | (shortcut) | | [Model View].[Offer Campaign Contact History by Day] |
Offer Campaign Response History by Day | | (shortcut) | | [Model View].[Offer Campaign Response History by Day] |
Offer Response History by Day | | (shortcut) | | [Model View].[Offer Response History by Day] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Calendar | | (shortcut) | | [Model View].[Calendar] |
|
Offer Performance by Month | Offer Contact History by Month | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCH_MO].[OFFERID] |
Month | float64 | attribute | [CampaignDS].[UARC_OCH_MO].[MONTH] |
Year | float64 | attribute | [CampaignDS].[UARC_OCH_MO].[YEAR] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_OCH_MO].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_OCH_MO].[NUM_OF_OFFERS_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_OCH_MO].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_OCH_MO].[NUM_OFF_VERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_OCH_MO].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_OCH_MO].[UNIQUE_RECIP_CG] |
Offer Campaign Contact History by Month | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCCH_MO].[OFFERID] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_OCCH_MO].[CAMPAIGNID] |
Month | float64 | attribute | [CampaignDS].[UARC_OCCH_MO].[MONTH] |
Year | float64 | attribute | [CampaignDS].[UARC_OCCH_MO].[YEAR] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_OCCH_MO].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_MO].[NUM_OF_OFFERS_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_OCCH_MO].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_MO].[NUM_OFF_VERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_OCCH_MO].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_MO].[UNIQUE_RECIP_CG] |
Offer Campaign Response History by Month | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCRH_MO].[OFFERID] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_OCRH_MO].[CAMPAIGNID] |
Month | decimal | attribute | [CampaignDS].[UARC_OCRH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_OCRH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[REVENUE_PER_RESP] |
Revenue Per Response Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[REV_PER_RESP_CG] |
Gross Revenue | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[GROSS_REVENUE] |
Gross Revenue Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_MO].[GROSS_REVENUE_CG] |
Offer Response History by Month | Offer Id | decimal | identifier | [CampaignDS].[UARC_ORH_MO].[OFFERID] |
Month | decimal | attribute | [CampaignDS].[UARC_ORH_MO].[MONTH] |
Year | decimal | attribute | [CampaignDS].[UARC_ORH_MO].[YEAR] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_ORH_MO].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_ORH_MO].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_ORH_MO].[UNIQUE_RESPONDERS] |
Unique Respondersroup | float64 | fact | [CampaignDS].[UARC_ORH_MO].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_ORH_MO].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_ORH_MO].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_ORH_MO].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | [CampaignDS].[UARC_ORH_MO].[REVENUE_PER_RESP] |
Revenue Per Response Control Group | float64 | fact | [CampaignDS].[UARC_ORH_MO].[REV_PER_RESP_CG] |
Gross Revenue | float64 | fact | [CampaignDS].[UARC_ORH_MO].[GROSS_REVENUE] |
Gross Revenue Control Group | float64 | fact | [CampaignDS].[UARC_ORH_MO].[GROSS_REVENUE_CG] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Offer Performance by Month Star Schema
 | Offer Contact History by Month | | (shortcut) | | [Model View].[Offer Contact History by Month] |
Offer Campaign Contact History by Month | | (shortcut) | | [Model View].[Offer Campaign Contact History by Month] |
Offer Campaign Response History by Month | | (shortcut) | | [Model View].[Offer Campaign Response History by Month] |
Offer Response History by Month | | (shortcut) | | [Model View].[Offer Response History by Month] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
Calendar Month | | (shortcut) | | [Model View].[Calendar Month] |
|
Offer Performance Summary | Offer Contact History Summary | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCH_SUMMARY].[OFFERID] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OF_OFFERS_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_OCH_SUMMARY].[NUM_OFF_VERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_OCH_SUMMARY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_OCH_SUMMARY].[UNIQUE_RECIP_CG] |
Offer Campaign Contact History Summary | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCCH_SUMMARY].[OFFERID] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_OCCH_SUMMARY].[CAMPAIGNID] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OF_OFFERS_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_SUMMARY].[NUM_OFF_VERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_OCCH_SUMMARY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_OCCH_SUMMARY].[UNIQUE_RECIP_CG] |
Offer Campaign Response History Summary | Offer ID | decimal | identifier | [CampaignDS].[UARC_OCRH_SUMMARY].[OFFERID] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_OCRH_SUMMARY].[CAMPAIGNID] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_OCRH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_OCRH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_OCRH_SUMMARY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF( [CampaignDS].[UARC_OCRH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN (0)
ELSE
([CampaignDS].[UARC_OCRH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF ([CampaignDS].[UARC_OCRH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN (0)
ELSE
([CampaignDS].[UARC_OCRH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE] is missing)
THEN (0)
ELSE
([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF ([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN (0)
ELSE
([CampaignDS].[UARC_OCRH_SUMMARY].[GROSS_REVENUE_CG]) |
Offer Response History Summary | Offer Id | decimal | identifier | [CampaignDS].[UARC_ORH_SUMMARY].[OFFERID] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_ORH_SUMMARY].[RESP_TRANS] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_ORH_SUMMARY].[RESP_TRANS_CG] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_ORH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_ORH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_ORH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_ORH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_ORH_SUMMARY].[RESP_AFTER_EXP_CG] |
Revenue Per Response | float64 | fact | IF ([CampaignDS].[UARC_ORH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN (0)
ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF ([CampaignDS].[UARC_ORH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN (0)
ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE] is missing)
THEN (0)
ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN (0)
ELSE ([CampaignDS].[UARC_ORH_SUMMARY].[GROSS_REVENUE_CG]) |
Offer Performance Metrics Summary | Offer ID | int64 | fact | [CampaignDS].[UARC_OPM_SUMMARY].[OFFERID] |
Best Match | int32 | fact | [CampaignDS].[UARC_OPM_SUMMARY].[BEST_MATCH] |
Best Match Control Group | int32 | fact | [CampaignDS].[UARC_OPM_SUMMARY].[BEST_MATCH_CG] |
Fractional Match | float64 | fact | [CampaignDS].[UARC_OPM_SUMMARY].[FRACTIONAL_MATCH] |
Multiple Match | float64 | fact | [CampaignDS].[UARC_OPM_SUMMARY].[MULTIPLE_MATCH] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Offer Performance Summary Star Schema
 | Offer Contact History Summary | | (shortcut) | | [Model View].[Offer Contact History Summary] |
Offer Campaign Contact History Summary | | (shortcut) | | [Model View].[Offer Campaign Contact History Summary] |
Offer Campaign Response History Summary | | (shortcut) | | [Model View].[Offer Campaign Response History Summary] |
Offer Response History Summary | | (shortcut) | | [Model View].[Offer Response History Summary] |
Offer Performance Metrics Summary | | (shortcut) | | [Model View].[Offer Performance Metrics Summary] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
|
|
Campaign Project by Offer Performance | Campaign Offer Project Performance Summary Metrics | Project ID | float64 | identifier | |
Project Total Cost | float64 | fact | |
Project Total Revenue | float64 | fact | |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Project by Offer Performance Summary Star Schema
 | Campaign Offer Response History Summary | | (shortcut) | | [Model View].[Campaign Offer Response History Summary] |
Offer Custom Attributes | | (shortcut) | | [Model View].[Offer Custom Attributes] |
Campaign | | (shortcut) | | [Model View].[Campaign] |
Offer | | (shortcut) | | [Model View].[Offer] |
CampToOffer | | (shortcut) | | [Model View].[CampToOffer] |
Project Performance Summary Metrics | | (shortcut) | | [Model View].[Project Performance Summary Metrics] |
Project Budget | | (shortcut) | | [MarketingOperationsMV].[Project Budget] |
Campaign Project by Offer Performance Summary Star Schema | Distinct Campaigns for Offers | Campaign ID | decimal | identifier | |
|
Campaign Project by Cell Performance | Campaign Cell Offer Contact History Summary | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCOCH_SUMMARY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCOCH_SUMMARY].[CELLID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_CCOCH_SUMMARY].[OFFERID] |
Number of Offers Given | float64 | fact | [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OF_OFFERS] |
Number of Offers Given Control Group | float64 | fact | [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OF_OFFERS_CG] |
Unique Recipients | float64 | fact | [CampaignDS].[UARC_CCOCH_SUMMARY].[UNIQUE_RECIPIENTS] |
Unique Recipients Control Group | float64 | fact | [CampaignDS].[UARC_CCOCH_SUMMARY].[UNIQUE_RECIP_CG] |
Number of Offer Versions | float64 | fact | [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OFF_VERS] |
Number of Offer Versions Control Group | float64 | fact | [CampaignDS].[UARC_CCOCH_SUMMARY].[NUM_OFF_VERS_CG] |
Campaign Cell Offer Response History Summary | Campaign ID | decimal | identifier | [CampaignDS].[UARC_CCORH_SUMMARY].[CAMPAIGNID] |
Cell ID | decimal | identifier | [CampaignDS].[UARC_CCORH_SUMMARY].[CELLID] |
Offer ID | decimal | identifier | [CampaignDS].[UARC_CCORH_SUMMARY].[OFFERID] |
Response Transactions | float64 | fact | [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_TRANS] |
Unique Responders | float64 | fact | [CampaignDS].[UARC_CCORH_SUMMARY].[UNIQUE_RESPONDERS] |
Unique Responders Control Group | float64 | fact | [CampaignDS].[UARC_CCORH_SUMMARY].[UNIQUE_RESP_CG] |
Not Contacted Responders | float64 | fact | [CampaignDS].[UARC_CCORH_SUMMARY].[NOT_CONT_RESP] |
Responses After Expiration | float64 | fact | [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_AFTER_EXP] |
Responses After Expiration Control Group | float64 | fact | [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_AFTER_EXP_CG] |
Response Transactions Control Group | float64 | fact | [CampaignDS].[UARC_CCORH_SUMMARY].[RESP_TRANS_CG] |
Revenue Per Response | float64 | fact | IF([CampaignDS].[UARC_CCORH_SUMMARY].[REVENUE_PER_RESP] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[REVENUE_PER_RESP]) |
Revenue Per Response Control Group | float64 | fact | IF([CampaignDS].[UARC_CCORH_SUMMARY].[REV_PER_RESP_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[REV_PER_RESP_CG]) |
Gross Revenue | float64 | fact | IF([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE] is missing)
THEN (0)
ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE]) |
Gross Revenue Control Group | float64 | fact | IF([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE_CG] is missing)
THEN(0)
ELSE([CampaignDS].[UARC_CCORH_SUMMARY].[GROSS_REVENUE_CG]) |
Project Performance Summary Metrics | Project ID | float64 | identifier | |
Project Total Cost | float64 | fact | |
Project Total Revenue | float64 | fact | |
CCOCH and Offer Attributes | Campaign ID | decimal | identifier | [Model View].[Campaign Cell Offer Contact History Summary].[Campaign ID] |
Cell ID | decimal | identifier | [Model View].[Campaign Cell Offer Contact History Summary].[Cell ID] |
Offer ID | decimal | identifier | [Model View].[Campaign Cell Offer Contact History Summary].[Offer ID] |
Number of Offers Given | float64 | fact | [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offers Given] |
Number of Offers Given Control Group | float64 | fact | [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offers Given Control Group] |
Unique Recipients | float64 | fact | [Model View].[Campaign Cell Offer Contact History Summary].[Unique Recipients] |
Unique Recipients Control Group | float64 | fact | [Model View].[Campaign Cell Offer Contact History Summary].[Unique Recipients Control Group] |
Number of Offer Versions | float64 | fact | [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offer Versions] |
Number of Offer Versions Control Group | float64 | fact | [Model View].[Campaign Cell Offer Contact History Summary].[Number of Offer Versions Control Group] |
Offer Fulfillment Cost | float64 | fact | [Model View].[Offer Custom Attributes].[Offer Fulfillment Cost] |
Offer Fixed Cost | float64 | fact | [Model View].[Offer Custom Attributes].[Offer Fixed Cost] |
Actual Cost | float64 | fact | [Model View].[CCOCH and Offer Attributes].[Unique Recipients] * [Model View].[CCOCH and Offer Attributes].[Offer Fulfillment Cost] + [Model View].[CCOCH and Offer Attributes].[Offer Fixed Cost] |
Cell without Ctrl Cells | Cell ID | decimal | identifier | [CampaignDS].[UARC_CELL].[CELLID] |
Cell Name | characterLength16 | attribute | [CampaignDS].[UARC_CELL].[CELLNAME] |
Cell Code | characterLength16 | attribute | [CampaignDS].[UARC_CELL].[CELLCODE] |
Control Cell ID | decimal | attribute | [CampaignDS].[UARC_CELL].[CONTROLCELLID] |
Is Control | int64 | attribute | [CampaignDS].[UARC_CELL].[ISCONTROL] |
Campaign ID | decimal | identifier | [CampaignDS].[UARC_CELL].[CAMPAIGNID] |
Namespace/Folder | Query Subject | Query Item | Type | Usage | Ref Obj/Expr. |
Campaign Project by Cell Performance Summary Star Schema
 | Campaign | | (shortcut) | | [Model View].[Campaign] |
Cell without Ctrl Cells | | (shortcut) | | [Model View].[Cell without Ctrl Cells] |
CCOCH and Offer Attributes | | (shortcut) | | [Model View].[CCOCH and Offer Attributes] |
Campaign Cell Offer Response History Summary | | (shortcut) | | [Model View].[Campaign Cell Offer Response History Summary] |
Project Performance Summary Metrics | | (shortcut) | | [Model View].[Project Performance Summary Metrics] |
Project Budget | | (shortcut) | | [MarketingOperationsMV].[Project Budget] |
Campaign Project by Cell Performance Summary Star Schema | Distinct Campaigns for Cells | Campaign ID | decimal | identifier | |
|
Copyright
© Copyright Unica Corporation 2003 - 2010. All rights reserved.
Unica Corporation
Reservoir Place North
170 Tracer Lane
Waltham, MA 02451-1379
Examples and Data
All software and related documentation is subject to restrictions on use and disclosure as set forth in the Unica Software
License and Services Agreement, with restricted rights for U.S. government users and applicable export regulations.
Companies, names, and data used in examples herein are fictitious unless otherwise noted.
Trademarks and Patents
Unica®, the Unica logo, Affinium®, MarketingCentral®, MarketSoft®, MarketSoft logo, DemandMore®, Leads to Revenue®, NetTracker®,
My NetTracker®, and Ask NetTracker® are registered trademarks of Unica Corporation with the U.S. Patent and Trademark Office.
Affinium Campaign™, Affinium Campaign Collaborate™, Affinium Campaign eMessage™, Affinium Campaign Interact™, Affinium Campaign
Optimize™, Affinium Detect™, Affinium Leads™, Affinium Leads Referral™, Affinium Leads Contact™, Affinium Model™, Affinium NetInsight™,
Affinium Insight™, Affinium Plan™, Affinium Mart™, Universal Dynamic Interconnect™, Interconnect Modules™, Marketic™, Powering Marketing
Success™, Drill Anywhere™, Marketing Objects™, Trend Anything™, Customer Value Maximization™, MAP™, One-to-One Optimization™, and Right-time
Marketing™ are trademarks of Unica Corporation. All other trademarks are the property of their respective owners.
Portions of the software described in this document are covered by U.S. Patent Numbers: 6,317,752, 6,269,325, 6,542,894, and
6,782,390.
The NetTracker, Affinium Insight, and Affinium NetInsight products are licensed under the following patents and patent
publications: US5,675,510, US6,115,680, US6,108,637, US5,796,952, US6,138,155, US6,653,696, US6,763,386, AU0701813, BR9609217, CA2223919,
EP0843946, JP03317705, MX193614, NO09705728, AU735285, CA2246746, CN1174316, CN1547123, CN1547124, DK870234, DE69720186, ES2195170, AU727170,
BR9808033, CA2284530, CN1251669, IL131871, JP2000514942, KR341110, NZ337756, WO9641495, EP0870234, EP1130526, EP1168196, US20040078292,
WO9810349, US20050114511, US20040221033, WO9843380.
Markup functionality in Affinium Plan is enabled through use of third-party software components from AdLib™ eDocument Solutions
and Adobe® Acrobat®. "Powered by AdLib™."
NOTICE: This document contains confidential and proprietary information of Unica Corporation ("Unica"). Use, duplication, or
disclosure without the express written consent of Unica Corporation is prohibited.