What's included in your Customers CSV on ZenVideo OTT

When you download your Customer's CSV, you will be presented with your users' data in relation to your product. The table below is for your reference to help you understand what the CSV includes and the definitions for each value.

⚠️Note: Include product_id definition to give an example (TVOD product, SVOD product, free reg product).

What's included in my Customer CSV?

Column	Definition	Value type	Value examples
customer_id	OTT ID of Customer	Integer	1234567
email	Email of customer	String	[e-mail]
first_name	Customer's first name	String	John
last_name	Customer's last night	String	Doe
city	City as determined by GeoIP lookup	String	Nashville
state	State as determined by GeoIP lookup	String	TN
country	The country as determined by GeoIP lookup	String	United States
product_id	OTT ID of the first product the user subscribed to or purchased	Integer	14440
product_name	Name of the first product the user subscribed to or purchased	String	My Video Product
action	The action was taken by the customer subscription: the user has started a free trial or purchased a subscription to an SVOD product follow: click the site's "Follow" button registration: user has registered with the site; should only exist for sites that allow free access, but some SVOD sites may see it as well if a viewer started the signup process but didn't finish or pay. rental: rented a TVOD product purchase: purchased a TVOD product	String	subscription
action_type	Property of action staff_invite: user was added to the platform by an OTT staff user coupon: if a user used a coupon (TVOD only) free_access: added via the Add Customer tool transaction: purchased via the site site follow: if a user signed up for a mailing list but hasn't registered or had a transaction on the site fulfillment: all app and API purchasers gift: purchased for the person by someone else	String	free_access
status	The current state of the customer free_trial: currently in a free trial (at the time of export) canceled: Customer specifically took an action to cancel their web subscription to prevent renewal enabled: Customer has access to the product via this ticket refunded: The customer was granted a refund and lost access to the product disabled: Customer no longer has access to the product. Tickets may be disabled for several reasons including admin or OTT staff took an action; the customer stopped pledging to the Patreon that had granted them access; the customer purchased via an In-App Purchase (e.g. on a Roku device) and we were unable to determine if they should still have access. paused: The user paused their subscription ticket, meaning it will stop renewing for a set number of months, and then will resume renewing. expired: Customer lost access to a subscription for one of a few reasons, including they had temporary free access to a subscription, which ended; customer subscribed via an In-App Purchase (e.g. on a Roku device) and canceled their trial or subscription, and we determined that they should no longer have access.	String	enabled
frequency	Subscription Frequency	String	monthly yearly null (followers and TVOD) custom (this sometimes represents users given access via the API, a branded app, or granted free access from your Admin.)
platform	The platform of customer origin	String	web API ios tvos Android android_tv amazon_fire_tv Roku
coupon_code	TVOD coupon code used	String	gxytuv
coupon_code_id	OTT ID of coupon code (TVOD)	Integer	3455
promotion_id	OTT ID of promo code (SVOD)	Integer	19
promotion_code	SVOD Promo code used. This field will always show the promotion applied when the first purchase was made, even if the discount no longer applies or if a new promo code has been added. If an existing customer (no promo used originally) redeems a promo code, it will not show up here.	String	luca50
campaign	Associated campaign with signup. If present, this is the value of the utm_campaign or campaign parameter that is passed into the checkout form. They help you track the value of social marketing programs and campaigns, and provide precise data about where traffic and conversions come from.	String	we-want-you-back
referrer	Page referrer at signup	String	mysite.com/blog/deals
event_created_at	Date of last event associated with the customer's account, which can be a wide variety of actions. If you open it outside of a text editor, the formatting may appear slightly off, but you can adjust this by selecting a different data format (e.g., Short Date) in Excel or Google Sheets.	Datetime	2020-07-28 17:27:41
customer_created_at	Date of customer creation If you open it outside of a text editor, the formatting may appear slightly off, but you can adjust this by selecting a different data format (e.g., Short Date) in Excel or Google Sheets.	Datetime	2016-07-31 16:53:00
expiration_date	Date of expected expiration if no renewal - this is a rolling value dependent on the next payment. If you open it outside of a text editor, the formatting may appear slightly off, but you can adjust this by selecting a different data format (e.g., Short Date) in Excel or Google Sheets.	Datetime	2020-08-28 16:53:00
marketing_opt_in	Flag if the Customer allows marketing communication. This is set upon checkout or in Customer /settings	Boolean	true false