Total Subscriber Value Report

Summary

The Total Subscriber Value Report gives an overview of each of your customer’s subscriptions, and the total value of their active subscriptions.

File Format & Naming Convention

[client_name]_TotalSubscriberValue_Report_MMDDYYYYHHMMSS.csv 

FIELD NAME

MAPPING/DEFINITIONS

DATA TYPE

SAMPLE DATA

Merchant User ID

Customer ID in merchant system

String, up to 128 characters

941874

Email Address

Subscriber's e-mail address

String, up to 128 characters

john.doe@ordergroove.com

Place Date

Date of the customer’s next upcoming order(MM/DD/YYYY)

Date, exactly 10 characters

08/26/2021

Discount Price

Discount price for the product

Decimal, up to 99999999.99

12.99

Frequency Days

Frequency of subscription (in days)

Smallint, up to 6 characters

60

In Stock

1 = In stock 0 = Out Of Stock

Tinyint(1)

1

Product Name

Product name

String, up 10 1024 characters

Raw Hazelnuts - 1 pound bag

SKU

Product SKU

String, up to 64 characters

3064-09

Order Quantity

Number of item units within the subscription

Small int, up to 5 characters

1

Total Subscriber Value

Total dollar value of the customer’s live subscriptions

Decimal, up to 99999999.99

110.29