LOADING SOURCE GBP £
HISTORICAL RETAIL / 2009—2011

Retail revenue
& returns.

A closer look at where recorded sales activity sits, how it moves, and what the transaction data can actually support.

UCI ONLINE RETAIL II SOURCE ROWS INDEPENDENT CASE STUDY
01/01

THE OPERATING QUESTION

Where is positive sales activity concentrated, and what do cancellations and negative-quantity lines reveal?

EVIDENCE BEFORE INTERPRETATION
01 / PERFORMANCE

The sales picture

GROSS POSITIVE LINE VALUELoadingEligible positive transaction lines
POSITIVE SALES INVOICESLoadingDistinct invoices with eligible lines
POSITIVE UNITS SOLDLoadingAcross all retained stock codes
GROSS VALUE / INVOICELoadingPositive line value ÷ eligible invoices
TRANSACTION TREND

Activity over time

Monthly aggregation across the selected period

Gross positive line valueMONTHLY / SOURCE-DERIVED
DEC 2009 — DEC 2011Missing months are displayed as zero only within the observed date range.
02 / COMMERCIAL MIX

Where the value sits

Full source period · eligible positive lines

GEOGRAPHY

Sales by country

Top countries by positive line value

A
Loading country totals...
Country is the source customer-country field. Missing values are grouped as Unknown / missing.
STOCK-CODE MIX

Highest-value codes

Source descriptions are shown as supplied

B
STOCK CODE / DESCRIPTIONUNITSLINE VALUESHARE
Loading stock-code totals...
All stock codes remain in the totals, including service and adjustment codes. Keyword matches are review candidates, not automatic exclusions.
MARKET CONCENTRATION—

Waiting for verified country totals.

STOCK-CODE CONCENTRATION—

Waiting for verified stock-code totals.

PEAK MONTH—

Waiting for the monthly series.

03 / CUSTOMER LENS

What the IDs reveal

Identified-customer cohort only

REPEAT ACTIVITY

Customer continuity

Distinct eligible invoices per identified customer

C
—IDENTIFIED CUSTOMERS
—REPEAT-CUSTOMER RATE
—REPEAT-CUSTOMER SALES SHARE
i

Customer measures exclude rows without CustomerID. They describe only the identified-customer cohort and should not be generalized to all source transactions.

EXCEPTION ACTIVITY

Two different signals

Never combine these into one return metric

D
CANCELLATION INVOICESInvoice identifiers beginning with C
—
NEGATIVE-QUANTITY LINESOutside cancellations · count includes all price values
—
NEGATIVE-QUANTITY VALUEOnly rows with positive unit prices can be valued
—
Negative quantities are return-like signals, not confirmed customer returns. Cancellation invoice identifiers are counted separately.
04 / DATA INTEGRITY

Know the weak points

Source workbook · measured at build time

EXACT DUPLICATE ROWS—Counted and retained in calculations
MISSING CUSTOMER IDS—Share of all source rows
NON-POSITIVE PRICES—Excluded from positive line value
INVALID DATES—Excluded from dated sales measures
!

The data audit has not loaded yet.

05 / METHOD & LIMITS

What the numbers mean

Definitions are part of the analysis

INCLUSION RULE

Gross positive line value

Quantity × UnitPrice for rows with a non-cancellation invoice identifier, a valid invoice date, Quantity above zero and UnitPrice above zero. All stock codes are retained.

QTY > 0 + PRICE > 0 + VALID DATE
EXCLUSION RULE

Not net revenue or profit

The dashboard does not subtract cancellation or negative-quantity activity from positive line value. The source has no cost-of-goods-sold field, so profit and margin cannot be calculated.

NO COST DATA ≠ PROFIT
INTERPRETATION BOUNDARIES

What this dataset cannot tell us

× Profit or gross margin × Stock availability or stockouts × Dispatch or delivery performance × Marketing ROI or acquisition source × Confirmed customer returns from negative quantities alone

Independent portfolio analysis · Historical source data · No client relationship implied.