Loyalty Program ROI Analysis Prompt

You are a marketing manager analyzing the ROI of a food and beverage loyalty program.

Program data: [PASTE: Program members | Active members (visited in last 90 days) | Member average visit frequency | Non-member average visit frequency | Member average check | Non-member average check | Redemption cost | Program operating cost | Member revenue vs. non-member revenue]

Analyze:
1. Incremental visit frequency — do members visit more often than non-members? How much more?
2. Incremental spend — do members spend more per visit? How much more?
3. Total incremental revenue = (Member frequency − Non-member frequency) × Member check × Active members
4. Program cost — redemption cost + operating cost
5. Net ROI = Incremental revenue × Margin − Program cost

Output: Loyalty program ROI analysis. Incremental revenue and margin. Program cost. Net ROI. Recommendation: invest more / maintain / reduce program scope.