Wrenfold← Back to the write-up · All demo stores

Wrenfold weekly trading

Week of —: — revenue from — orders, — on the week before. Meta returned — on Shopify-attributed revenue against the — Meta reports, and there are — high-priority stock and 3PL actions to clear before Monday's pick.

Shopify orders and stock are real data from the Wrenfold demo store. GA4, Meta, TikTok, Omnisend and the 3PL file are sample exports built in each tool's standard format, because a fictional brand can't connect them.

Revenue, latest week——
Orders——
Conversion rate——
Average order value——
Repeat rate——
Blended CAC——

Conversion is Shopify orders over GA4 sessions. Repeat rate is the share of orders from customers who had ordered before. Blended CAC is Meta plus TikTok spend over new customers. Changes compare with the week before; rates move in percentage points.

Revenue by marketing source

Weekly, inc. VAT and shipping. Source comes from the order's UTM tags.

Return on ad spend

Shopify-attributed revenue over spend (solid) against what each platform reports (dashed). Meta prospecting started w/c 12 Oct.

Conversion rate and sessions

Bars are GA4 sessions; the line is conversion rate. Cheaper prospecting traffic lowered conversion from w/c 12 Oct.

Actions for this week

From the 3PL reconciliation, stock cover, ad returns and the master data margin check, most urgent first.

#PriorityAreaWhat to do

Stock cover by SKU

Units available over average weekly sales for the last four full weeks. Lowest cover first.

SKUProductAvailableSold / weekWeeks' coverFlag

3PL stock reconciliation

SKUs where the warehouse file and Shopify disagree. Difference is Shopify minus the 3PL.

SKUPriorityIssueShopify3PLDiff.