Starting today and over the next 5 business days, six people are running QA in the database to ensure things look good before we launch Big English soon. Creating a ticket to keep track of findings.
I ran a pretty thorough QA and found some interesting flags that I want to mention below, but overall I think everything looks fantastic.
New Status showing as blank in Civi
These are correctly labeled in Acoustic as "New" but Civi UI doesn't show anything for status.
CIDs: 64257386, 64261641, 61327965, 56092642, 64263346, 64262193, 32187153, 64263066, 64273884, 64214308
Civi x Acoustic data mismatches
A few strange cases of mismatching data:
35918419 - Labeled as Recurring Donor in Acoustic, but not a recurring donor in Civi.
59250832 - Labeled as a Major Donor in Acoustic, but has no contributions in Civi. Should NULLs in Civi overwrite Acoustic?
Some segment/status outliers
Searched for anyone who doesn't have any of the 20 possible labels, and got a scoop of donors that for whatever reason got stuck and haven't updated since Jun 21, 2024, even though we ran a full db overwrite the other day. Dropping all of them below:
61936037
8090444
12522325
1840065
12884388
41953210
42034634
58590405
18999430
50320738
3254995
35027618
52089835
62768725
62667164
53940107
54488102
23498514
58570274
62632871
54107090
61102307
44639205
50193811
61980745
62996739
60845717
62825957
33622530