UC-1
Every legislator wants to know what you do for their district. Answer for all 82 counties at once.
Turn coverage, membership, digital reach and education data into a county-by-county case your government-relations team can hand to any member of the legislature.
- Who this is for
- Executive Director · Government Relations
- When it comes up
- The state budget session. In Mississippi that runs January to April, so the case has to exist by early January.
Sound familiar?
Three things we hear in almost every conversation.
- “A senator from a rural county asks what we do for her district. I have a statewide number and an anecdote.”
- “Our appropriation was cut twenty percent and I could not show, county by county, what that money bought.”
- “The coverage map lives with the chief engineer, membership lives in the CRM, and nobody has ever put them on the same page.”
What it runs on
The data you already have.
A connector pulls on a schedule. An upload is the export you already download — dropped in, profiled and cleaned on arrival. We label which is which because there is no live connector for Nielsen, streaming providers, podcast hosts or donor CRMs yet, and pretending otherwise would waste your time.
- Broadcast coverage by transmitterupload
- Google Analytics 4connector
- YouTube Analyticsconnector
- Membership export by ZIPupload
- Event attendanceupload
- Education / classroom usageupload
How it works
From those files to the answer, in 4 steps.
Everything gets resolved to a county
Membership ZIPs, GA4 cities, school districts and transmitter contours all describe places in different vocabularies. Entity resolution maps them onto one geography so they can be counted together.
resolve_entities · join_datasets · standardize_dates
The map draws itself
One choropleth of the whole state, shaded by whichever measure the question needs — members per thousand residents, streaming hours, classroom reach — with the underlying rows one click away.
create_geo_chart · calculate_derived_metrics
Every district gets its own page
Rather than one statewide figure, each district gets its members, its audience, its schools and its share of service, benchmarked against the state median so a rural member can see where they stand.
rank_entities · benchmark_segments · generate_kpi_card
The claims come with their evidence attached
Every number in the written summary is checked against what the analysis actually produced. Anything unsupported is removed before you read it, so nothing goes into a hearing that cannot be backed up.
build_evidence_pack · generate_insight_card
What you get
On your screen at the end of it.
- A county-level impact map for the whole state
- A one-page leave-behind per legislative district
- A live dashboard a staffer can open during a hearing
- An evidence pack behind every figure you quote
Try it with your data.
Send us your coverage map and a membership export. We will build your district pages before the session opens.
Free, no obligation, and the dashboard is yours whether or not you continue. Prefer to talk first? Book a walkthrough.
Questions
What people ask before they start.
+We do not have clean ZIP data. Does that rule us out?
No. Profiling runs first and tells you what is actually in the file — malformed ZIPs, blanks, inconsistent state codes — then suggests cleaning steps you preview before applying. Messy membership exports are the normal case, not the exception.
+Can we show this to legislators directly?
Yes. A dashboard can be shared by link or embedded in another site, and exported to PDF for a leave-behind. Share links are read-only and can be revoked.
+Does our membership data go to an AI company?
Not unless you decide it should. New organisations start with external AI processing switched off and the model able to see column names only, never values. Changing that is a deliberate, recorded, per-organisation decision.
+How long does the first version take?
If you can export coverage and membership, a working county map is usually the first afternoon. Adding education and event data is the week after.
Related