Dataset Submission Guidelines

dataset example

Your Excel-CSV dataset must be a single table in "tidy" form, where each variable forms a column and each observation forms a row. The maximum file size is 200MB. Click here to download an example dataset.

Required Columns

The dataset must include:

  • Any number of dimension columns (e.g., channel, product, category, customer, country, promo/no promo, visited/not visited,...).
  • A metric column for revenues or costs, named "Amount" or "Sales," in plain number format (no thousands separators or currency signs).
  • A "Date" column in YYYY-MM-DD format or a "Period" column (e.g. 2023 vs 2022)

Other Columns

The dataset can also include:

  • "Units" column: measures the number of items/packs of product sold (in plain number format).
  • "Volume" column: measures the volume (kilos, liters, etc.) of product sold (in plain number format).
  • "Discount" column: contains the discount in absolute value (not in %) and in positive sign.
  • "COGS column": contains the cost of goods sold (COGS) in absolute value (not in %) and in positive sign.
  • A "Scenario" column can be added for comparing Plan with Actual.

A Price column is not required, as the app will re-calculate the unit or volume price and ignore any Price columns if present.

Driver Columns

Driver columns contain metrics that have a linear relationship with the cost/revenue column and help explain changes in sales. Examples include Visits, Bookings, and Distribution. These metrics must be in value (not in %) and can include:

  • Category weighted distribution: measures the weighted number of outlets where a product is available for sales.
  • Checkouts: measures the number of purchase decisions (tickets, bookings, checked out shopping carts, etc.).
  • Visits: measures the number of customer interactions (shop/website visits, traffic, inquiries, leads, etc.).

Encoding and formatting

CSV files must be in UTF-8 encoding.

Metric columns must be in plain number format, with no thousand separators, no currency signs, zero written as "0" and not as "-", and a leading minus sign for negative numbers (e.g. -20)

© Mparanza LLC. All Rights Reserved