Knowledge Center

Knowledge Center > Subscription Management > Customer Accounts > Manage Customer Accounts > Key Metrics for Customer Accounts > Total Contract Value > Exporting TCV data for analysis

Exporting TCV data for analysis

The SubscriptionDetails export file provides more detail than the Zuora application user interface, and can be a useful resource.

Exporting the SubscriptionDetails file

Export Subscriptions

To export the file:

  1. Navigate to Customers > Subscriptions in the left-hand navigation section.
  2. Click Export Subscriptions, located under Action on the right.
  3. Click OK to open the zip file containing the export file named SubscriptionDetails.csv
  4. Click the SubsriptionDetails file to open it in Microsoft Excel or another spreadsheet application.

TCV of a charge

The SubscriptionDetails export file contains a row for every one-time charge, and a row for every section of a recurring charge. This means that one recurring charge can occupy more than one row of the spreadsheet:

  1. Filter the spreadsheet by the "Subscription Code" column to show only the desired subscription.
  2. (optional) To more easily locate the rows for the desired charge you can add additional column filters. For example, filter by "Charge Type" to show only the relevant type of charge (One-Time or Recurring), and "Product" to show only the relevant product name. You can also refer to the "Effective Start" and "Effective End" column s to trace renewals and amendments.
  3. The TCV values for every one-time charge and section of a recurring charge in the subscription are in the "TCV" column. To calculate the TCV for a recurring charge, add up the TCV values for all the sections of that charge.

Note that when a recurring charge is renewed, a new row is not created; the row for the most recent section is updated.

Charge TCV

TCV of a subscription

The TCV of a subscription is the sum of the TCV values for all one-time and recurring charges over the lifetime of the subscription; from the date the subscription started until the end of the current term. The SubscriptionDetails export file contains these values:

  1. Filter the spreadsheet by the "Subscription Code" column to show onlythe desired subscription.
  2. The TCV values for every one-time charge and recurring charge in the subscription are in the "TCV" column. Sum up all these values to calculate the TCV of the subscription. Note that usage charges do not have a TCV value , so leaving these rows displayed will not affect the calculation.

Subscription TCV

TCV of a customer

The TCV of a subscription is the sum of the TCV values of all the one-time and recurring charges across the customer's subscriptions. The SubscriptionDetails export file contains these values:

  1. Filter the spreadsheet by the "Customer Account" column to show only the desired customer.
  2. The TCV values for every one-time and recurring charge across all the customer's subscriptions are in "TCV" column. Sum up all these values to calculate the TCV of the customer. Note that usage charges do not have a TCV value , so leaving these rows displayed will not affect the calculation.

Customer TCV

Last modified
00:53, 22 Nov 2016

Tags

This page has no custom tags.

Classifications

(not set)