User Tools

Site Tools


en:dataexchange:export_optin_changes

This is an old revision of the document!


Export Types

Optin Changes

Every change (additions and losses) of optins are exported.

Filename:
[SENDER-ID]_optin_changes_[full|incremental].csv (respectively with individual date suffix)

Example:

"channel";"ts";"userId";"custID";"channelAddress";"status"
"mail";"2019-01-26 00:10:04";"522503";"CUSTOMERCODE";"mail@mail.com";"1"
"app";"2019-11-22 14:23:02";"32103";"CUSTOMERCODE";"1da232ef23df323a09";"-1"
"sms";"2019-12-11 11:12:12";"52103";"CUSTOMERCODE";"+49171123456789";"1"
  • channel[string]: channel
  • ts [datetime]: timestamp of change (YYYY-MM-DD HH:MM:SS)
  • userId [int]: ID of user (promio internal, unique per user)
  • custID [string]: ID of customer (external)
  • channelAddress[string]: channel address
  • status [int, -1|1]:
    -1: optin removed
    1: optin added
en/dataexchange/export_optin_changes.1601969590.txt.gz · Last modified: 2020/10/06 09:33 by fw