subscriber_properties

customer_id

STRING

REQUIRED

the customer id (typically e-mail address)

property_name

STRING

REQUIRED

the subscriber field

property_value

STRING

NULLABLE

the subscriber field value if in string format (null otherwise)

property_value_ts

TIMESTAMP

NULLABLE

the subscriber field value if in date time format (null otherwise)

lists

STRING

REPEATED

the names/ids of the subscriber lists to push this information to

origin

STRING

REQUIRED

please provide a unique key defining the origin system of these data, not used, but useful for debugging / monitoring

creation_tm

TIMESTAMP

REQUIRED

please provide timestampe of the initial creation of this row

last_modified_tm

TIMESTAMP

REQUIRED

please provide timestampe of the last modification of this row