Supported Modules

The CSV Upload tool currently supports editing and inserting data for three of the SFV Modules:

User
Contact Preferences
Custom Data Fields

Additionally, the SFTP and External Bucket connectors support:

All previous modules
Digital Usage
Email
Entitlement
Form
Hospitality
Opportunity
Push
Retail
Streaming
Structured Event
Ticket

Uploadable Fields

User Module

Required	Field Name	Data type	Input Format	CSV	SFTP / Ext Bucket	Notes
x	scv_user_id	String		x	x	"None" by default. Expects unique values.
	email_address	String		x	x
	source_updated_tstamp	String			x
	primary_source	String			x
	device_id	String			x
	sso_id	String			x
	push_id	String			x
	is_push_revoked	Boolean			x	1 or 0
	is_email_suppressed	Boolean			x	1 or 0
	email_contact_id	String			x
	mobile_number	String		x	x
	title	String		x	x
	first_name	String		x	x
	last_name	String		x	x
	full_name	String		x	x
	gender	String		x	x	Please check existing valid set of values
	birth_date	Date	yyyy-mm-dd	x	x
	age	String		x	x
	address_line_1				x
	address_line_2				x
	address_line_3				x
	postcode	String		x	x
	postcode_town	String		x	x
	postcode_region	String		x	x
	postcode_latitude	Numeric		x	x
	postcode_longitude	Numeric		x	x
	postcode_district	String		x	x
	postcode_area	String		x	x
	country_code	String		x	x	2 letter ISO country code
	country_name	String		x	x
	continent_name	String		x	x
	distance_to_club	Numeric		x	x
	job_title	String		x	x
	company_name	String		x	x
	originating_source	String		x	x
	originating_source_insight	String		x	x
	originating_source_tstamp	Date time	yyyy-mm-dd hh:mm:ss	x	x
	import_name	String		x	x
	import_type	String		x	x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	x	Populate to soft-delete a previously uploaded record.

Contact Preferences Module

Required	Field Name	Data type	Input Format	CSV	SFTP / Ext Bucket	Notes
x	scv_user_contact_preference_id	String		x	x	Expects unique values.
	email_address	String		x	x
	scv_user_id	String		x	x
	source_system_id	String		x	x
	source_system_name	String		x	x
	source_system_user_id	String		x	x
	source_type	String		x	x
	name	String		x	x
	description	String		x	x
	key	String		x	x
	option_id	String		x	x
	option_name	String		x	x
	option_status	String		x	x
	option_modified_at	Date time	yyyy-mm-dd hh:mm:ss	x	x
	import_name	String		x	x
	import_type	String		x	x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	x	Populate to soft-delete a previously uploaded record.

Custom Data Fields Module

Required	Field Name	Data type	Input Format	CSV	SFTP / Ext Bucket	Notes
	import_name	String		x	x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	x	Defaults to the time the file is processed, if not provided.
	email_address	String		x	x
x	scv_user_id	String		x	x	Expects unique values.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	x	Populate to soft-delete a previously uploaded record.
	<additional_fields>					Please provide the list to the Cortex team

Ticket Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
	scv_user_id	String		x
x	scv_user_ticket_id	String		x	Expects unique values.
	email_address	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	season	String		x
	product_id	String		x
	product_name	String		x
	product_description	String		x
	product_type	String		x
	product_sub_type	String		x
	product_start_date	Date	yyyy-mm-dd	x
	product_end_date	Date	yyyy-mm-dd	x
	venue_name	String		x
	distance_travelled	Numeric		x
	competition_name	String		x
	competition_type	String		x
	home_team_name	String		x
	away_team_name	String		x
	transaction_date	Date	yyyy-mm-dd	x
	transaction_days_before_start_date	Numeric		x
	is_transaction_cancelled	Boolean		x	1 or 0
	transaction_cancellation_date	Date	yyyy-mm-dd	x
	transaction_value	Numeric		x
	transaction_price_band	String		x
	transaction_price_class	String		x
	order_id	String		x
	order_value	Numeric		x
	payment_method	String		x
	seat_number	String		x
	seat_row	String		x
	block_name	String		x
	area_name	String		x
	stand_name	String		x
	stadium_name	String		x
	has_linked_ticket_wallet	Boolean		x	1 or 0
	is_ticket_wallet_shared	Boolean		x	1 or 0
	has_attended	Boolean		x	1 or 0
	arrival_time	Date time	yyyy-mm-dd hh:mm:ss	x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Retail Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
	scv_user_id	String		x
x	scv_user_retail_id	String		x	Expects unique values.
	email_address	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	branch_code	String		x
	branch_name	String		x
	department_name	String		x
	sub_department_name	String		x
	season	String		x
	product_id	String		x
	product_description	String		x
	product_category	String		x
	transaction_id	String		x
	transaction_date	Date	yyyy-mm-dd	x
	transaction_quantity	Numeric		x
	transaction_value	Numeric		x
	promo_code	String		x
	order_id	String		x
	order_value	Numeric		x
	is_refunded	Boolean		x	1 or 0
	refund_date	Date	yyyy-mm-dd	x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Digital Usage Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
x	scv_digital_content_id	String		x	Expects unique values.
x	scv_user_id	String		x	Expects unique values.
	email_address	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	digital_app_id	String		x
	content_type	String		x
	content_id	String		x
	content_name	String		x
	content_category	String		x
	total_usage_events	Numeric		x
	total_duration	Numeric		x
	avg_duration	Numeric		x
	days_after_publication_date	Numeric		x
	first_usage_at	Date time	yyyy-mm-dd hh:mm:ss	x
	last_usage_at	Date time	yyyy-mm-dd hh:mm:ss	x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Structured Event Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
	scv_user_id	String		x
x	scv_user_structured_event_id	String		x	Expects unique values.
	email_address	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	digital_app_id	String		x
	usage_at	Date time	yyyy-mm-dd hh:mm:ss	x
	category	String		x
	action	String		x
	label	String		x
	property	String		x
	value	Numeric		x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Email Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
x	scv_user_email_id	String		x	Expects unique values.
	scv_user_id	String		x
	email_address	String		x
	source_system_name	String		x
	campaign_id	String		x
	campaign_name	String		x
	campaign_description	String		x
	campaign_category	String		x
	activity_type	String		x
	sent_at	Date time	yyyy-mm-dd hh:mm:ss	x
	activity_date	Date	yyyy-mm-dd	x
	activity_url	String		x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Form Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
x	scv_user_form_id	String		x	Expects unique values.
	scv_user_id	String		x
	email_address	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	form_id	String		x
	form_name	String		x
	form_description	String		x
	form_category	String		x
	form_completed_at	Date time	yyyy-mm-dd hh:mm:ss	x
	is_form_complete	Boolean		x	1 or 0
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Streaming Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
	scv_user_id	String		x
x	scv_user_streaming_id	String		x	Expects unique values.
	email_address	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	season	String		x
	product_id	String		x
	product_type	String		x
	product_name	String		x
	product_description	String		x
	product_length	String		x
	product_start_date	Date	yyyy-mm-dd	x
	product_end_date	Date	yyyy-mm-dd	x
	is_product_active	Boolean		x	1 or 0
	transaction_id	String		x
	transaction_date	Date	yyyy-mm-dd	x
	transaction_value	Numeric		x
	transaction_currency	String		x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Push Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
x	scv_user_push_id	String		x	Expects unique values.
	scv_user_id	String		x
	source_system_name	String		x
	campaign_id	String		x
	campaign_name	String		x
	campaign_description	String		x
	campaign_category	String		x
	activity_type	String		x
	activity_url	String		x
	sent_at	Date time	yyyy-mm-dd hh:mm:ss	x
	activity_date	Date	yyyy-mm-dd	x
	created_at	Date time	yyyy-mm-dd hh:mm:ss	x
	updated_at	Date time	yyyy-mm-dd hh:mm:ss	x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Opportunity Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
x	scv_user_opportunity_id	String		x	Expects unique values.
	scv_user_id	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	product_name	String		x
	opportunity_record_type	String		x
	event_name	String		x
	package_type	String		x
	client_relationship	String		x
	area	String		x
	season	String		x
	opportunity_stage	String		x
	total_price	Numeric		x
	quantity	Numeric		x
	loss_reason	String		x
	opportunity_opened_at	Date time	yyyy-mm-dd hh:mm:ss	x
	opportunity_closed_at	Date time	yyyy-mm-dd hh:mm:ss	x
	opportunity_updated_at	Date time	yyyy-mm-dd hh:mm:ss	x
	created_at	Date time	yyyy-mm-dd hh:mm:ss	x
	updated_at	Date time	yyyy-mm-dd hh:mm:ss	x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Entitlement Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
x	scv_user_entitlement_id	String		x	Expects unique values.
	scv_user_id	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	season	String		x
	product_id	String		x
	product_name	String		x
	product_description	String		x
	entitlement_id	String		x
	entitlement_type	String		x
	entitlement_name	String		x
	entitlement_description	String		x
	entitlement_start_date	Date	yyyy-mm-dd	x
	entitlement_end_date	Date	yyyy-mm-dd	x
	is_active_entitlement	Boolean		x	1 or 0
	transaction_id	String		x
	transaction_date	Date	yyyy-mm-dd	x
	transaction_value	Numeric		x
	created_at	Date time	yyyy-mm-dd hh:mm:ss	x
	updated_at	Date time	yyyy-mm-dd hh:mm:ss	x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.

Hospitality Module

Required	Field Name	Data type	Input Format	SFTP / Ext Bucket	Notes
	scv_user_id	String		x
x	scv_user_hospitality_id	String		x	Expects unique values.
	email_address	String		x
	source_system_name	String		x
	source_system_user_id	String		x
	source_type	String		x
	season	String		x
	product_id	String		x
	product_name	String		x
	product_description	String		x
	product_type	String		x
	product_sub_type	String		x
	product_start_date	Date time	yyyy-mm-dd hh:mm:ss	x
	product_end_date	Date time	yyyy-mm-dd hh:mm:ss	x
	venue_name	String		x
	distance_travelled	Numeric		x
	competition_name	String		x
	competition_type	String		x
	home_team_name	String		x
	away_team_name	String		x
	transaction_date	Date time	yyyy-mm-dd hh:mm:ss	x
	transaction_days_before_start_date	Numeric		x
	is_transaction_cancelled	Boolean		x	1 or 0
	transaction_cancellation_date	Date time	yyyy-mm-dd hh:mm:ss	x
	transaction_value	Numeric		x
	transaction_price_band	String		x
	transaction_price_class	String		x
	order_id	String		x
	order_value	Numeric		x
	payment_method	String		x
	seat_number	String		x
	seat_row	String		x
	block_name	String		x
	area_name	String		x
	stand_name	String		x
	stadium_name	String		x
	has_linked_ticket_wallet	Boolean		x	1 or 0
	is_ticket_wallet_shared	Boolean		x	1 or 0
	has_attended	Boolean		x	1 or 0
	arrival_time	Date time	yyyy-mm-dd hh:mm:ss	x
	import_name	String		x
	import_type	String		x
	uploaded_at	Date time	yyyy-mm-dd hh:mm:ss	x	Defaults to the time the file is processed, if not provided.
	deleted_at	Date time	yyyy-mm-dd hh:mm:ss	x	Populate to soft-delete a previously uploaded record.