Contacts Activity
- Stepin\ Shashin Petel
Contact Activity Report
Intro
Contact Activity Report
Provides activity stats (sent, opens, clicks and more) for each contact (i.e., email address). So as opposed to the aggregate reports above, these are stats for each contact!
Choose a set of filters (time-frame, segment, campaign, field value, etc.) for the set of contacts you'd like to get in the resulting report and analyze their stats.
For that set of contacts, you can see see how many email messages were sent, how many opens and clicks each contact performed in the selected time-frame.
In the Export Combined Detailed Report, you can see exactly when each campaign was sent to each contact, what message was sent, the time-stamp of when they performed each open and click, on which link(s) they clicked on, as well as time-stamps of the unsubscribes, bounces and complaints, for each contact, if and when those occurred.
Note: When you choose the campaign filter, it will only select contacts that participated in the selected campaign(s) and will provide stats only for those selected campaign(s) taking into account also the required time-frame filter.
Contact Activity Aggregated and Export Combined Detailed Report
Click on the Search Contact Activity button.
Select a Segment, Campaign, or any other set of contacts (including a specific email address, or email is not empty) to generate a report, that will appear in the Report Dashboard at the top of the list.
It is very important to select the time-frame you want the contact activity to cover.For all contact activity in the list for the previous day, select email is not empty, and yesterday’s date:
Click on the ‘View Report' (as seen in the screenshot above) for an aggregated report with a summary of all sends, opens, and clicks per contact, in the given stats time range you chose. Here you’ll also find deactivation dates as well as the last sent, and last opened dates.
You can also Edit contacts from this screen.
To export the full detailed report for all contacts and all their activity (send / open / click / soft_bounce / hard_bounce / unsubscribe / complaint) click on the 'Export Combined Detailed Report' button.
Export Combined Detailed Report
Following is an explanation of the columns you'll find in this export CSV:
email: contact email address (self-explanatory)
type: of activity. Can be any one of the following: send / open / click / soft_bounce / hard_bounce / unsubscribe / complaint / resubscribe.
mailing_id: Ongage campaign ID AKA CID. In the case of Events this number is the campaign trigger instance id (aka mailing_instance_id).
mailing_name: the name of the campaign associated with that CID. In the case of Events, this is the name of the Event.
email_message_id: the message id sent in that campaign.
mailing_type: campaign (regular bulk campaign), triggered (aka event), transactional.
mailing_schedule: the time and date that the campaign was scheduled for.
timestamp: deprecated
action_timestamp_rounded: the rounded to the hour timestamp when the activity happened (send / open / click / soft_bounce / hard_bounce / unsubscribe / complaint). In case of Send this is the schedule date.
esp_id: the unique numeric id that identifies the specific ESP/SMTP vendor in Ongage.
connection_id: the ECID related to the activity type.
link_id: the unique Ongage id related to the link of that particular click activity.
data: the URL of the link
days_passed: days passed from send date to open or click activity date
ip: of open or click when available. This mapping is performed by means of an IP geolocation database.
country_code: related to IP of open and click when available. This
browser: from where open or click clicked occurred when available.
os: of device where open or click clicked occurred when available.
ocx_bounce_reason: It shows you the bounce reason like soft bounce, hard bounce and complaint.
Note: Timestamps in export CSV are UTC without user time zone offsetting.
How can I see which links did contacts click on
Create a report as described above.
Export the detailed report as described, and you'll get a CSV of that detailed report.
Open the CSV in Excel or any Spreadsheet software, filter by 'type' 'click' and you can see exactly who clicked on which link, when and in which campaign:
How to View Bounce Reasons in the Contact Activity Report
Using this option, marketers can view the bounce reason associated with each hard bounce and soft bounce.
Bounce reasons provide marketers with in-depth deliverability analysis for troubleshooting and optimizing deliverability.
Note: that the bounce status and bounce reasons available in the Contact activity report are retrieved directly from SMTP/ESP vendor.
The max size of the bounce reason field is 2048 characters.
To view bounce reasons in the contact activity report, follow the steps below:
When generating the Contact Activity report, select and add the Bounce Reason field in the column from the available output fields.
Click on view report and once the report is generated, and it will include a column of the last bounce reason in the CSV report file.
Click on the ‘Export Combined Detailed Report’ as explained in the section above and download the CSV.
In the CSV file downloaded, under the “Type” column you will see the “Soft Bounce” and/or “Hard Bounce” as values for bounced contacts.
For the same contacts, under the “ocx_bounce_reason” column, you can see all the bounce reasons for each contact.