Skip to content

marketing

sqllocks_spindle.domains.marketing

Marketing domain — campaigns, contacts, leads, opportunities, and deals.

Classes

MarketingDomain

Bases: Domain

Marketing domain with campaigns, contacts, leads, and conversions.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - campaign_type: Campaign categories (fixed: 15) - industry: Target industries (fixed: 25) - campaign: Marketing campaigns (anchor: 200 small) - lead_source: Lead origins (fixed: 20) - contact: Marketing contacts - lead: Qualified leads from contacts - opportunity: Sales opportunities from leads - email_send: Email send events per campaign - web_visit: Website visits per contact - conversion: Conversion events from leads

Methods:
star_schema_map()

Return the star schema mapping for the Marketing domain.

Produces
  • dim_contact (from contact)
  • dim_campaign (from campaign, enriched with campaign_type)
  • dim_lead_source (from lead_source)
  • dim_date (generated from created_date / sent_date)
  • fact_lead (from lead)
  • fact_opportunity (from opportunity + lead)
  • fact_email (from email_send)
cdm_map()

Return the CDM entity map for the Marketing domain.