Data Quality
Checking for sample imbalance in an ecommerce experiment
Compare observed experiment units with the planned split, trace where imbalance begins and decide whether the store-test result can be used.
Section
Data Quality
Data Quality
Checking product IDs across tracking events
Audit item IDs from product view through purchase. Find parent and variant switches, missing IDs and catalogue mapping changes.
Data Quality
Connecting sales analysis with stock availability
Join variant order lines to dated orderability intervals and keep uncertain stock periods visible before comparing sales rates.
Data Quality
Detecting missing currencies and order values
Check purchase events for usable currency and value fields, distinguish genuine zeroes from missing data, and trace exceptions to orders.
Data Quality
Ecommerce data quality
Check the definitions, completeness, consistency and freshness of ecommerce data before using store reports to make decisions.
Data Quality
Filtering internal and test orders from reports
Classify simulated and real test orders, apply report exclusions consistently, and understand the limits of internal-traffic filters.
Data Quality
Handling incomplete histories in a customer-value report
Separate short follow-up, missing earlier orders, uncertain identity and unsettled adjustments in customer-value reports.
Data Quality
Identifying search terms that return no useful products
Find onsite searches with empty or weak results, inspect the products shown and choose a measured fix.
Data Quality
Linking returns to product-level performance
Link recorded physical returns, reasons and product-value reversals to original order lines using comparable follow-up windows.
Data Quality
Reconciling analytics revenue with store orders
Reconcile GA4 purchase value with store orders by aligning the order population, revenue metric, discounts, refunds, currency and dates.
Data Quality
Reconciling event totals across measurement tools
Align event definitions and reporting periods, match purchase records when possible, and investigate gaps between measurement tools.
Data Quality
Reviewing access to customer-level analytics
Review who can view or export identifiable store data, check effective permissions and record a decision for each grant.
Data Quality
Showing data freshness in a store report
A report without an update time can make yesterday’s incomplete data look final. Show when each source was last processed and whether the current period may still change.