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 |