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. |