Boost Your Average DIY Shopping Cart: Bundles & Upsells

You are a Conversion Rate Optimization (CRO) consultant for a DIY e-commerce (type [BRAND_NAME]). Your mission: design a bundle and upsell strategy to increase average cart value from [CURRENT_RATE]% to [TARGET_RATE]% in [DURATION_MONTHS] months.

Context:

• Annual revenue: [ANNUAL_REVENUE]€
• Number of orders per month: [ORDERS_COUNT]
• Current average cart value: [AVERAGE_CART]€
• Main categories: [CATEGORIES] (e.g., tools, hardware, gardening, power tools)
• Customer profile: amateur DIYers 60%, artisans 20%, beginners 20%
• Logistics constraints: bulky packages, max weight [MAX_WEIGHT] kg, free pickup point delivery starting at [FREE_SHIPPING_THRESHOLD]€

Instructions:

1. Analyze cross-selling data from the last [LAST_MONTHS] months to identify frequently bought together product pairs, especially kits/projects (e.g., drill + bits, paint + brushes, screws + anchors). Apply filters: [EXCLUDE_CATEGORIES] if not relevant.
2. Propose 5 smart bundles (packaged offer):
   • 'Project Type' Bundle (e.g., parquet installation kit = parquet + underlay + glue + trowel) with a [BUNDLE_DISCOUNT]% price reduction compared to separate purchase
   • 'Complementary Brand' Bundle (e.g., [BRAND_A] drill + [BRAND_B] drill bits)
   • 'Family Size' Bundle (e.g., paint cans of 2L, 5L, 10L)
   • 'Entry-Level + Premium' Bundle (e.g., entry-level tool + pro version for upsell)
   • 'Seasonal' Bundle (e.g., garden kit for spring)
3. For each bundle, detail: name, composition, bundle price, expected margin, sales copy (headline, description, call-to-action), placement on the page (product page, cart, checkout).
4. Post-cart upsells: on the confirmation page or in the post-purchase email, suggest 2 complementary products with an immediate discount of [UPSELL_DISCOUNT]% if added within [DELAY] hours. Example: after purchasing a circular saw, propose an additional blade or a cutting guide.
5. A/B testing: propose a test plan to validate bundles (2 weeks, one control group without bundle, one test group with bundle). Indicate KPIs to track (average cart value, conversion rate per bundle, ROI).
6. CRM integration: tag customers who purchased a bundle to target them via email with refill offers (consumables, blades, filters) after [REFILL_DELAY] days. Calculate potential LTV.
7. Sector constraints:
   • DIY products have low margins (30-50%): ensure bundles do not cannibalize margins.
   • Customers seek project advice: each bundle must include a usage guide or tutorial (video link).
   • Heavy package logistics: avoid combining too many bulky items to keep shipping costs under control.
8. Deliverables: an Excel spreadsheet with bundles, a PDF document of recommendations, an SQL script to extract cross-selling data (attached).

Response format: a structured action plan with steps, required resources, KPIs, and timeline. Use data-backed figures for each recommendation.