Acoustic: Import Audiences & 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: XML 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 XML API to import Acoustic users and their activity to Lytics. Each run of the job will proceed as follows:
- 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_usersstream in Lytics. - 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_activitystream in Lytics. - After successful completion, the job 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 job will receive your current Acoustic data.
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
email unique_id | Email Address | string | |
| First Name | first_name | First Name | string |
| Last Name | last_name | Last Name | string |
| Email Type | sp_email_type | Acoustic Email Type | string |
map(list, Opted Out) | sp_list_optout_status | Acoustic Optout Status by List | map[string]string |
map(list, todate(Opted Out Date)) | sp_list_opt_out_date | Acoustic Opt Out Date by List | map[string]time |
map(list, todate(Opt In Date)) | sp_list_opt_in_date | Acoustic Opt In Date by List | map[string]time |
map(list, Opt In Details) | sp_list_opt_in_details | Acoustic Opt In Details | map[string]string |
| emaildomain(email) | emaildomain | Email Domain | string |
Similarly, the following fields are included in the default mapping for the silverpop_activity stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
email unique id | string | ||
| emaildomain | Email Domain | string | |
| Url | hashedurls | Hashed Urls Visited | map[string]intsum |
| max(epochms()) | last_active_ts | Last Active on Any Channel | date |
| Campaign Id | sv_campaign_ids | Acoustic Campaign the send originated from | []string |
| event | sv_clickct | Acoustic Click count | int |
| Event Type | sv_email_event | Acoustic Events | map[string]intsum |
| Url | sv_email_urls | Acoustic URLs | []string |
| min(epochms()) | sv_firstclick_ts | Acoustic First Click | date |
| min(epochms()) | sv_firstopen_ts | Acoustic First Open | date |
| min(epochms()) | sv_firstsent_ts | Acoustic First Sent | number |
| hourofday() | sv_hourlyopen | Acoustic Hourly Events | map[string]intsum |
| hourofweek() | sv_hourofweek | Acoustic Hour of Week Events | map[string]intsum |
| max(epochms()) | sv_lastclick_ts | Acoustic Last Click | date |
| max(epochms()) | sv_lastopen_ts | Acoustic Last Open | date |
| max(epochms()) | sv_lastsent_ts | Acoustic Last Sent | date |
| list_id | sv_list_ids | Acoustic List the send originated from | []string |
| Mailing Id | sv_mailing_ids | Acoustic Mailing the send originated from | []string |
| Mailing Name | sv_mailing_names | Acoustic Mailing Names | []string |
| Mailing Name | sv_mailing_names_click_count | Acoustic Mailing Names Click Count | map[string]intsum |
| Mailing Name | sv_mailing_names_clicked | Acoustic Mailing Names Clicked | []string |
| Mailing Name | sv_mailing_names_open_count | Acoustic Mailing Names Open Count | map[string]intsum |
| Mailing Name | sv_mailing_names_opened | Acoustic Mailing Names Opened | []string |
| Mailing Name | sv_mailing_names_sent | Acoustic Mailing Names Sent | []string |
| Mailing Name | sv_mailing_names_sent_count | Acoustic Mailing Name Sent Count | map[string]intsum |
| yymm() | sv_monthly | Acoustic Opens By Month | map[string]intsum |
| event | sv_openct | Acoustic Open count | int |
| Program Id | sv_program_ids | Acoustic Program Ids | []string |
| min(epochms()) | sv_subscribe_ts | Acoustic Subscribe Time | date |
| min(epochms()) | sv_unsubscribe_ts | Acoustic Unsubscribe Time | date |
Configuration
Follow these steps to set up an Import Audiences and Activity Data job for Acoustic. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select Acoustic from the list of providers.
- Select the Import Audiences and Activity Data job type from the list.
- Select the Authorization you would like to use or create a new one.
- Enter a Label to identify this job you are creating in Lytics.
- (Optional) Enter a Description for further context on your job.
- From the Type dropdown, select the Acoustic source type: database, list, or query.
- From the Source dropdown, select the Acoustic source to import user data from.
- Click on the Show Advanced Options tab to expand the advanced configuration.
- Check the Keep Updated checkbox to update the list every 8 hours.
- In the Activity Start field, enter the date to import activity from. The default is to retrieve one year of activity.
- Click Start Import.
