Real sales by source

Store excl. VAT after refunds core

Sales excl. VAT after refunds by the source recorded on the order. Each order appears once: the rows add up to store sales (within a few cents of rounding).

Formula

Σ (total − refunded) × 1/(1+VAT) by utm_source

Where the AI finds it

get_order_sources → rows.*.sales_excl_vat_after_refunds

How it is verified

Calculation checked against hand-computed values · MT-46 · McpOrderSources::forWindow

Ask it like this

For [store], show real sales by source for the last 30 days (get_order_sources, period=last_30).

Can be broken down by

Order sourceget_order_sources

Used in prompts

Which channels bring real sales?

From the same tool

Source share of salessource_share Orders with a proven paid clickpaid_click_orders

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

Connect