Lucid Measurement offers multiple data export options, equipping you with more tools to get the most out of working with Lucid. These exports are available via the download icon in the upper-right corner of the UI.
Any filters applied in the UI will be retained in the data exports.
Export raw data (.csv)
A respondent-level raw data file containing all the underlying information that powers the Impact Measurement. Listed below are the data fields available in the raw data export:
Lucid respondent identifier
Survey completion date and time
Respondent demographic profile
Age
Gender
Income
Job industry
Ethnicity
Hispanic
Zip code
State
Region
Education level
Occupation status
Impression metadata
Ad length*
Creative ID
Creative name
Creative group name
Custom variables (c1-c5)
Daypart*
Frequency
Group (exposed or control)
Impression date
Network**
Placement ID
Placement name
Placement group name
Site ID
Site name
Site group name
Tracked media
Device
Media channel
Frequency
*Only included for campaigns that measure linear tv exposures.
**Data will be included under the header for Placement ID
Survey question responses
Weight
Strata
For questions with a multi-select format, there is a column for each answer choice for the question; the header row will be in the format of “Answer choice: KPI name” (example: “Brand name: brand awareness”). Please reach out to your Lucid Project Success Manager for the mapping values if needed. The raw data .csv provides users a way to create custom calculations using your campaign data.
See calculating lift from raw data file for more information.
Export summary report (.xlsx)
A tabbed spreadsheet containing lift percentages and sample counts for each brand KPI. When this option is selected, the report is emailed to the user that requested it. Please note, the email may take up to 10 minutes to arrive. For each brand KPI, the summary report generates a data table for the following:
Overall
Demographics
Gender
Age
Household income
Impression data
Ad length*
Creative
Cross platform*
Daypart*
Frequency
Network*
Placement
Site
Device
The minimum sample threshold for lift calculation is fifty exposed completes.
The excel summary report shows the exposed, control, lift % breakout and sample counts by KPI and KPI answers for all of the different breakouts listed above. This provides a detailed overview of your campaign’s performance by demographic and media variable breakouts.
Export powerpoint report (.ppt)
A powerpoint deck with the key results and reports from the live or completed campaign. The powerpoint deck is emailed to the account of the user who requested it. The email will be delivered within 10 minutes and the link to download will be valid for 3 days.
The email cannot be specified.
The following key data tables and visuals of your brand lift analysis is included in a Lucid branded powerpoint:
How impact measurement works
The campaign and study details (campaign dates, impressions tracked, sample collection, tracked media, brand lift KPIs measured)
Study results (bar charts and data tables where appropriate)
Executive summary
Overall performance
Media and audience insights
Different from the UI, this will show up to 5 top insights depending on the number of insights with enough sample (50+ completes)
Target audience(s) included – one slide for each
Age breakdown by KPI
Gender breakdown by KPI
Frequency breakdown by KPI
Cross-platform breakdown by KPI
Once the deck is exported, it is fully customizable.
The powerpoint export is a quick and easy way to share a powerpoint deck with the key results and insights.