Aller au contenu principal

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