Check whether your Facebook ads sell the products they show

Ad spend next to real store sales for each advertised product, and the ones whose ads cost more than they sell.

  • Needs Meta Ads + Shopify
  • Claude only
  • Read-only

Using Meta Ads and Shopify, for each product I advertise on Facebook and Instagram, compare the last 30 days of ad spend with that product's sales in Shopify. Which products sell less than their ads cost?

Open in Claude
Needs

A Meta ad account and a Shopify store

Connect
Share

What you get back

Example answerSample data, to show what comes back

Using Meta Ads and Shopify, for each product I advertise on Facebook and Instagram, compare the last 30 days of ad spend with that product's sales in Shopify. Which products sell less than their ads cost?

The apron's ads cost more than it sold

The skillet and the Dutch oven pay their way. The apron took $310 in ads and sold $280.

ProductAd spendShopify salesSales per $1
Cast iron skillet$420$1,8904.50
Enamel Dutch oven$130$5204.00
Linen apron$310$2800.90

Pause the apron ads or test new images. The other two pay off.

What the assistant does

  1. 1

    Reads the ad spend for each product you advertise.

  2. 2

    Reads the same products' sales in Shopify.

  3. 3

    Works out the sales for every dollar spent.

  4. 4

    Flags the products whose ads cost more than they sell.

More prompts

All prompts

Find your next prompt

Requests for listings, orders, buyers, ads and research, each with an example of what comes back.