Monitor usage

The Usage dashboard shows validation activity recorded by the app, helping you monitor:

• Total validations
• Success rate
• Valid, invalid, and error counts
• Confidence distribution
• Recent validation requests

Select time frame

Use Select time frame to show usage from:

• 1 hour
• 24 hours
• 7 days
• 30 days

Select Refresh to reload the dashboard.

Validation statistics and success rate

Use Validation statistics and success rate to compare activity across:

• Address validation
• Email validation
• Phone validation

Each product section shows total validations, success rate, and the count of valid, invalid, and error outcomes.

Confidence distribution

Use Confidence distribution to review the distribution of validation confidence values for Address, Email, and Phone activity in the selected time frame.

Recent validation requests

Use Recent validation requests to review the last 10 recorded requests for each product:

• Address (last 10 requests)
• Email (last 10 requests)
• Phone (last 10 requests)

Usage tables

The dashboard reads from app-owned usage tables:

Each single-record call creates a usage row with interface_type set to record. Each completed or partially completed bulk job creates a usage row with interface_type set to bulk.

Query usage from SQL

SELECT
  execution_time,
  interface_type,
  source_table,
  output_table,
  total_records,
  valid_records,
  invalid_records,
  error_count,
  processing_time_seconds
FROM EXPERIAN_DATA_VALIDATION.CONFIG.email_usage_stats
ORDER BY execution_time DESC
LIMIT 20;

Aggregate usage by validation type:

SELECT 'address' AS validation_type, SUM(total_records) AS total_records
FROM EXPERIAN_DATA_VALIDATION.CONFIG.address_usage_stats
UNION ALL
SELECT 'email', SUM(total_records)
FROM EXPERIAN_DATA_VALIDATION.CONFIG.email_usage_stats
UNION ALL
SELECT 'phone', SUM(total_records)
FROM EXPERIAN_DATA_VALIDATION.CONFIG.phone_usage_stats;