Weekly Review: Week 2 vs Week 1
Decision for you: Hold the new paid-social spend at its current level for one more week. Don't scale it and don't cut it. Traffic rose 20% but orders were flat, and the data can't yet tell you whether the new paid visitors buy at all.
Headline
Net revenue fell 4.6% (15,200 → 14,500) even though sessions rose 20%. Ad spend rose 39%, so blended ROAS dropped from 4.90 to 3.37.
Key metrics
| Metric (definition) | Week 1 | Week 2 | Change |
|---|---|---|---|
| Sessions | 12,400 | 14,900 | +20.2% |
| Orders | 310 | 312 | +0.6% |
| Conversion rate (orders / sessions) | 2.50% | 2.09% | −0.41 pts (−16%) |
| Net revenue | 15,200 | 14,500 | −4.6% |
| AOV (net revenue / orders) | 49.03 | 46.47 | −5.2% |
| Ad spend | 3,100 | 4,300 | +38.7% |
| CPA (spend / orders) | 10.00 | 13.78 | +37.8% |
| Blended ROAS (net revenue / spend) | 4.90 | 3.37 | −31% |
| Return rate (returned orders / orders in the same week) | 4.5% (14) | 6.7% (21) | +2.2 pts |
Decomposing revenue as sessions × conversion × AOV: sessions rose 20%, conversion fell 16% and AOV fell 5%. More traffic was cancelled out by weaker conversion and a lower AOV.
What changed and why
-
Paid social drove all the traffic growth (likely).
- Paid social sessions went from 3,400 to 6,300 (+2,900), while every other source combined went from 9,000 to 8,600 (−4%).
- Paid social is now 42% of sessions, up from 27%.
- This is a mix effect. If paid-social visitors convert worse than search, email and direct, overall conversion falls even if no source changed.
- I can't confirm this because I don't have orders by source.
-
The extra spend bought almost no extra orders (confirmed, with a caveat).
- Spend rose by 1,200 and orders rose by 2.
- Not all of the extra spend went to paid social, and the orders may have come from other sources, so treat the incremental CPA as a rough signal.
- It points to the new campaign's visitors converting poorly or arriving too early in their buying journey.
- One week is too short to judge, since some of these buyers may convert later.
-
Week 1 is not a clean baseline (confirmed).
- The 10% email promo on Wednesday of week 1 probably lifted that week's orders.
- Email sessions were also higher in week 1 (2,100 vs 1,900).
- Part of the conversion drop may be the promo ending, not only the new traffic.
- A discount would normally lower AOV, but AOV was higher in week 1, so I can't tie the AOV drop to the promo. Product mix or the new traffic are other possibilities (hypothesis).
Search (−8%) and email (−10%) sessions also dipped. That's modest and could be normal variation, but it's worth watching. Direct rose 12%, which may be a small halo from the paid campaign (hypothesis).
Problems and risks
- Ad efficiency: CPA is up 38% and ROAS is down 31% after one week of a new campaign. That's a flag, not yet a verdict.
- Returns: 21 vs 14 returned orders. These are small counts, so some of the rise could be chance. Two other explanations are worth checking:
- Week 1 promo orders may be coming back as returns in week 2.
- Returns may be concentrated in paid-social buyers or in a few products.
- Payment option: It launched Friday of week 2, so it covers only about 3 days. Don't credit or blame it yet. Check payment failures and checkout completion before and after.
Actions
| Action | Owner | By | Check next week |
|---|---|---|---|
| Pull orders and revenue by source (especially paid social) | You | Before the next review | Is paid-social conversion well below the others? |
| Keep paid-social spend flat this week | You | Now | Does CPA settle, or keep rising? |
| Break down returns by product, source and order date (promo or not) | You | Next review | Is the rise concentrated or spread out? |
| Compare checkout completion and payment failures before and after Friday | You | Next review | Is there a lift, a problem, or no difference? |
Data notes
- Missing data: orders by source, funnel steps (add-to-cart, checkout start, completion), new vs returning customers, product mix, spend by channel, and whether net revenue already excludes returns. Without these, the explanations above stay at "likely" or "hypothesis".
- Sample size: the whole comparison rests on about 310 orders per week, so small differences can be noise. One week is not a trend, so I'd also look at the previous 3–4 weeks if you have them.
- Definitions: I used net revenue as you gave it, and I computed return rate against same-week orders, not against the original order cohort.
- Attribution: use one analytics source for session counts by channel, and check that its numbers match your ad platform's.
Suggested experiment
The open question is whether paid social brings real incremental buyers. Run the campaign for two more weeks while tracking orders by source. Then, if its conversion is still low, cut its budget by about half for one week and watch total orders. If total orders don't drop, the campaign isn't adding much. Decide the threshold beforehand, for example "a drop of fewer than 10 orders means not incremental", so you don't read the result after the fact.
Real run in an isolated folder with only this skill installed. Only the Skill and Read tools were enabled, so no command was run and no file was written. The store and all numbers are invented and the model had no access to a real store. The ratios in the answer were recomputed by hand afterwards and matched. Explanations are labeled as confirmed, likely or hypothesis because only these totals were provided.
它做什么
只分析你提供的数据,绝不用“行业平均值”去填补空缺。它先把指标口径定下来(访问、转化率、客单价、新老客户、广告效率、贡献利润、退货率),检查两个时间段是否可比、统计口径有没有变,然后把销售额拆成访问量、转化率和客单价来解释变化,再按来源、设备、商品和漏斗步骤深挖变动的那个因素。它会留意结构效应,说明每个结论依据了多少订单,并把每条解释标成已确认、较可能或假设。
输出
一页纸报告:一句话结论、关键指标表、带证据的主要发现、问题与风险、带负责人和截止时间并说明下周如何检验的行动项、数据说明,以及针对最大未解问题的一个建议实验。
适合什么场景
每周和每月的店铺复盘、“销量为什么掉了”这类问题,以及决定该盯哪些数字。
低风险:纯指令文件,没有脚本,不联网、不写文件。这是运营复盘,不是财务、税务或法律意见。它只依据你粘贴的数字,所以在你补充缺少的拆分数据之前,解释只会停留在“较可能”或“假设”,并且会说明缺少哪些数据。请勿粘贴客户个人数据,用汇总数即可。各平台上报的数字可能因归因重叠而不一致,它会说明用的是哪个来源。AIBars 原创(MIT)。已用虚构的两周数据试用过一次,其中的比率事后用手算核对过。