{
  "agentscompany": 1,
  "id": "sales-dashboard",
  "kind": "bot",
  "title": "Sales analyst",
  "description": "Comes with a sales dashboard ready, keeps it live and tells you what changed.",
  "bots": [
    {
      "name": "Otto",
      "label": "Sales analyst",
      "shape": 12,
      "color": 10,
      "instructions": "You keep the sales dashboard up to date.\n- Revenue, orders, average ticket, best sellers and returns, compared with the previous period.\n- Point out what changed and a likely reason; flag anything that needs action today.",
      "harness": "claude",
      "skills": [
        {
          "folder": "xlsx",
          "link": "https://github.com/anthropics/skills/tree/main/skills/xlsx"
        }
      ],
      "routines": [
        {
          "cron": "0 8 * * *",
          "prompt": "Update the sales dashboard and tell me in two lines what changed since yesterday."
        }
      ]
    }
  ],
  "dashboards": [
    {
      "title": "Store Sales",
      "key": "sales",
      "spec": "{\"title\":\"Store Sales\",\"subtitle\":\"Last 30 days · Sep 16 – Oct 15, 2026\",\"currency\":\"USD\",\"components\":[{\"type\":\"kpis\",\"items\":[{\"label\":\"Revenue\",\"value\":247510,\"format\":\"currency\",\"delta\":0.139,\"deltaLabel\":\"vs. previous 30 days\",\"trend\":[39360,41260,40042,40844,42730,43274]},{\"label\":\"Orders\",\"value\":3619,\"delta\":0.105,\"deltaLabel\":\"vs. previous 30 days\",\"trend\":[575,603,585,597,625,633]},{\"label\":\"Avg. order value\",\"value\":68.39,\"format\":\"currency\",\"delta\":0.031},{\"label\":\"Conversion rate\",\"value\":0.0284,\"format\":\"percent\",\"delta\":0.018,\"trend\":[0.0262,0.027,0.0268,0.0277,0.0281,0.0284]}]},{\"type\":\"area\",\"span\":8,\"title\":\"Daily revenue\",\"note\":\"dashed = previous 30 days\",\"x\":[\"2026-09-16\",\"2026-09-17\",\"2026-09-18\",\"2026-09-19\",\"2026-09-20\",\"2026-09-21\",\"2026-09-22\",\"2026-09-23\",\"2026-09-24\",\"2026-09-25\",\"2026-09-26\",\"2026-09-27\",\"2026-09-28\",\"2026-09-29\",\"2026-09-30\",\"2026-10-01\",\"2026-10-02\",\"2026-10-03\",\"2026-10-04\",\"2026-10-05\",\"2026-10-06\",\"2026-10-07\",\"2026-10-08\",\"2026-10-09\",\"2026-10-10\",\"2026-10-11\",\"2026-10-12\",\"2026-10-13\",\"2026-10-14\",\"2026-10-15\"],\"format\":\"currency\",\"series\":[{\"name\":\"This period\",\"data\":[8831,8094,8127,7426,6882,8034,7849,8297,9212,7868,7324,7952,7415,8343,9008,8502,8798,7465,7509,8570,7985,9079,9494,8098,8074,8072,7917,9032,9087,9166]},{\"name\":\"Previous period\",\"data\":[6951,6753,5691,6644,8013,7932,8130,7093,6132,6619,6302,7843,8807,7416,7418,6644,5855,7083,7869,8298,8352,6931,6591,6657,6342,8356,8695,7617,7762,6450],\"dashed\":true,\"color\":\"#6b6b70\"}],\"events\":[{\"x\":\"2026-10-03\",\"label\":\"Fall sale\"}],\"refs\":[{\"y\":7500,\"label\":\"daily target\",\"tone\":\"good\"}]},{\"type\":\"donut\",\"span\":4,\"title\":\"Revenue by channel\",\"format\":\"currency\",\"data\":[{\"name\":\"Online store\",\"value\":128705,\"color\":\"#5DB0FD\"},{\"name\":\"Instagram Shop\",\"value\":51977,\"color\":\"#FD939B\"},{\"name\":\"Amazon\",\"value\":42077,\"color\":\"#FDC949\"},{\"name\":\"Retail POS\",\"value\":24751,\"color\":\"#6b6b70\"}]},{\"type\":\"table\",\"span\":8,\"title\":\"Best sellers\",\"sort\":\"revenue\",\"pageSize\":6,\"rowAction\":\"Show details for {product}\",\"columns\":[{\"key\":\"product\",\"label\":\"Product\"},{\"key\":\"sku\",\"label\":\"SKU\"},{\"key\":\"units\",\"label\":\"Units\",\"better\":\"max\"},{\"key\":\"revenue\",\"label\":\"Revenue\",\"format\":\"currency\",\"type\":\"bar\"},{\"key\":\"trend\",\"label\":\"Last 6 weeks\",\"type\":\"spark\"},{\"key\":\"change\",\"label\":\"vs. prev.\",\"type\":\"delta\"},{\"key\":\"stock\",\"label\":\"Stock\",\"type\":\"badge\",\"tones\":{\"In stock\":\"good\",\"Low\":\"warn\",\"Out\":\"bad\"}}],\"rows\":[{\"product\":\"Merino Crew Sweater\",\"sku\":\"KN-204\",\"units\":412,\"revenue\":36668,\"trend\":[52,58,61,70,79,92],\"change\":0.22,\"stock\":\"In stock\"},{\"product\":\"Waxed Canvas Tote\",\"sku\":\"BG-118\",\"units\":538,\"revenue\":26362,\"trend\":[80,84,88,90,96,100],\"change\":0.09,\"stock\":\"Low\"},{\"product\":\"Everyday Chino\",\"sku\":\"PT-031\",\"units\":301,\"revenue\":20769,\"trend\":[55,50,52,49,47,48],\"change\":-0.04,\"stock\":\"In stock\"},{\"product\":\"Leather Card Holder\",\"sku\":\"AC-077\",\"units\":624,\"revenue\":18096,\"trend\":[96,101,99,108,105,115],\"change\":0.06,\"stock\":\"In stock\"},{\"product\":\"Wool Beanie\",\"sku\":\"AC-090\",\"units\":470,\"revenue\":13630,\"trend\":[40,55,68,82,101,124],\"change\":0.61,\"stock\":\"Low\"},{\"product\":\"Oxford Shirt\",\"sku\":\"SH-012\",\"units\":188,\"revenue\":12784,\"trend\":[36,34,31,30,29,28],\"change\":-0.11,\"stock\":\"Out\"}]},{\"type\":\"bullet\",\"span\":4,\"title\":\"Low stock\",\"note\":\"units on hand vs. reorder point\",\"items\":[{\"label\":\"Oxford Shirt (SH-012)\",\"value\":0,\"target\":60,\"ranges\":[30,60,150]},{\"label\":\"Waxed Canvas Tote (BG-118)\",\"value\":38,\"target\":80,\"ranges\":[40,80,200]},{\"label\":\"Wool Beanie (AC-090)\",\"value\":44,\"target\":90,\"ranges\":[45,90,220]},{\"label\":\"Linen Napkins (HM-210)\",\"value\":27,\"target\":40,\"ranges\":[20,40,120]}]},{\"type\":\"callout\",\"span\":12,\"tone\":\"warning\",\"title\":\"Oxford Shirt is sold out\",\"text\":\"It sold 188 units this period. The supplier lead time is 12 days, so reorder **150 units** today to be back in stock before Oct 30.\"},{\"type\":\"actions\",\"buttons\":[{\"label\":\"Draft reorder for low-stock items\",\"message\":\"Draft purchase orders for all low-stock items\"},{\"label\":\"Explain the revenue jump\",\"message\":\"Explain what drove the revenue increase this period\",\"style\":\"secondary\"}]}]}",
      "refresh": "Fill it with the store's real sales: revenue, orders, average ticket, conversion, best sellers, channels and stock (Shopify, Mercado Livre or the spreadsheets you have).",
      "cron": "0 8 * * *"
    }
  ]
}