Connect a source
Sales

Orders

The most recent orders, with the campaign each one joins back to — where one exists.

AI verdict
1 of the last 18 orders cannot be joined back to an ad.
3 actions

Order status

Last 18 orders

61%
17%
11%
delivered61.1%in transit16.7%pending5.6%returned11.1%cancelled5.6%

Attribution gap

Orders that carry no click id

14.2%of revenue unjoined

1 of the last 18 orders arrived without a click id — influencer codes, WhatsApp and direct traffic. Every channel ROAS in Marketing is computed on the remainder.

Recent orders

OrderDateCustomerCityChannelSegmentItemsValue · SARMarginAttributed toStatus
#3832432026-08-07cust_637047e23cTabukWebsiteAt risk337022.2%TikTok · Spark Ads UGCcancelled
#7610952026-08-07cust_697e7c67e4repeatKhobarMobile appPotential loyalist51.3k46.4%Google · Search Branddelivered
#7415632026-08-07cust_ec948fd562repeatKhobarWebsiteChampions51.6k38.2%Meta · Ramadan Prospectingreturned
#4796152026-08-06cust_d255bd292cAbhaWhatsApp ordersChampions177836.1%Google · Search Brandin transit
#4545262026-08-06cust_215b1d466aAbhaWebsiteLoyal177535.3%Google · PMax Catalogin transit
#3862382026-08-06cust_c17c744367repeatMedinaWebsiteAt risk150336.1%Google · Search Branddelivered
#2600702026-08-05cust_1bb902a115MeccaWebsitePotential loyalist338840.6%Snapchat · Flash Sale Burstdelivered
#5522562026-08-05cust_b0ae29a49bMeccaWebsitePotential loyalist113921.8%Meta · Retargeting DPAdelivered
#1674192026-08-04cust_4ae4c91849repeatKhobarWebsiteAt risk31.2k28%no click iddelivered
#2623542026-08-04cust_14e55ffa8fRiyadhWebsiteHibernating51.5k33.7%Meta · Ramadan Prospectingdelivered
#7504062026-08-04cust_41927bc20fDammamRetail storesNew266130.4%Google · Search Branddelivered
#4197012026-08-03cust_1bc718c8c2repeatKhobarWebsitePotential loyalist169845.8%Google · Search Brandin transit
#7465772026-08-03cust_3cf4405d48MeccaWebsiteHibernating530123.8%Snapchat · Flash Sale Burstpending
#3756662026-08-02cust_74d20bb40arepeatMeccaMobile appChampions231636.7%TikTok · Spark Ads UGCdelivered
#1213102026-08-02cust_795ff687ceTabukMobile appAt risk51.7k21.4%Meta · Ramadan Prospectingdelivered
#8047562026-08-02cust_a004e55614TabukWhatsApp ordersNew31.4k46%Meta · Ramadan Prospectingdelivered
#5603342026-08-01cust_d0a8d9f0a1repeatJeddahWhatsApp ordersPotential loyalist31.2k28.6%TikTok · Spark Ads UGCreturned
#7850512026-08-01cust_dc3a3f955eMedinaMobile appHibernating128132.7%Snapchat · Flash Sale Burstdelivered
Order-flow analysis
Sightrz Analyst · claude-opus-5 · 2026-08-07 06:00 UTC

1 of the last 18 orders cannot be joined back to an ad.

Order flow is running at 632 a day with 392 SAR average value. 7 of the 18 most recent came from returning customers, and 3 ended returned or cancelled — both rates are visible here days before they appear in the monthly close.

What the data says · 3
WatchConfidence94%
14.2% of revenue has no click id

Influencer codes, WhatsApp orders and direct traffic all land without a click. Every ROAS figure in Marketing is computed on the remainder, so the true blended return is higher than the platforms report — and unevenly so.

1/18 recent orders unsourced · 1.1M SAR of the window
WatchConfidence66%
Returns cluster in one city and one channel

Cash-on-delivery refusals concentrate geographically. Treating the blended return rate as uniform over-charges the healthy regions and under-prices the problem one.

3/18 recent orders returned or cancelled · 10.6% blended
WorkingConfidence80%
Repeat orders carry a higher basket

Returning customers are ordering more items per order than first-time buyers. That gap is the argument for spending on retention rather than another prospecting cohort.

39% of recent orders are repeat · 37.9% trailing repeat rate
Recommended actions · 3
Add a WhatsApp Business source

It is the largest unsourced bucket. The referral payload exists on the first inbound message only, so capturing it at that moment is what closes the gap.

Recover ~8pp of attributionMedium effortConfidence85%
Require a reason code on cancellation

Cancellations currently close without one, so the difference between out-of-stock, changed-mind and payment-failure is unrecoverable after the fact.

Makes the return finding actionableLow effortConfidence88%
Hold COD orders above 3× AOV for confirmation

High-value cash-on-delivery is where refusal concentrates. A confirmation step costs one message and removes the most expensive failures.

Save ~157.5k SAR / 30dLow effortConfidence73%