HomeCourse › Module 16

Scenario: Sales & Marketing

Lead-list cleanup, CRM exports, campaign reporting, funnel analysis, and a weekly pipeline report you stop having to build.

Scenarios 7 lessons ~80 min

Meet Lena, a sales-ops lead. Every Monday she rebuilds the same pipeline report. Every quarter she dedupes a giant lead list. Here's how Python earns its keep on each of these tasks.

Lessons in this module

  1. User story: dedupe a 50,000-lead list · 10 min
    Marketing pulled a list. Half of them are already in the CRM. Find the half that aren't.
  2. User story: roll up the marketing campaign report · 10 min
    Spend, impressions, clicks, conversions, by campaign and channel.
  3. User story: funnel analysis · 9 min
    From session → product view → add to cart → checkout → purchase.
  4. User story: the Monday pipeline report · 10 min
    Total pipeline, weighted forecast, deals moving by stage.
  5. User story: RFM segmentation · 10 min
    Score every customer on Recency, Frequency, Monetary value. Build a champions list.
  6. User story: simple multi-touch attribution · 9 min
    Who gets credit when a customer touched four channels before buying?
  7. User story: sales territory rebalancing · 10 min
    Split a country into roughly-equal account groups for new reps.