PostUp: Import Audiences & Activity Data
Import PostUp recipients and campaign activity into Lytics to gain insights into your users and campaigns.
Integration Details
- Implementation Type: Server-side.
- Implementation Technique: REST API.
- Frequency: Batch.
- Resulting data: User profiles, and User fields.
This integration utilizes the PostUp APIs to import user data. Once the import is started the job will:
- If it has been more then 24 hours since the last recipient import:
- Iterate through lists.
- For each list, request recipients in the list
- Ingest the recipients, to the postup_users stream
- Request all campaigns
- For each campaign, request all the mailings in it
- For each mailing request a mailing report, of each activity type:
- Opens
- Unique clicks
- Hard Bounces
- Soft Bounces
- Ingest the tab separated file for each report to the postup_activity stream.
Fields
The following fields are included in the default mapping of the postup_users stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| email(address) | email unique id | Email Address | string |
| recipientId | pu_id unique id | PostUp Recipient ID | string |
| externalId | pu_ext_id unique id | PostUp External ID | string |
| set("email" or "mobile") | channels | All Channels Used (web, email, etc.) | []string |
| emaildomain(address) | emaildomain | Email Domain | string |
| carrier | pu_carrier | PostUp carrier | string |
| set(list_catagory) | pu_categories | PostUp List Categories | []string |
| comment | pu_comment | string | |
| dateJoined | pu_joined_date | PostUp Date Joined | date |
| set(list_id) | pu_list_ids | PostUp List IDs | []string |
| set(list_title) | pu_list_titles | PostUp List Titles | []string |
| sourceSignupDate | pu_source_signup_date | PostUp Date Signed Up Source | date |
| status | pu_status | string | |
| dateUnsub | pu_unsub_date | PostUp Date Unsubscribed | date |
The following fields are included in the default mapping of the postup_activity stream:
| Source Field | Lytics User Field | Description | Type |
|---|---|---|---|
| recipientId | pu_id unique id | PostUp Recipient ID | string |
| email(address) | email unique id | Email Address | string |
| externalId | pu_ext_id unique id | PostUp External ID | string |
| set("email" or "mobile") | channels | All Channels Used (web, email, etc.) | []string |
| emaildomain(address) | emaildomain | Email Domain | string |
| valuect(hash(urlmain(url_clicked))) | hashedurls | Hashed Urls Visited | map[string]intsum |
| map("email" or "mobile", epochms()) | last_channel_activities | Last Activity By Channel | map[string]time |
| bounce_reason | pu_bounce_reason | PostUp Last Bounce Reason | string |
| count(event_type) | pu_click_ct | PostUp Click Count | int |
| map(campaign_id,1) | pu_click_ct_by_campaign | PostUp Campaign Click Count | map[string]int |
| valuect(hourofday()) | pu_hourly_open | PostUp Hourly Opens | map[string]intsum |
| valuect(hourofweek()) | pu_hourofweek | PostUp Hour of Week Opens | map[string]intsum |
| epochms() | pu_last_click_ts | PostUp Last Click | date |
| urlmain(url_clicked) | pu_last_click_url | PostUp Last URL Clicked | string |
| epochms() | pu_last_open_ts | PostUp Last Open | date |
| valuect(yymm()) | pu_monthly | PostUp Opens By Month | map[string]intsum |
| count(event_type) | pu_open_ct | PostUp Open Count | int |
| map(campaign_id,1 | pu_open_ct_by_campaign | PostUp Campaign Open Count | map[string]int |
Configuration
Follow these steps to set up and configure an import of PostUp in the Lytics platform. If you are new to creating jobs in Lytics, see the Jobs Dashboard documentation for more information.
- Select PostUp from the list of providers.
- Select the Import 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.
Complete the configuration steps for your job.
In the Site ID text input, enter your PostUp site ID. It can be found at the bottom of the Server tab in the PostUp UI
- Click Start Import.
