Campaign Cell Agreement SalesCampaign Cell Allocation LimitCampaign Cell Allocation PctCampaign Cell Maximum Target NumCampaign Cell Targeted NumContact Strategy
| Business Data Model Data Model |
| Description | A marketing activity that defines a set of rules for coordinating communications within a single campaign. The total population of campaign targets are allocated to campaign cells either arbitrarily on the basis of a defined percentage of the total target population or based on specific criteria such as party characteristics. Dividing the total target population into campaign cells allows the healthcare organization to study campaign results where different sets of steps were executed for different sets of targets. For example, the organization may divide a target population into four homogeneous campaign cells each of which uses a different set of campaign steps. The results can be analyzed to determine which set of steps is more effective in producing the desired campaign results. |
| Attributes | |
| Campaign Cell Agreement Sales |
|
| Campaign Cell Allocation Limit |
|
| Campaign Cell Allocation Pct |
|
| Campaign Cell Maximum Target Num |
|
| Campaign Cell Targeted Num |
|
| Contact Strategy |
|
| Relationship | |
 Campaign includes Campaign Cell |
|
| Generalization | |
 Campaign Cell - Marketing Activity |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Campaign Cell Agreement Sales
| Description | The number of agreements (for example: policies) sold to parties in the campaign cell. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Cell Allocation Limit
| Description | The maximum number of parties from the target group allocated to a campaign cell. Note: The allocation limit is usually based on the budget of the campaign and therefore makes it different from the maximum target number attribute. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Cell Allocation Pct
| Description | The percentage of the total target group to be arbitrarily allocated to this cell. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Cell Maximum Target Num
| Description | The upper limit of the number of targets, typically existing or potential customers, to be included in the campaign cell. A zero or null value indicates the campaign cell has no upper limit for targets. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Campaign Cell Targeted Num
| Description | The number of parties which the organization actually approached in the campaign cell. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Contact Strategy
| Description | Identifies the methodology for approaching parties to be followed by the campaign. For example: Cold Call Referral Contact Mailshot Renewal Notice |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Campaign includes Campaign Cell
| Is Identifying Relationship | false |
| Child Table | Campaign Cell |
| Child Role Name | is included in |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Campaign |
| Parent Role Name | includes |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Campaign Cell - Marketing Activity
| Supertype | Marketing Activity |
| Subtype | Campaign Cell |
| Transform As | TABLE |
| Business Data Model Data Model |