Reports and Statements

Generating a report returns a run whose report_url becomes a presigned CSV download link once the run completes. This page documents the columns of each report type's CSV, generated from the same schema the Seller API publishes alongside its OpenAPI description.

See Reports and Statements for the GET /reports, GET /reports/{report_id}, and POST /reports operations that create and list these runs.

Financial report

CSV column header: seller_financial_report.

Column Type Description
transaction_completed_at_utc datetime When this ledger transaction completed, in UTC.
order_placed_at_utc datetime When the order was placed, in UTC. Null for a transaction not tied to a specific order, such as a shipping charge, carrier adjustment, or tip.
seller_id string The ID of the seller this report is for.
transaction_type string The kind of ledger transaction: ORDER_EARNINGS, SHIPPING_CHARGE, CARRIER_ADJUSTMENT, CARRIER_ADJUSTMENT_REFUND, ORDER_REFUND, ORDER_REFUND_SHIPPING_COSTS, APPEALED_ORDER_REFUND, APPEALED_ORDER_REFUND_SHIPPING_COSTS, or TIP.
transaction_message string A human-readable note recorded on the ledger transaction.
order_id string The order this transaction is for. Null for a transaction not tied to a specific order, such as a carrier adjustment or tip.
listing_title string The title of the listing sold. Set only for ORDER_EARNINGS.
listing_description string The description of the listing sold. Set only for ORDER_EARNINGS.
product_category string The category of the product sold. Set only for ORDER_EARNINGS.
buy_format string How the item was sold, such as auction or buy it now. Set only for ORDER_EARNINGS.
sale_type string FLASH when the item was sold as part of a flash sale, otherwise null. Set only for ORDER_EARNINGS.
quantity_sold integer The quantity of the item sold. Set only for ORDER_EARNINGS.
sku string The SKU of the item sold. Set only for ORDER_EARNINGS.
cost_of_goods number The seller's recorded per-item cost for the item sold, in major currency units. Set only for ORDER_EARNINGS.
livestream_id string The show this transaction is associated with. Null for a transaction not tied to a show, such as a carrier adjustment or an order placed outside a show.
livestream_title string The title of the associated show.
buyer_name string The buyer's username. Set only for ORDER_EARNINGS and TIP transactions.
buyer_state string The buyer's shipping address state. Set only for ORDER_EARNINGS.
buyer_country string The buyer's shipping address country code. Set only for ORDER_EARNINGS.
shipment_id string The shipment this transaction is associated with. Null for a transaction not tied to a shipment, such as a tip.
transaction_currency string The currency transaction_amount and the fee columns are in.
transaction_amount number The signed amount of this ledger transaction, in major currency units. Negative for charges and refunds.
buyer_paid number The order's total amount charged to the buyer, in major currency units. Set only for ORDER_EARNINGS.
original_item_price number The item's price before any seller-generated coupon was applied, in major currency units. Set only for ORDER_EARNINGS.
coupon_cost number The seller-generated coupon amount applied to the order, in major currency units; negative when a coupon was applied. Set only for ORDER_EARNINGS.
post_coupon_price number The item's price after any seller-generated coupon was applied: original_item_price plus coupon_cost. Set only for ORDER_EARNINGS.
seller_shipping_charge number Shipping costs paid by the seller on this order, in major currency units. Set only for ORDER_EARNINGS.
commission_fee number Whatnot's commission on this order, in major currency units. Set only for ORDER_EARNINGS.
commission_tax number Tax charged on commission_fee, in major currency units. Set only for ORDER_EARNINGS.
processing_fee number Payment processing fee charged on this order, in major currency units. Set only for ORDER_EARNINGS.
processing_fee_tax number Tax charged on processing_fee, in major currency units. Set only for ORDER_EARNINGS.
ledger_transaction_id string The ID of the underlying ledger transaction.

Overview analytics report

CSV column header: analytics_overview_report.

Column Type Description
date string The calendar day this row covers, in ISO 8601.
currency string The currency the money fields in this row are denominated in.
estimated_sales string, nullable The sum of the final purchase prices of completed orders, after any seller-generated coupons have been applied. Does not include shipping costs, taxes, or non-order revenue like tips.
in_show_estimated_sales string, nullable Estimated sales from orders placed during a show.
marketplace_estimated_sales string, nullable Estimated sales from orders placed on the profile shop outside a show.
estimated_earnings string, nullable Estimated sales for completed orders minus fees and costs, such as commission, payment processing fees, and seller-paid shipping costs.
in_show_estimated_earnings string, nullable Estimated earnings from orders placed during a show.
marketplace_estimated_earnings string, nullable Estimated earnings from orders placed on the profile shop outside a show.
orders_count integer, nullable The number of unique transactions paid for by buyers, excluding giveaways.
in_show_orders_count integer, nullable The number of orders placed during a show, excluding giveaways.
marketplace_orders_count integer, nullable The number of orders placed on the profile shop outside a show.
giveaway_orders_count integer, nullable The number of giveaway orders.
average_order_value string, nullable The average final purchase price of each completed order, calculated by dividing estimated sales by orders, excluding giveaways.
buyers_count integer, nullable The number of unique buyers who completed a purchase.
new_buyers_count integer, nullable The number of unique buyers who bought from the seller for the first time.
returning_buyers_count integer, nullable The number of unique buyers who had bought from the seller before and bought again.
follows_count integer, nullable The number of people who followed the seller.
referral_follows_count integer, nullable The number of follows that came from a referral.
non_referral_follows_count integer, nullable The number of follows that did not come from a referral.
livestreams_count integer, nullable The number of shows the seller went live for.
stream_minutes integer, nullable The total duration of the seller's shows, in minutes.
viewers_per_hour integer, nullable The average number of unique viewers per hour.
average_watch_time_seconds integer, nullable The average length of time each viewer watched, in seconds.

Livestreams analytics report

CSV column header: analytics_livestreams_report.

Column Type Description
livestream_id string The ID of the show this row covers.
livestream_title string The title of the show.
start_time datetime When the show started.
currency string, nullable The currency the money fields in this row are denominated in. Null when the show has no sales, earnings, or giveaway spend.
livestream_impression_count integer, nullable Times the show's thumbnail appeared in the feed or in search before the show ended.
livestream_clickthrough_rate number, nullable The percentage of people who clicked into the show after seeing its thumbnail in the feed or search before the show ended.
sales string, nullable Total sales from orders in this show, excluding shipping, taxes, and tips.
estimated_earnings string, nullable Estimated sales minus fees and costs, such as Whatnot's commission, payment processing fees, and seller-paid shipping costs.
orders_count integer, nullable The number of unique transactions paid for by buyers during this show, excluding giveaways.
average_order_value string, nullable The average final purchase price of each completed order, excluding giveaways.
giveaway_orders_count integer, nullable The number of giveaway orders during this show.
giveaway_spend string, nullable Total shipping costs on giveaway orders from this show.
buyers_count integer, nullable The total number of unique buyers who bought from the seller during this show.
first_time_buyers_count integer, nullable The number of unique buyers who bought from the seller for the first time during this show.
returning_buyers_count integer, nullable The number of unique buyers who had bought from the seller before and bought again during this show.
giveaway_winners_count integer, nullable The number of unique buyers who won a giveaway during this show.
first_time_giveaway_winners_count integer, nullable The number of unique buyers who won a giveaway from the seller for the first time during this show.
returning_giveaway_winners_count integer, nullable The number of unique buyers who had won a giveaway from the seller before and won again during this show.
buyer_shares_count integer, nullable The number of times the show was shared by users.
stream_minutes integer, nullable The total duration of the show, in minutes.
max_concurrent_viewers integer, nullable The highest number of viewers watching the show at one given time.
total_views integer, nullable The total number of times viewers watched the show for 30 seconds or more. A viewer can count more than once if they leave and rejoin.
distinct_viewers_count integer, nullable The total number of unique viewers who watched the show for 30 seconds or more.
average_rating number, nullable The average rating buyers gave for orders from this show.

Show details analytics report

CSV column header: analytics_show_details_report.

Column Type Description
show string, nullable The show's title.
start_time datetime, nullable When the show started.
duration_minutes integer, nullable The show's length, in minutes.
category string, nullable The show's product category.
thumbnail_impressions integer, nullable How many times the show's thumbnail was shown in feeds.
thumbnail_ctr number, nullable Share of thumbnail impressions that were tapped, in percentage points.
currency string, nullable ISO currency code of the money fields in this row (estimated_sales, estimated_earnings, estimated_aov, sales_per_hour, giveaway_shipping_cost).
estimated_sales string, nullable Total sales from orders in this show, excluding shipping, taxes, and tips.
estimated_sales_benchmark number, nullable Change in estimated_sales against the seller's own trailing average, in percentage points.
estimated_sales_benchmark_label string, nullable What estimated_sales_benchmark is compared against.
estimated_earnings string, nullable Estimated sales minus fees and costs (commission, payment processing, seller-paid shipping).
estimated_earnings_benchmark number, nullable Change in estimated_earnings against the seller's own trailing average, in percentage points.
estimated_earnings_benchmark_label string, nullable What estimated_earnings_benchmark is compared against.
estimated_orders integer, nullable Estimated number of completed orders in this show, excluding giveaways and cancellations.
estimated_orders_benchmark number, nullable Change in estimated_orders against the seller's own trailing average, in percentage points.
estimated_orders_benchmark_label string, nullable What estimated_orders_benchmark is compared against.
estimated_aov string, nullable Average order value for this show (estimated_sales divided by estimated_orders), excluding giveaways.
estimated_aov_benchmark number, nullable Change in estimated_aov against the seller's own trailing average, in percentage points.
estimated_aov_benchmark_label string, nullable What estimated_aov_benchmark is compared against.
sales_per_hour string, nullable estimated_sales divided by the show's duration in hours.
sales_per_hour_benchmark number, nullable Change in sales_per_hour against the seller's own trailing average, in percentage points.
sales_per_hour_benchmark_label string, nullable What sales_per_hour_benchmark is compared against.
orders_per_hour integer, nullable estimated_orders divided by the show's duration in hours.
orders_per_hour_benchmark number, nullable Change in orders_per_hour against the seller's own trailing average, in percentage points.
orders_per_hour_benchmark_label string, nullable What orders_per_hour_benchmark is compared against.
total_giveaway_orders integer, nullable Number of giveaway orders in this show.
buyer_giveaway_orders integer, nullable Number of buyer-appreciation giveaway orders in this show.
giveaway_shipping_cost string, nullable The seller's total shipping cost on giveaway orders in this show.
giveaways_per_hour integer, nullable total_giveaway_orders divided by the show's duration in hours.
unique_giveaway_entries integer, nullable Distinct people who entered any giveaway in this show, counted once each across giveaways.
unique_giveaway_winners integer, nullable Distinct giveaway winners in this show.
new_followers_from_giveaways integer, nullable New followers gained as a result of giveaways in this show.
total_views integer, nullable Total times viewers watched this show for more than 30 seconds; a viewer can count more than once if they leave and rejoin.
max_concurrent_viewers integer, nullable Highest number of viewers watching this show at the same time.
viewers_per_hour integer, nullable unique_viewers divided by the show's duration in hours.
viewers_per_hour_benchmark number, nullable Change in viewers_per_hour against the seller's own trailing average, in percentage points.
viewers_per_hour_benchmark_label string, nullable What viewers_per_hour_benchmark is compared against.
avg_watch_time string, nullable Average time each viewer spent watching this show, formatted as e.g. "5 min 24s".
avg_watch_time_benchmark number, nullable Change in average watch time against the seller's own trailing average, in percentage points.
avg_watch_time_benchmark_label string, nullable What avg_watch_time_benchmark is compared against.
new_followers integer, nullable Net new followers gained during this show.
new_followers_benchmark number, nullable Change in new_followers against the seller's own trailing average, in percentage points.
new_followers_benchmark_label string, nullable What new_followers_benchmark is compared against.
show_shares integer, nullable Number of times this show was shared by users.
show_shares_benchmark number, nullable Change in show_shares against the seller's own trailing average, in percentage points.
show_shares_benchmark_label string, nullable What show_shares_benchmark is compared against.
unique_viewers integer, nullable Distinct viewers who watched this show for more than 30 seconds.
returning_viewers integer, nullable Of unique_viewers, those who had watched this seller before.
returning_viewers_percentage number, nullable returning_viewers as a share of unique_viewers, in percentage points.
new_viewers integer, nullable Of unique_viewers, those watching this seller for the first time.
new_viewers_percentage number, nullable new_viewers as a share of unique_viewers, in percentage points.
unique_buyers integer, nullable Distinct buyers who purchased during this show.
returning_buyers integer, nullable Of unique_buyers, those who had bought from this seller before.
returning_buyers_percentage number, nullable returning_buyers as a share of unique_buyers, in percentage points.
new_buyers integer, nullable Of unique_buyers, those buying from this seller for the first time.
new_buyers_percentage number, nullable new_buyers as a share of unique_buyers, in percentage points.