How to Access the DoorDash Reporting API

6 min de lecture

What is the Reporting API?

The DoorDash Reporting Application Programming Interface (API)  is a new tool that merchants can opt-in to use to access DoorDash reporting data.

In the context of reporting, an API is a mechanism that enables you to request and access standardized reports either directly or via select existing 3rd party reporting platforms. This is an alternative to accessing data directly within the Merchant Portal, via S3 Bucket, or Sigma.

What information can I see?

The Reporting API currently contains a standard set of Marketplace reports for Restaurants and New Verticals, including Financials, Operations, Menu, and Customer Feedback.

The Marketplace (Merchant Pick) Reports reports contain similar information as the Sales, Operations and Financial reports in the Merchant Portal Report Builder.

For more details, navigate the “API Reports Overview” section.

How can I sign-up for Reporting API?

Direct integration

Upon integrating into the Reporting API, you will be able to request a standard set of Marketplace reports, including Financials, Operations, Menu, and Customer Feedback, by following the steps below:

  1. Request a report using the API

  2. Once generated, make a request to retrieve the specified Report ID

  3. The API will return a link to download your report

Reports will refresh on a daily basis and Merchant Pick reports will reflect the same data that is shown in the Merchant Portal.

To indicate your interest in getting access to DoorDash’s Reporting API please indicate your interest using the following link. Our access team will review your request and you will be notified by email when your request has been approved.

Via a preferred Partner

DoorDash has integrated with select third-party platforms for data aggregation, including Itsacheckmate and Nextbite, with plans to explore  additional partner integrations in the future. You can use these platforms to access a holistic reporting view across multiple local commerce platforms. 

To get started with It’s a Checkmate, click here to learn more.

To get started with Nextbite, click here to learn more.

API Reports Overview

Requested Reporting files are generated as Comma Separated (.csv) text files. To determine which report group your business belongs to review the table below: 

Report Groups

Report Users

Marketplace (Merchant Pick) Reports

Restaurants, Merchants with Merchant Pick Shopping Protocol (e.g., some convenience, hot + prepared merchants, alcohol merchants, etc.)

Marketplace (Dasher Shop) Reports

Merchants with Dasher Shop Shopping Protocol (e.g., grocery, retail, some convenience merchants, etc.)

Marketplace - Merchant Pick Reports 

Category

Report

Report_Type Value

Description

Feedback

Consumer Feedback

“CONSUMER_FEEDBACK"

This report outputs all customer feedback that has been received (item level reviews, store level reviews, etc.)

Finance

Payout Summary

"PAYOUT_SUMMARY"

This report outputs a summary all payouts that have been completed within the requested report time frame

Finance

Transaction Details

"TRANSACTION_DETAIL"

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

Operations

Canceled Orders

"CANCELLED_ORDERS”

This report outputs a list of all canceled orders regardless of reason

Operations

Order Details

"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

Operations

Menu Item Error

"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

Operations

Store Temporary Deactivations

"TEMPORARY_DEACTIVATION"

This report outputs a list of all stores that are currently temporary deactivated

Operations

Menu Open Hours

"MENU_OPEN_HOURS"

This report outputs the menu hours for all stores 

Operations

Menu Special Hours

”MENU_SPECIAL_HOURS"

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

Operations

Merchant Avoidable Wait

"AVOIDABLE_WAIT"

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

Marketplace - Dasher Shop Reports

Category

Report

Report_Type Value

Description

Finance

Payout Summary

“NV_PAYMENTS”

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

Finance

Transaction Details

“NV_TRANSACTIONS”

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

Finance

Order Item

“NV_ORDER_ITEMS”

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

How often will reports be updated?

All reports are refreshed once daily at 7 PM PST for the previous day ending at 11:59PM PST

How far back can I access reporting data via the API?

The current limit for reporting data is 2 years

What are the current Rate Limits on both endpoints?

40 queries per second

What if I would like to access reports that are not listed above?

Our teams will be adding other report types (e.g., Marketing, Drive, Storefront) in future releases.

My business is based outside of the US. Can I leverage the Reporting API?

Yes, the Reporting API only supports US, Canada and Australia partners.

What if I want to access data via a Partner that is not currently listed?

We will be looking into adding other Partners in the future.

What is the difference between Marketplace Merchant Pick and Dasher Shop Reports?

Merchant Pick vs Dasher Shop are different order fulfillment models based on in-store operations.

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 Shop

When the Dasher is in charge of selecting the items, checking out, and delivering them to the customer (overview here).