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:
- 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 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 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 and configure an import workflow of Acoustic users and their activity from the Lytics platform.
- Log into your Lytics account.
- Select Acoustic from the integrations list.
- Click New Workflow.
- Select Import Users & Activity.
- Select the authorization you previously created.
- 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.
- (Optional) Check the Keep Updated checkbox to import 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 to begin the workflow.
