Analyze Campaign Cash and Debt by Election Cycle Playbook

TL;DR: The FEC Campaign Finance Scraper turns public OpenFEC records into a repeatable campaign cash analysis dataset for policy analysts. It accepts focused discovery inputs, saves structured evidence, deduplicates records, and exposes explicit result limits. Use it when a browser export or a one-off script would make comparisons difficult to reproduce. Keep dated snapshots, validate row counts, and join additional security or ownership evidence separately instead of stretching public-source data beyond what it proves.

Why scrape OpenFEC for cycle analysis?

campaign cash analysis replaces manual catalog checks with comparable, time-stamped evidence. A source website answers one question at a time, while policy analysts usually need to compare a cohort, repeat the same query next week, and explain why an option was shortlisted. The useful unit is therefore not a screenshot; it is a stable table with provenance.

The OpenFEC record contributes candidate identity, office, state, party, election years, principal committee identity, totals availability, cycle coverage, aggregate receipts, aggregate contributions, spending, cash, and debt. Those fields support discovery, triage, trend analysis, and watchlists without claiming that popularity proves security or product quality. The official OpenFEC API documentation describes the source and its public access model. Apify's Tasks documentation explains how tested inputs become repeatable scheduled jobs.

This workflow is especially useful when the decision has a defined population and cadence: defined research cohorts, regulated records, funded projects, or identities that require review. Start with a narrow question, retain the raw evidence, and calculate rankings downstream. That separation keeps collection reproducible and analysis revisable.

How does this compare to the alternatives?

A purpose-built Actor gives cycle analysis a smaller operational surface than maintaining a custom collector. The source itself remains authoritative; the Actor standardizes extraction, limits, deduplication, and delivery.

Method	Commercial model	Reliability	Setup time	Ongoing maintenance
DIY Python script	Engineering time plus hosting	Depends on local retry and schema handling	Hours to days	Owned by your team
Generic scraping API	Usage or subscription	Page-oriented and source-dependent	Hours	Selectors and pagination remain yours
Thirdwatch Actor	Pay per saved result	Source-specific validation and retries	Minutes	Managed listing and schema updates

The DIY route can be appropriate for a deeply customized internal system. A generic API helps when rendered pages are the only source. For public public-source data, the actor page offers a direct path with inputs that match the actual collection modes and output shaped for datasets.

How to run campaign cash analysis in 5 steps

What question should the dataset answer?

The first step is to write one decision question with a defined population and review cadence. Examples include identifying maintained options, monitoring a production watchlist, or comparing activity within one category. Avoid a query like "all software," because a large result set makes neither the inclusion rule nor the refresh strategy clear.

Write down the audience, expected result range, fields required for the decision, and what happens when a value changes. That short contract prevents silent scope expansion. For market research, discovery queries are appropriate. For governance, exact names are usually stronger because the cohort should not drift between runs.

Which Actor input should I use?

Use discovery inputs for broad research and exact-name inputs for fixed watchlists. The Actor schema exposes only supported fields, and the default limits keep the first run small. This example combines the modes supported by this Actor:

{"queries":["Smith"],"candidateIds":[],"cycle":2026,"office":"S","includeTotals":true,"maxResultsPerQuery":25,"maxResults":25}

Keep separate Tasks when two queries represent different business questions. Combined runs deduplicate by candidateId, which is useful for a canonical table but can hide query membership. If membership matters, store a bridge table containing query, key, run ID, and collection time.

How do I run it through the Apify API?

The Apify client can start the Actor and return its dataset in one reproducible script. Put the token in an environment variable rather than source control.

import os
from apify_client import ApifyClient

client = ApifyClient(os.environ["APIFY_TOKEN"])
run = client.actor("thirdwatch/fec-campaign-finance-scraper").call(
    run_input={
        "queries": ["Smith"],
        "candidateIds": [],
        "cycle": 2026,
        "office": "S",
        "includeTotals": true,
        "maxResultsPerQuery": 25,
        "maxResults": 25,
    }
)
items = list(client.dataset(run["defaultDatasetId"]).iterate_items())
print(f"saved {len(items)} records from run {run['id']}")

For production automation, set an explicit timeout, log the run ID, and fail the downstream load if the Actor run is not successful. The Apify API documentation covers run and dataset endpoints for non-Python clients.

How should I validate the returned records?

Validation should check identity, evidence URLs, counts, and the fields required by the decision. Do not reject a row merely because an optional description or popularity metric is null. Public datasets contain records of different ages and publishing practices, so optional-field completeness is not uniform.

required = ["candidateId", "sourceUrl", "source"]
bad = [row for row in items if any(not row.get(field) for field in required)]
if bad:
    raise ValueError(f"{len(bad)} rows failed identity validation")
if len(items) == 0:
    raise ValueError("The run returned no evidence; keep the previous snapshot")

Add range checks for counts, parse timestamps into UTC, and compare current volume with the previous successful run. A sudden collapse often indicates a changed query, upstream outage, or rate limit,not a real market event.

How do I schedule and store the snapshots?

A saved Task turns the tested input into a stable collection contract. Choose a cadence that matches the signal: daily for release watchlists, weekly for operational portfolios, and monthly for market maps. Write each successful run to an immutable dated partition before updating a current-state table.

Use candidateId as the natural key, collected_at as snapshot time, and the source URL as evidence. Calculate changes after ingestion: new records, removed records, version transitions, activity changes, and rank movement. Alert only on changes tied to a decision; indiscriminate alerts teach teams to ignore the feed.

What does the OpenFEC output look like?

The output preserves a canonical identity and the public metadata needed for cycle analysis. A representative record looks like this:

{"candidateId":"S8FL00216","name":"BARTLETT, HAMILTON ALLEN SMITH","office":"Senate","party":"REP","totalsStatus":"available","receipts":3852434.85,"disbursements":831532.74,"totalsCycle":2026,"source":"Federal Election Commission public data"}

The candidateId field is the durable join key. The sourceUrl is the human-review path, while source identifies the upstream system. Dates, classifications, amounts, status fields, and source identifiers are snapshot evidence. Keep the raw row even if a downstream model uses only a subset; reprocessing is cheaper and more defensible than recollecting historical state.

Common pitfalls in campaign cash analysis

The most common failure is treating public-source data as a complete risk or quality verdict. Federal law restricts sale or commercial use of individual contributor information. This Actor intentionally returns no donor rows, names, employers, occupations, locations, or contact details.

Other pitfalls include mixing discovery and watchlist rows without recording mode, overwriting the previous good snapshot after an empty run, comparing rank across different query caps, and alerting on mutable tag names without retaining immutable version or digest evidence. Rate limits also make aggressive concurrency counterproductive.

Use explicit limits, stable queries, UTC collection times, and immutable snapshots. Join review decisions and external evidence in separate, attributed tables. The Thirdwatch Actor handles bounded requests, retries, deduplication, and public-source normalization; your downstream model remains responsible for the business decision.

Related use cases

These adjacent workflows extend the same evidence-first collection pattern. Continue with:

• Compare Fec Candidate Finance Totals
• Monitor Fec Candidate Receipts And Spending
• Build Fec Candidate Committee Dataset
• Build an npm package intelligence dataset
• Explore all Thirdwatch data workflows
• Read the business-data scraping guide

Source boundary and responsible use

The Actor never calls individual-contributor endpoints and removes treasurer, agent, phone, and address fields. With the shared DEMO_KEY, candidate discovery uses the official FEC cycle candidate-master file; supplied keys use live OpenFEC search. Totals depend on filing coverage and amendments. Each row reports totalsStatus, and a private OpenFEC key supports steadier enrichment at scale.

Federal law restricts sale or commercial use of individual contributor information. This Actor intentionally returns no donor rows, names, employers, occupations, locations, or contact details. The Actor saves a source URL and input query with every record so reviewers can trace a finding. Keep the unmodified dataset alongside any derived score, and label internal judgments as analysis rather than source facts.

Operate a watchlist as a controlled cohort

For campaign cash analysis, discovery and monitoring should be different Tasks. Discovery can use broad phrases and change over time. A watchlist should use stable identifiers whenever the source supports them, with an owner and review reason for every member.

Maintain a small control table containing identifier, date added, owner, purpose, expected cadence, and removal status. Join each successful OpenFEC snapshot to that table. Report watchlist identities missing from the source separately from source identities missing from the watchlist; those conditions have different causes and owners.

Review stale entries on a fixed cadence. Do not silently drop a record because one run omitted it. Mark the first missing date, confirm the source page, and keep history after removal. A useful watchlist explains both current state and how the cohort changed.

Compare alternatives without inventing a score

A defensible comparison begins with a decision matrix whose columns precede the data. Write the must-have constraints first, followed by evidence fields and then preference fields. Hard constraints might include runtime compatibility, public source availability, an approved license, recent maintenance, or a specific provider. Adoption counts and ratings usually belong later because they help prioritize review but rarely determine eligibility alone.

Normalize every candidate to one row and retain the original values beside derived values. Timestamps should use UTC, counts should remain numeric, and version strings should remain untouched even if a secondary parser creates comparable segments. Record why a field is comparable. Two catalogs may use the word "downloads" for different windows, so cross-source totals should not be ranked without a common definition.

Avoid a single opaque composite score. Present the hard-constraint result, evidence coverage, and preference measures independently. If stakeholders insist on weighting, publish the weights and run a sensitivity check. A candidate that wins only under one narrow weighting scheme is not a robust winner. Showing the top three across several plausible weight sets makes tradeoffs visible.

Review outliers on their canonical pages. Extremely high counts can reflect age, bundles, automation, or transitive use. A newly released option can look weak despite strong technical fit. Conversely, a popular record can be abandoned or incompatible. Add a short reviewer note instead of trying to force every nuance into a numeric field.

Freeze the comparison input and collection date when a decision is made. Future runs should create new versions rather than silently revising the old table. That makes it possible to explain both the original choice and whether later evidence justifies reconsideration. The collector supplies consistent public facts; the matrix, policy rules, and accountable reviewer produce the decision.

Comparison evidence thresholds

Require every shortlisted alternative to meet the same minimum evidence threshold. If one option lacks a repository, compatibility declaration, or recent timestamp, show the gap rather than filling it from an unrelated source without attribution. A separate enrichment table can join trusted evidence later while keeping provenance clear.

Run the comparison once without popularity measures. If the shortlist changes completely after installs, downloads, stars, or ratings are introduced, discuss that dependence explicitly. Popularity may reduce operational uncertainty, but it can also overpower requirements that matter more. The final memo should state which facts were decisive, which were tie-breakers, and which remained unknown.