Understanding what happens after CRM
A channel label alone cannot explain a customer journey. I examine how CRM activity relates to later applications and paid outcomes, including repeat conversion through other channels.
The problem
Last-touch reporting can hide earlier CRM activity. An apparent channel win may follow earlier engagement, and comparisons become misleading if the lookback period or customer matching is inconsistent.
The approach
- Define the population, conversion event, lookback window and unit of analysis before querying.
- Separate previous paid activity from previous paid activity specifically attributed to CRM.
- Compare repeat conversion by channel and inspect the time between CRM interaction and subsequent outcomes.
- Check how conclusions change with the lookback window, and treat association separately from incremental impact.
My contribution
SQL query design, customer journey logic, cohort interpretation and translation into business questions.
What this illustrates
Before making an attribution claim, check what happened earlier in the customer journey and what the data can actually establish.
Method summary based on analysis topics I have worked on. No causal lift or financial outcome is claimed.