This is our documentation on it - we do bring back the source (it can be overwritten but I think that would be rare)
https://wikitech.wikimedia.org/wiki/Fundraising/Data_and_Integrated_Processes/Acoustic_Integration#Remind_me_later_contacts

It looks like this is the list https://civicrm.wikimedia.org/civicrm/admin/search#/create/Contribution?params=%7B%22version%22:4,%22select%22:%5B%22id%22,%22Contribution_Contact_contact_id_01.display_name%22,%22Contribution_Contact_contact_id_01.source%22%5D,%22orderBy%22:%7B%7D,%22where%22:%5B%5B%22Contribution_Contact_contact_id_01.groups:name%22,%22IN%22,%5B%22Silverpop_imports_310%22%5D%5D,%5B%22receive_date%22,%22%3E%3D%22,%222022-09-13%22%5D,%5B%22contribution_status_id:name%22,%22%3D%22,%22Completed%22%5D%5D,%22groupBy%22:%5B%5D,%22join%22:%5B%5B%22Contact%20AS%20Contribution_Contact_contact_id_01%22,%22INNER%22,%5B%22contact_id%22,%22%3D%22,%22Contribution_Contact_contact_id_01.id%22%5D%5D%5D,%22having%22:%5B%5D%7D (but I haven't tried to see if it will export yet)

Thanks, @Eileenmcnaughton, for noting the documentation. Based on this documentation, it looks like if the record has a Contact ID in Acoustic (née Silverpop) it's rml_source value will not be updated in Civi because the query that makes that update is specifically looking for records in Acoustic without Contact IDs. Is that correct?

If that's the case, this effectively makes the rml_source value in Civi the user's first rml_source value. We know that people sign up multiple times on RMLs - though we would have to dig into to the data for prevalence - so my concern is that we won't know the rml_source value for more recent signups. Acoustic's rml_source value will be the opposite since the data is overwritten each time a signup occurs. Since we're analyzing a recent RML signup form, the Acoustic data will be more useful in this case.

@EWilfong_WMF - you are correct the source will only be equal to the RML source IF that is how they first enter our database. If an existing contact (either a previous donor or previous RML person) does an RML they are already in our database & we don't record the later RML

& well done on the analysis - you cut to the chase of it

Thanks for confirming, @Eileenmcnaughton. Since I do not have Civi access, would it be possible for you to provide me the list of RML email donations with Contact ID, Email address, amount and donation date/time since Sept. 13? The utm_source value for these donations would start with "RML2223_".

@JMando So for the contact records created from the Acoustic -> Civi import, the first_name and last_name will initially be null and the civicrm_contact.source column will start with "Silverpop" (e.g. "Silverpop B2223_1003_en6C_m_p1_lg_rml_RMLOptions 10/04/2022") . Once they donate, the first_name and last_name should be populated.

For any donors that donate via a link from an RML email (including donors who already existed in Civi), the link from the email will pass through a utm_source value that starts with "RML" as @EWilfong_WMF mentions in the previous comment. So searching on the wmf_contribution_extra.utm_source field would be the best way to get RML-linked donations from all donors, not just donors created via the RML import.

Checking in here to see if we could get this data tomorrow (Oct. 11).

@Ejegg do you mean the drupal.contribution_tracking.utm_source field? That is the one we usually pull into reporting (and I do not see a utm_source in civicrm.wmf_contribution_extra).

@EWilfong_WMF do you have access to the shared file server (or a folder therein)? Trying to think of the best way to get you this data securley as it has PII (email address).

@JMando - I do not believe I have access to the shared file server. We use Google Drive on our end and I have shared a folder there directly with you that you could use to send the data. Or you could share it with me via your Slack org as I am a guest on that account.