skills.rest
canyouseeus
canyouseeusCOMMUNITY
Explore all skills by this author →
GitHub

revenue-data-validator

Filter test revenue data across affiliates, gallery, and subscriptions using SQL.

Updated Nov 9, 2025
Search Tags:#subscriptions#dashboard#sql#test-data#revenue#data-validation#affiliates
One-click install
npx skills add https://github.com/canyouseeus/thelostandunfounds --skill revenue-data-validator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: revenue-data-validator
Source: https://github.com/canyouseeus/thelostandunfounds/tree/main/.agent/skills/revenue-data-validator
Command: npx skills add https://github.com/canyouseeus/thelostandunfounds --skill revenue-data-validator

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Identifies and filters test/dummy revenue data that inflates platform metrics across all revenue streams (affiliates, gallery, subscriptions).

Core Features & Use Cases

  • Affiliate Revenue Validation: Detects test emails, pre-launch dates, round-number earnings, and missing conversion records.
  • Gallery Revenue Validation: Filters orders from test emails and early-stage development orders; validates completed payments.
  • Subscription Revenue Validation: Flags test/admin user subscriptions and pre-launch subscriptions.
  • Implementation notes: Uses SQL queries to isolate real revenue and a dashboard-ready filter for production dashboards.

Quick Start

Identify and filter test revenue records across affiliates, gallery, and subscriptions to reveal real revenue.

Frequently Asked Questions about revenue-data-validator

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I filter test revenue data from my platform metrics?▼

To filter test revenue data, you apply SQL queries and dashboard filters across all revenue streams to identify dummy records. This process isolates real earnings by checking for non-production accounts, pre-launch dates, and round-number earnings.

What is the best way to validate affiliate revenue for test accounts?▼

Validating affiliate revenue involves detecting test emails, pre-launch dates, and missing conversion records. Applying these criteria flags dummy affiliate earnings, ensuring your dashboard metrics reflect only verified production revenue.

How do I exclude pre-launch subscription and gallery orders from revenue dashboards?▼

Excluding pre-launch subscription and gallery orders requires applying launch-date gating and validating completed payments. This filters early-stage development orders and admin user subscriptions, leaving only real revenue in your dashboards.

Can I use SQL to flag dummy revenue records across multiple streams?▼

Yes, you can use SQL to flag dummy revenue records across multiple streams. The SQL queries identify test indicators and apply a maintainable is_test_data flag to mark or isolate test records from production data.

Why are round-number earnings inflating my platform revenue metrics?▼

Round-number earnings inflate platform revenue metrics because they are often generated by test or dummy accounts. Filtering these specific test indicators alongside non-production accounts removes the artificial inflation from your data.

Related Skills

Explore More Data & Analytics Skills→
avansaberavansaber
87

violart2claw

Validate database schemas for monetary columns using real or float data types.

Official
Basic
Ryko1141Ryko1141

revenue-tracking

Automate revenue tracking and reconciliation across SaaS, commissions, and affiliate income.

Community
Advanced
fall-development-robfall-development-rob
7

FMP News Intelligence

Monitor and aggregate financial news and press releases across equities, crypto, and forex.

Community
Intermediate
UlanxxUlanxx

canary

Monitor live URLs for console errors, performance regressions, and page failures.

Community
Advanced