Skip to main content

Subscriptions Query

Zuora

Subscriptions Query

Overview

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

Data Source Selections

Navigation: Reporting > Data Sources

In the Data Source drop-down, choose Rate Plan.

See Generate a Data Source Export general instruction on how to create a data source export.

Objects and Fields

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

Object Fields

Account

  • Account Number
  • Name

Product

  • Name

Subscription

  • Cancelled Date
  • Contract Effective Date
  • Initial Term
  • Name
  • Renewal Term
  • Service Activation Date
  • Status
  • Updated Date

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 (NameStatusCreated 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