Reporting API: Online Ordering Reports

Request DoorDash Online Ordering (Direct Ordering) reports through the Reporting API

Overview

DoorDash has recently added a set of reports for digital ordering (previously called Storefront) through the Reporting API. They cover store operations (avoidable wait, cancelled orders, menu item errors, menu hours, store downtime and temporary deactivations) as well as order, transaction and some customer data. This document describes the schema of each report, including column names, data types, definitions and examples.

Before You Begin

To have the new reports added to your integration, do one of the following:

• Submit a support ticket in the DoorDash Developer Portal.
• Reach out to your DoorDash Account Manager, who can work with our team to get the new set of reports added.

Include the report types you want to receive (for example, OO_AVOIDABLE_WAIT) in your request.

Encrypted reports (PII)

The Order Detail (OO_ORDER_DETAIL), Transaction Detail (OO_TRANSACTION_DETAIL), and Customers (OO_CUSTOMER) reports include personally identifiable information (PII), so they are delivered encrypted. Requesting any of these reports requires an additional layer of security: a PGP key pair.

Generate your PGP key pair before you submit your request, and share your public key with DoorDash when you request the reports. Never share your private key. For setup instructions, see the PGP Encryption for Reporting API guide.

Request a Report

Online Ordering reports use the same Reporting API flow as every other report: create the report, then retrieve the download link. Set report_type to one of the values below. See Get a report for the full steps.

Report	Report type
Avoidable Wait	OO_AVOIDABLE_WAIT
Cancelled Orders	OO_CANCELLED_ORDERS
Menu Item Error	OO_MENU_ITEM_ERROR
Menu Open Hours	OO_MENU_OPEN_HOURS
Menu Special Hours	OO_MENU_SPECIAL_HOURS
Store Downtime	OO_STORE_DOWNTIME
Temporary Deactivations	OO_TEMPORARY_DEACTIVATIONS
Order Detail	OO_ORDER_DETAIL
Transaction Detail	OO_TRANSACTION_DETAIL
Customers	OO_CUSTOMER

Avoidable Wait

Report type: OO_AVOIDABLE_WAIT

This report outputs a list of orders that have merchant avoidable wait

Column Name	Data Type	Definition	Example
business_id	number	DoorDash Business ID	185
store_id	number	DoorDash Store ID	24725
order_delivered_date	date	Date when order was delivered	2022-08-03 0:00:00
order_delivered_time	varchar	Timestamp of order delivery	11:54:48
dd_order_id	varchar	Doordash Order ID	fae261ba
client_order_id	varchar	Client Order ID	cef4d65b-09cc-427a-a4e4-efb3115c9e3e-doordash
merchant_supplied_id	varchar	The merchant's store identifier	123-0
store_name	varchar	Store name	Metro Pizza Main Street
was_asap	boolean	This flag is used to identify scheduled deliveries. e.g. was_flag = False, will give you future deliveries	TRUE
confirmed_food_ready_time	timestamp	Time the store confirmed the food was ready	2022-08-03 11:43:20
dasher_arrival_time	timestamp	Local time when dasher arrived at store	2022-08-03 11:42:56
order_pickup_time	timestamp	Time when dasher picked up the order	2022-08-03 11:49:27
minutes_late	number	Time difference between when food was ready and food pickup time	6
delivered_at	timestamp	Time when order was delivered	2022-08-03 11:54:48
total_delivery_time	number	Time difference between when order was placed and when order was delivered	24
order_subtotal	number	Order Subtotal	35
net_payout	number	Order payout	26
currency	varchar	The currency used for transactions in this store	USD
order_place_date	date	Order place date	2022-08-03
order_place_time	time	Order place time	11:43:20
organization_franchise_id	varchar	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
organization_franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise

Cancelled Orders

Report type: OO_CANCELLED_ORDERS

This report outputs a list of all canceled orders and the reason for cancellation

Column Name	Data Type	Definition	Example
business_id	number	DoorDash Business ID	185
store_id	number	DoorDash Store ID	24725
order_place_date	timestamp	Date when order was placed	2022-08-02 0:00:00
order_place_time	timestamp	Time when order was placed	21:49:56
store_name	varchar	Internal DoorDash Store Name	Metro Pizza Main Street
order_id	varchar	This value is unique to the order	ed74e64e
client_order_id	varchar	Client order ID from the POS (Merchant-facing ID from POS system) If not POS, then this will be empty	69f2ccf2-5a51-4d7f-bdb2-5ae865454c15-doordash
merchant_supplied_id	varchar	The merchant's store identifier	123-0
was_asap	boolean	This flag is used to identify scheduled deliveries. e.g. was_flag = False, will give you future deliveries	TRUE
cancelled_at	timestamp	Timestamp when order was canceled	2022-08-02 22:12:24
cancellation_category	varchar	Category of cancellation	Avoidable Store Operations
cancellation_category_desc	varchar	Detailed description of the category of cancellation	Store closed
is_paid	boolean	Flag to show whether order was paid or not	FALSE
mx_friendly_non_payment_reason	varchar	It shows the reason why order was canceled and have different values like: Wrong Order Handed to Dasher Order Not Prepared Mx Did Not Confirm etc.	NULL
order_confirmation_time	timestamp	Timestamp when the order was confirmed	2022-08-02 21:50:04
minutes_to_confirm	number	Minutes it took to confirm the order	1
minutes_to_cancel	number	Minutes it took to cancel the order	22.47
order_subtotal	number	Order Subtotal	40
net_payout	number	Order payout	0
currency	varchar	The current used for transactions in this store	USD
organization_franchise_id	varchar	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
organization_franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise

Menu Item Error

Report type: OO_MENU_ITEM_ERROR

This report outputs a list of orders that had either a missing or incorrect item along with the specific item that was flagged

Column Name	Data Type	Definition	Example
business_id	number	DoorDash Business ID	185
store_id	number	DoorDash Store ID	24725
timestamp_local_date	timestamp	Date of transaction in local time	2022-08-03 0:00:00
timestamp_local_time	timestamp	Time of transaction in local time	2022-08-03 14:26:17
timestamp_utc_date	timestamp	Date of transaction in UTC time	2022-08-03 0:00:00
timestamp_utc_time	timestamp	Time of transaction in UTC time	2022-08-03 18:26:17
dd_order_id	varchar	This value is unique to the order.	f3706751
merchant_order_id	varchar	Client order ID from POS (Merchant-facing ID from POS system) If not POS, then this will be empty	800ec4b8-1cee-46c5-b20d-ef4accfd16ce-doordash
merchant_supplied_id	varchar	The merchant's store identifier	123-0
store_name	varchar	Internal DoorDash Store Name	Metro Pizza Main Street
error_category	varchar	Missing Item or Incorrect Item category	ingredient_error
menu_category	varchar	The type of menu item that had an error (ie Main, Side)	BIGWAY® Series
item_name	varchar	Name of impacted menu item	#10 All-American Club®
quantity	number	Quantity of impacted menu items	1
error_charge	number	The total error charge	170
customer_comments	varchar	Customer entered comment on menu item error	NULL
modifier_detail	json	It contains the order item details like menu item extra option	{"item_extra_option":[{"name":"Artisan Flatbread (220 Cals)","quantity":"1"}]}
order_link	varchar	URL of the Order	https://www.doordash.com/merchant/deliveries/0179a57f-bedb-4689-8b6e-8caff3706751?store_id=256263
organization_franchise_id	varchar	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
organization_franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise

Menu Open Hours

Report type: OO_MENU_OPEN_HOURS

This report outputs the menu hours for all stores

Column Name	Data Type	Definition	Example
business_id	number	DoorDash Business ID	185
store_id	number	DoorDash Store ID	24725
menu_id	number	DoorDash Menu ID	12669534
menu_name	varchar	Menu Name	Metro Pizza - [ALL DAY][Metro Pizza 123-0][2.16.2025]
day_of_week	varchar	Day of the week like Monday, Tuesday and so on	Sun
day_index	number	It is the index of the week. Where 0 represents 'Mon', 1 'Tuesday' and so on.	6
start_time	timestamp	Start time when menu is available	9:00:00 AM
end_time	timestamp	End time when menu will not be available	8:00:00 PM
organization_franchise_id	varchar	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
organization_franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise

Menu Special Hours

Report type: OO_MENU_SPECIAL_HOURS

This report outputs all the upcoming special hours that have been set for all stores

Column Name	Data Type	Definition	Example
business_id	number	DoorDash Business ID	185
store_id	number	DoorDash Store ID	24725
menu_id	number	DoorDash Menu ID	12669534
menu_name	varchar	Menu Name	Metro Pizza - [ALL DAY][Metro Pizza 123-0][2.16.2025]
day	date	Date of the menu special hours	2025-12-25
start_time	timestamp	Start time when menu is available	9:00:00 AM
end_time	timestamp	End time when menu will not be available	8:00:00 PM
is_closed	boolean	is_closed should dictate what kind of special hours it represents, whether it's to make it available/unavailable	FALSE
organization_franchise_id	varchar	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
organization_franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise

Store Downtime

Report type: OO_STORE_DOWNTIME

Daily summary by category of the total number of minutes store was unavailable/temporarily deactivated during open hours

Column Name	Data Type	Definition	Example
date	date	Date	6/7/25
store_id	number	DoorDash Store ID	24725
store_name	varchar	DoorDash Store	Metro Pizza Main Street
merchant_supplied_id	varchar	The merchant's store identifier	123-0
downtime_category	varchar	Downtime category short code	Store Issue
downtime_category_description	varchar	Downtime category description	Auto Pause - High Avoidable and/or POS Cancellation Rate
downtime_minutes	number	Total number of minutes of the downtime for the day by category	45

Temporary Deactivations

Report type: OO_TEMPORARY_DEACTIVATIONS

This report outputs a list of stores that are currently temporarily deactivated

Column Name	Data Type	Definition	Example
business_id	number	DoorDash Business ID	185
store_id	number	DoorDash Store ID	24725
created_at_time	timestamp	Timestamp that the deactivation was created	8/11/2022 2:30:00
end_time	timestamp	Timestamp that the deactivation ended	8/11/2022 8:59:59
notes	varchar	Detailed notes on the deactivation reason and how to resolve the deactivation	Your store has been temporarily deactivated because multiple Dashers reported your store as closed. If your store is actually closed, please update your DoorDash store hours. If your store is not closed, you can reactivate the store via the Merchant Portal or your Tablet. If you would like to learn more about Dashers reporting your store as closed, please click here: https://help.doordash.com/merchants/s/article/Dasher-Reports-Store-Closed-DRSC?language=en_US##
reason	varchar	Reason of the deactivation	Multiple Dashers reported your store as closed
scheduled_end_time	timestamp	Timestamp of the scheduled endtime of the deactivation	8/11/2022 8:59:59
organization_franchise_id	varchar	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
organization_franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise

Order Detail

Report type: OO_ORDER_DETAIL

This report includes all orders along with the items and modifiers associated with the order as well as the order subtotal and whether a Dashpass was used on the order. If applicable a merchant order number (Merchant POS Order Id) is supplied as well

Column Name	Data Type	Definition	Example
business_id	number	DoorDash Business ID	185
store_id	number	DoorDash Store ID	24725
active_date	timestamp	Date of when order was submitted UTC	2022-08-03 0:00:00
active_date_utc	timestamp	Date of when order was submitted UTC	2022-08-03 0:00:00
dd_order_number	varchar	Doordash delivery UUID	1df0588a-711d-4fb6-8899-a49882e8822d
mx_order_number	varchar	Merchant's external order identifier. This is only relevant if orders are integrated to Merchant's POS system. This field may be null when the report is generated.	ab9ebc86-df9b-4c2b-a4f4-6570f52886a0-doordash
external_order_id	varchar	Merchant's external order identifier. This is only relevant if orders are integrated to Merchant's POS system. This field may be null when the report is generated.	ab9ebc86-df9b-4c2b-a4f4-6570f52886a0
business_name	varchar	Business name	Metro Pizza
store_name	varchar	Store name	Metro Pizza Main Street
merchant_store_id	varchar	The merchant’s store identifier	123-0
item_merchant_supplied_id	number	Item Id supplied by the Merchant	40246
order_item_id	number	ID for Item within Order	3000003058997073
dd_item_id	number	DD Item Id	2407118091
item_name	varchar	Item Name	Chocolate Chip (210 Cals)
category_name	varchar	Item Category	Sides
menu_name	varchar	Menu Name	Metro Pizza - [ALL DAY][Metro Pizza 123-0][2.01.2025]
timezone	varchar	Timezone of merchant	US/Central
is_consumer_pickup	boolean	Is pickup order	FALSE
dashpass	boolean	Are order/customer eligible for dashpass discount	TRUE
original_item_price	number	Original Item Price	1
unit_price	number	Item Price	1
order_item_quantity	number	Item quantity	2
subtotal	number	Cart subtotal	1
order_place_date	date	Order Place date	2026-08-03
order_place_time	varchar	Order Place time	0:00:00
order_cart_id	number	Order cart ID	30000097073
created_at	timestamp	Order Created at	2026-08-03 0:00:00
updated_at	timestamp	Order Updated at	2026-08-03 1:00:00
organization_franchise_id	varchar	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
organization_franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise
Ordering Surface	varchar	Indicates if the order was placed via web or mobile app	Web/App
Is Pay in Store	varchar	Indicates if the order was paid for in store	True/False
Is_dasher_delivered	varchar	Indicates if the order was self delivery or not	True/False
PAR Token	varchar	Par token field	1234

Transaction Detail

Report type: OO_TRANSACTION_DETAIL

This report outputs payout and transaction data on an order by order basis

Column Name	Data Type	Definition	Example
timestamp_utc_time	timestamp	Time of transaction in UTC time	8/2/2022 14:34:41
timestamp_utc_date	timestamp	Date of transaction in UTC time	2022-08-03 0:00:00
timestamp_local_time	timestamp	Time of transaction in Local time	8/2/2022 14:34:41
timestamp_local_date	timestamp	Date of transaction in Local time	2022-08-03 0:00:00
order_received_local_time	timestamp	Local time when the order was received by DoorDash	14:20:45
order_pickup_local_time	timestamp	Local time when the order was picked up by the customer or Dasher	14:38:12
payout_time	timestamp	Time in which the payout was paid to your bank account	09:00
payout_date	timestamp	Date in which the payout was paid to your bank account	2022-08-05
business_id	number	DoorDash Business ID	185
business_name	varchar	DoorDash Business Name	Metro Pizza
store_id	number	DoorDash Store ID	24715
store_name	varchar	Internal DoorDash Store Name	Metro Pizza Yonge St
franchise_id	number	A unique internal identifier assigned to the franchise organization that owns or operates the store. Note: If this field is inaccurate or blank and you have Fz Orgs created with DoorDash, please partner with your Account Manager to get this data backfilled.	20993520
franchise_name	varchar	DoorDash Franchise Name	Metro Pizza Franchise
merchant_store_id	varchar	The merchant's store identifier	123-0
transaction_type	varchar	The Transaction Type denotes if the transaction line item reflects a delivery, adjustment, error charge, payout or store payment. DELIVERY - delivery or transaction level details for orders that are fulfilled ADJUSTMENT - order cart adjustments that can be a +/- value; a common example is when a Customer places order but changes it afterwards (i.e. by removing/adding an item) For adjustments, you can review further details in the “Description” column, such as customer refunds for order cart adjustments and requested items being unavailable. ERROR_CHARGE - missing and incorrect adjustments For error charges, the “Description” column identifies the item and reasoning that was the cause of the error charge. Payout - regular payouts sent to the Merchant to pay for deliveries they fulfilled within a given time frame; equivalent of what is seen on the Payment Summary page Store Payment - one off payments or charges to the Merchant. Examples could be a reimbursement for a dispute and Tablet subscription fee List of possible entries ADJUSTMENT, DELIVERY, DEMANDGEN_DELIVERY, DRIVE_DASHER_REGULATORY_FEE, DRIVE_DELIVERY, DRIVE_PROMOTION, DRIVE_REFUND, ERROR_CHARGE, AD_FEE, STORE_PAYMENT_AD_FREE_TRIAL, STORE_PAYMENT_PROMOTION_FREE_TRIAL	DELIVERY
delivery_uuid	varchar	Unique identifier of this DoorDash delivery	ad935e96-2c22-3001-b8a0-06b70e
doordash_transaction_id	varchar	Unique DoorDash ID for each transaction	8347359552
doordash_order_id	varchar	Same Order ID as shown in the Orders tab and what you reference to our support team if you have any questions. If there are multiple transactions associated with an order (i.e., original order, subsequent error charge, later adjustment), they all share the same original Order ID. This value is unique to the order.	453dfa1e
merchant_delivery_id	varchar	Client order ID from POS (Merchant-facing ID from POS system) If not POS, then this will be empty	1dd60278-1f72-4133-a5f7-1e3b76
pos_order_id	varchar	The order ID on your POS.	800-2451
dd_pos_revenue_center	varchar	Revenue center for your in-store sales	Dine-In
description	varchar	Additional details for the transaction type (i.e. what the error charge is for - “1 chicken”)	Order Received Time: 2024-10-30 18:42:10
final_order_status	varchar	Indicates if orders were delivered, picked up, or canceled. For canceled orders, this will also share the cancellation reason. Cancellation reason - For any unpaid canceled orders, this indicates payout status along with a cancellation reason (e.g., “Item Out of Stock”) Possible Values: 1. Picked Up 2. Delivered 3. Canceled	Delivered
currency	varchar	The currency used for transactions in this store	USD
payout_id	number	DoorDash unique ID for each payout. Each payout can include the payout for deliveries, one-time store payments, etc lumped into one Payout_ID	48213590
payment_method	varchar	Method of payment used for transaction (e.g., credit_card)	CREDIT_CARD
abandoned_reason	varchar	Reason an order was abandoned or not completed prior to payment, if applicable.	Customer Cancelled Before Checkout
subtotal	number	Pre-tax amount of the delivery	35.00
subtotal_including_gst	number	Pre-tax amount of the delivery including GST	38.50
discount	number	In store order discount	5.00
surcharge	number	Additional flat surcharge applied to the order (e.g., a regulatory or local surcharge), separate from the itemized fees below.	1.00
subtotal_tax_passed_to_merchant	number	Total subtotal tax collected from the customer and passed through to the merchant. May be superseded by the federal/provincial breakdown further down this table for Canadian orders.	2.10
customer_delivery_fee	number	Delivery fee charged to the customer for this order.	3.99
customer_delivery_fee_tax	number	Total taxes on delivery fees based on your store’s location.	0.35
customer_small_order_fee	number	Fee you collect from customers for small orders, which DoorDash collects from customers and then passes on to you	2.00
customer_small_order_fee_tax	number	Taxes on small order fees	0.18
bag_fee	number	Fee you collect from customers for providing bags.	0.25
bag_fee_tax	number	Taxes on bag fees	0.02
cup_fee	number	Fee you collect from customers for specific beverages.	0.10
cup_fee_tax	number	Taxes on cup fee	0.01
bottle_deposit_fee	number	Fee you collect from customers for specific beverages.	0.10
bottle_deposit_fee_tax	number	Taxes on bottle fee	0.01
sf_health_mandate_fee	number	San Francisco Health Care Security Ordinance (HCSO) mandate fee passed to the customer for SF-based stores.	0.89
sf_health_mandate_fee_tax	number	Taxes on the SF health mandate fee.	0.08
restaurant_operations_fee	number	Flat operations fee applied to help cover store-level operating costs, where applicable.	1.50
restaurant_operations_fee_tax	number	Taxes on the restaurant operations fee.	0.13
staff_benefits_fee	number	Fee applied to help fund staff benefits programs, where applicable by market.	0.50
staff_benefits_fee_tax	number	Taxes on the staff benefits fee.	0.04
staff_tip	number	Tip given directly to in-store staff, separate from the Dasher/courier tip below.	2.00
courier_tip	number	Tip given to the Dasher who delivered the order.	4.00
commission	number	Amount in commission charged, collected by DoorDash.	8.75
commission_tax	number	Amount in taxes on the commission charged for the payout period	0.79
dashpass_marketing_fee	number	Marketing fee associated with DashPass promotions/placements, charged to the merchant.	1.20
dashpass_marketing_fee_tax	number	Taxes on the DashPass marketing fee.	0.11
payment_processing_fee	number	Fee charged to the merchant to cover payment processing costs.	0.30
payment_processing_fee_tax	number	Taxes on the payment processing fee.	0.03
delivery_fees	number	Total delivery fee associated with the order.	3.99
delivery_fees_tax	number	Taxes on the delivery fee.	0.35
pickup_order_fee	number	Fee applied specifically to pickup (non-delivery) orders.	0.75
pickup_order_fee_tax	number	Taxes on the pickup order fee.	0.07
alcohol_flat_fee	number	Flat fee on alcohol sales	1.00
alcohol_flat_fee_tax	number	Taxes on alcohol fee	0.09
flexible_fulfillment_fee	number	Flat fee for flexible fulfillment options	0.50
flexible_fulfillment_fee_tax	number	Taxes for fulfIllment flat fee	0.04
drive_charge	number	Fee for Drive On-Demand deliveries	6.50
drive_promotion	number	Promotional credit or discount applied to a DoorDash Drive delivery.	-2.00
drive_dasher_regulatory_fee	number	Regulatory fee associated with the Dasher on a Drive delivery, passed through in the payout.	0.35
cash_fee	number	Fee associated with orders paid by cash.	0.50
voice_order_fee	number	Fee associated with orders placed through DoorDash Voice ordering.	1.00
tablet_fee	number	Monthly fee for a DoorDash Tablet	9.99
tablet_fee_tax	number	Taxes on tablet fee	0.89
printer_fee	number	Monthly fee for a DoorDash printer	4.99
printer_fee_tax	number	Taxes on printer fee	0.44
commerce_platform_subscription_fee	number	Monthly subscription fee for DoorDash's commerce platform tools.	29.00
commerce_platform_subscription_fee_tax	number	Taxes on the commerce platform subscription fee.	2.57
sms_usage_fee	number	Fee for SMS messaging usage associated with order notifications.	0.05
other_merchant_fee	number	Catch-all fee category for merchant charges that don't fall under a more specific fee type above.	1.00
marketing_fees_including_any_applicable_taxes	number	The amount a merchant pays to run marketing on DoorDash. This field will be populated as 'NULL' for any transactions before 3/11/2025.	10.00
customer_discounts_from_marketing_funded_by_you	number	The amount covered by you to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.	5.00
customer_discounts_from_marketing_funded_by_doordash	number	The amount covered by DoorDash to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.	5.00
customer_discounts_from_marketing_funded_by_a_third_party	number	The amount covered by any third party to give customers a reduction in price for their food. This field will be populated as 'NULL' for any transactions before 3/11/2025.	0.00
doordash_marketing_credit	number	The total amount funded by DoorDash to offset your marketing costs. This field will be populated as 'NULL' for any transactions before 3/11/2025.	3.00
third_party_contribution	number	The total amount funded by a third party such as a franchise partner, franchise group, or brand to offset your marketing costs. This field will be populated as 'NULL' for any transactions before 3/11/2025.	0.00
marketing_fees_all_discounts_and_fees_for_historical_reference_only	number	Historical reference data for the amount a merchant pays to run marketing on DoorDash, not inclusive of taxes	12.00
marketing_fee_tax_on_applicable_marketing_fees_for_historical_reference_only	number	Historical reference data for taxes on applicable marketing fees, using legacy calculation methodology.	1.06
ad_fee_for_historical_reference_only	number	Historical reference data for the ad fee charged to the merchant, prior to the current reporting methodology.	4.00
ad_fee_tax_for_historical_reference_only	number	Historical reference data for taxes on the ad fee.	0.35
ad_fee_inclusive_of_gst_for_historical_reference_only	number	Historical reference data for the ad fee inclusive of GST (Australia/Canada).	4.40
error_charges	number	The total error charge	170
adjustments	number	The total amount of additions or corrections applied to your earnings. This field will be populated as 'NULL' for any transactions before 11/1/2024.	-2.50
adjustments_for_historical_reference_only	number	Historical reference data for the total amount of additions or corrections applied to your earnings.	-2.50
snap_ebt_discount	number	The total SNAP/EBT payout that you will receive from Fiserv at a later time.	0.00
net_total	number	The final net payout amount for this transaction line, after all fees, taxes, discounts, and adjustments.	27.85
net_total_for_historical_reference_only	number	Historical reference data for the net total prior to adjustments, using legacy calculation methodology.	29.85
preadjusted_subtotal	number	Subtotal before applying the inflation/deflation rate	35.00
preadjusted_tax_subtotal	number	Tax calculated using the subtotal before applying the inflation/deflation rate	3.08
subtotal_for_tax	number	Tax will be calculated based on this subtotal amount	35.00
subtotal_tax_passed_to_merchant_federal_harmonized	number	The subtotal GST/HST (as applicable) that DoorDash collected from the customer and passed to the Merchant (Canada)	3.00
subtotal_tax_passed_to_merchant_provincial	number	The subtotal PST/RST/QST (as applicable) that DoorDash collected from the customer and passed to the Merchant (Canada)	1.00
subtotal_tax_remitted_by_doordash_to_tax_authorities	number	The total taxes applicable to order subtotal that were collected by DoorDash from the customer and remitted directly to the tax authorities, pursuant to relevant marketplace facilitator laws.	3.15
customer_fee_tax_remitted_by_doordash_to_tax_authorities	number	The total taxes applicable to customer fees that were collected by DoorDash from the customer and remitted directly to the tax authorities, pursuant to relevant marketplace facilitator laws.	0.42
tax_remitted_by_doordash_on_fees_doordash_charges_to_merchant	number	Total taxes DoorDash remitted directly to tax authorities on the fees DoorDash charges to the merchant.	0.18
doordash_funded_subtotal_discount_amount_for_historical_reference_only	number	Historical reference data for the amount covered by DoorDash to give customers a reduction in price for their food at the subtotal.	5.00
merchant_funded_subtotal_discount_amount_for_historical_reference_only	number	Historical reference data for the amount covered by you to give customers a reduction in price for their food at the subtotal.	5.00
external_gift_card_credit_amount	number	Credit amount applied to the order from an externally issued gift card	10.00
merchant_funded_loyalty_discount_amount	number	Discount amount funded by the merchant through a loyalty program.	3.00
cash_adjustment	number	Adjustment applied to a cash-paid order	0.15
consumer_delivery_fee	number	Delivery fee at an order level	3.99
consumer_service_fee	number	Service fee at an order level	2.49
consumer_small_order_fee	number	Additional fee applied to small orders	2.00
consumer_legislative_fee	number	Additional fee at an order level due to local regulations	0.50
consumer_tip	number	Consumer tip	4.00

Customers

Report type: OO_CUSTOMER

This report outputs the customers who have placed orders online

Column Name	Data Type	Definition	Example
Date	date	Date the order was placed (local to the store)	2026-05-25
Time	varchar	Time of day the order was placed (HH:MM:SS, local to the store)	21:50:15
Order Id	varchar	DoorDash order ID (UUID)	be7e5715-bc98-3001-9d15-509ba638703e
Store Id	number	DoorDash Store ID	12345
First Name	varchar	Customer first name	John
Last Name	varchar	Customer last name	Smith
Email	varchar	Customer email address	[email protected]
Store Name	varchar	Store name	Metro Pizza Main Street
Phone Number	varchar	Customer phone number, including country code	+11234567890
Zipcode	varchar	Postal code of the delivery address. NULL for pickup orders	12345
Delivery Address	varchar	Street address the order was delivered to. NULL for pickup orders	100 Yonge St
Order Type	varchar	How the order is fulfilled: delivery or pickup	pickup
Order Status	varchar	Current status of the order, e.g. completed	completed
Customer Type	varchar	Whether the customer is new or a repeat customer of the store	repeat
Franchise ID	varchar	Unique DoorDash identifier of the franchise organization that owns or operates the store	20993520
Franchise Name	varchar	Name of the franchise organization that owns or operates the store	Metro Pizza Franchise

Next Steps

• Generate your JWT token with the Generate your JWT Token guide.
• Pull your first report with the Getting your first report guide.
• Questions? Email [email protected].