Question
I am exporting my Campaign details to CSV but am unsure what all the column headings mean. Do you have a list of column heading definitions for the campaign CSV export?
Answer
Yes. Listed below are the CSV column heading definitions:
- First Name - The user's first name
- Last Name - The user's last name
- Campaign Guid - System side unique identifier for the campaign
- Users Guid - System side unique identifier for this user in this campaign
- Primary Email Opened - Was the email viewed (True/False)?
- Date Email Opened - The date/time the email was first viewed
- Primary Clicked - Was the link in the email clicked (True/False)?
- Date Clicked - The date/time the link was clicked in the email for the first time
- Multi Email Open - count of the number of times, beyond the first, that the email was viewed
- Multi Click Event - count of the number of times, beyond the first, that the phishing link was clicked
- Email Address - The user's email address
- Date Sent - The date/time that the email was sent to the user
- Campaign Title - The name of the campaign chosen by the customer (e.g. "IT Staff first test Jan 2014")Template Sophistication
- Template Sophistication - no longer users - legacy parameter
- Campaign Recipient List - The group or department that the campaign was sent to (e.g. IT, HR, Finance)
- Email Opened IP Address - IP address that could be recorded of the system that downloaded the tracking pixel
- Email Opened Browser - Browser type of the system that downloaded the tracking pixel (determined by the User Agent String received in the communication)
- Email Opened Browser Version - Browser version of the system that downloaded the tracking pixel (determined by the User Agent String received in the communication)
- Email Opened OS - OS type of the system that downloaded the tracking pixel (determined by the User Agent String received in the communication)
- Email Opened OS Version - OS version of the system that downloaded the tracking pixel (determined by the User Agent String received in the communication)
- Email Opened User Agent - User Agent String received in the communication during the download of the tracking pixel
- Clicked IP Address - IP address that could be recorded of the system that the link was clicked
- Clicked Host Name - Hostname that could be recorded of the system that the link was clicked
- Clicked Browser - Browser type that could be recorded of the system that the link was clicked
- Clicked Browser Version - Browser version that could be recorded of the system that the link was clicked
- Clicked OS - OS type that could be recorded of the system that the link was clicked
- Clicked OS Version - OS version that could be recorded of the system that the link was clicked
- Clicked User Agent - User Agent String received in the communication during the click of the phishing link
- Teachable Moment Started - Did the user make it to the teachable moment (True/False)?
- Acknowledgement Completed - Did the user click the acknowledge button at the bottom of the teachable moment page affirming that they read and understood the teachable moment (True/False)?
- Date Acknowledged - The date/time that the user clicked the Acknowledge button on the Teachable Moment
- Weak Egress - Was the user able to download the tracking pixel for Weak Egress detection (TRUE/FALSE)
- Reported - Did the user report the phish to the infosec group using PhishAlarm or another mechanism (True/False)?
- Date Reported - The date/time that the user reported the phishing email
- Whois Latitude - The latitude of the IP address of the first click
- Whois Longitude - The longitude of the IP address of the first click
- Whois City - The city of the IP address of the first click
- Whois State - The state of the IP address of the first click
- Whois Country - The country of the IP address of the first click
- Whois Continent - The continent of the IP address of the first click
- Whois Domain - The domain of the IP address of the first click
- Whois ISP - The ISP of the IP address of the first click
- Whois Organization - The organization of the IP address of the first click
- Email Bounced - Was the delivered email bounced back or had an automated reply returned (TRUE/FALSE)
- Passed? - Did the user meet the requirements to not fail the phishing campaign type (TRUE/FALSE)
- Vulnerability Count - Count of the number of plugins that were detected as vulnerable
- Adobe PDF Version - The version of Acrobat in use
- Adobe PDF Vulnerable - Is/was the version of Acrobat out of date at the time of the campaign (True/False)?
- Current Adobe PDF Version - Version of software reported as current by the vendor
- Adobe Flash Version - The version of Flash in use
- Adobe Flash Vulnerable - Is/was the version of Flash out of date at the time of the campaign (True/False)?
- Current Adobe Flash Version - Version of software reported as current by the vendor
- QuickTime Version - The version of Quicktime in use
- QuickTime Vulnerable - Is/was the version of Quicktime out of date at the time of the campaign (True/False)?
- Current Quicktime Version - Version of software reported as current by the vendor
- RealPlayer Version - The version of RealPlayer in use
- RealPlayer Vulnerable - Is/was the version of RealPlayer out of date at the time of the campaign (True/False)?
- Current RealPlayer Version - Version of software reported as current by the vendor
- Java Version - The version of Java in use
- Java Vulnerable - Is/was the version of Java out of date at the time of the campaign (True/False)?
- Current Java Version - Version of software reported as current by the vendor
- Silverlight Version - The version of Silverlight in use
- Silverlight Vulnerable - Is/was the version of Flash out of date at the time of the campaign (True/False)?
- Current Silverlight Version - Version of software reported as current by the vendor
- Windows Media Player Version - The version of Windows Media Player in use
- Windows Media Player Vulnerable - Is/was the version of Windows Media Player out of date at the time of the campaign (True/False)?
- Current Windows Media Player Version - Version of software reported as current by the vendor
- Various columns entered here - depending on Custom Properties Uploaded
- Phishing Template - Name of the Phishing Template sent to the user from the campaign