Ciro

By HEY CIRO S.A.C.

Get New App Alerts

Open in ChatGPT

Open in Claude

Overview

Ciro is a sell-out analytics platform for consumer brands that sell through retail chains. It brings together the sales and stock data each chain shares with its suppliers, links the chain's product and store codes to the brand's own catalog, and keeps that data current. With the Ciro connector, Claude answers questions with that data for the Ciro organization you connect: sales and units by chain, banner, brand, category, product, store, region or time, with comparisons against last year or last month; stock, out-of-stocks and stock coverage; purchase suggestions to reach your target days of inventory; your saved Ciro dashboards; and how current each chain's data is. The connector is read-only: it can't change data, settings or users. You approve each connection for one Ciro organization, and your access is checked again on every request. Ciro is built for key account managers, sales teams and demand planners at consumer brands, mainly in Latin America. You need a Ciro account with access to an organization.

Tools

add_dashboard_tiles

ChatGPT

Adds tiles to a saved dashboard this person can change (list_dashboards says which). Tiles work as in create_dashboard. They show first on the dashboard, or last once someone has arranged its layout. Returns the dashboard's tiles afterwards.

create_dashboard

ChatGPT

Saves a new dashboard in Ciro with the given tiles (KPIs, charts and tables), e.g. to keep a report built with query_data: repeat each query's measures, dimensions, filters and date range, with a chart that fits it. It is personal (only this person sees it, under 'Mi espacio') unless shared is true, which puts it in the organization's dashboards for everyone. Only the organization's owners and admins can share. Tiles run on live data every time the dashboard opens and show every row their breakdown returns, so a title can't promise a top N: chart breakdowns with few values (chain, banner, brand, category, month) and use a sorted table for products or stores. Returns the dashboard's id, its link in Ciro and its tiles.

get_data_catalog

ChatGPT

Lists every measure (metric) and dimension (breakdown) query_data accepts, grouped like Ciro's explorer, with labels, units and definitions, plus the organization's currency and today's date. Call it first when you don't know the exact field for a question.

get_data_status

ChatGPT

Shows, per chain (Cadena), the last day with sales, the last stock report and the state and last successful sync of each of its integrations. Use it for 'is my data up to date?' questions or to explain gaps before analyzing recent days.

list_dashboards

ChatGPT

Lists the saved dashboards this person can see in Ciro (shared with the organization or personal), whether they can change each one, and each one's tiles with their ids. Use run_dashboard to read one.

list_dimension_values

ChatGPT

Lists the values of a dimension, e.g. the organization's chains (retail_group_name), brands, categories, or the products and stores matching a search. Use it to get the exact spelling before filtering query_data with equals.

query_data

ChatGPT

Computes measures over the organization's sell-out (sales), stock and replenishment data, optionally broken down by dimensions and time. Returns a table with the exact date range covered. Examples: sales by chain last month → measures [total_net_sales, total_units_sold], dimensions [retail_group_name], date_range "last month". Monthly trend → time_granularity "month". Top 10 products → dimensions [product_name], order by the measure desc, limit 10. Stockouts → measures [stores_with_stockout, coverage_stockout] by product_name. Purchase suggestion → measures [suggested_units, suggested_money, current_doh] by retail_group_name or store_name. Stock measures always show the latest known stock, whatever the date range. Percentages come in points (12.5 = 12.5%).

remove_dashboard_tiles

ChatGPT

Removes tiles from a saved dashboard this person can change, by the tile ids list_dashboards shows. They're deleted for everyone who sees the dashboard and can't be restored. Returns the tiles left.

run_dashboard

ChatGPT

Runs every tile of a saved dashboard and returns each tile's data, the same numbers the person sees in Ciro. Pass date_range to read it over other days than the ones it was saved with.