Reporting & Analytics

Ask a question. Get a report.

Type a question in plain language — “How many products are missing GTINs?” or “Show me supplier response rates by category.” The AI writes and executes a read-only SQL query against your entire dataset, then presents the results as formatted tables, summaries, and visualisations. No report builder. No dashboard configuration. Just answers.

Products, suppliers, compliance status, scan patterns, and more — all queryable by conversation.

AI-designed infographics

The platform generates visual infographics rendered as PNG images. Multi-chart layouts combine bar charts, pie charts, line charts, KPI boxes, and data tables in a single graphic. The AI extracts your brand palette from your website and applies it automatically — or falls back to a professional default if no brand colours are configured. Product distribution by category, compliance readiness overview, QR scan geographic heatmaps, supplier response rates. All generated on demand.

Saved reports

Every generated report is saved and accessible from the reports section with thumbnail previews. Re-run any saved report to get updated data. Delete outdated reports. Build a library of recurring analyses without recreating them each time.

Scan analytics dashboard

QR code scan data is aggregated by date, country, and device type. Configure time windows. See geographic distribution of scans across markets. Break down traffic by device and browser. Bot detection filters out automated traffic so you see real consumer engagement. Every scan captured by the resolver flows into this dashboard — giving you visibility into where your products are being scanned, how often, and by whom.

What questions can the AI analytics answer?

The reporting AI has read-only SQL access to your entire dataset. This means any question you can ask about your products, suppliers, compliance status, or scan patterns, the AI can answer. It writes the query, executes it, and presents the results.

Examples of questions brands ask in practice:

• “How many products are missing GTINs?” — the AI queries the product table, counts records without GTIN values, and lists them by name and SKU
• “What is the average supplier response time by category?” — the AI joins data requests with supplier categories, calculates mean response times, and ranks them
• “Which products have the highest carbon footprint?” — the AI queries environmental data, ranks products by total CO2 emissions, and shows the breakdown by Scope 1, 2, and 3
• “Show me all suppliers who have not responded to data requests in the last 30 days” — the AI filters pending requests by date and returns supplier names, request categories, and days elapsed
• “What percentage of our product catalogue has complete DPP data?” — the AI checks each product against the 15 EPRS data categories and calculates completeness

The AI presents results as formatted tables with totals and summaries. For visual answers, it generates charts and infographics on demand.

How do the AI-generated infographics work?

The infographic generator creates multi-chart PNG images that combine different visualisation types in a single graphic. A typical infographic might include a bar chart of product distribution by category, a pie chart of compliance status, KPI boxes showing headline numbers, and a data table with detail rows.

The AI automatically applies your brand palette. It analyses your company website to extract colours, and uses them for chart fills, backgrounds, and typography. If no brand colours are configured, it falls back to a professional default palette.

Common infographic types:

• Compliance readiness overview — a visual summary of your 8-stage compliance score with progress bars and status indicators
• Product distribution by category — bar or pie chart showing how your catalogue breaks down by GS1 GPC classification
• QR scan geographic heatmap — where in the world your products are being scanned, aggregated by country
• Supplier response rates — which suppliers have responded to data requests and which have not, broken down by category and status
• Environmental data summary — carbon footprint distribution across your product range, with Scope 1/2/3 breakdown

Infographics are saved to your reports library and can be re-run at any time to reflect updated data.

What does the scan analytics dashboard show?

Every QR code scan that passes through the GS1 resolver generates an analytics record. The scan analytics dashboard aggregates these records into actionable views:

Time-series analysis. See scan volume over time — by day, week, or month. Identify trends, seasonal patterns, or spikes following marketing campaigns or product launches.

Geographic distribution. Scan data includes IP geolocation (city, country, region, coordinates). See which markets are engaging with your products. A fashion brand might discover that scans are concentrated in France and Germany but nearly absent in Scandinavia, informing market strategy.

Device and browser breakdown. Understand how consumers are scanning — iPhone vs Android, Chrome vs Safari, mobile vs desktop. This data informs the design of your DPP consumer pages.

Bot detection. Automated scrapers, search engine crawlers, and monitoring tools generate scans that are not real consumer engagement. The dashboard filters these out so your metrics reflect actual human interaction.

Product-level drill-down. See which specific products are receiving the most scans. High-scan products may warrant more detailed DPP pages or additional sustainability data.

How can DPP analytics inform business decisions?

DPP scan data is a new source of consumer insight that did not exist before digital product passports. Every scan is a signal that someone cared enough to point their phone at your product and learn more. This data supports several business functions:

Sustainability reporting. Track consumer engagement with your sustainability disclosures. Report to your board or ESG stakeholders that X thousand consumers accessed your product passport data in Q3, with Y% growth quarter-over-quarter.

Market intelligence. Geographic scan data tells you where consumers are engaging with your products. If you see high scan volumes in a market where you have not invested in marketing, that is a signal worth investigating.

Supply chain validation. Cross-reference scan locations with your distribution records. If products are being scanned in markets where they were not intended to be sold, that could indicate parallel imports or distribution issues.

Product development. Which products get the most scans? Which DPP data categories do consumers spend the most time viewing? This feedback loop can inform product design, labelling decisions, and sustainability investments.

For a deeper look at how AI transforms supply chain data analysis, see our post on AI-powered supply chain data analysis.

How Aura helps

Most DPP platforms treat reporting as an afterthought — a static dashboard bolted onto the side. Aura builds analytics into the core of the platform. The AI has direct access to every data table, so there is no lag between data collection and insight. Ask a question, get an answer in seconds.

The combination of conversational analytics, brand-styled infographics, saved reports, and a dedicated scan dashboard means you do not need a separate business intelligence tool. Your DPP data, compliance scores, supplier response rates, and consumer engagement metrics are all queryable from one interface.

Reports generated in Aura can be shared with executive stakeholders, included in sustainability disclosures, or used to drive internal project prioritisation. The data is always live, always current, and always specific to your products.

Frequently asked questions

Do I need to know SQL to use the reporting features?

No. The AI translates your natural language questions into SQL queries automatically. You ask “How many products are missing carbon data?” and the AI handles the query construction, execution, and result formatting. The underlying SQL is available for technical users who want to inspect it, but it is never required.

Can I schedule reports to run automatically?

Currently, reports are generated on demand through the AI chat interface. Saved reports can be re-run at any time to get updated data. Scheduled report delivery is on the product roadmap for a future release.

What data is included in the scan analytics?

Every scan record includes: product identification (GTIN, serial, lot), source URL, resolved URL, HTTP response code, IP geolocation (city, country, region, coordinates), device type (mobile, desktop, tablet), browser and OS details, and bot detection flags. Personal data is not collected — the analytics capture device and location metadata, not user identity.

Can I export reports and infographics?

Yes. Infographics are generated as PNG images and can be downloaded directly. Report data can be exported through the AI chat — ask for a summary and the AI produces formatted output suitable for presentations, sustainability reports, or internal dashboards.