القائمة
Build customer cohorts and measure repeat purchases by joining the demo orders_demo and customers_demo tables. Triggers on cohort, retention, and repeat-purchase questions over the demo dataset.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
| name | cohort-helper |
| description | Build customer cohorts and measure repeat purchases by joining the demo orders_demo and customers_demo tables. Triggers on cohort, retention, and repeat-purchase questions over the demo dataset. |
Group demo customers into cohorts and measure repeat-purchase behaviour.
agnes schema orders_demo and agnes schema customers_demo (customer_id, name, country).agnes query "SELECT count(*) FROM (SELECT customer_id FROM orders_demo GROUP BY 1 HAVING count(*) > 1)".customer_id and group by country, e.g. agnes query "SELECT c.country, count(DISTINCT o.customer_id) AS customers, count(*) AS orders FROM orders_demo o JOIN customers_demo c USING (customer_id) GROUP BY 1 ORDER BY 2 DESC".All analysis is local against the bundled synthetic dataset.