Prompt Library
Charts & Analysis
Cohort LTV by acquisition channel: which channel pays back fastest?
E-commerce & Retail
Try this prompt
Compare 30, 90, and 180-day LTV for customers acquired through each channel (paid search, paid social, organic, email, affiliate, direct). Use monthly acquisition cohorts from the last 6 months. Show revenue per user at each milestone, average payback period vs. estimated CAC, and which channel produces the highest LTV at 180 days. Flag any channel where LTV has declined across consecutive cohorts.
Click to copy