On this page you will find the specifications regarding the Model: CRM and Dimension Table: MARKETING CAMPAIGN RESPONSE FACT.
This model dimension represents responses created in marketing campaign actions and is based on the IFS Cloud fact FACT_BUSINESS_ACTIVITY. All models that refers to this dimension will have the attributes and hierarchies as described below.
| Attribute | Description (where applicable) |
| Activity Sub Type | Activity Sub Types are used to specify the nature of an activity. |
| Campaign Response Connection ID | The ID of the connection (account or lead) that marketing campaign response is created for. |
| Campaign Response Connection Type | The type of the connection (account or lead) that marketing campaign response is created for. |
| Campaign Response Multiple Choice | The marketing campaign response which is in multiple choice type. |
| Campaign Response Note | The marketing campaign response which is in note type. |
| Campaign Response Numeric or Text | The marketing campaign response which is in numeric or text type. |
| Campaign Response Representative ID | The representative that marketing campaign response is created by. |
| Campaign Response Single Choice | The marketing campaign response which is in single choice type. |
| Campaign Response Target ID | The target that marketing campaign response is created from. |
| Campaign Response Yes or No | The marketing campaign response which is in yes / no type. |
| Campaign Response Yes or No Description | The marketing campaign response which is in yes / no type. |
| Campaign response Date | Date without time stamp. |
| Model Name |
| CRM |
The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| MARKETING CAMPAIGN RESPONSE FACT | FACT_MKTG_ACTION_RESPONSE_TM | FACT_MKTG_ACTION_RESPONSE_BI | FACT_MKTG_ACTION_RESPONSE | Data Mart |