Data API

AO databaseAO database

List builderList builder Export APIExport API

User dataUser data

Transactional data

Transactional data

Hybrid data

Hybrid data

CSV or XLS

Automated ftp/sftpAutomated ftp/sftp

https GET

request

https GET

request

CSV or XML

Options for exporting data from EN

Options for importing data to EN

Saved formatsSaved formats

Manual import

via dashboard

Manual import

via dashboardImport APIImport API

https multi-part POST requesthttps multi-part POST request

AO databaseAO database

Import fileImport file

Types of data in EN

• Default user data– 1 user = 1 record (based on email address).– All users have a default data record.

• Transactional data– For a particular action, any given user may or may not have one or

more transaction logs linked to their data record.

• Question data– Any given user may or may not have a response stored for a

particular question element.

Transactional data

What information does transactional data capture?

Common

Transactional data format

Common transaction data

segments

Activity-specific transaction data

segments

Default user data segments

API customisation options

NamingCampaign/question/broadcast namesColumn headersAction types

Structure/formatOutput columnsXML/CSVCSV delimiter

Filtering Action typesOpt-in

Transactional data changes

• Transactional data section expanded

• Detailed fundraising data segments

• Extra fundraising transaction types, including bank payments and recurring payments

Later this year…

• Import logic customisability

• Historical question data

• Time ranges

• sftp improvements

• XML call to query job status

Individual customisation

• Specific in-house/third party data protocol

• Re-ordering of columns

• Mapping of non-standard output

• Multiple file output (e.g. Main data file + Activity file)

Community Conference 2011

Information and signup at:

www.engagingnetworks.net/community2011