Documentation / Product / Integrations / Acoustic

Acoustic: Import Users and Activity

Import Acoustic users and their activity information into Lytics so you can leverage that data to build behavioral audiences and gain Insights powered by Lytics data science.

Integration Details

  • Implementation Type: Server-side.
  • Implementation Technique: SOAP API to download CSV formatted data.
  • Frequency: Data is imported in a batch process imported once, or every 8 hours on a continuous basis.
  • Resulting Data: Full Lytics user profiles for all Acoustic users complete with activity data.

This integration utilizes the Acoustic API to import Acoustic users and their activity to Lytics. Each run of the workflow will proceed as follows:

  1. Exports users from the selected Acoustic Database as a CSV file to an Acoustic-manged SFTP server. The CSV files are then read and imported to the silverpop_users stream in Lytics.
  2. Exports email activity from users in the selected Acoustic Database as a CSV file to an Acoustic-manged SFTP server. The CSV files are then read and imported to the silverpop_activity stream in Lytics.
  3. After successful completion, the workflow will import new/updated users with their updated activity every 8 hours if configured to run continuously.

Fields

The following fields are included in the default mapping for the silverpop_users stream. Note this integration was formerly named Silverpop, hence the data stream name, but this workflow will receive your current Acoustic data.

Source FieldLytics User FieldDescriptionType
emailemail unique_idEmail Addressstring
First Namefirst_nameFirst Namestring
Last Namelast_nameLast Namestring
Email Typesp_email_typeAcoustic Email Typestring
map(list, Opted Out)sp_list_optout_statusAcoustic Optout Status by Listmap[string]string
map(list, todate(Opted Out Date))sp_list_opt_out_dateAcoustic Opt Out Date by Listmap[string]time
map(list, todate(Opt In Date))sp_list_opt_in_dateAcoustic Opt In Date by Listmap[string]time
map(list, Opt In Details)sp_list_opt_in_detailsAcoustic Opt In Detailsmap[string]string
emaildomain(email)emaildomainEmail Domainstring

Similarly, the following fields are included in the default mapping for the silverpop_activity stream:

Source FieldLytics User FieldDescriptionType
Emailemail unique idstring
emailemaildomainEmail Domainstring
UrlhashedurlsHashed Urls Visitedmap[string]intsum
max(epochms())last_active_tsLast Active on Any Channeldate
Campaign Idsv_campaign_idsAcoustic Campaign the send originated from[]string
eventsv_clickctAcoustic Click countint
Event Typesv_email_eventAcoustic Eventsmap[string]intsum
Urlsv_email_urlsAcoustic URLs[]string
min(epochms())sv_firstclick_tsAcoustic First Clickdate
min(epochms())sv_firstopen_tsAcoustic First Opendate
min(epochms())sv_firstsent_tsAcoustic First Sentnumber
hourofday()sv_hourlyopenAcoustic Hourly Eventsmap[string]intsum
hourofweek()sv_hourofweekAcoustic Hour of Week Eventsmap[string]intsum
max(epochms())sv_lastclick_tsAcoustic Last Clickdate
max(epochms())sv_lastopen_tsAcoustic Last Opendate
max(epochms())sv_lastsent_tsAcoustic Last Sentdate
list_idsv_list_idsAcoustic List the send originated from[]string
Mailing Idsv_mailing_idsAcoustic Mailing the send originated from[]string
Mailing Namesv_mailing_namesAcoustic Mailing Names[]string
Mailing Namesv_mailing_names_click_countAcoustic Mailing Names Click Countmap[string]intsum
Mailing Namesv_mailing_names_clickedAcoustic Mailing Names Clicked[]string
Mailing Namesv_mailing_names_open_countAcoustic Mailing Names Open Countmap[string]intsum
Mailing Namesv_mailing_names_openedAcoustic Mailing Names Opened[]string
Mailing Namesv_mailing_names_sentAcoustic Mailing Names Sent[]string
Mailing Namesv_mailing_names_sent_countAcoustic Mailing Name Sent Countmap[string]intsum
yymm()sv_monthlyAcoustic Opens By Monthmap[string]intsum
eventsv_openctAcoustic Open countint
Program Idsv_program_idsAcoustic Program Ids[]string
min(epochms())sv_subscribe_tsAcoustic Subscribe Timedate
min(epochms())sv_unsubscribe_tsAcoustic Unsubscribe Timedate

Configuration

Follow these steps to set up and configure an import workflow of Acoustic users and their activity from the Lytics platform.

  1. Log into your Lytics account.
  2. Select Acoustic from the integrations list. acoustic-integration-tile
  3. Click New Workflow.
  4. Select Import Users & Activity.
  5. Select the authorization you previously created.
  6. From the Type dropdown, select the Acoustic source type, database, list, or query.
  7. From the Source dropdown, select the Acoustic source to import user data from. acoustic-import-pt1
  8. Click on the Show Advanced Options tab to expand the advanced configuration.
  9. (Optional) Check the Keep Updated checkbox to import the list every 8 hours.
  10. In the Activity Start field, enter the date to import activity from. The default is to retrieve one year of activity.
  11. Click Start Import to begin the workflow. acoustic-import-pt2