How do I set up catalog advertising software for tracking SKU profitability across marketplace campaigns?

To set up catalog advertising software for tracking SKU profitability across marketplace campaigns, you want a setup that connects product-level ad spend, sales, fees, and margins in one place.

1) Define the profitability formula

Decide what “profitability” means for each SKU. A common formula is:

Profit = Revenue - COGS - marketplace fees - ad spend - shipping/fulfillment - returns/discounts

And for campaign reporting:

ROAS = Revenue attributed to ads / Ad spend
ACOS = Ad spend / Revenue attributed to ads
Contribution margin = Profit / Revenue

If you have multiple marketplaces, include marketplace-specific fees and tax handling.

2) Make sure your catalog data is clean

Your catalog software should have a reliable product feed with:

• SKU / parent SKU / child SKU
• ASIN, listing ID, or product ID per marketplace
• Product name, category, brand
• COGS
• MSRP or sell price
• Margin target
• Inventory status
• Variations/pack sizes

Use one master SKU mapping table so every marketplace listing points back to a single internal SKU.

3) Connect the required data sources

You typically need these integrations:

• Marketplace sales data: orders, units sold, revenue, refunds
• Advertising platform data: campaign, ad group, keyword/product target, spend, impressions, clicks, attributed sales
• Fee data: referral fees, FBA/fulfillment fees, storage, commissions
• Inventory/ERP data: COGS, stock, purchase costs
• Returns data: refunded units, return fees, chargebacks

If the software doesn’t directly integrate, use an ETL tool or data warehouse in between.

4) Set up SKU-level attribution rules

To track profitability by SKU, configure attribution so ad results roll up correctly:

• Map each ad entity to a SKU, ASIN, or listing ID
• Decide whether attribution is:
  • Direct only: sales on the advertised SKU only
  • Halo/conversion assist: includes related or variant sales
• Handle cases like:
  • Parent/child ASINs
  • Bundles/kits
  • Cross-sell purchases
  • Multi-pack vs single-unit SKUs

For profitability, direct SKU attribution is usually the safest starting point.

5) Build margin-aware reporting

Create dashboards or reports with these metrics per SKU and per campaign:

• Spend
• Sales
• Units sold
• CPC / CTR / CVR
• ROAS / ACOS
• Gross margin $
• Contribution margin $
• Profit per order
• Profit per ad click
• Break-even ACOS
• Break-even CPC
• Return rate

A helpful metric is:

Break-even ACOS = Gross margin % - fulfillment/fee % - return impact %

6) Configure budget and bid optimization rules

Once profitability is visible, set software rules such as:

• Increase bids on SKUs with positive contribution margin and high conversion
• Reduce bids on SKUs with ACOS above break-even
• Pause campaigns for SKUs with negative margin after fees and ad spend
• Prioritize high-margin SKUs when inventory is limited
• Exclude low-margin SKUs from aggressive automation

You can also set guardrails like:

• Minimum margin threshold
• Maximum ACOS by category
• Minimum stock level before bidding

7) Normalize marketplace differences

Each marketplace has different fee structures and attribution windows, so configure:

• Fee schedules by marketplace
• Attribution windows
• Currency conversion
• Tax/VAT handling
• Shipping model differences
• Return/refund policies

This prevents one marketplace from looking more profitable than it really is.

8) Test with a pilot group

Start with a small set of SKUs and campaigns:

• 10–20 SKUs
• 2–3 marketplaces
• A mix of high-margin and low-margin products

Compare software-reported profitability against your finance/ERP numbers to ensure the model is accurate.

9) Automate alerts

Set alerts for:

• SKU profitability falling below threshold
• Spend increasing without revenue growth
• Stockouts on top-performing SKUs
• Campaigns with high spend and negative margin
• Margin changes due to supplier cost updates

10) Reconcile regularly

Run weekly or monthly reconciliation between:

• Ad platform attributed revenue
• Marketplace order revenue
• ERP gross margin
• Finance P&L

This keeps SKU profitability trustworthy.

Suggested software capabilities to look for

If you’re choosing catalog advertising software, look for:

• Product/SKU mapping across marketplaces
• Ad and marketplace integration
• Fee and margin support
• Profit dashboards by SKU, campaign, and marketplace
• Rule-based bid automation
• Inventory-aware optimization
• Custom fields for COGS and fees
• Export/API access

If you want, I can also give you:

1. a step-by-step implementation checklist,
2. a data model/schema for SKU profitability tracking, or
3. a vendor evaluation scorecard for choosing the software.