Campaign

The Campaign model is designed to analyze the number of campaigns conducted by the company. You can also analyze the activities being conducted under the Campaign umbrella.

Start Date and End Date are used to analyze the facts in this model. See Infor M3 Analytics for M3 CloudSuites Administration Guide for a list of available dates for this model.

Source information

The main source of this model is the Campaign table in M3 CLM (M3_MOBCORE_CAMPAIGN) and it is joined with Campaign Part (M3_MOBCORE_CAMPAIGN_PART) and Campaign Part Type (M3_MOBCORE_CAMPAIGN_PART_TYPE) which provides additional information for the Campaign. Due to the many-to-many relationship of the tables, the uniqueness of this model is determined by the combination of CampaignID, CampaignPartID, and CampaignPartTypeID. Using the measures in this model, you can analyze the Campaign by Sales Team based on the Campaign Owner. The Campaign Owner is referenced through the CRM User.