Contact

The Contact model is designed to analyze the number of contacts that the company has in the system, and the activities and opportunities that are connected to these contacts. Using the measures in this model, you can also analyze the number of months since a contact and its activities and opportunities were last updated.

Create Date and Update Date are used to analyze the facts in this model.

Source information

The main source of information of this model is the Contact table in M3 CLM (M3_MOBCORE_CONTACT). This table is joined with the Opportunity Contact table (M3_MOBCORE_REL_OPPORTUNITY_CONTACT) and Activity Contact table (M3_MOBCORE_REL_ACTIVITY_CONTACT), which provides additional information on the contact's activity and opportunity records.