WorkflowFor E-commerce Sellers

Advertising Profitability Audit.

Monthly advertising review to ensure you're investing, not just spending. ✅

ChatGPT · Claude · Gemini·Advanced·~231 tokens
Curated by the AIPP team
Last updated 14 May 2026 · v3
advertising-profitability-audit.md · 231 words
You are a senior {{role}} brought in to help {{target_user}} complete a Advertising Profitability Audit.

# Context
Original working context:
- Step 1: I spent {{total_ad_spend}} last month and generated {{ad_attributed_revenue}}. But I need to understand my TRUE advertising profitability. Calculate: TACoS, blended ACOS across all channels, advertising cost per acquisition, and advertising contribution to margin.
- Step 2: Break down advertising performance by channel: {{list_channels_with_spend_and_revenue}}. Identify the highest and lowest ROI channels.
- Step 3: Recommend how to reallocate next month's budget of {{amount}} across channels based on ROI.
- Step 4: Design a 90-day plan to reduce TACoS by {{target}} while maintaining revenue. 📌

# Goal
Produce the exact deliverable requested for this use-case. Make the output practical, specific, and ready to use.

# Constraints
- Use the user's variables exactly where relevant.
- Avoid generic filler and vague advice.
- Be specific to the stated audience, platform, market, role, industry, or situation.
- Ask only essential clarifying questions if required; otherwise make reasonable assumptions and continue.

# Output
Return the final deliverable in a clean, skimmable format with clear headings, bullets, tables, scripts, templates, or steps as appropriate.

The variables to fill in

PlaceholderWhat to put thereExample
{{total_ad_spend}}Total ad spendinsert your specific value
{{ad_attributed_revenue}}Ad attributed revenueinsert your specific value
{{list_channels_with_spend_and_revenue}}List channels with spend and revenueinsert your specific value
{{amount}}Amount$5,000
{{target}}Targetinsert your specific value
{{role}}Rolefreelance client onboarding strategist
{{target_user}}Target usera freelance consultant

How to customize this prompt

  1. Replace each {{double-curly}} with your real context.
  2. Adjust the constraints section to match your tone — formal, casual, blunt.
  3. If the engagement is recurring, change the duration line to mention milestones rather than days.
  4. Run it in your tool of choice. The output should be ready to paste with at most one small edit.

When to use

Monthly advertising review to ensure you're investing, not just spending. ✅

PRO TIP

TACoS declining over time is the clearest signal of a healthy e-commerce business — it means organic sales are growing faster than advertising. Set a monthly TACoS target and treat upward movement as an alarm, not a normal fluctuation.

Related prompts

Workflow

Build a 30-Day YouTube Content Calendar

At the start of each month to plan ahead and stay consistent.

Workflow

Turn One Video Into a Multi-Platform Content System

After publishing a long-form video to maximise content ROI across all platforms.

Workflow

Create a YouTube Series Framework

When launching a series to build subscriber retention and binge-watching behaviour.

Workflow

Build a 30-Day Instagram Content Calendar

At the start of each month to plan content in advance and stay consistent.

★ EXPLORE MORE PROMPTS

More for E-commerce Sellers

Browse all prompts built for E-commerce Sellers — free and premium, ready to copy.

Browse more prompts →