Skip to main content

Marketplace Dasher Pick Reports

Payout Summary​

Report Type - NV_PAYMENTS_V3

Description​

This report outputs order level details for all direct deposit payouts that have been completed within the requested report timeframe based on store's local time.

Note: Legacy report version available here.

Example Report​

Column NameData TypeDefinitionExampleSince Report Version
payout_date_utcdateThe UTC date when the payout was initiated (MM/DD/YYYY format)7/3/20251
transaction_date_utcdateThe UTC date when the Dasher swiped the red card in the store (MM/DD/YYYY format)06/28/20251
transaction_date_localdateThe local date when the Dasher swiped the red card in the store (MM/DD/YYYY format)06/28/20251
payout_time_localISO8601 timestamp with explicit timezone offsetThe local timestamp when the payout was sent, format: YYYY-MM-DD HH24:MI:SS2025-07-03 1:12:131
transaction_time_utcISO8601 standard timestampUTC timestamp when the red card was swiped, format: YYYY-MM-DD HH24:MI:SS2025-06-28 1:12:131
transaction_time_localISO8601 timestamp with explicit timezone offsetLocal timestamp when the red card was swiped, format: YYYY-MM-DD HH24:MI:SS2025-06-27 19:12:131
business_idintegerDoorDash business ID for the merchant110034561
business_namestringDoorDash business name for the merchantMarkets USA1
merchant_store_idstringMerchant-supplied store ID3011
doordash_store_idintegerDoorDash store ID for the merchant332456351
store_namestringDoorDash store name for the merchantThe Market (South Ave)1
timezonestringStore’s local timezoneUS/Pacific | US/Eastern | US/Central1
delivery_uuidUUIDUnique DoorDash delivery identifierUUID-string1
client_order_idstringDoorDash’s internal POS order identifiercef4d65b-09cc-427a-a4e4-efb3115c9e3e-doordash1
external_order_uuidUUIDMerchant’s external order identifier (if POS-integrated)UUID-string1
transaction_typestringThe type of transaction for this order: delivery = delivery data based on DD platform, swipe = swipe data based on red card processor, adjustment = order adjustmetn changes based on DD platformDELIVERY / SWIPE / ADJUSTMENT1
transaction_notesstringAdditional notes or reason for adjustment from customers or internal sourcesIssue: 1 Advil Ibuprofen Coated Tablets 100 mg (24 ct) missing1
shopping_protocolstringShopping protocol used - Merchant Pick vs Dasher Pick; Merchant Pick: Where the Merchant is preparing the items and then the cost of the goods are covered by Direct Deposit (standard for restaurants); Dasher Pick: When the Dasher is in charge of selecting the items checking out, and delivering them to the customerDASHER_PICK / MERCHANT_PICK1
is_dashpassbooleanTrue if the order included DashPass subscription discountTRUE / FALSE1
is_consumer_pickupbooleanTrue if the customer picked up the order instead of deliveryTRUE / FALSE1
currency_codestringLocal currency of the store using ISO 4217 format (e.g., USD). Every amount field below are in local currency and in DOLLARS with 2 decimalsUSD / CAD / AUS1
order_marketing_fee_amount0.00FMarketing service fee charged to the merchant0.551
dashpass_marketing_fee_amount0.00FFlat DashPass marketing fee charged2.051
order_tip_amount0.00FTip amount given to merchant for pickup orders2.51
platform_subtotal_amount0.00FSubtotal amount before taxes/fees on the DoorDash platform (includes all items, not just alcohol)20.291
platform_tax_amount0.00FTotal tax amount charged on the DoorDash platform (includes all items, not just alcohol)3.191
order_snap_ebt_amount0.00FAmount paid by the customer using SNAP EBT10.511
store_charge_amount0.00FAmount charged at the physical merchant store19.291
store_refund_amount0.00FAmount refunded at the physical merchant store2.011
commission_rate0.00FPercentage commission charged by DoorDash on the order5.51
total_order_commission_amount0.00FTotal commission amount deducted from the order0.271
total_commission_tax_amount0.00FTax applied on the commission0.151
tax_remitted_by_dd_amount0.00FTax paid directly by DoorDash in states where DoorDash remits tax directly to the government (does not pass it to the merchant)3.191
total_payout_amount0.00FTotal net amount paid to the merchant (after fees, refunds, etc.)25.291
payout_transfer_idintegerBank transfer identifier used for tracking this payout1289506241

Transaction Details​

Report Type - NV_TRANSACTIONS_V3

Description​

This report outputs order level details for all red card/in-store card transactions within the requested report timeframe based on store's local time.

Note: Legacy report version available here.

Example Report​

Column NameData TypeDefinitionExampleSince Report Version
transaction_date_utcdateThe date when the Dasher swiped the red card in the merchant store (UTC) in MM/DD/YYYY format12/24/20251
transaction_date_localdateThe date when the Dasher swiped the red card in the merchant store (store local time) in MM/DD/YYYY format12/24/20251
actual_delivery_date_utcdateThe date when the order was delivered (UTC) in MM/DD/YYYY format12/25/20251
transaction_time_utcISO8601 standard timestampThe date and time when the Dasher swiped the red card in the merchant store (UTC) in YYYY-MM-DD HH24:MI:SS format2025-12-25 1:12:131
transaction_time_localISO8601 timestamp with explicit timezone offsetThe date and time when the Dasher swiped the red card in the merchant store (store local time) in YYYY-MM-DD HH24:MI:SS format2024-12-24 20:12:231
actual_delivery_time_utcISO8601 standard timestampThe date and time when the order was delivered (UTC) in YYYY-MM-DD HH24:MI:SS format2025-12-25 1:30:131
actual_delivery_time_localISO8601 standard timestampThe date and time when the order was delivered (store local time) in YYYY-MM-DD HH24:MI:SS format2024-12-24 20:30:231
order_received_time_localISO8601 timestamp with explicit timezone offsetThe date and time when the order was received at the merchant's store (store local time) in YYYY-MM-DD HH24:MI:SS format2024-12-24 19:50:551
store_confirmed_time_localISO8601 timestamp with explicit timezone offsetThe date and time when the store confirmed the order (store local time) in YYYY-MM-DD HH24:MI:SS format2024-12-24 19:45:551
order_scheduled_time_localISO8601 timestamp with explicit timezone offsetThe order's scheduled delivery time based on DoorDash's quoted delivery time (store local time) in YYYY-MM-DD HH24:MI:SS format2024-12-24 19:45:551
dasher_arrived_at_store_time_localISO8601 timestamp with explicit timezone offsetThe date and time when the Dasher arrived at the store (store local time) in YYYY-MM-DD HH24:MI:SS format2024-12-24 19:48:551
pickup_time_localISO8601 timestamp with explicit timezone offsetThe date and time when the Dasher marked the order as picked up (store local time) in YYYY-MM-DD HH24:MI:SS format2024-12-24 19:46:001
timezonestringLocal timezone of the storeUS/Pacific | US/Eastern | US/Central1
business_idintegerDoorDash business ID for the merchant110034561
business_namestringDoorDash business name for the merchantMarkets USA1
merchant_store_idstringMerchant-supplied store ID3011
doordash_store_idintegerDoorDash store ID for the merchant332456351
store_namestringDoorDash store name for the merchantThe Market (South Ave)1
store_street_addressstringStore's street address, without city/state/zip123 South Avenue1
delivery_zip_codestringThe zip code of the customer's delivery address100111
delivery_uuidUUIDUnique identifier of this DoorDash deliveryUUID-String1
external_order_uuidUUIDMerchant's external order identifier (if integrated with POS); this field is null for Dasher Pick/Red Card merchantsUUID-String1
order_cart_idintegerCart ID from checkout sent to Fiserv; required for reconciliation300001000000001
receipt_barcodestringBarcode value on the order receipt (Dasher Pick merchants only)44221202220300400919908001
hashed_consumer_idstringHashed DoorDash consumer IDsdfasfa1341-asfax1
is_dashpassbooleanIndicates if the order included DashPass subscription benefitsTRUE / FALSE1
is_consumer_pickupbooleanIndicates if the order was a customer pickupTRUE / FALSE1
is_drive_deliverybooleanIndicates if the order was a Drive deliveryTRUE / FALSE1
is_doubledashbooleanIndicates if the order was a DoubleDash deliveryTRUE / FALSE1
is_scheduled_orderbooleanIndicates if the order was scheduled in advanceTRUE / FALSE1
is_contains_alcoholbooleanIndicates if the order contained alcohol itemsTRUE / FALSE1
is_cancelledbooleanIndicates if the order was cancelledTRUE / FALSE1
cancelled_at_time_localISO8601 timestamp with explicit timezone offsetLocal time when the order was cancelled in YYYY-MM-DD HH24:MI:SS format2024-12-24 19:46:001
cancellation_categorystringCategory of cancellation reason from Dasher or customerorder_taking_too_long1
final_order_statusstringThe final status of the orderDelivered / Cancelled1
is_order_invoiceablebooleanIndicates if this order can be invoiced in the monthly invoiceTRUE / FALSE1
submit_platformstringPlatform the customer used to place the orderiOS / Android / desktop / mobile web1
shopping_protocolstringShopping protocol used - Merchant Pick vs Dasher Pick; Merchant Pick: Where the Merchant is preparing the items and then the cost of the goods are covered by Direct Deposit (standard for restaurants); Dasher Pick: When the Dasher is in charge of selecting the items checking out, and delivering them to the customerDASHER_PICK / MERCHANT_PICK1
payment_protocolstringPayment method setup on the store (used for tax model classification)dasher_red_card / direct_deposit1
currency_codestringStore’s local currency code as per ISO 4217 standard. Every amount field below are in local currency and in DOLLARS with 2 decimal precisionUSD / CAD / AUS1
bag_fee_amount0.00FBag fee charged on the order0.751
bag_fee_tax_amount0.00FTax applied on the bag fee0.121
bottle_deposit_fee_amount0.00FBottle deposit fee charged on the order0.511
bottle_deposit_fee_tax_amount0.00FTax applied on bottle deposit fee0.091
cup_fee_amount0.00FCup fee charged on the order0.351
cup_fee_tax_amount0.00FTax applied on cup fee0.051
eco_fee_amount0.00FEco fee for the order – null until Q4 20250.111
eco_fee_tax_amount0.00FEco fee tax for the order – null until Q4 20250.011
state_province_tax_amount0.00FProvincial sales tax (only for Canada stores!)4.031
card_pos_total_amount0.00FTotal swiped amount in-store including tax (NOT DoorDash platform total)151.121
order_snap_ebt_amount0.00FTotal amount paid using SNAP EBT51.121
order_return_snap_ebt_amount0.00FSNAP EBT refund amount if the order was returned12.521
card_merchant_namestringMerchant name passed via red card payment processor (from POS to Red Card)MARKET #12341
card_fulfillment_store_idintegerStore ID as passed via Red Card transaction (from merchant's POS)12341
card_approval_codestring5–6 digit code printed on POS receipt for payment authorizationA937951
card_network_reference_idstringUnique transaction ID from red card payment processorMPWSKT30B06211
card_allowance_uuidUUIDUUID of allowance from payment database tied to the red card transactionstring-UUID1
card_first_sixintegerFirst six digits of digital BIN of the red card (typically 539186 for marqeta red card and 447478 for stripe red card)4474781
card_last_fourintegerLast four digits of the red card used57201
card_transaction_statusstringIndicates if the red card transaction was successfully settledsettled / reversed transaction / declined1

Order Item​

Report Type - NV_ORDER_ITEMS_V3

Description​

This report outputs item level details of orders within the requested report timeframe based on store's local time, including item fullfillment status, item financial data, and Dasher operation data.

Note: Legacy report version available here.

Example Report​

Column NameData TypeDefinitionExampleSince Report Version
transaction_date_utcdateThe date when the Dasher swiped the red card in the merchant store (UTC) in MM/DD/YYYY format12/24/20251
transaction_date_localdateThe date when the Dasher swiped the red card in the merchant store (store local time) in MM/DD/YYYY format12/24/20251
actual_delivery_date_utcdateThe date when the order was delivered (UTC) in MM/DD/YYYY format12/25/20251
transaction_time_utcISO8601 standard timestampThe date and time when the Dasher swiped the red card in the merchant store (UTC) in YYYY-MM-DD HH24:MI:SS format2025-12-25 1:12:131
transaction_time_localISO8601 standard timestampThe date and time when the Dasher swiped the red card in the merchant store (store local time) in YYYY-MM-DD HH24:MI:SS format2025-12-25 1:12:131
actual_delivery_time_utcISO8601 standard timestampThe timestamp when the order was delivered (UTC), format: YYYY-MM-DD HH24:MI:SS2025-12-25 1:30:131
timezonestringLocal timezone of the storeUS/Pacific | US/Eastern | US/Central1
business_idintegerDoorDash business ID for the merchant32026-06-08 0:00:001
business_namestringDoorDash business name for the merchantMarkets USA1
merchant_store_idintegerMerchant-supplied store ID1900-10-27 0:00:001
doordash_store_idintegerDoorDash store ID for the merchant92923-06-15 0:00:001
store_namestringDoorDash store name for the merchantThe Market (South Ave)1
shopping_protocolstringShopping protocol used - Merchant Pick vs Dasher Pick; Merchant Pick: Where the Merchant is preparing the items and then the cost of the goods are covered by Direct Deposit (standard for restaurants); Dasher Pick: When the Dasher is in charge of selecting the items checking out, and delivering them to the customerDASHER_PICK / MERCHANT_PICK1
dasher_idintegerUnique identifier for the Dasher who fulfilled the order13074791
delivery_uuidUUIDUnique identifier for the DoorDash deliveryUUID-string1
is_doubledashbooleanTrue if this item was part of a DoubleDash deliveryTRUE / FALSE1
is_missing_incorrectbooleanTrue if this item was marked missing or incorrect by customer or supportTRUE / FALSE1
is_cancelledbooleanTrue if the whole delivery was cancelledTRUE / FALSE1
cancelled_at_time_localISO8601 timestamp with explicit timezone offsetLocal time when the delivery was cancelled2024-12-24 19:46:001
cancellation_categorystringCategory of cancellation as reported by customer or Dasherorder_taking_too_long1
is_item_deliveredbooleanTrue if the item was successfully deliveredTRUE / FALSE1
was_delivery_returnedbooleanTrue if the delivery was returned (on the same day)TRUE / FALSE1
was_item_returnedbooleanTrue if the item was returned (on the same day)TRUE / FALSE1
shop_start_time_localISO8601 timestamp with explicit timezone offsetLocal time when Dasher marked start shopping, format: YYYY-MM-DD HH24:MI:SS2025-12-25 13:20:551
item_pick_start_time_localISO8601 timestamp with explicit timezone offsetLocal time when Dasher began picking this item, format: YYYY-MM-DD HH24:MI:SS2025-12-25 14:20:551
item_pick_end_time_localISO8601 timestamp with explicit timezone offsetLocal time when Dasher finished picking this item, format: YYYY-MM-DD HH24:MI:SS2025-12-25 14:22:551
item_pick_duration_secondsintegerDuration in seconds for picking this item1201
not_found_at_localISO8601 timestamp with explicit timezone offsetLocal time when Dasher marked the item as not found, format: YYYY-MM-DD HH24:MI:SS2025-12-25 14:01:551
picked_at_localISO8601 timestamp with explicit timezone offsetLocal time when Dasher marked the item as picked up, format: YYYY-MM-DD HH24:MI:SS2025-12-25 14:01:551
shop_end_time_localISO8601 timestamp with explicit timezone offsetLocal time when Dasher marked finish shopping, format: YYYY-MM-DD HH24:MI:SS2025-12-25 15:20:551
item_namestringName of the itemAdvil Ibuprofen Coated Tablets 200 mg (24 ct)1
item_idintegerUnique DoorDash-assigned item ID67788336951
item_merchant_supplied_idstringMerchant-supplied item identifier302898-0-11
item_uuidUUIDUUID of the item in this orderUUID-string1
catalog_upc_idstringUniversal Product Code ID of the item from DoorDash catalog["028029196443","028029196443","028029816563"]1
scanned_upc_idstringUPC of the item as scanned by the Dasher - this field could be null because Dasher can bypass the scan280291964431
brandstringBrand of the itemAdvil1
categorystringDoorDash’s primary product categoryMedicine1
aisle_name_l1stringPrimary in-store classificationSnacks1
aisle_name_l2stringSecondary in-store sub-classificationChips1
is_alcoholbooleanTrue if the item is an alcoholic productTRUE / FALSE1
is_snap_eligiblebooleanTrue if the item qualifies for SNAP EBTTRUE / FALSE1
is_weighted_itembooleanTrue if the item is sold by weightTRUE / FALSE1
measurement_unitstringUnit of measurement from the catalog (e.g., lb, oz, kg, each) - default to eacheach / lb / kg / oz1
quantity_requested0.00FNumber of units requested by the customer2.51
quantity_delivered0.00FNumber of units successfully delivered to the customer21
weighted_quantity_delivered0.00FDelivered quantity in weight (if applicable)1.231
currency_codestringCurrency in ISO 4217 format (e.g., USD, CAD). Every amount field below are in local currency and in DOLLARS with 2 decimalsUSD / CAD / AUS1
inventory_item_price_amount0.00FItem unit price from merchant's inventory/catalog1.211
platform_item_price_amount0.00FItem unit price on DoorDash platform1.311
total_item_inventory_amount0.00FTotal item price: inventory_item_price_amount * quantity_delivered2.421
total_item_platform_amount0.00FTotal item price from DoorDash with quantity included2.621
item_tax_rate0.00FTax rate applied to this item51
item_tax_amount0.00FActual tax charged on this item (based on total_item_platform_amount)0.131
unadjusted_item_tax_rate0.00FHypothetical tax rate if no EBT was applied6.51
unadjusted_item_tax_amount0.00FHypothetical tax amount without EBT0.151
item_credit_card_amount0.00FAmount paid via credit card on the item2.011
item_snap_ebt_amount0.00FAmount paid via SNAP EBT on the item0.511
item_snap_return_amount0.00FSNAP EBT refund amount if the item was returned0.251
was_requestedbooleanTrue if this item was part of the original order (not a sub)TRUE / FALSE1
was_foundbooleanTrue if Dasher found the item in storeTRUE / FALSE1
was_missingbooleanTrue if the item was missing from the storeTRUE / FALSE1
was_subbedbooleanTrue if the item was substitutedTRUE / FALSE1
was_refundedbooleanTrue if the item was refundedTRUE / FALSE1
is_substitute_itembooleanTrue if this record is the substituted itemTRUE / FALSE1
requested_item_idintegerDoorDash-assigned ID of the original requested item (this value only exists if this item is a substitute)72363976261
requested_item_namestringName of the original requested itemAdvil Ibuprofen Coated Tablets 100 mg (24 ct)1
requested_item_merchant_supplied_idstringMerchant's ID for the originally requested item302898-0-11
substituted_item_merchant_supplied_idstringMerchant's ID for the substituted item192007803391
substitution_preferencestringCustomer's selected substitution preferencerefund / no_preference_selected / chooose_sub / contact_me1
substitution_ratingstringRating provided by customer for the substitution - 0 being a bad substitution and 1 being a good substitution0 / 11
substitution_rating_time_utcISO8601 standard timestampTime when customer gave substitution feedback (UTC), format: YYYY-MM-DD HH24:MI:SS2025-12-25 13:20:551
substitution_rating_tagstringTags selected by customer when rating a substitution[ "SUBS_RATING_TAG_OTHER" ]1
consumer_commentstringFree-text feedback provided by the customer on this item"standard substitution comment"1

Operations and Consumer Feedback​

Report Type - NV_OPERATIONS_CONSUMER_FEEDBACK

Description​

This report outputs operational metrics such as shop time, missing & incorrect, SNAP data, etc. as well as all customer feedback that has been received (item level reviews, store level reviews, etc.)

Example Report​

Column NameData TypeDefinitionExample
active_datedateDelivery Completed Time (in Local Timezone)02/28/2021
created_attimestampDelivery created time (in UTC)10/19/2024 23:35:36
delivery_uuidstringDoorDash Delivery Identifier in UUID formatUUID-string
store_idintegerDoorDash Store ID345
store_namestringDoorDash Store name301
business_idintegerDoorDash Business IDUUID-string
external_order_referencestringOptional - if provided, this will be Order Identifier managed by Merchant.The Market
pos_delivery_idintegerOptional - if POS integration is done, this will be Order Identifier managed at Pont of Sale system.5486816
d2r_minutesintegerDMeasures minutes from when dasher accepts the order to when they reaches to the Merchant's geo fence area1
r2c_minutesintegerMeasures minutes from when dasher marks the order as picked up to when they mark the order as delivered1
shop_timeintegerMeasures minutes that Dasher takes to pick & shop items at the store.1
is_asapintegerCx placed an order with delivery requested as soon as possible vs scheduling the order for future timestamp.1|0
lateness_minsintegerMeasures minutes of order being delivered late to customer from promised time. It could be negative if order was delivered before promised time.11
is_store_eligible_for_snapebtbooleanTRUE if store is eligible to receive SNAP/EBT Orders.TRUE
snap_ebt_amountintegerSnap EBT amount for the order, in cents.20.29
cx_platformstringCustomer Operating System, ie. iOS, Android, Web.ios
cancellation_categorystringOptional - If order is cancelled, the cancellation category is provided by Dasher or Customer.1|0
fulfillment_item_countintegerTotal number of items that were fulfilled for the order1
is_all_filledbooleanFlag indicating all the items requested are fullfilledTRUE
is_missing_incorrectbooleanDelivery contains any missing or incorrect itemsTRUE
not_found_before_subs_item_counintegerNumber of original requested items missing before the substitution.2
is_poor_food_qualitybooleanFlag indicating items are with poor food quality as suggested by Customer.TRUE
merchant_ratingintegerRating provided by the customer about the merchant5
merchant_commentsstringComments provided by the customer about the merchantcomments