The member activity file can be dropped daily onto Ordergroove's SFTP and contains a log of the previous day's activity of actions taken with regard to a subscriber or subscription. For example: changes taken within the Subscription Manager, customer service updates, API updates, and automated events that may trigger transactional emails to customers.
This report is a legacy report and therefore please note that the fields included in this export cannot be customized, and not all codes may be used for your specific integration.
If you are interested in real time event updates around activity, you might consider using webhooks instead.
File Format & Naming Convention
[client_name]_crm_subscriber_events_MMDDYYYYHHMMSS.csv
|
FIELD NAME |
MAPPING/ DEFINITIONS |
DATA TYPE |
SAMPLE DATA |
|
og_subscription_id |
Public Subscription ID within the OG system |
String, up to 40 characters |
53694dc2b05511e59d99ac764e157edc |
|
user_id |
The unique identifier for the subscriber in the Merchant's system |
String, up to 128 characters |
9648 |
|
customer_email |
Subscriber's email |
String, up to 128 characters |
jane.smith@ordergroove.com |
|
subscription_action_event |
“1”: “Subscription Started”, “2”: “Order Placed”, “3”: “Credit Card Issue”, “4”: “Order Reminder”, “5”: “Subscription Cancelled”, “6”: “Credit Card Expired”, "8": "Subscription - Changed Shipping Address", "9": "Reactivated Subscription", "10": "Subscription - Changed Payment Information", "11": "Subscription - Changed Delivery Frequency", "12": "Subscription - Changed Next Order Date ("Pause" in Subscription Manager), "13": "Subscription - Changed Email Reminder", "14": "Subscription - Changed Quantity", "15": "Subscription - Skipped Next Shipment", "16": "Subscription - Changed Product", "17": "Subscription - Sent Shipment Now", “18”: “Subscription - Use Shipping For All”, “19”: “Subscription - Use Billing For All”, “20”: “Subscription - Use Payment For All”, "21": "Order - Canceled Order", "22": "Order - Removed Item", "23": "Item - Changed Quantity", "24": "Order - Sent Shipment Now", "25": "Change - Order Date", "27": "Order - Changed Shipping Address", "28": "Order - Changed Payment Information", “30”: “Item Discontinued”, “31”: “Item out of stock - Start” “32”: “Item out of stock - Day 15”, “33”: “Item out of stock - Day 30”, "36": "Replaced Discontinued Product", "38": "Merged Orders", "44": "Placement Credit Card Expired", "49": "IU Subscription Started", "50": "IU One Time", "53": "IU Start", "54": "IU Confirm", "57": "Order Rejected - Retry Limit Reached", "71": "Subscription product ID swap", "74": "Orders Merged", "75": "Order Rejected by Merchant", "76": "Order Cancelled by Merchant", "77": "Item into OOS flow", "79": "Order Split", "80": "Orders Merged from Combination Savings" "82": "Customers Merged", "85": "Item Subscribe - Item Converted to Subscription", "86": "Discontinued Product Swap - Discontinued Product Swapped for Replacement", "87": "Discontinued One Time Item Product Swap", "92": "Bulk Subscription Started" |
Int, up to 10 characters |
1 |
|
activity_date |
Date/time of last activity MMDDYYYYHHMMSS |
Datetime, exactly 14 digits |
10022019045522 |