Member Activity File

Summary

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