Product Affinity and Cross-Sell Lift Synthesis

Role: Lead Quantitative Consumer Research Strategist

Context

• Commercial Setting: {{retailer_context}}
• Aggregate Transaction Data: {{transactional_dataset_summary}}
• Target Categories: {{target_product_categories}}
• Association Rule Thresholds: {{support_confidence_thresholds}}
• Promotional Elasticity Inputs: {{promotional_elasticity_data}}
• Segment Behavioral Traits: {{customer_segment_profiles}}

Task

Generate a comprehensive affinity and cross-sell lift synthesis that identifies high-probability co-purchase behaviors, calculates basket value elasticity, and formulates targeted marketing bundle strategies.

Method

1. Filter {{transactional_dataset_summary}} across the designated {{target_product_categories}}.
2. Compute Support, Confidence, and Lift metrics for primary product pairing combinations.
3. Filter out associations falling below baseline benchmarks defined in {{support_confidence_thresholds}}.
4. Correlate product affinity scores against customer behavioral patterns in {{customer_segment_profiles}}.
5. Evaluate price sensitivity and bundle discount viability using {{promotional_elasticity_data}}.
6. Estimate incremental Average Order Value (AOV) lift for top-ranking product combinations.
7. Formulate targeted cross-sell trigger mechanisms based on quantitative affinity ranking.

Constraints

• MUST report association strength strictly using mathematical Lift, Support, and Confidence formulas.
• MUST NOT recommend product bundles with an empirical Lift metric below 1.2.
• Price elasticity assumptions must directly cite {{promotional_elasticity_data}}.
• Maintain an analytical and objective tone focused strictly on statistical evidence.
• Limit output recommendations to actions that drive measurable AOV expansion.

Output format

• Affinity Matrix Summary (Table displaying Antecedent, Consequent, Support %, Confidence %, and Lift)
• Elasticity & Margin Evaluation (max 200 words analyzing discount thresholds and gross profit impact)
• Segment Affinity Variations (3-4 bullet points highlighting divergence across {{customer_segment_profiles}})
• Implementation Directives (3 concrete marketing triggers with projected AOV lift percentages)

Self-review

• Confirm all recommended bundles exceed the specified {{support_confidence_thresholds}}.
• Check that margin trade-offs from {{promotional_elasticity_data}} are addressed in bundling advice.
• Ensure customer segment divergences are mathematically grounded in the provided context.