Additional report ideas โ data needed
Covered by this export
Order value and average order value; total and average merchandise quantity;
shipping charged and its average; coupon usage and discount value;
order activity by store; decoration-associated order value.
Requires additional fields or exports
โข Decoration-only value / price per impression: decoration charges,
quantities and placement/impression records.
โข Decoration impression quantity: verified impression or placement counts;
repeated process codes are not sufficient.
โข Blank-product sales value: blank selling prices or separate blank sales totals.
โข Order turnaround: accepted/created and completed timestamps plus status.
โข Quote value, response time and conversion: quote IDs, request/response dates,
values, status and linked order IDs.
โข Rush order counts, value and percentage: an explicit rush indicator.
โข Artwork approval counts and turnaround: approval IDs and request/approved timestamps.
โข Purchase order counts, values and suppliers: PO IDs, values, dates and supplier IDs/names.
โข Profit and loss: sales detail, product/decoration costs and operating expenses.
โข Affiliate commissions paid: verified commission records plus payment status/date;
Store Commission alone does not prove payment.
โข Sales tax collected: confirmed line/adjustment tax definitions plus
payment/collection records; Tax alone does not prove collection.
โข Active affiliate stores: affiliate status and active/inactive flags;
a store with orders is not proof of current active status.
