Model: CRM - Specifications for Dimension Table: MARKETING CAMPAIGN RESPONSE FACT

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.

Attributes

Attribute Description (where applicable)
Activity Sub TypeActivity Sub Types are used to specify the nature of an activity.
Campaign Response Connection IDThe ID of the connection (account or lead) that marketing campaign response is created for.
Campaign Response Connection TypeThe type of the connection (account or lead) that marketing campaign response is created for.
Campaign response DateDate without time stamp.
Campaign Response Multiple ChoiceThe marketing campaign response which is in multiple choice type.
Campaign Response NoteThe marketing campaign response which is in note type.
Campaign Response Numeric or TextThe marketing campaign response which is in numeric or text type.
Campaign Response Representative IDThe representative that marketing campaign response is created by.
Campaign Response Single ChoiceThe marketing campaign response which is in single choice type.
Campaign Response Target IDThe target that marketing campaign response is created from.
Campaign Response Yes or NoThe marketing campaign response which is in yes / no type.
Campaign Response Yes or No DescriptionThe marketing campaign response which is in yes / no type.

USED BY MODEL(S)

Model Name
CRM

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
MARKETING CAMPAIGN RESPONSE FACTFACT_MKTG_ACTION_RESPONSE_BIFACT_MKTG_ACTION_RESPONSEOn Line