Elections
Where are the code and notebooks for election results collection and ingestion stored?
mdata_mgmt repository
What is the last worksheet that PSMs and DMs need to fill out with a partner before we can begin to migrate their data to Organizer?
Data Copy worksheet
What must a profile have in M{insights to be considered 'copyable' to Organizer?
full name, phone number, street address, email address, or non-voter file external id
How many segments can a partner have copied over to Organizer?
We do not have a hard cap on the number of segments, but we should push hard to keep the number small
What are three errors that the election ingestion code might raise when inspecting election results?
Missing candidate first or last name, missing election_race_id
Incorrect/out of range data in election_race_id or win fields
election_race_id inconsistent within file and with election_race_id in results file
Candidate names inconsistent between candidates and results files
Incorrect number of winners based on votes allowed
Results for election_race_id already ingested
Missing data in results file columns
Incorrect/out of range data in results file columns
election_race_id inconsistent within file and with election_race_id in candidates file
Candidate names inconsistent between results and candidates files
Results for election_race_id already ingested
Total ballots cast > registered voters in a region
Down ballots cast > total ballots cast in a region
Down ballots cast > registered voters in a region
In what format are we planning to copy "un-supported data points"?
for most things we will handle them as forms, lists will be as custom attributes
You have a partner that is permissioned on AZ, CA, WI, and TX in M{insights. They are migrating to Organizer and want to be provisioned on CA, TX, and NY. What geographies should your Atlas transition report cover?
CA and TX. (you can include notes about NY - the new geo, but we won't compare coverages/matches, etc)
Can a partner request to combine two or more M{insights accounts into a single Organizer account?
Yes
What steps need to be taken to prepare for election results collection/ingestion with Atlas data? (Name 2 out of three)
Make sure you have mdata_mgmt repo cloned and up to date
Have the election_race_id for the race you’re collecting
Generate a fresh election results folder with templates
What is one improvement improvement announced in the last Organizer release?
We've significantly improved the experience of filtering on outreach activity data (email, form, phone, and canvassing)The Import tool now suggests column/attribute mappings (e.g. suggesting that fname likely represents First Name), saving clicks and reducing import errorsUsers can now edit key elements of in-progress Canvassing efforts after they’ve launched, including re-assigning canvassers to a different turf and changing effort end dates (and sending related notifications to canvassers in the mobile apps)
What is fast matching in Organizer, and why is important to the work that we do?
matching based on IDs
Allows us to force a match on an import
After they are fully onboarded and running campaigns on Organizer (ex: they have been on for 3 months), can a partner request to swap out their geos? (ie: can they ask to be de-permissioned on CA and permissioned on TX instead)?
no
What is contained by default in the raw_results_and_region_data folder when generating election collection templates?
The region consolidation csv
What are the three reports/documents you need to have to be able to populate the data copy worksheet?
Activity report (via Kareem's record_count notebook), segments report and forms report from Ella/Support
When preparing Atlas by Murmuration Transition Report for our partners, what are 3 things you could include in the New Fields and Values section...Where can you find more information?
- new fields that weren't available to the partner in M{insights
- new higher value values for existing fields
- expanded coverage in fields
Organizer Data Compared to M{insights data confluence page
https://murmuration.atlassian.net/wiki/x/AYBTC
Migration has many steps where we are either exporting or importing data. In which step, can only one account's import or export happen at a time:
- exporting PII, custom attributes, and external IDs
- importing PII data, custom attributes, and external IDs
- exporting interaction data
- importing interaction data
exporting interaction data
This is pulling from backup MongoDB. To ensure there is no chance of impacting server stability, only one account's interaction data can be exported at a time, this is part of the reason, for now, engineers will be handling interaction exports
Why are registered_voters_in_region and total_ballots_cast_in_region stored in a separate Snowflake table from down_ballots_cast_in_region?
Both registered_voters_in_region and total_ballots_cast_in_region may be sourced from either the election results or via Atlas data, while down_ballots_cast_in_region should only ever be sourced from official election results.
ALL TEAMS :
When importing interaction data into Organizer (via data copy workflow), roughly how long does it take to import 100k interactions?
Price is right rules: closest without going over
40 minutes
For phone numbers attached to accounts that are copied over to Organizer:
1. if the phone number was marked as opt-in in M{insights, what will be their opt-in status in Organizer?
2. if the phone number was marked as opt-out, what will be their opt-in status in Organizer?
1. All other phone numbers will be marked as “unknown” in Organizer.
2. Phone numbers that are marked as opt-out in M{insights will be marked as opt-out in Organizersource: Data copy limitations confluence page
Name three reasons why you may not be able to identically recreate a segment in Organizer
- Custom attribute not copied over
- Field may not exist in Organizer (can't select name exists)
- Uses a geography that they no longer have access to
- They chose to not copy over the relevant interaction data
- Product limitations