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.