Generated by Claude Code -- 2026-05-19 07:02:17 PST
Database: C:\temp\analytics\teeccino_analytics.db
Data Freshness
| Source | Last Date | Target | Status |
|---|
| Shopify Orders |
2026-05-18 |
daily |
CURRENT |
| Meta Ads |
2026-05-19 |
daily |
CURRENT |
| Google Ads |
2026-05-04 |
daily (API not implemented) |
STALE |
| ShipStation |
2026-05-05 |
daily |
STALE |
| Daily KPIs (calc_daily_shopify) |
2026-05-18 |
daily |
CURRENT |
| Price List (2026-05) |
165 SKUs |
monthly (auto-generated) |
CURRENT |
Date Coverage (Last 14 Days)
No date gaps in the last 14 days.
Data Quality Checks
All data quality checks passed.
Fulfillment Time (DTC)
Healthy — 67% of orders ship within 1 day.
Last 30 Days (2,649 orders)
| Avg days to ship | 1.14 |
| Median days | 1.00 |
| P90 days | 2.00 |
| Same-day ship % | 27.7% |
| Within 1 day % | 66.9% |
| Within 2 days % | 92.8% |
| Slow (>3 days) % | 0.8% |
Last 90 Days (10,114 orders)
| Avg days to ship | 2.28 |
| Median days | 2.00 |
| P90 days | 5.00 |
| Same-day ship % | 18.9% |
| Within 1 day % | 42.7% |
| Within 2 days % | 61.8% |
| Slow (>3 days) % | 25.1% |
6-Month Trend (DTC, by order date)
| Month | Orders | Avg Days | Within 1 Day % |
|---|
2025-12 |
3,013 |
6.15 |
15.6% |
2026-01 |
4,020 |
2.51 |
26.4% |
2026-02 |
4,612 |
4.17 |
5.5% |
2026-03 |
4,103 |
2.56 |
29.2% |
2026-04 |
4,003 |
1.14 |
68.9% |
2026-05 |
390 |
1.10 |
67.2% |
Days = first ship_date − order date (Pacific local). Multi-shipment orders use earliest ship_date.
Excludes orders not yet shipped. Full breakdown in Shipping & Fulfillment Matrix.xlsx → Fulfillment Time sheet.
Latest Pipeline Run
[Tue 05/19/2026 7:00:01.16] Starting Claude Code pipeline run
Database Tables
| Table | Rows | Date Range |
|---|
raw_orders |
153,566 |
2023-01-01 to 2026-05-18 |
raw_line_items |
523,581 |
|
raw_discount_allocations |
199,092 |
|
order_journey |
153,566 |
|
order_moments |
273,138 |
|
raw_meta_ads |
1,204 |
2023-02-01 to 2026-05-19 |
raw_google_ads |
1,213 |
2023-01-01 to 2026-05-04 |
raw_shipments |
111,863 |
2024-01-02 to 2026-05-05 |
price_list |
11,257 |
2023-01 to 2026-05 |
cogs |
1,517 |
|
calc_daily_shopify |
1,234 |
2023-01-01 to 2026-05-18 |
calc_daily_sku_sales |
144,203 |
2023-01-01 to 2026-05-18 |
calc_attribution |
153,105 |
|
calc_customer_cohorts |
60,591 |
|
Matrix Workbooks
| Workbook | Last Modified | Status |
|---|
| Sales & Revenue Matrix.xlsx |
2026-05-19 07:01 |
CURRENT |
| Product Performance.xlsx |
2026-05-19 07:01 |
CURRENT |
| Advertising & Attribution.xlsx |
2026-05-19 07:01 |
CURRENT |
| Shipping & Fulfillment Matrix.xlsx |
2026-05-19 07:01 |
CURRENT |
| Shopify KPI 2026 - Updated.xlsx |
2026-05-19 07:01 |
CURRENT |
Recent Dashboard Publishes
| Commit | Date | Message |
|---|
3cf53af |
2026-05-19 07:02 |
Update status page with live pipeline data |
f02cfd6 |
2026-05-19 07:01 |
Ops dashboard update 2026-05-19 |
e93c26a |
2026-05-19 07:01 |
Update PDP Upsell Performance dashboard (2026-05-19 07:01:54) |
79b2574 |
2026-05-19 07:01 |
Fulfillment dashboard build 2026-05-19 |
b3d6f87 |
2026-05-19 07:01 |
Discount deep-dive: 2 pages rebuilt 2026-05-19 07:01 |
9a85a24 |
2026-05-19 07:01 |
YTD dashboard: 1 pages updated 2026-05-19 07:01 |
b951e8a |
2026-05-19 07:01 |
MTD v2 dashboard: 1 pages rebuilt 2026-05-19 07:01 |
50d2c5d |
2026-05-19 07:00 |
Update Mission Control |
e1f33ba |
2026-05-19 04:06 |
Update project dashboards: campaign-versatility, pdp-rebuild, promo-management, rollover |
a92c0ba |
2026-05-19 04:06 |
Update Mission Control |
Automation Ownership
Claude Code (OpenClaw) -- Primary Owner
- Analytics DB pipeline (daily_run.py + run_pipeline.py)
- Shopify GraphQL ingestion
- Meta Ads API ingestion
- Google Ads ingestion
- ShipStation API ingestion
- Monthly price list generation (auto)
- Daily transforms + KPI calculations
- Matrix workbook generation (3 workbooks)
- MTD / YTD dashboard builds + push
- This ops dashboard
- Remote health monitor (scheduled agent)
Crowley (Legacy -- retired)
CSV pipeline -- replaced by Analytics DBMonthly matrices -- replaced by build_all_matrices.pyDashboard generator -- replaced by build_mtd_dashboard.py
Claude Code is the primary owner of all data pipelines and dashboards.
Crowley migration is complete. The legacy CSV pipeline is fully superseded by the Analytics DB.