Ecommerce AnalystConversion OptimizationBeginnerSingle prompt

E-commerce Conversion Funnel Audit AI Prompt

Audit the e-commerce conversion funnel from landing to purchase and identify the highest-priority optimization opportunities. Funnel data: {{funnel_data}} Platform: {{platform}}... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.

Prompt text
Audit the e-commerce conversion funnel from landing to purchase and identify the highest-priority optimization opportunities.

Funnel data: {{funnel_data}}
Platform: {{platform}} (Shopify, WooCommerce, Magento, custom)
Traffic: {{monthly_sessions}} monthly sessions

1. Funnel stages and current conversion rates:
   - Session to Product View rate: sessions that viewed at least one product page
   - Product View to Add-to-Cart rate
   - Add-to-Cart to Checkout Initiation rate
   - Checkout Initiation to Purchase rate (checkout completion)
   - Overall session-to-purchase conversion rate

   Benchmark comparison by device:
   - Desktop: typical e-commerce CVR 2-4%
   - Mobile: typical e-commerce CVR 1-2%
   - How does this store compare?

2. Cart abandonment analysis:
   - Cart abandonment rate: (add-to-cart - purchases) / add-to-cart
   - Industry average: ~70%. If > 80%, significant optimization opportunity.
   - Checkout abandonment rate: where in the checkout flow do users leave?
   - Most common exit pages during checkout

3. Device and traffic source breakdown:
   - Conversion rate by device (desktop, mobile, tablet)
   - Conversion rate by traffic source (organic, paid, email, direct, social)
   - Which combination (source x device) has the highest and lowest CVR?
   - Mobile CVR vs desktop CVR gap: if > 50% lower on mobile, mobile UX is the priority

4. Product page conversion rate:
   - Add-to-cart rate by product category
   - Products with high traffic but low add-to-cart rate (< 5%): page or product issue?
   - Products with high add-to-cart but low purchase rate: cart abandonment issue for specific products

5. Checkout friction analysis:
   - How many steps in the checkout? (Target: 1-2 pages)
   - Is guest checkout available? (Forced account creation kills mobile conversions)
   - Payment options: does the store offer the top payment methods for its audience?
   - Form fields: any unnecessary fields that slow completion?

6. Priority recommendations:
   - Top 3 interventions by expected revenue impact
   - Expected lift in CVR for each intervention
   - Estimated annual revenue gain from each 0.1% CVR improvement at current traffic

Return: funnel metrics table, abandonment analysis, device breakdown, product page analysis, checkout friction assessment, and prioritized recommendations.

When to use this prompt

Use case 01

Use it when you want to begin conversion optimization work without writing the first draft from scratch.

Use case 02

Use it when you want a more consistent structure for AI output across projects or datasets.

Use case 03

Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.

Use case 04

Use it when you want a clear next step into adjacent prompts in Conversion Optimization or the wider Ecommerce Analyst library.

What the AI should return

The AI should return a structured result that covers the main requested outputs, such as Funnel stages and current conversion rates:, Session to Product View rate: sessions that viewed at least one product page, Product View to Add-to-Cart rate. The final answer should stay clear, actionable, and easy to review inside a conversion optimization workflow for ecommerce analyst work.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in Conversion Optimization.

Frequently asked questions

What does the E-commerce Conversion Funnel Audit prompt do?+

It gives you a structured conversion optimization starting point for ecommerce analyst work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for ecommerce analyst workflows and marked as beginner, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

E-commerce Conversion Funnel Audit is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are Checkout Abandonment Recovery, Full E-commerce Analytics Chain, Personalization Opportunity Analysis.