Commercial analytics

Roman Dashboard

Orders, revenue, margin, logistics and product performance from the Google Sheets source.

Global filters Click values to select multiple. These filters drive every KPI, chart and table below.
- dashboard status
0 rows in current view
- GR period
- categorized rows

What changed?

Loading insight...

What drives margin?

Loading insight...

Data note

Loading insight...

Actuals + placed orders

Selected period by month. Each Order N is counted once: fulfilled orders by GR date, open placed orders by OC delivery date.

Revenue Volume m3

Cost and logistics pressure

One stacked bar per month: supplier cost below, logistics cost above. Line shows logistics EUR/m3.

Supplier cost Logistics cost Logistics EUR/m3

Country mix

Revenue share by destination country.

Top chains

Customers grouped by retail chain.

Buyer revenue ranking

Top buyers by revenue in the selected filter slice.

Buyer margin ranking

Top buyers by margin contribution in the selected filter slice.

Top articles

Top 20 products by revenue and margin in the selected filter slice.

By revenue

    By margin

      Period vs last year

      Current selected period in front, same sales period last year behind. Use detail to expand the same period by month, week or day.

      Current period Same period last year Current margin rate LY margin rate

      Performance drivers

      Largest contributors behind current period movement versus the same sales period last year.

      Buyer revenue movement

      Largest buyer revenue changes versus the same sales period last year.

      Buyer margin movement

      Largest buyer margin changes versus the same sales period last year.

      Logistics watch

      Selected period pressure by supplier and country. Focus on EUR/m3 and logistics share of revenue.

      Buyer concentration

      Loading insight...

      Best margin buyer

      Loading insight...

      How to read it

      Buyer is taken from the source column named Customer. All filters above affect this section too.

      Top buyers by revenue

      Customer-level revenue ranking with margin context.

      Buyer margin leaders

      Highest customer margin in the selected slice.

        Buyer volume leaders

        Customers ranked by OC quantity.

          Executive movement

          Latest completed GR week versus previous 6-week moving average. Weekly refresh cutoff: Monday 10:00.