Scan Data
Scan Data lists every scan recorded for your Dynamic QR codes. Each row is one scan. You can filter the rows, choose which columns the table shows, and export the filtered rows to Excel or CSV.
Accessing Scan Data
- Log in to QRTRAC.
- In the left sidebar, under Data, click Scan Data. It appears below Analytics.
- The page shows the filters at the top and the Scan Results (N) table below. N is the number of rows shown.
The Scan Data page with 7D selected. Sample data: the codes, names, and scans are illustrative.
Understanding the Scan Results Table
Each row is one scan. Empty values show as - in the table and stay blank in exports. Use Select Columns to show or hide any column below.
| Column | What it shows |
|---|---|
| QR Id | The ID of the QR code that was scanned. |
| QR Name | The name you gave the QR code. |
| QR Type | The type code, such as VCARD, WEB, PDF, or FORM. |
| QR Source URL | The QRTRAC link that the QR code uses. |
| Destination URL | Where scanners are sent. For Website URL, Short Link, and Multi-language codes, this is the redirect URL you set. For other types, it matches QR Source URL. |
| Tags | The QR code's tags, separated by commas. |
| Folder | The folder path, such as Folder / Subfolder. Blank if the QR code is not in a folder. |
| Owner | The user who created the QR code. |
| User Id | An identifier recorded with each scan. |
| User Name, User Company, User Email | Shown only when the scans include that information. |
| Scanned On | The date and time of the scan, in your organization's time zone. |
| Source | The source recorded with the scan. Often blank. |
| Device | The device brand, such as Apple or Samsung. |
| OS | The operating system, such as iOS or Android. |
| Browser | The browser or app that opened the QR code. |
| Country, State, City, Suburb, ZIP Code | The scanner's location, where recorded. The ZIP Code column is labeled Postcode in the dashboard and in exports. City shows the county instead when one is recorded. |
| Latitude, Longitude | Decimal coordinates, where recorded. See Location and Device Information. |
| Ip | The IP address recorded with the scan. |
| Team | Appears when the view includes teams other than your current team. |
Filtering Scan Records
The QR code and date range filters choose which scans are loaded. The column filters, search, and sorting then narrow the loaded rows.
Filter by QR code
- Click Filter applied. The number shows how many QR codes are selected.
- Check the QR codes you want, or use Select All.
The list contains your Dynamic QR Codes. When the page opens, the 10 most recently updated QR codes are selected.
Filter by date range
- 1D: today only
- 7D, 15D (default), 1M, 3M, 6M, 1Y: the last 7, 15, 30, 90, 180, or 360 days, including today
- Custom: pick a start and end date in the calendar, then click Apply. Future dates can't be selected.
After a custom range, click the reset icon next to the button to return to 15D.
The QR Codes filter open, with the date range buttons beside it
Filter by column values
- Click the filter icon (funnel) in a column header.
- Check the values to keep. Use the search box in the panel to find a value.
- Click Clear filter to remove the filter for that column.
When a column filter is active, a button next to the Scan Results heading shows the number of active filters, such as 1 filter. Click it to clear all column filters.
The City column filter, opened from the funnel icon in the column header
Search and sort
- The Search box matches text only in the columns that are currently shown. Hiding a column removes it from the search.
- Click a column name to sort. Each click cycles through ascending, descending, and unsorted.
How filters affect the results
The Scan Results (N) count shows the matching rows. When some rows are hidden, it reads Scan Results (N of M), where M is the total loaded.
If the table is empty
- No QR codes: No QR codes available to show scan data. Please create a QR code to get started.
- No scans in the selected filters: There is no scans data to display for selected filter settings. Please change date filter from above.
Multiple teams
If you belong to more than one team, a Teams filter appears. Select the teams, then click Apply. When the view includes teams other than your current team, a Team column is added to the table and to exports.
Customizing Visible Columns
- Click the gear icon next to the Scan Results heading to open Select Columns.
- Check or uncheck a column. The table updates right away.
- Use Select All or Deselect All at the top to change every column at once.
Your choice is saved in the browser you are using. It does not carry over to other browsers or devices.
The Select Columns panel, opened from the gear icon
Column selection does not change exports
Hiding a column only hides it in the table. Both export files always include every column listed below.
Exporting Scan Data
Both export buttons download the rows that match your current filters, with every column.
Export Excel Report
Click Export Excel Report. Your browser downloads Scan Data.xlsx.
- The workbook has one sheet named Scan Data.
- The header row is shaded yellow.
- Two rows below the last scan, a
Date : [date and time of export]line is added.
Export CSV Report
Click Export CSV Report. Your browser downloads Scan Data.csv.
- Values are separated by semicolons (
;), not commas, and every value is in double quotes. - The file is UTF-8 with no byte-order mark and has no date line.
Export headers
Both exports use these headers, in this order:
- Team (only when the view includes teams other than your current team)
- QR Id
- QR Name
- QR Type
- QR Source URL
- Destination URL
- Tags
- Folder
- Owner
- User Id
- User Name, User Company, User Email (only when the data includes them)
- Scanned On
- Source
- Device
- OS
- Browser
- Country
- State
- City
- Suburb
- ZIP Code (Postcode)
- Latitude
- Longitude
- Ip
Excel tip (general Excel guidance, not a QRTRAC feature): if a CSV opens with all of its text in one column, go to Data > From Text/CSV in Excel and set the delimiter to Semicolon.
A Scan Data.xlsx export with sample data. IP addresses are masked in this example.
Location and Device Information
Country, State, City, Suburb, and ZIP Code are filled in when QRTRAC records them for a scan. Some scans have no location values.
Latitude and Longitude are recorded for some scans. For the GPS Tracking setting under Advanced Settings, see How to Apply GPS Tracking on QR Code.
Device, OS, and Browser show what QRTRAC recorded for each scan.
Notes and Limitations
- Dynamic QR codes only. The QR Codes filter lists Dynamic QR Codes, so static QR codes don't appear in the QR Codes filter.
- One table, no pages. All matching rows appear in one table without page numbers.
Frequently Asked Questions
Q How can I view scan records?
A Open Scan Data from the left sidebar, as described in Accessing Scan Data.
Q Can I filter records by QR code?
A Yes, with the Filter applied menu, as described above.
Q Can I select which columns appear?
A Yes, with the gear icon. Exports still include every column.
Q Can I export scan records?
A Yes, with Export Excel Report (.xlsx) or Export CSV Report (.csv).
Q What is the difference between the Excel and CSV exports?
A They contain the same rows and columns. Excel exports an .xlsx workbook with a yellow header row. CSV exports use semicolons as separators.
Q Why might some location information be unavailable?
A Some scans have no location values because QRTRAC did not record them. Latitude and Longitude are recorded for some scans only. See the GPS Tracking setting under Advanced Settings.
Q Do static QR codes generate scan records?
A Scan Data lists Dynamic QR codes only. Static QR codes don't appear in the QR Codes filter.