ddhq-miss-audit

Classify unmatched gp_api campaigns against DDHQ election results using SQL and web verification.

3|1|Updated Feb 7, 2025
One-click install
npx skills add https://github.com/thegoodparty/gp-data-platform --skill ddhq-miss-audit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ddhq-miss-audit
Source: https://github.com/thegoodparty/gp-data-platform/tree/main/.claude/skills/ddhq-miss-audit
Command: npx skills add https://github.com/thegoodparty/gp-data-platform --skill ddhq-miss-audit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires databricks, python, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill audits and quantifies gp_api product campaigns that have no matching DDHQ election result within a given election-date window, classifying unmatched campaigns into definitive reasons.

Core Features & Use Cases

  • Audit DDHQ Campaigns: Identify and analyze campaigns that lack matching election results.
  • Reason Classification: Classify unmatched campaigns into reasons like data quality issues, missing races, or false negatives.
  • Data Processing: Uses deterministic SQL pre-pass and web-verification subagent fan-out for accuracy.
  • Output Generation: Generates external aggregate summary CSV, internal detail CSV, and confirmed-winners list.
  • Use Case: When asked to understand or quantify why product users tied to a campaign are not matched to election results.

Quick Start

Run the 'ddhq-miss-audit' skill with the election-date window '2026-01-01' to '2026-05-31'.

Frequently Asked Questions about ddhq-miss-audit

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

FAQPage Schema
How do I audit unmatched election campaigns against DDHQ results?▼

Auditing unmatched election campaigns against DDHQ results requires identifying gp_api product campaigns with no matching election data within a specific date window. This process classifies unmatched campaigns into definitive reasons like data quality issues or missing races.

Why do some product campaigns have no matching DDHQ election results?▼

Some product campaigns lack matching DDHQ election results due to data quality issues, missing races, or false negatives. An audit classifies these unmatched campaigns using deterministic SQL pre-pass and web-verification to pinpoint the exact discrepancy.

Do I need Databricks and Python to run a campaign matching audit?▼

Yes, you need a Databricks and Python environment to execute the campaign matching audit. The Skill utilizes these dependencies to run its deterministic SQL pre-pass and web-verification subagent fan-out for accurate election analysis.

What's the best way to classify unmatched campaign data in an election analysis?▼

The best way to classify unmatched campaign data is using a deterministic SQL pre-pass followed by web-verification. This approach accurately categorizes unmatched gp_api campaigns into specific reasons like data quality issues, missing races, or false negatives.

What output formats are generated when quantifying missing DDHQ election matches?▼

Quantifying missing DDHQ election matches generates an external aggregate summary CSV, an internal detail CSV, and a confirmed-winners list. These outputs provide both high-level summaries and granular details of the unmatched campaign audit.

Can I run a campaign audit for a specific election-date window?▼

Yes, you can run a campaign audit for a specific election-date window by providing start and end dates, such as 2026-01-01 to 2026-05-31. The audit identifies unmatched gp_api campaigns within that defined timeframe.