> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Accounts query

> Learn about the Accounts query.

Learn about the Accounts query.

## Overview

The Accounts query let you export a report with a group of your customers or of all of your customers. This article explains how to create the Accounts query including the data source objects and fields required for export. This report reproduces the data provided by the Customers Report that was deprecated as of R182.

## Data source selections

**Navigation: Reporting > Data Sources**

From the **Data Source** drop-down, choose **Subscription**.

See [Generate a data source export](/docs/platform/data/reporting/data-sources-and-exports/generate-a-data-source-export) general instructions on how to create a data source export.

## Objects and fields

The following table describes the objects and their fields used in the Accounts query:

<table>
  <tr>
    <th>
      Object
    </th>

    <th>
      Fields
    </th>
  </tr>

  <tr>
    <td>
      Subscription
    </td>

    <td>
      * Contract Effective Date
      * Created Date
      * Name
      * Previous Subscription ID
      * Updated Date
    </td>
  </tr>

  <tr>
    <td>
      Account
    </td>

    <td>
      * Account Number
      * Name
      * Status
    </td>
  </tr>

  <tr>
    <td>
      Bill To
    </td>

    <td>
      * First Name
      * Last Name
    </td>
  </tr>
</table>

## Filters

The following are recommended filter fields to refine your search. If you want to view all customers with any status, a filter is not required.

Set your filters ( **Name**, **Status**, **Created Date**, and **Updated Date** ) to help you define what you want to see and retrieve in your reports.

* **Name**: Enter the customer name to export data based on an individual customer account.
* **Status**: Select a status type from the list to filter by status (Draft, Active, or Canceled).

## Time frame

The following are recommended date filters.

* **Created Date**: The date the customer accounts were created. The minimum number of days that you can run a report for is two days. For example, if you set your date filter to be 1/1/2014 through 1/2/2014, your report will show customer accounts created on 1/1/2014 and 1/2/2014.
* **Updated Date**: The last date that the customer account was modified.

## Format

Select to export as a CSV or CSV ZIP