Ads Day Book

Rebuilt hourly on the box from the warehouse — nothing here is typed in. Pick any of the last ten days above.
Meta spend and campaign ROAS from meta_analysis_campaign_daily; revenue and orders are Shopify totals for the three stores, excluding cancelled, voided, refunded and Matrixify bulk-imports — the same filter the hourly WhatsApp report uses.
Blended ROAS is Shopify revenue ÷ Meta spend. “Revenue less spend” is contribution before product cost, not profit.
The closing floor is a 1.00 return with a ₹1,000 single-day minimum, so a one-day test cannot trigger a closure — that is what the under-₹1k tier holds.
No order counts per campaign. Meta-attributed purchase counts are not stored in this warehouse, so tiers report money and return rather than an invented order split.