Marketing Analytics Data - SFDC Models

The SFDC Models grouping is used to designate models built from the Salesforce source objects.

Mart_crm_attribution_touchpoint

The Attribution Touchpoint mart is the consolidated repository of Marketo Measure’s (Bizible’s) Attribution Touchpoint data. An Attribution Touchpoint is a touchpoint associated with an Opportunity in SFDC. This mart allows you to analyze engagement by Opportunity and/or Account during the entire lifecycle of either.

Use Cases

  1. Attributed ARR
  2. Touchpoints during a given stage

Key Fields

  1. Attribution Touchpoint
    1. The record of engagement, captured through Bizible (Marketo Measure) that is associated with an Opportunity in SFDC.
  2. Net ARR
    1. Definition
  3. Attribution Models
    1. Bizible-defined
    2. Linear
      1. An even distribution of weight/attribution split amongst every touchpoint related to the record.
  4. Is MGP Channel Based
    1. At least 2 unique marketing channel touchpoints for First Order and 3 unique marketing channel touchpoints for Growth opportunities, within a window of 365 days before Pipeline Created Date
  5. Is MGP Opportunity
    1. Is MGP Channel Based = TRUE and Sales Qualified Source = SDR
  6. Gitlab Model Weight
  7. Time Decay Model Weight
  8. Data Driven Model Weight
  9. Touchpoint Sales Stage
    1. The Sales funnel stage the touchpoint occurred in.
  10. Is FMM Influenced
    1. Whether a given touchpoint is influenced by FMM effort.
  11. Is FMM Sourced
    1. Whether a given touchpoint is sourced by FMM effort.

Key Metrics

  1. Attributed Weight
    1. The weight of a given touchpoint, based on which attribution model you are looking at.
  2. Attributed Net ARR
    1. The attributed net arr, based on which attribution model you are looking at.

Data Lineage

  1. Data is sourced from SFDC and Bizible/Marketo Measure
  2. The full lineage can be seen here

DBT Solution

The dbt solution generates a dimensional model from RAW source data. The exceptions are the following fields that are calculated based on business logic implemented within specific dbt models:

Field Business Logic
touchpoint_sales_stage Defined in model
is_mgp_opportunity Defined in model
is_fmm_influenced Defined in model
is_fmm_sourced Defined in model

Mart_crm_event

The SFDC Event mart is the organized and formatted consolidation of Event data from SFDC. Events are a form of Activity in SFDC, usually associated with meetings (digital or in-person).

Use Cases

  1. Volume/timeline of Events in the Opportunity lifecycle
  2. Efficacy of a given Event in progressing an Opportunity towards Closed Won.

Key Fields

  1. sales_dev_rep_*
    1. The associated Sales Dev Rep and their Manager’s information from SFDC

Key Metrics

  1. Count of Events (dim_crm_event_pk)

Data Lineage

  1. Data is sourced from SFDC
  2. The full lineage can be seen here

DBT Solution

The dbt solution generates a dimensional model from RAW source data.

Mart_crm_person

The seamless combination of SFDC Leads and Contacts into a consolidated Person object. This mart allows for quick and easy access to both SFDC objects in a single table. It also integrates information from Bizible/Marketo Measure, Marketo, and IDs from other GitLab Tech Stack sources.

Use Cases

  1. Number of people in a given funnel stage
  2. Progression of a given person record through the funnel
  3. Conversion from one funnel stage to the next

Key Fields

  1. Dim_crm_person_id - the unique surrogate key for each person record

Key Metrics

  1. MQL Count
  2. Inquiry Count
  3. Inquiry to MQL Conversion

Data Lineage

  1. Data is sourced from SFDC
  2. The full lineage can be seen here

DBT Solution

The dbt solution generates a dimensional model from RAW source data. The exceptions are the following fields that are calculated based on business logic implemented within specific dbt models:

Field Business Logic
is_lead_source_trial Defined in model
is_abm_tier_inquiry Defined in model
is_abm_tier_mql Defined in model
person_first_country Defined in model
is_exclude_from_reporting Defined in model

Mart_crm_tasks

The SFDC Tasks mart is the organized and formatted consolidation of Task data from SFDC. Tasks are usually notes from the Sales Dev or Sales team on actions taken or engagements that took place.

Use Cases

  1. Volume/timeline of Tasks in the Opportunity lifecycle
  2. Efficacy of a given Task in progressing an Opportunity towards Closed Won.

Key Fields

  1. sales_dev_rep_*
    1. The associated Sales Dev Rep and their Manager’s information from SFDC

Key Metrics

  1. Count of Tasks (dim_crm_task_pk)

DBT Lineage

  1. Data is sourced from SFDC
  2. The full lineage can be seen here

DBT Solution

The dbt solution generates a dimensional model from RAW source data.

Mart_crm_touchpoint

The Person/Buyer Touchpoint mart is the consolidated repository of Marketo Measure’s (Bizible’s) Person/Buyer Touchpoint data. A Person/Buyer Touchpoint is an engagement associated with a Person (Lead/Contact) based on the rules set by the organization for important/capturable engagements.

Use Cases

  1. Touchpoints during a given stage
  2. Touchpoints per record

Key Fields

  1. Buyer (Person) Touchpoint
    1. The record of engagement, captured through Bizible (Marketo Measure) that is associated with a Person (Lead/Contact) in SFDC.
  2. Attribution Models
    1. Bizible-defined
    2. Linear
      1. An even distribution of weight/attribution split amongst every touchpoint related to the record.
  3. Is FMM Influenced
    1. Whether a given touchpoint is influenced by FMM effort.
  4. Is FMM Sourced
    1. Whether a given touchpoint is sourced by FMM effort.

Key Metrics

  1. Attributed Weight
    1. The weight of a given touchpoint, based on which attribution model you are looking at.

Data Lineage

  1. Data is sourced from SFDC and Bizible/Marketo Measure
  2. The full lineage can be seen here

DBT Solution

The dbt solution generates a dimensional model from RAW source data. The exceptions are the following fields that are calculated based on business logic implemented within specific dbt models:

Field Business Logic
is_fmm_influenced Defined in model
is_fmm_sourced Defined in model
Last modified February 24, 2025: Creating Marketing Analytics Data page (ec253af0)