Modules Structure

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 Integration Manager (SFTP) Upload tool supports:

  • All previous modules
  • Digital Usage
  • Email
  • Form
  • Retail
  • Structured Event
  • Ticket

The email_address field will need to be present in every upload, as this is the link between the user and each of the modules. Please check below the fields currently supported via de CSV Upload tool for each of these.

Uploadable Fields

User Module

Required

Field Name

Data type

Input Format

CSV

SFTP

Notes

scv_user_id

String

x

x

"None" by default. Expects unique values.

x

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

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

Contact Preferences

Required

Field Name

Data type

Input Format

Notes

scv_user_contact_preference_id

String

source_system_id

String

source_system_name

String

source_system_user_id

String

source_type

String

name

String

description

String

x

key

String

Please check existing valid preference keys. One entry per key per user.

option_id

String

option_name

String

Please check existing valid preference options

option_status

String

x

option_modified_at

Date time

yyyy-mm-dd

Custom Data Fields

RequiredField NameData typeInput FormatNotes
favourite_club_teamString

Email

RequiredField NameData typeInput FormatNotes
scv_user_idStringDefaults to 'None'
xemail_addressString
scv_user_email_idString
source_system_nameString
xcampaign_idString
campaign_nameString
campaign_descriptionString
campaign_categoryString
xactivity_typeString
sent_atDate timeyyyy-mm-dd hh:mm:ss
activity_dateDate timeyyyy-mm-dd hh:mm:ss
activity_urlString

Form

RequiredField NameData typeInput FormatNotes
scv_user_idStringDefaults to 'None'
xemail_addressString
scv_user_form_idString
source_system_nameString
source_system_user_idString
source_typeString
form_idString
form_nameString
form_descriptionString
form_categoryString
form_completed_atDate timeyyyy-mm-dd hh:mm:ss
is_form_completeBoolean1 or 0

Ticket

RequiredField NameData typeInput FormatNotes
scv_user_idStringDefaults to 'None'
xemail_addressString
scv_user_ticket_idString
source_system_nameString
source_system_user_idString
source_typeString
seasonString
xproduct_idString
xproduct_nameString
product_descriptionString
product_typeString
product_sub_typeString
product_start_dateStringyyyy-mm-dd hh:mm:ss
product_end_dateStringyyyy-mm-dd hh:mm:ss
venue_nameString
distance_travelledFloat
competition_nameString
competition_typeString
home_team_nameString
away_team_nameString
transaction_dateDate timeyyyy-mm-dd hh:mm:ss
transaction_days_before_start_dateInteger
is_transaction_cancelledBoolean1 or 0
transaction_cancellation_dateString
transaction_valueFloat
transaction_price_bandString
transaction_price_classString
order_idString
order_valueFloat
payment_methodString
seat_numberString
seat_rowString
block_nameString
area_nameString
stand_nameString
stadium_nameString
has_linked_ticket_walletBoolean1 or 0
is_ticket_wallet_sharedBoolean1 or 0
has_attendedBoolean1 or 0
arrival_timeString

Retail

RequiredField NameData typeInput FormatNotes
xemail_addressString
scv_user_idString
scv_user_retail_idString
source_system_nameString
source_system_user_idString
source_type
branch_codeString
branch_nameString
department_nameString
sub_department_nameString
seasonString
xproduct_idString
xproduct_descriptionString
product_categoryString
xtransaction_idString
xtransaction_dateDate timeyyyy-mm-dd hh:mm:ss
transaction_quantityInteger
transaction_valueFloat
promo_codeString
order_idString
order_valueFloat
is_refundedBoolean1 or 0
refund_dateString

Digital Usage

RequiredField NameData typeInput FormatNotes
scv_user_idStringDefaults to 'None'
xemail_addressString
scv_digital_content_idString
source_system_nameString
source_system_user_idString
source_typeString
digital_app_idString
content_typeString
xcontent_idString
xcontent_nameString
content_categoryString
total_usage_eventsInteger
total_durationInteger
avg_durationInteger
days_after_publication_dateInteger
xfirst_usage_atDateyyyy-mm-d
last_usage_atDateyyyy-mm-dd

Structured Event

RequiredField NameData typeInput FormatNotes
scv_user_idStringDefaults to 'None'
xemail_addressString
scv_user_structured_event_idString
source_system_nameString
source_system_user_idString
source_typeString
digital_app_idString
xusage_atDate Timeyyyy-mm-dd hh:mm:s
xcategoryString
xactionString
xlabelString
propertyString
valueFloat