Marketplace Dasher Pick Reports

Payout Summary

Report Type - NV_PAYMENTS

Description

This report outputs a order-level details for all payouts that have been completed within the requested report time frame

Example Report

Column Name	Data Type	Definition	Example
transaction_date_utc	string	Date in UTC timezone when charge has been sent in MM/DD/YYYY format	02/28/2021
transaction_date_local	string	Date in Mx store timezone when charge has been sent in MM/DD/YYYY format	02/29/2021
transaction_timestamp_utc	timestamp	Timepoint in UTC timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS	02/28/2021
transaction_timestamp_local	timestamp	Timepoint in Mx store timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS	02/28/2021
timezone	string	Mx Store timezone	US/Pacific
merchant_store_id	integer	The merchant's store identifier	301
store_name	string	Store name	The Market
business_name	string	Business name	Market USA
delivery_uuid	string	UUID of Doordash delivery	UUID-string
client_order_id	integer	client_id of order in POS database	5486816
external_id	string	(when relevant) Merchant (external) POS ID external_id of order in POS database	UUID-string
shopping_protocol	string	Shopping protocol as per MDS store table	shopperdasher merchant
dashpass	integer	Is this order with dash pass or not	1|0
is_consumer_pickup	integer	Is this order pickup or not (is_consumer_pickup)	1|0
order_received_time_local	timestamp	Timepoint with timezone of actual order place in Mx store timezone in YYYY-MM-DD HH24:MI:SS	03/11/2021
order_status	string	Order Status	delivered
transaction_type	ENUM	Type of transaction	DELIVERY|ADJUSTMENT
currency	string	Cart currency as per ISO 4217	USD
order_subtotal_dollar	0.00F	Subtotal in cart	20.29
order_tax_amount_dollar	0.00F	Total tax paid by consumer	3.19
commission_rate	0.00F	Commission rate	0.05
order_commission_dollar	0.00F	DoorDash commission	2.23
commission_tax_dollar	0.00F	commission tax	0.01
order_marketing_fee_dollar	0.00F	Marketing commission	0
dashpass_marketing_fee_dollar	0.00F	DashPass flat fee	2
tax_remitted_by_dd_dollar	0.00F	States where DoorDash is the merchant of record, DoorDash remits tax directly to the government (does not pass it to the Mx)	0.19
order_merchant_tip_amount_dollar	0.00F	Merchant tip amount for pickup orders (merchant_tip_amount)	3.71
store_charge_dollar	0.00F	Amount charged to the merchant	-2.19
store_refund_dollar	0.00F	Amount refunded to the merchant	1.1
payout_amount_dollar	0.00F	Amount paid out during the transfer	25.19
transaction_notes	string	Description regarding error charges and adjustments	Issue: 1 Advil Ibuprofen Coated Tablets 100 mg (24 ct) missing
payout_transfer_id	integer	Doordash Internal Id of bank transfer	128950624
payout_timestamp	timestamp	Timepoint with timezone when charge has been sent in ISO 8601 format with timezone	03/11/2021

Transaction Details

Report Type - NV_TRANSACTIONS

Description

This report outputs transaction details which can be used for financial reconciliation of RedCard transactions.

Example Report

Column Name	Data Type	Definition	Example	Since Report Version
transaction_date_utc	date	Date in UTC timezone when charge has been sent in MM/DD/YYYY format	02/28/2021	1
transaction_date_local	date	Date in Mx store timezone when charge has been sent in MM/DD/YYYY format	02/29/2021	1
transaction_timestamp_utc	timestamp	Timepoint in UTC timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS	2021-02-28 17:41:12	1
transaction_timestamp_local	timestamp	Timepoint in store timezone when charge has been sent in YYYY-MM-DD HH24:MI:SS	2021-02-28 12:41:12	1
timezone	string	The timezone of the store	US/Pacific	1
amount_captured	0.00F	Amount of in-store transactions in currency. This value does not include any markup.	5.19	1
currency	string	Currency as per ISO 4217	USD	1
merchant_store_id	string	The merchant's store identifier	301	1
store_name	string	Store name	The Market	1
business_id		The ID of the business associated with the transaction.	11003456	1
business_name	string	Business name	Markets USA	1
delivery_uuid	string	UUID of Doordash delivery	UUID-string	1
external_id	string	Merchant's external order identifier. This is only relevant if orders are integrated to Merchant's POS system. If a Mx is on Dasher Shop and Deliver, it will be null. This field may be null when the report is generated.	UUID-string	1
shopping_protocol	string	Shopping protocol protocol configured in DoorDash store setup. Identifies if the merchant is fulfilling orders or Dashers are picking.	shopper|dasher merchant	1
is_consumer_pickup	boolean	Is this order pickup or not (is_consumer_pickup)	TRUE|FALSE	1
approval_code	string	5 or 6 digit numbers unique ID assigned to a given authorization. It is printed on the receipt at the point of sale.	93795	1
allowance_id	string	ID of allowance in allowance table of payment database. This value comes from Marqeta Payment Processor.	UUID-string	1
network_reference_id	string	Network-assigned unique identifier of the transaction. This value comes from Marqeta Payment Processor.		1
acting_card_first_six	integer	DoorDash’s BIN, always the same (539186) but not exclusive to this number	539186	1
acting_card_last_four	integer	Last four digits of red card PAN from marqeta settlements	9887	1
marqeta_merchant_name	string	Merchant Name passed through payment network (from the merchant to their (acquiring) payment processor to DoorDash’s payment processor (marqeta)	MARKET #1234	1
marqeta_store_id	string	Mechant StoreID extracted from Marqeta data	1234	1
is_settled	boolean	Whether marqeta transaction is settled or not	TRUE	1
order_marketing_fee_dollar				1
crc_barcode		CRC barcode		1
dashpass	boolean	Whether or not a subscription discount was applied to the transaction.	TRUE	1
store_refund_dollar	0.00F	refund amount in dollar	5.12	1
store_charge_dollar	0.00F	charge amount in dollar	6.12	1
client_order_id	string		UUID-string	1
store_street_address	string	store street address	123 South Avenue	1
is_scheduled_order	boolean	is order schedule for delivery	TRUE|FALSE	1
order_received_time_local	timestamp	Timepoint with timezone of actual order place in Merchant's store timezone in YYYY-MM-DD HH24:MI:SS	2021-02-28 17:41:12	1
order_scheduled_time_local	timestamp	timestamp when order was scheduled	2021-01-22 17:44:47	1
store_confirmed_time_local	timestamp	timestamp when store confirmed the order	2021-01-22 17:44:47	1
dasher_arrived_at_store_time_local	timestamp	timestamp when dasher arrived at the store to pick up the order	2021-04-20 17:08:05	1
pickup_time_local	timestamp	time at dasher started picking up the order	2021-04-20 17:08:05	1
payment_protocol	timestamp	protocol for payments like red card etc		1
bag_fee	0.00F	bag fee total in the order	0.12	1
bag_fee_tax_amount	0.00F	bag feel total tax for the order	0.01	1
is_doubledash	boolean	if uuid is doubledash then true else false	TRUE	1
bottle_deposit_fee	integer	bottle deposit fee	12	1
receipt_barcode	string	barcode of receipt	xdda	1
submit_platform	string	Platform customer used (iOS, desktop, Android, mobile web)	android	1
hashed_consumer_id	string	hashed consumer ID	sdfasfa1341-asfax	2
total_snap_ebt_amount	0.00F	Amount paid for the item using SNAP EBT card	0	3
total_return_snap_ebt_amount	0.00F	Snap abt amount refunded when an order is returned	0	3
order_cart_id	integer	Cart ID from checkout. This is sent to Fiserv, and is needed by Mx to reconcile	12345678899383738	3
cup_fee_amount	0.00F	Cup fee amount	0	3
cup_fee_tax_amount	0.00F	Cup fee tax amount	0	3
bottle_deposit_fee_tax_amount	0.00F	bottle deposit fee tax amount	0	3
state_province_tax_amount	0.00F	State province tax amount	0	3
cancellation_category	string	Category of cancellation reason from Dasher or customer	order_taking_too_long	4
active_date_local	date	The date when the delivery was completed (in store's local time) in MM/DD/YYYY format	12/24/2025	4
actual_delivery_time_local	date	The date and time when the order was delivered (store local time) in YYYY-MM-DD HH24:MI:SS format	2024-12-24 19:50:55	4

Order Item

Report Type - NV_ORDER_ITEMS

Description

This report outputs item level details of orders, including picked, not found, and substituted items.

Example Report

Column Name	Data Type	Definition	Example	Since Report Version
delivery_uuid	string	The universally unique identifier for a delivery.	8be22d51-b630-4053-872f-9455fd8beba7	1
delivery_created_at	timestamp	The date and time when the delivery was created.	01/23/2023	1
store_id	integer	The unique identifier for a store.	984803	1
store_name	string	Store name	The Market	1
merchant_store_id	string	The Merchant's store identifier	10/27/1900	1
business_id	integer	The unique identifier for a business.	412816	1
business_name	string	Business name	Markets USA	1
shopping_protocol	string	The protocol used for shopping (e.g. curbside pickup, delivery, etc.).	DASHER_PICK|MERCHANT_PICK	1
dasher_id	integer	The unique identifier for a Dasher (i.e. the person delivering the order).	1307479	1
item_id	integer	The unique identifier for an item.	6778833695	1
item_merchant_supplied_id	string	Id of the item supplied by merchant	302898-0-1	1
item_name	string	The name of the item.	Advil Ibuprofen Coated Tablets 200 mg (24 ct)	1
substitution_preference	string	The substitution preference for the item (e.g. allow substitutions, prefer exact item, do not substitute, etc.).	substitute	1
was_requested	integer	A boolean value indicating whether the item was requested (i.e. included in the original order).	1|0	1
was_found	integer	A boolean value indicating whether the item was found in the store.	1|1	1
was_missing	integer	A boolean value indicating whether the item was missing from the store.	1|2	1
was_subbed	integer	A boolean value indicating whether the item was substituted with another item.	1|3	1
was_refunded	integer	A boolean value indicating whether the item was refunded.	1|4	1
sub	integer	Flag indicating if item is substitute	1|5	1
requested_item_id	integer	The unique identifier for the requested item.	7236397626	1
requested_item_merchant_supplied_id	string	Originally requested merchants supplied item id in case of substitution	19200780339	1
requested_item_name	string	Originally requested item name in case of substitution	Advil Ibuprofen Coated Tablets 100 mg (24 ct)	1
picked_at	timestamp	Time when the time was picked by Cx	01/23/2023	1
not_found_at	timestamp	Time when the time was marked as not found by Cx	01/23/2023	1
shop_start_time	timestamp	Time when Dx started shopping for the delivery	01/23/2023	1
shop_end_time	timestamp	Time when Dx completed shopping for the delivery	01/23/2023	1
is_alcohol	boolean	Indicates whether the item is an alcohol product.	TRUE	1
quantity	integer	total quantity of items being delivered	12	1
weighted_quantity	0.00F	the total weight of the items being delivered, with each item being weighed individually	12/31/1899	1
quantity_requested	integer	the quantity of items requested by the customer	11	1
upc_id	string	Unique ID	07/08/3415	1
measurement_unit	string	Weighed quantity of the item	each	1
is_weighted_item	integer	Whether the item is weighed	TRUE	1
item_price	integer	Unit price of the item in USD currency	549	1
item_price_dollar	0.00F	Unit price of the item in US dollar	01/03/1900	1
total_item_price_dollar	0.00F	Total price of the item in US dollar	01/03/1900	1
item_tax_amount_dollar	0.00F	Total tax paid for the item in USD dollar	12/31/1899	1
is_delivered	boolean	Indicates whether the item was delivered or was removed from the cart due to Dasher inability to find the item or the item being out of stock.	TRUE	1
delivery_zip_code	string	zip code for delivery address	02/09/2022	1
substituted_for_item_merchant_supplied_id	string	item_merchant_supplied_id substituted	12/16/48887	1
delivery_created_date_utc	date	Date when delivery is created (UTC)	01/23/2023	1
delivery_created_timestamp_utc	timestamp	timestamp when delivery is created (UTC)	01/23/2023	1
store_transaction_date_utc	date	date when transaction is done at store (UTC)	01/23/2023	1
store_transaction_timestamp_utc	timestamp	timestamp when transaction is done at store (UTC)	01/23/2023	1
item_price_no_markup_dollar	0.00F	item price without markup	01/03/1900	1
aisle_name_l1	string	Aisle category 1	Snacks	1
aisle_name_l2	string	Aisle category 2	Chips	1
brand	string	brand of item	Advil	1
total_item_price	integer	Total price of the item in USD currency	2780	1
tax_rate	integer	Tax rate of the item	7	1
tax_amount	integer	Total tax paid for the item in USD currency	202	1
category	string	Category of the item	Medicine	1
delivery_fraud_rule_ind	integer	Flag indicating when grand rule was fired for delivery	0	1
delivery_cr_category	string	Category of the item in case of when fraud rule is fired	no_cr_issued	1
sub_rating	integer	Substitution rating provided by the customer - 0 being a bad substitution and 1 being a good substitution	1	1
sub_rating_timestamp	timestamp	Rating provided by Cx for substitution	03/25/2023	1
tags_selected	variant	Tags selected when the rating of the substitution is provided	[ "SUBS_RATING_TAG_OTHER" ]	1
comment	variant	Additional comment when the rating of the substitution is provided	standard substitution comment	1
item_uuid	string	UUID of the item	9526bda5-d722-4904-b5b3-af072d771c40	1
item_pick_start_time	timestamp	Item pick start time	01/04/2022	1
item_pick_end_time	timestamp	Item pick end time	01/04/2022	1
item_pick_duration_seconds	integer	Time in seconds taken by Dx for picking the item	356	1
cancelled_at	timestamp	Canceled date time of the canceled delivery (UTC)	09/05/2021	1
is_missing_incorrect	boolean	Flag indicating whether delivery is marked M&I by either Cx or support	FALSE	1
is_from_store_to_us	boolean	Flag indicating whether the delivery is drive	FALSE	1
is_cancelled	boolean	Flag indicating whether the delivery is canceled	FALSE	1
is_snap_eligible	boolean	Flag indicating whether the item is eligible to pay with SNAP EBT Card	FALSE	1
snap_ebt_amount	integer	Amount paid for the item using SNAP EBT card	0	1
credit_card_amount	integer	Amount paid for the item using credit card	499	1
etl_load_at	timestamp	ETL insert time	04/17/2023	1
item_price_local	integer	Unit price of the item in local currency dollar	499	1
total_item_price_local	integer	Total price of the item in local currency dollar	499	1
is_doubledash	boolean	if uuid is doubledash then true else false	TRUE	1
item_price_no_markup_total_dollar	0.00F	price of item markup total in dollar	4.99	1
item_was_returned	boolean	Whether item was returned or not	TRUE	2
return_delivery_uuid	string	UUID of Doordash return delivery	8be22d51-b630-4053-872f-9455fd8beba7	2
return_timestamp_utc	timestamp	When was delivery return in utc timestamp	2021-04-20 17:08:05	2
return_timestamp_local	timestamp	When was delivery return in local timestamp	2021-04-20 17:08:05	2
delivery_was_returned	boolean	Whether all the items in the delivery were returned	FALSE	2
snap_return_amount	0.00F	Snap abt amount refunded when an item is returned	0	3
unadj_item_tax_rate	0.00F	This is the aggregate sales tax rate used to calculate that would have been used on this item. This value will not be affected by EBT SNAP amount applied. Actual sales tax paid by dollar amount will be populated in Sales Tax.	1.6	3
unadj_item_tax_amount_dollar	0.00F	What the tax amount would have been if the item was paid for with non-EBT; Online Revenue multiplied by Original Sales Tax rate (includes mark-up).	0.09	3
order_cart_id	integer	Cart ID from checkout. This is sent to Fiserv, and is needed by Mx to reconcile	12345678899383738	3
item_price_local_dollar	0.00F	Unit price of the item local in dollar	10.01	4
total_item_price_local_dollar	0.00F	Total price of the item local in dollar	20.02	4
tax_amount_local	0.00F	Total tax paid for the item local currency	5.01	4
item_tax_amount_local_dollar	0.00F	Total tax paid for the item local currency in dollar	10.02	4

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 Name	Data Type	Definition	Example
active_date	date	Delivery Completed Time (in Local Timezone)	02/28/2021
created_at	timestamp	Delivery created time (in UTC)	10/19/2024 23:35:36
delivery_uuid	string	DoorDash Delivery Identifier in UUID format	UUID-string
store_id	integer	DoorDash Store ID	345
store_name	string	DoorDash Store name	301
business_id	integer	DoorDash Business ID	UUID-string
external_order_reference	string	Optional - if provided, this will be Order Identifier managed by Merchant.	The Market
pos_delivery_id	integer	Optional - if POS integration is done, this will be Order Identifier managed at Pont of Sale system.	5486816
d2r_minutes	integer	DMeasures minutes from when dasher accepts the order to when they reaches to the Merchant's geo fence area	1
r2c_minutes	integer	Measures minutes from when dasher marks the order as picked up to when they mark the order as delivered	1
shop_time	integer	Measures minutes that Dasher takes to pick & shop items at the store.	1
is_asap	integer	Cx placed an order with delivery requested as soon as possible vs scheduling the order for future timestamp.	1|0
lateness_mins	integer	Measures 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_snapebt	boolean	TRUE if store is eligible to receive SNAP/EBT Orders.	TRUE
snap_ebt_amount	integer	Snap EBT amount for the order, in cents.	20.29
cx_platform	string	Customer Operating System, ie. iOS, Android, Web.	ios
cancellation_category	string	Optional - If order is cancelled, the cancellation category is provided by Dasher or Customer.	1|0
fulfillment_item_count	integer	Total number of items that were fulfilled for the order	1
is_all_filled	boolean	Flag indicating all the items requested are fullfilled	TRUE
is_missing_incorrect	boolean	Delivery contains any missing or incorrect items	TRUE
not_found_before_subs_item_coun	integer	Number of original requested items missing before the substitution.	2
is_poor_food_quality	boolean	Flag indicating items are with poor food quality as suggested by Customer.	TRUE
merchant_rating	integer	Rating provided by the customer about the merchant	5
merchant_comments	string	Comments provided by the customer about the merchant	comments