Ad spend as % of sales

Store excl. VAT after refunds

The inverse of MER as a percentage: how much of every 100 sold goes to ads.

Formula

ad_spend ÷ sales_excl_vat_after_refunds × 100

Where the AI finds it

get_performance → efficiency.ad_spend_share_of_sales_pct

How it is verified

Calculation checked against hand-computed values · MT-48 · McpPerformance::window

Ask it like this

For [store], show ad spend as % of sales for the last 30 days compared with the previous 30 (get_performance, compare=previous_period).

Can be broken down by

Day, week or monthget_performance

Used in prompts

Prepare the monthly client review Weekly client report Find unusual changes Yesterday's pulse Where did the profit go? Is our growth healthy? Which channels drive profitable growth? Are we on track this month? What the customer base looks like Which channels bring real sales? How much email matters

From the same tool

Ordersorders Sales incl. VAT, before refundssales_incl_vat_before_refunds Sales excl. VAT, before refundssales_excl_vat_before_refunds Refunds excl. VATrefunds_excl_vat Sales excl. VAT, after refundssales_excl_vat_after_refunds Average order valueaov Cost of goods (COGS)cogs Ad spendad_spend Platform-claimed revenueplatform_revenue Platform-claimed conversionsplatform_conversions Platform ROASplatform_roas Cost per clickcpc MER (marketing efficiency ratio)mer Customerscustomers First-seen customersfirst_seen Returning customersreturning Business resultbusiness_result Figure verdictverdict

Connect Claude or ChatGPT to seenly.ad and ask for this figure on your store, for any period, with its basis and verdict.

Connect