Exports
Last updated
Last updated
LUCY provides a versatile data export functionality, accessible through the "Export" option within the campaign overview page. Users have the flexibility to export either all monitored data or select specific data for export. This feature supports a range of formats and methodologies, catering to various user needs.
Navigate to a Campaign -> Results -> Exports
All exports are available in either CSV or XML format.
This option exports data for recipients within a specified time range to a new group. This is useful for creating segments of recipients who have been active or participated within a certain period, and facilitating targeted follow-up campaigns or analyses.
The Benchmark export provides a snapshot of campaign performance by compiling key metrics like message delivery, open rates, click-throughs, and overall success rates into a comprehensive report.
This export option compiles a detailed log of user interactions from the campaign, recording entries like timestamps, participant details, associated scenarios, and specific user-submitted information, exemplified by login credentials.
Automated Exports is a functionality that allows for the scheduled and recurrent generation of reports based on predefined criteria and intervals.
Navigate to a Campaign -> Results -> Automated Exports
Export Target: Choose data sets to automate, like All Victims, Not Succeeded, Clicks Data, or Campaign Benchmark.
Export Frequency: Set the frequency for the export—daily, weekly, monthly, or yearly.
Export Time: Decide the specific time of day for the export to run.
Export Days: Specify which days the export should occur, based on the chosen frequency.
Export Type: Select the format of the exported file, such as XML or CSV.
This tool is designed to regularly provide fresh data without manual effort, aiding consistent and timely analysis sent directly to the email address of the campaign creator.
API Integration: LUCY offers API access for users preferring automated data retrieval.
Lucy provides many exportable data points, covering aspects from recipient information to interaction metrics, such as:
Personal and contact information (name, email, phone number)
Engagement metrics (clicks, submissions, training completion)
Campaign specifics (scenario name, domain, staff type)
Technical data (operational system, IP, browser, plugins used)
Interaction timelines (email submission, click, report times)
Quiz and training metrics (quiz answers, training completion)
Security awareness levels
Collumn name | Description | Value Type |
---|---|---|
name
Name of the recipient
Text
Email of the recipient
Text
phone
Phone number of the recipient
Numeral
gender
Gender of the recipient
Male / Female
link
Unique link of the recipient
Text
lure_submitted_at
Time of lure email submission
Timestamp
mail_submitted_at
Time of email submission
Timestamp
clicked
Recipient clicked the link in the email
Yes / No
clicked_at
Time recipient clicked the link in the email
Timestamp
succeeded
Success action triggered for the recipient
Yes / No
succeeded_at
Time when success action was triggered
Timestamp
trained
Recipient has completed the training
Yes / No
trained_at
Time when recipient has completed the training
Timestamp
reported
Recipient has reported the message via LUCY Report Plugin
Yes / No
reported_at
Time when recipient has reported the message
Timestamp
domain
Domain used in the campaign's scenario
Text
scenario
Name of the scenario on the campaign
Text
staff_type
Info about recipient's staff category
Text
location
Info about recipient's location
Text
division
Info about recipient's department
Text
comment
Additional optional comment about the recipient
Text
os
Operational System of the workstation that submitted first click
Text
ip
IP of the workstation that submitted first click
Numeral
proxy_ip
IP of the proxy
Numeral
browser
Browser of the workstation that submitted first click
Text
plugins
Plugins detected on the workstation that submitted first click
Text
country
Country based on IP
County Code
success_rate
How many times a recipient was successfully attacked, depending on the Success Action
Numeral
click_rate
How many times a recipient clicked the attack link
Numeral
scenario_time
Amount of time the victim has spent on the phishing link page
Numeral
awareness_time
Amount of time the victim has spent on the awareness link page
Numeral
email_subject
Subject of the sent email
Text
first_click_after_delivery
Time value in seconds between mail_submitted_at and succeeded_at
Numeral
first_report_after_delivery
Time value in seconds between mail_submitted_at and reported_at
Numeral
reminder_click_submitted_at
Time when recipient clicked the reminder link
Timestamp
reminder_training_start_submitted_at
Time when the recipient started the training provided by reminder
Timestamp
reminder_training_finish_submitted_at
Time when the recipient finished the training provided by reminder
Timestamp
downloaded_files
File-based attack downloaded files by the recipient
Text
collected_data
The data that has been submitted by the recipient on the landing page
Text
out_of_office_at
Time of Out of Office autorespond
Timestamp
bounced_at
Time of the Bounced response
Timestamp
responded_at
Time of the incoming response to the email
Timestamp
certificate_received
Recipient has received a certificate
Yes / No
training_with_quiz_passed
Recipient has passed a training with Quiz mode enabled
Yes / No
training_with_quiz_passed_at
Time when recipient has passed a training with Quiz mode enabled
Timestamp
training_noquiz_finished
Recipient has finished a training without Quiz
Yes / No
training_noquiz_finished_at
Time when recipient has finished a training without Quiz
Timestamp
security-level
Level of awareness security
Numeral
answers_count_0
Quiz answers count
Numeral
answers_percent_0
Quiz answers percentage (based on total number of questions)
Percentage
correct_answers_count_0
Number of correct quiz answers
Numeral
correct_answers_percent_0
Correct answers percentage (based on total number of questions)
Percentage
wrong_answers_count_0
Number of wrong quiz answers
Numeral
wrong_answers_percent_0
Wrong answers percentage (based on total number of questions)
Percentage
quiz_time_spent_0
Time spent for quiz
Minutes / Seconds
training_succeeded_0
Recipient has completed the training with Extended method of tracking the end of the quiz
Yes / No
training_succeeded_at_0
Time when recipient has completed the training with Extended method of tracking the end of the quiz
Timestamp