End-to-End Analytics Audit | Dataford Interview Questions

Tell me about your methodology for conducting an end-to-end analytics audit on a high-traffic e-commerce portal.

For this exercise, audit source orders against Adobe Analytics order events and identify records requiring investigation. Compare order totals with captured event revenue and account for missing, duplicate, orphaned, and null-revenue events.

Output

One row per order or analytics order key requiring investigation.
Columns: audit_order_id, order_date, order_total, event_count, captured_revenue, and audit_status.
Include only non-OK records. Sort by audit_order_id ascending.

Schema

ecommerce_orders

Column	Type	Description
order_idPK	INT	Unique source order identifier
order_date	DATE	Date the order was placed
order_total	DECIMAL(10,2)	Source order revenue

adobe_analytics_order_events

Column	Type	Description
event_idPK	INT	Unique Adobe Analytics event identifier
order_id	INT	Order key reported by the analytics event
event_revenue	DECIMAL(10,2)	Revenue captured by the analytics event
event_timestamp	TIMESTAMPTZ	Timestamp when the analytics event was received

Your question is End-to-End Analytics Audit. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem