Exporting data from Experiences by Jebbit can sometimes lead to confusion when the exported values don’t align with what's displayed in the dashboard. This article explains common discrepancies, highlights best practices for interpreting export data, and provides solutions to frequently asked questions about lead counts, redacted data, and product engagement reporting.
Before you begin
Before analyzing exports or reconciling lead data:
Confirm which regions (EU vs. Non-EU) your exports are coming from.
Determine your brand's data retention policy.
Ensure you have access to all reporting types (Attribute Report, Event-Level Report, etc.).
Coordinate with your CRM team to understand data integration points, if applicable.
Export behavior & data interpretation
Understand Lead Discrepancies between dashboard and exports
The dashboard displays all completed experience submissions, including those without email addresses and duplicates. Exported data might show fewer entries due to:
Deduplication of repeated email addresses
Exclusion of "N/A" or blank responses
Separate exports for EU and Non-EU regions
To reconcile:
Merge data from both regions
Filter out non-response entries
Apply filters to isolate unique lead entries using Attribute Level Reports
Use an Attribute Level Report to:
View all submissions (including duplicates and non-captures)
Apply filters to isolate unique lead entries
Duplicate emails in lead counts
Every submission is counted as a lead, regardless of whether the email address was previously captured.
Interpret redirect rates over 100%
Redirect rate is calculated based on total clicks. If a single user clicks multiple CTAs or links, each action counts separately, potentially pushing the rate over 100%.
Enhance export usability
To improve usability:
Open CSVs in Excel or Google Sheets
Use filters to isolate specific outcomes
Build pivot tables to summarize results
Identify unique users in exports
Export an Attribute Report with these fields:
Client User ID
User Session ID
This allows identification of distinct users and sessions. Use Event-Level Reports to track session-level interactions
Understand redacted data in exports
Personal data is redacted after 12 months or according to your brand’s data retention policy. Once redacted, data is unrecoverable unless it was stored in an integrated CRM.
To maintain data access:
Schedule recurring exports via Report Center
Coordinate retention policies with your organization
Adjust time zones in exports
All CSV exports default to UTC. Use Excel to convert:
Save the file in Excel
Use a formula to shift timestamps to your local time zone (e.g., UTC+7)
Analyze product recommendations and engagement
Use the Event Level Report to track:
Product clicks and views
User interaction per product
Use the Aggregated Product Feed Data export to monitor:
Views: Number of times a product appeared
Responses: Number of clicks
Response Rate: Clicks divided by views
FAQ
Why can’t I see my survey responses in Jebbit?
If survey responses aren’t appearing, it might be because of a permissions issue. Check that your account role has the correct access rights to view responses. If not, ask an administrator to update your permissions. Once the proper access is granted, your survey responses will be visible.
How can I fix the issue with the CSV file not being delimited correctly in Excel?
This issue may be due to the delimiter settings. Assuming you are using Excel to access the CSV, the default delimiter might be different. Excel doesn't always assume the delimiter as a comma. To fix this, import the CSV explicitly in Excel by opening a blank Excel sheet, selecting Data > Get External Data > From Text > CSV, and choosing comma as the delimiter. Additionally, if you are on a Windows machine, go to Control Panel > Region > Additional Settings and change the "List separator" to a comma or to match your CSV.
Next steps
Schedule ongoing reports via the Report Center.
Align with your CRM and data governance teams for longer-term strategies