5 Integrations We’re Thankful For
The number of platforms we're able to integrate with has grown substantially in our last two years. As we look back on the year, we wanted to share the 5 integrations that we’re most thankful for:
Lyft Concierge: CTA set up an SFTP server to ingest reports generated on the platform. Lyft provides three versions of each file with different refresh cadences (daily, weekly, and monthly). CTA filters through thousands of files to only ingest the files refreshed daily to deliver the most up-to-date data.
How does this help our partners: Using Lyft data, our partners are able to see when their canvassers are using Lyft to reach their turf and can track the rides that are called for voters who need a Lyft to the polls!
BallotReady: CTA partnered closely with the BallotReady team to review, test, and migrate the files provided from CSV to Avro formats as Avro has a schema definition language, greatly improving the accuracy of importing the data types of fields. BallotReady provides CTA a bulk export of data through S3. Over time, CTA has added more BallotReady data streams as they’ve become available, now supporting the following in PAD: website clicks, candidates, referendums, and polling locations.
How does this help our partners? With BallotReady data, CTA partners gain access to comprehensive information on every officeholder, election, candidate, and polling place across the country. This empowers our partners to identify, focus on, recruit candidates, and mobilize for the elections that matter most to them.
ActBlue: CTA and ActBlue engineers started collaborating on the development of an ActBlue source connection on Airbyte during a hackathon in 2022. We’ve since finished the development of the connection to pass requirements for open source contribution to the Airbyte community. We’re able to integrate: paid contributions, refunded contributions, canceled transactions, and managed form contributions.
How does this help our partners? ActBlue data in PAD gives CTA partners access to a wealth of fundraising data and metrics. This empowers them to make informed decisions about their donors and secure the resources they need to support their crucial work.
Swayable: Swayable and CTA collaborated on configuring a S3 bulk export for PAD to ingest and deliver compound segments, content, survey questions, and responses. These survey responses are delivered as one table in PAD after CTA engineered a method to flatten and combine the various survey response files provided by Swayable.
*How does this help our partners?*With Swayable's data, our partners can analyze survey responses and respondent demographics in greater detail. This allows them to improve their strategies and better understand the effectiveness of their programs.
ADP Payroll: We built two syncs for PAD from the ADP platform: Worker Management and Payroll. CTA set up the ADP Payroll sync with files transferred via SFTP and accounting for ADP’s retention rate — files are deleted automatically after an initial download due to the sensitive nature of the PII data.
How does this help our partners? By using ADP Payroll data, CTA partners can easily create reports and gain valuable insights into their employees and expense trends. This information can help them manage their budgets and plan for future programs more effectively.