Exporting Reports
This page explains how to export BaseQR analytics for sharing and offline analysis. Exports support common formats and include the filters and report types you select.
Purpose
• Share results — Provide stakeholders with a snapshot of campaign performance.
• Analyze offline — Use spreadsheets or BI tools to explore trends alongside other datasets.
• Archive — Keep periodic records for comparisons over time.
Export options
• Formats — CSV, Excel, and PDF.
• Scope — Exports reflect your current filters (date range and, if set, campaign).
• Report types — Total Scans, Device Breakdown, Location Breakdown, and Time Patterns.
Filters and scope
• Date range — Choose the window to include (for example, last 7 days, this month, custom).
• Campaign filter — Optionally restrict to a single campaign for focused reporting.
• Code detail — For a specific QR code, export from its detail context to include only that code’s data.
Report types and columns
• Total Scans — Date, Campaign, Code (name/ID), Total Scans. Use for volume and trend summaries.
• Device Breakdown — Date, Campaign, Code, Device/OS, Total Scans. Use to compare iOS vs. Android performance.
• Location Breakdown — Date, Campaign, Code, Country/Region/City (as available), Total Scans. Use for regional patterns.
• Time Patterns — Hour-of-day or Day-of-week aggregates with Total Scans. Use for scheduling and staffing insights.
How to export
1. Open Reports — Set the date range and, if needed, select a campaign.
2. Choose report types — Select one or more (Total Scans, Devices, Locations, Time Patterns).
3. Select a format — CSV/Excel for analysis; PDF for shareable snapshots.
4. Export — Download the file and verify contents before distribution.
Quality checks before sharing
• Filters — Confirm the date range and campaign scope match the intended audience.
• Consistency — Ensure UTM conventions in your campaign(s) are consistent so downstream GA4 comparisons are clean.
• Notes — If a destination or UTM change occurred mid-period, add a brief note alongside the export for context.
Working with GA4
• Align by UTMs — Filter GA4 by utm_campaign, utm_source, and utm_medium to compare GA4 sessions and conversions with BaseQR scan exports.
• Expect differences — BaseQR counts scans; GA4 counts sessions after page load. Compare trends and rates rather than exact totals.
Troubleshooting
• Empty or partial data — Expand the date range or remove the campaign filter; confirm scans exist for the selected window.
• Column mismatches — Re-export with the correct report type(s); each export includes only its selected columns.
• Large files — Use CSV or limit the date range, then aggregate in your spreadsheet or BI tool.
Best practices
• Standardize cadence — Export on a consistent schedule (for example, weekly or by flight) to simplify reviews.
• Pair with context — Share the export alongside the campaign description (goals, placements, UTM plan) for quicker interpretation.
• Retain source files — Keep exports in a shared location for auditability and year-over-year comparisons.