PROGnostications
Welcome to the CTA Blog, featuring how-to’s, tool insights, partner spotlights, and more (including from PROG, our mascot).
Scroll through our latests posts below or search for a topic here:
Notes from BenDesk: Incorporating Programming Elements
Is it possible to incorporate programming elements like variable settings, IF statements, or loops into my SQL queries in BigQuery?
Voter Formation Project: Case Study
Bringing together data sources from across the internet.
Notes from BenDesk: User Acces
Is it possible to give a user access to specific data in PAD without granting them access to everything in my project? If so, how can I do it?
Partner Spotlight: Pipeline Initiative
Our solve the challenging task of bringing together disparate data sources on school board districts across the country.
A Roadmap for Supporting the Community
Our roadmap for addressing the data gaps and pain points of our partners.
Our Approach to AI
CTA remains cautiously optimistic about the future of AI and its implications for political tech.
Notes from BenDesk: Granting PAD Access
Can I give access to data from another PAD BigQuery project without allowing users to access the source project itself?
Passkeys (and What They Mean For You)
What the big change coming logging into your Google accounts means for you.
Notes from BenDesk: Finding Metadata
Is there an easy way to find metadata about my projects in PAD?
Changes to Google Analytics
The long-awaited retirement of Google Analytics UA is almost here!
NotePAD: Our Comprehensive Knowledge Base
Our comprehensive knowledge base that covers a broad range of topics related to CTA’s infrastructure
BenDesk: Automating Tasks in PAD
Is there an easy way to connect and automate common data tasks in PAD?
5 Things You Can Do in PAD
Functionalities in our data warehouse that extend beyond just writing queries.
How to Create Dashboards in Looker Studio
Integrations with Looker Studio can help anyone create dashboards to analyze, understand, and present your data.
CTA + Impact Action: Building the District Dashboard
Teaming up to build a powerful data infrastructure to help Impact and their grantees make informed decisions in real-time
March Bracket Madness
We believe everyone should have easy access to their insights for decision-making, program iteration, and strategic planning.