MER (marketing efficiency ratio)

Store excl. VAT after refunds core

Store sales excl. VAT after refunds divided by all ad spend. Independent of attribution.

Formula

sales_excl_vat_after_refunds ÷ ad_spend

Where the AI finds it

get_performance → efficiency.mer_excl_vat_after_refunds

How it is verified

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

Ask it like this

For [store], show MER (marketing efficiency ratio) 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 Ad spend as % of salesad_share 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