Attentive Extractor Documentation

This article will help you understand how Daasity retrieves data from Attentive, how to setup the data feed from Attentive, limitations on the current data feed and how data is stored in the Attentive Mobile schema

Key Topics

Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created

Integration Availability

This integration is available for:

  • Growth
  • Pro

Extraction Overview

The Daasity integration with Attentive uses our CSV loader functionality in conjunction with the Attentive SFTP server to retrieve the export from Attentive.

In order to enable the integration you must reach out to your Merchant Success team at Attentive and complete the following steps:

  1. Ask the Attentive team to setup an SFTP account on their server (https://sftp.attentivemobile.com) and create both a login and password (NOTE: this username / password is different from their regular Attentive Mobile login)
  2. Ask Attentive to start sending the following two files on a daily basis
    1. attentive_conversions_YYYYMMDD.csv
    2. attentive_email_SMS_YYYYMMDD.csv
  3. Ask Attentive to send a historical file through the SFTP server with a maximum size of 2GB per file
  4. Enter the username/password the Attentive team supplied for the SFTP server into the UI in the Daasity App

NOTE: The two files from Attentive will have formats as described in the table definitions below

Entity Relationship Diagram (ERD)

Endpoints

Conversions Table

The [conversions] table is generated from the [attentive_conversions_YYYYMMDD.csv] file that Attentive places into their SFTP folder on a daily basis

  • Update method: UPSERT
CSV Column Database Column
phone phone
client_id client_id
amount amount
timestamp conversion_at
message_id message_id
message_name message_name
message_text message_text
message_type message_type
message_subtype message_subtype

Notifications Table

The [notifications] table is generated from the [attentive_email_SMS_YYYYMMDD.csv] file that Attentive places into their SFTP folder on a daily basis

  • Update method: UPSERT
CSV Column Database Column
type type
phone phone
client_id client_id
email email
timestamp event_at
join_source join_source
message_id message_id
message_name message_name
message_text message_text
message_type message_type
message_subtype message_subtype
message_start message_at
creative_id creative_id
creative_name creative_name
creative_type creative_type
creative_subtype creative_subtype

Release Updates

  • 2022-03-22: Initial Documentation Created

Related Resource