홈 / Skills / 이커머스 운영 / 운영 주간 리뷰 (E-commerce Weekly Review)
이커머스 운영

운영 주간 리뷰 (E-commerce Weekly Review)

AIBarsMITSkill 언어: 영어
라이선스 확인됨스크립트 없음낮은 위험
데모실행 기록 · claude-sonnet-5-5 · 2026년 10월
Here are my store numbers for the last two weeks. Please write my weekly review. Week 1: sessions 12,400; orders 310; net revenue 15,200; ad spend 3,100; returns 14 orders. Week 2: sessions 14,900; orders 312; net revenue 14,500; ad spend 4,300; returns 21 orders. By source in week 2: paid social 6,300 sessions (was 3,400), search 4,800 (was 5,200), email 1,900 (was 2,100), direct 1,900 (was 1,700). I started a new paid-social campaign on Monday of week 2 and ran a 10% off email on Wednesday of week 1. The checkout page got a new payment option on Friday of week 2.
Skill: ecommerce-weekly-review

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

  1. 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.
  2. 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.
  3. 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). 가상의 2주치 숫자로 한 번 시험 실행했고 비율은 나중에 손으로 계산해 확인했습니다.