Page MenuHomePhabricator

KHaggard (Katie Haggard)
User

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Friday

  • Clear sailing ahead.

User Details

User Since
Nov 9 2018, 10:42 PM (288 w, 4 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
KHaggard (WMF) [ Global Accounts ]

Recent Activity

Yesterday

KHaggard added a comment to T365534: Update RML donors to have status of non-donor in CiviCRM.

There are certainly other ways we can isolate Non-donor RML sign-ups in Acoustic, we've done that in the past via "both_funds_latest_donation_date is blank".

Tue, May 21, 10:25 PM · Fundraising Sprint: justWork(), Fundraising-Backlog
KHaggard added a comment to T363527: New Segmentation Framework not quite usable yet.

Also noting other bugs with the segmentation framework, this is another one:
T363959

Tue, May 21, 8:27 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog
KHaggard added a comment to T363527: New Segmentation Framework not quite usable yet.

deleting my last comment above since it's a different issue; new ticket here: T365523

Tue, May 21, 7:13 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog
KHaggard created T365523: Deep Lapsed records are being labeled as Ultra Lapsed.
Tue, May 21, 7:12 PM · Fundraising Sprint: justWork(), Fundraising-Backlog

Wed, May 8

KHaggard added a comment to T363527: New Segmentation Framework not quite usable yet.
Wed, May 8, 5:45 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Thu, May 2

KHaggard added a comment to T354379: Acoustic clarity issue on acoustic date fields as they relate to merged CiviCRM contact.

@Ejegg Honestly, to me it's not super clear how that would work but I think it's possible to re-key the database with CID instead of email. I think it will be quite a process though that we'll need to work with Brian and Trilogy on. Assuming that we will need to re-key Acoustic before we set up any data flows from Civi. Is that correct, @bsisolak ?

Thu, May 2, 8:23 PM · Fundraising-Backlog
KHaggard added a comment to T344216: Year end update for donor segments & statuses.

Got it, thanks @Eileenmcnaughton Do you have a recommended timeline for an outage? End of June maybe? Let me know and I can at least add in a note for the rest of the team on when to expect segment instability and slowness. Thanks

Thu, May 2, 2:48 PM · Fundraising Sprint: justWork(), Fundraising Sprint: didAnyoneTryThis(), Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, May 1

KHaggard renamed T363959: Non-donor status missing records in our segmentation framework from RML non-donors are not being counted in our segmentation framework to Non-donor status missing records in our segmentation framework.
Wed, May 1, 11:42 PM · Patch-For-Review, Fundraising Sprint: justWork(), Fundraising-Backlog
KHaggard created T363959: Non-donor status missing records in our segmentation framework.
Wed, May 1, 11:31 PM · Patch-For-Review, Fundraising Sprint: justWork(), Fundraising-Backlog

Mon, Apr 29

KHaggard added a comment to T363498: Unusual Inclusion of Non-3C Donors in Springlish Segmentation.

Hi @AKanji-WMF - yes we already looked at this together with DR before the ticket was logged and we've confirmed on our side that all our queries contained the ruleset:

country is equal to one of the following: US GB CA

The cases mentioned above are contacts with a pattern of weird home address switching back and forth that changed their home country in Acoustic at the time or before the time of sending. But it wasn't done by an agent. Hope this helps.

Mon, Apr 29, 10:13 PM · Fundraising Tech - Chaos Crew, FR-donorservices, Fundraising-Backlog

Thu, Apr 25

KHaggard updated subscribers of T363527: New Segmentation Framework not quite usable yet.
Thu, Apr 25, 10:15 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog
KHaggard added a comment to T363527: New Segmentation Framework not quite usable yet.

Here's a file of CIDs to look at prioritizing dedupe / triaging how we can fix this long term with fr-tech.

Thu, Apr 25, 10:10 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog
KHaggard triaged T363527: New Segmentation Framework not quite usable yet as High priority.
Thu, Apr 25, 9:46 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog
KHaggard created T363527: New Segmentation Framework not quite usable yet.
Thu, Apr 25, 9:46 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Feb 7 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Quick update: Did a spot check with some names in Acoustic and it looks good from my side :)

Feb 7 2024, 12:34 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Feb 2 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Ok, great. @Eileenmcnaughton the data jobs for today completed and all 4 of them look good to me. The full file Unsubscribes looks like what we'd expect too:

Feb 2 2024, 8:05 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Feb 1 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

I think we exported the full Unsubscribes list because it wasn't causing any slowdowns to do it and it helps us make sure there isn't errors like that one time in 2018 where we saw the MSL shrinking over time and we only were able to catch and fix it because of the full data send summary reports.

Feb 1 2024, 8:58 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Jan 31 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Thanks @Eileenmcnaughton - so, the databaseupdate csv processed fine to me, summary below:

Jan 31 2024, 7:27 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Jan 30 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Alright, everything looks fine to me @Eileenmcnaughton .

Jan 30 2024, 8:07 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

OK @Eileenmcnaughton we were able to successfully map everything. Just running the files that were in queue now. I'm going to do a quick check that they all complete successfully and then I'll comment again here.

Jan 30 2024, 6:43 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Ok cool. I'm hoping to get other members of the email team to watch me map the files so they know how to do it in the future. Since it's getting late my time, I'm thinking I'll push the mapping to tomorrow at a time where others can watch "live".

Jan 30 2024, 4:00 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Oh ok. It is possible to cancel that? Acoustic is at a place now where if it attempts to run the "old regularly scheduled" file it will try to add back the fields I just deleted, which could take several hours to re-delete. I remember that happened in the past once.

Jan 30 2024, 2:40 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Right now it's telling me there's nothing on FTP. @Eileenmcnaughton Just an FYI.

Jan 30 2024, 1:51 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Awesome, thanks @Eileenmcnaughton. I'm going to grab a smoothie really quick but when I get back I'll map it. Please let me know when it's up. :)

Jan 30 2024, 12:20 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Jan 29 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Alright I'm all set now and ready to map whenever you are @Eileenmcnaughton Below is what I named everything and it's field type:

Jan 29 2024, 11:38 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Actually, let me clarify, you can send over the mapping file whenever you're ready, I just won't be able to map until closer to my end of day since reorganizing the fields is taking Acoustic a long time to process.

Jan 29 2024, 7:04 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Hi, so I've paused the data jobs in Acoustic now and I'm changing the existing fields to the new names and purging the old values. I'll update when finished and when I'm ready for the mapping file. @Eileenmcnaughton

Jan 29 2024, 6:04 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Jan 24 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Ah ok got it. I just did a poll with the email team on which one makes more sense to them and they all unanimously voted for:

Jan 24 2024, 4:34 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Jan 23 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

@Eileenmcnaughton Understood. Yeah, let's pin this for a later time. For now, I think it would be fine to leave Civi as-is but just rename the export file / job with whatever fits with Acoustic (as we have been doing).

Jan 23 2024, 11:02 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Ok. For now, I think I want to stick with how I wrote the fiscal year totals above.

Jan 23 2024, 9:19 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Got it, thanks. It might work regardless of how you export the whole numbers, but I just wanted to let you know that's how they present in Acoustic in case that matters. Thanks @Eileenmcnaughton .

Jan 23 2024, 8:57 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

I have a quick question. I was going to set numeric for the field type for the id fields. Acoustic formats numeric fields like this (e.g. 32.00) with two spaces after the decimal point. Does this work with you @Eileenmcnaughton or is there a reason we should format those numbers as a text field to retain the whole number as they present in Civi?

Jan 23 2024, 7:59 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard updated the task description for T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.
Jan 23 2024, 12:40 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard updated the task description for T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.
Jan 23 2024, 12:39 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Oh yeah thanks, that was what I was wondering. I like "id" better too. Ok so they will be:

Jan 23 2024, 12:38 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog
KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Yes those @Eileenmcnaughton . What do you think makes sense as the export name for those? Something like:

Jan 23 2024, 12:18 AM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Jan 19 2024

KHaggard added a comment to T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.

Thanks @Eileenmcnaughton - I think we would actually like to do both, so 4 new custom fields actually. What do you currently have those numeric values labeled like in Civi?

Jan 19 2024, 9:27 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Jan 10 2024

KHaggard added a comment to T321163: Adding and storing rml_source data for RML donations reporting.

Hi @AKanji-WMF - Circling back over to this. I had a conversation with @EWilfong_WMF and I think we are good to move forward on this. I don't believe this would overlap with the coding structures work Nora is working on, because that project is about identifying the type of fundraising campaign and not specifically about sourcing the banner a person signed up for RML before donating via RML email.

Jan 10 2024, 7:19 PM · Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, Fundraising-Backlog

Jan 9 2024

KHaggard added a comment to T354379: Acoustic clarity issue on acoustic date fields as they relate to merged CiviCRM contact.

Thanks @AKanji-WMF for your patience. Danny is back in office today and I spoke with him in a 1:1. He wants to chat with Brian about timeline if we approached this in the more streamlined way vs. our usual add-and-export-over way and I think that conversation is happening on Thursday. We should have a clearer way forward after that, I'll touch base here again next week on the decision point. Thanks all!

Jan 9 2024, 9:08 PM · Fundraising-Backlog

Jan 5 2024

KHaggard added a comment to T354379: Acoustic clarity issue on acoustic date fields as they relate to merged CiviCRM contact.

Ok. I'll chat with Danny next week about this, but most likely I don't think we will be re-architecturing anytime soon. I'll circle back next week.

Jan 5 2024, 12:46 AM · Fundraising-Backlog

Jan 4 2024

KHaggard added a comment to T354379: Acoustic clarity issue on acoustic date fields as they relate to merged CiviCRM contact.

Thanks @Ejegg - that's an interesting link, would that replace the need for adding more custom fields? Ideally, it would be awesome if we didn't have to add more fields to the nightly export, but if that's the only way / best way, we can just add them to the existing file DatabaseUpdate next time we're going to remap.

Jan 4 2024, 9:03 PM · Fundraising-Backlog
KHaggard created T354379: Acoustic clarity issue on acoustic date fields as they relate to merged CiviCRM contact.
Jan 4 2024, 7:29 PM · Fundraising-Backlog

Dec 13 2023

KHaggard created T353386: FY2324 Q3: Need to map new Civi fields over to Acoustic.
Dec 13 2023, 9:52 PM · Fundraising Sprint: brb(), Unplanned-Sprint-Work, Fundraising-Backlog

Dec 8 2023

KHaggard added a comment to T352771: Matching Gift information link broken.

Do they match the IDs in the main database, _all_Wikimedia ?

Dec 8 2023, 7:51 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Dec 6 2023

KHaggard updated subscribers of T352771: Matching Gift information link broken.
Dec 6 2023, 12:13 AM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Dec 5 2023

KHaggard added a comment to T352771: Matching Gift information link broken.

@Ejegg Hi, I just deactivated that program in Acoustic.

Dec 5 2023, 5:47 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Nov 3 2023

KHaggard closed T350386: Civi to Acoustic Export: Job Status Failed as Resolved.

This looks to be resolved as we had successful import jobs today. Thanks everyone! Resolving this task.

Nov 3 2023, 9:31 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Nov 2 2023

KHaggard added a comment to T350386: Civi to Acoustic Export: Job Status Failed.

Thanks @Cstone :) Figured it was related to upgrade work as usual with the maintenance weeks but I appreciate you for confirming and @LMedley-WMF for logging this just in case! <3

Nov 2 2023, 7:51 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Oct 25 2023

KHaggard added a comment to T321163: Adding and storing rml_source data for RML donations reporting.

Hi @AKanji-WMF - Apologies I just saw this. Well, we're back in code-freeze time + email-team-code-freeze time, so this can't move forward right now and has to wait until later.
Besides, it looks like we're also waiting for @NNichols to weigh in.
And I'm not sure at this point if the coding structures project includes this and I may need to reevaluate where this task lands in the fabric of the other data optimizations that surfaced this year. I'm going to make a note for myself to check in with Eric about this soon.

Oct 25 2023, 12:11 AM · Fundraising Sprint Turtles that are robotic that destroy the whole world with their foot theory, Fundraising-Backlog

Oct 20 2023

KHaggard triaged T349358: Acoustic suppressed emails 2023-10-19 as High priority.

I'll also add that the reason why this is the first time we're seeing this is that we usually don't rely much on suppression lists because we handle everything with queries, however, I always thought of suppression lists as a possibility to use if we have rush jobs and need to suppress a group of people quickly. I didn't realize that if we deployed an email and the suppression was used that Civi would pick it up and translate it as unsubscribes. Definitely don't want going forward, as we may need the flexibility to suppress people for certain sends and not other sends.

Oct 20 2023, 3:52 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Oct 17 2023

KHaggard added a comment to T347724: Removing some WMF donor fields.

Thanks @Eileenmcnaughton . Yes, just confirming that any fields currently in the export file that are being removed / changed / added should (for now) remain in the export file with value=0 until we can find a time after Big English to roll out the changes in Acoustic (I think just swapping the old CY totals with the FY totals). Reasoning is because changes in the export file, no matter how minuscule, tends to make the job fail until Acoustic matches it exactly.

Oct 17 2023, 6:11 PM · Fundraising Sprint Uptown cURL, Fundraising-Backlog

Oct 10 2023

KHaggard added a comment to T346819: Post-payment monthly convert donors need appropriate flag in Civi.

Thanks @Ejegg . I'll leave it up to @krobinson and her team to determine the urgency around updating this now vs. 24 days.

Oct 10 2023, 6:43 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Oct 3 2023

KHaggard closed T347965: Civi to Acoustic Export: Job Status Failed as Resolved.
Oct 3 2023, 3:42 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog
KHaggard added a comment to T347965: Civi to Acoustic Export: Job Status Failed.

All four data jobs for Oct 3rd have completed successfully. We will proceed with scheduling emails again.

Oct 3 2023, 3:40 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog
KHaggard added a comment to T347965: Civi to Acoustic Export: Job Status Failed.

Awesome ticket, @ppenloglou Thanks for logging this.
I'm running the jobs that Jack sent over now.

Oct 3 2023, 2:58 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Oct 2 2023

KHaggard added a comment to T347724: Removing some WMF donor fields.

Oh ok that works. Thanks @Eileenmcnaughton

Oct 2 2023, 3:57 PM · Fundraising Sprint Uptown cURL, Fundraising-Backlog

Sep 29 2023

KHaggard added a comment to T347724: Removing some WMF donor fields.

Just a quick little reminder, please hold off on deleting the few CY fields that are still in the export to Acoustic until we replace them with FY... and then we could blow them away after. :)
I'm pretty sure deleting them will cause the import to fail until we remap Acoustic (even with deletions) and I want to avoid remapping anything until after Big English.

Sep 29 2023, 11:44 PM · Fundraising Sprint Uptown cURL, Fundraising-Backlog

Sep 28 2023

KHaggard closed T347462: Civi to Acoustic Export: Job Status Failed as Resolved.

Given how this is running again, assuming I can resolve this ticket?

Sep 28 2023, 4:00 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Sep 22 2023

KHaggard closed T347170: Civi/Silverpop Failmail Alert as Resolved.

Just ran the Acoustic jobs and everything is coming through normally. Thanks @Ejegg !

Sep 22 2023, 8:18 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog, FR-failmail

Sep 21 2023

KHaggard added a comment to T346819: Post-payment monthly convert donors need appropriate flag in Civi.

Hi @Ejegg - quick clarification, our emails targeted AF_has_active_recurring_donation = No. So the 'pending' donors have "No" as their value currently.

Sep 21 2023, 8:14 PM · Fundraising Tech - Chaos Crew, Fundraising-Backlog
KHaggard added a comment to T346819: Post-payment monthly convert donors need appropriate flag in Civi.

Hi @Ejegg - we use the custom fields in Acoustic. Specifically:
AF_has_active_recurring_donation
AF_recurring_latest_donation_date

Sep 21 2023, 2:50 AM · Fundraising Tech - Chaos Crew, Fundraising-Backlog

Aug 16 2023

KHaggard added a comment to T344383: Acoustic - request to store click data in mailing stats.
Aug 16 2023, 10:32 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
KHaggard added a comment to T344383: Acoustic - request to store click data in mailing stats.

Actual date of when clicktracking was turned on: Dec 20 2022

Aug 16 2023, 10:31 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Aug 11 2023

KHaggard closed T317929: Civi TY Receipt Unsubscribe form passes email address through the URL as Invalid.

Hi @AnnWF - I think you meant to ping me in your comment, correct?

Aug 11 2023, 8:51 PM · Fundraising-Backlog

Aug 9 2023

KHaggard added a comment to T318188: Acoustic Click-tracking - SSL cert for links.email.wikimedia.org.

Yes @AKanji-WMF - this ticket was resolved last year. We have the cert and have had click tracking on for a handful of months.

Aug 9 2023, 2:46 AM · Fundraising-Backlog

Aug 3 2023

KHaggard added a comment to T343293: Plan for end-of-financial-year updating of donor segments & statuses.

@Eileenmcnaughton I might need more insight on how we're all aligning for the function of these statuses and segments, but my assumption with the rollout of these new columns is that we would want the most current value possible for our email sends. If a donor was Lapsed June 30 but changed to Active July 1, we would want to act on them as an Active donor for the new FY.

Aug 3 2023, 4:48 PM · Fundraising Sprint Owner of a Lonely Product, fundraising-tech-ops, Fundraising-Backlog

Jul 31 2023

KHaggard added a comment to T342879: Civi to Acoustic Export: Job Status Failed.

Got it, Thanks @Cstone - we will continue to monitor this week and work with you where needed!

Jul 31 2023, 3:38 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Jul 28 2023

KHaggard added a comment to T342879: Civi to Acoustic Export: Job Status Failed.

We ended up unscheduling the email sends set to deploy today in an abundance of caution until we were able to run the jobs manually.

Jul 28 2023, 3:45 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Jul 27 2023

KHaggard updated subscribers of T342879: Civi to Acoustic Export: Job Status Failed.

Thanks for logging this ticket @LMedley-WMF
I logged into Acoustic and tried out running the jobs manually and the civi export files were found. This is the second time recently we've had a timing issue so I'm going to tag @AKanji-WMF

Jul 27 2023, 4:11 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Jul 21 2023

KHaggard closed T342430: Civi to Acoustic Export: Job Status Failed as Resolved.

Ok I was able to manually run the jobs and the files were there. This was just a timing issue - probably something caused the Civi export to take a little longer and it missed the window of time to get to the FTP.
I'm going to resolve the ticket for now, but let's keep an eye on it in case the same issue repeats over the weekend and into Monday.

Jul 21 2023, 5:45 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog
KHaggard added a comment to T342430: Civi to Acoustic Export: Job Status Failed.

Thank you @LMedley-WMF !
Looks like the files weren't there for Acoustic to pick up. I'm going to test out manually running the jobs now to see if the files are there now. Will update again shortly.

Jul 21 2023, 5:03 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

Jul 20 2023

KHaggard added a comment to T339296: Update acoustic export to include new segment fields.

Thanks for summarizing @Eileenmcnaughton - That list of fields looks right to me.

Jul 20 2023, 4:44 PM · Patch-For-Review, Fundraising Sprint Istanbool (not Constantidouble), Fundraising-Backlog
KHaggard added a comment to T341902: Data Axle Project - Re-import to Civi.

Just for clarification, Joseph Mando sent me a Delve list to suppress from our email sends. We don't have any room in the calendar for the next few months to import any new fields into Acoustic, so please hold on kicking off any nightly import changes that would affect Acoustic. Thanks!

Jul 20 2023, 4:34 PM · Fundraising Sprint: explain($LikeImFive), Fundraising Sprint: didAnyoneTryThis(), Fundraising Sprint Uptown cURL, Fundraising-Backlog

Jul 6 2023

KHaggard added a comment to T339296: Update acoustic export to include new segment fields.

Ohh ok thanks for clarifying @Eileenmcnaughton I have Civi access and I'm looking at those pages now.
I wasn't expecting two fields for these definitions, but it does makes sense to separate them like that.
I'm surprised to see Deep lapsed, Ultra Lapsed, and NonDonors underneath "Segments" - those seem like just Status fields to me - just my two cents though.

Jul 6 2023, 12:12 AM · Patch-For-Review, Fundraising Sprint Istanbool (not Constantidouble), Fundraising-Backlog

Jul 5 2023

KHaggard added a comment to T339296: Update acoustic export to include new segment fields.

Thanks @Eileenmcnaughton - Okay so just to recap so I understand: you're saying that
donor_status can be a numeric value (i.e. 100, 200, 1000)
donor_segment can be a text string label (i.e. "Major Donor")

Jul 5 2023, 11:44 PM · Patch-For-Review, Fundraising Sprint Istanbool (not Constantidouble), Fundraising-Backlog
KHaggard added a comment to T339296: Update acoustic export to include new segment fields.

Oh ok, can you give a quick value example of the difference between donor_segment and donor_status? Are they both text fields?

Jul 5 2023, 9:11 PM · Patch-For-Review, Fundraising Sprint Istanbool (not Constantidouble), Fundraising-Backlog
KHaggard updated subscribers of T339296: Update acoustic export to include new segment fields.

Hi @Eileenmcnaughton The removals make sense to me. We haven't been using the calendar year USD total fields at all, but perhaps if we switch it to fiscal year USD totals that would be more useful. Is that possible to do?

Jul 5 2023, 6:28 PM · Patch-For-Review, Fundraising Sprint Istanbool (not Constantidouble), Fundraising-Backlog

Jun 23 2023

KHaggard updated subscribers of T302444: Email edit ui: allow users to send draft MC emails to themselves .

Hi @AKanji-WMF - Hmm I'm not sure I haven't seen this task before. I don't manage the Civi TY emails anymore so I'll loop in @NNgu-WMF
Hey Natalie, are you able to send yourself the monthly convert test emails in Civi?

Jun 23 2023, 6:34 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jun 14 2023

KHaggard added a comment to T269811: As an email stats updater, I need to find results for a send that is missing from Superset.

Hi @AKanji-WMF - I don't think this segment ever made it into Superset. However, this is so old now that it it's not worth retroactively working on it, plus I think the data for this send has already expired from Acoustic anyway. My opinion is that we close this ticket out.

Jun 14 2023, 5:51 PM · Fundraising Sprint Airline Passenger Experience, Fundraising Sprint Zeitgeistbusters, Fundraising Sprint Yellow hornets of kindness and healing, FR-Tech-Analytics, FR-Email, Fundraising-Backlog

Jun 12 2023

KHaggard added a comment to T338259: Civi Export: What to do with the MatchingGifts file and mystery fields .

Thanks @AKanji-WMF ! I feel like I wrote a lot in my last comment so the over-communicator in me wants to just plainly restate for clarity:

  • We only need to stop exporting the MatchingGifts-* CSV to resolve this ticket. No other work is needed at this time. :)
Jun 12 2023, 8:38 PM · Fundraising-Backlog

Jun 7 2023

KHaggard added a comment to T338259: Civi Export: What to do with the MatchingGifts file and mystery fields .

Hi all, just following up. @NNichols and I chat over slack and here is more context from Nora:

Jun 7 2023, 8:32 PM · Fundraising-Backlog
KHaggard added a comment to T338259: Civi Export: What to do with the MatchingGifts file and mystery fields .

Ok, thanks @Eileenmcnaughton . I just read the documentation and confirming on my side that those last two rows in the chart don't exist in Acoustic. We never received a request to create the columns: minimum_gift_matched_usd, match_policy_last_updated.

Jun 7 2023, 7:40 PM · Fundraising-Backlog

Jun 6 2023

KHaggard updated subscribers of T338259: Civi Export: What to do with the MatchingGifts file and mystery fields .
Jun 6 2023, 6:29 PM · Fundraising-Backlog
KHaggard created T338259: Civi Export: What to do with the MatchingGifts file and mystery fields .
Jun 6 2023, 6:28 PM · Fundraising-Backlog

Jun 2 2023

KHaggard closed T338041: Civi to Acoustic Export: Job Status Failed as Resolved.

Thanks to the work of @Cstone and @jgleeson and @AnnWF we're back in business! Copying the job data summary for the Unsubscribes-* List to celebrate because we now have a reduction of bad data (it was 520 and now it's 3, yay!) The rest of the jobs for DatabaseUpdate-*, Optout-*, and the new ChecksumEmails-* have processed successfully. Thanks team!

Jun 2 2023, 8:24 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog
KHaggard added a comment to T338041: Civi to Acoustic Export: Job Status Failed.

Thanks @Dwisehaupt ! We have emails scheduled to go out on Monday so I'm hoping we can resolve this today. We didn't receive any files today for June 2nd - will those be coming through in the next couple hours? Thanks

Jun 2 2023, 6:10 PM · Fundraising Tech - Chaos Crew, FR-Email, Fundraising-Backlog

May 23 2023

KHaggard updated subscribers of T336000: Update Acoustic Unsubscribe landing page domain to be served by a secure wikimedia.org domain.
May 23 2023, 9:12 PM · Fundraising-Backlog, fundraising-tech-ops, FR-Email
KHaggard updated subscribers of T336000: Update Acoustic Unsubscribe landing page domain to be served by a secure wikimedia.org domain.
May 23 2023, 9:11 PM · Fundraising-Backlog, fundraising-tech-ops, FR-Email
KHaggard added a comment to T336000: Update Acoustic Unsubscribe landing page domain to be served by a secure wikimedia.org domain.

Hi @AKanji-WMF - this ticket is referring to what you and I were emailing about on May 3rd, where you mentioned that this is probably enabled through Operations, not fundraising tech.
I'm happy to go forward with Eric's recommendation to use lp.email.wikimedia.org. Who should we tag to get this moving forward?

May 23 2023, 9:11 PM · Fundraising-Backlog, fundraising-tech-ops, FR-Email

May 2 2023

KHaggard closed T254304: Conflicting fields in some Acoustic contact records, a subtask of T253152: Q4 FY2019/20 investigate export and upload issues with the silverpop export , as Resolved.
May 2 2023, 4:26 PM · Fundraising Sprint Pseudopretzels, Fundraising Sprint Octopus hugs, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Lazy Loading Life, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
KHaggard closed T254304: Conflicting fields in some Acoustic contact records as Resolved.

Wow this ticket is so old it has our original silverpop field names! We can close this out @Eileenmcnaughton
Out of curiosity I ran that query again and it returns zero as expected so all data is sorted out and clear.

May 2 2023, 4:26 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Feb 24 2023

KHaggard renamed T330403: Civi to Acoustic Export: Job Status Failed from Acoustic Import: Job Status Failed to Civi to Acoustic Export: Job Status Failed.
Feb 24 2023, 4:39 PM · Fundraising-Backlog, FR-Email, Fundraising Tech - Chaos Crew
KHaggard updated subscribers of T330403: Civi to Acoustic Export: Job Status Failed.

This failed again this morning, also got this failmail: Silverpop emails - Upload files failed with code 1
@XenoRyet @AKanji-WMF We have emails scheduled for deployment next Tuesday and we won't be able to send them until this ticket is resolved. It seems like Civi's nightly export to the FTP is failing.

Feb 24 2023, 4:37 PM · Fundraising-Backlog, FR-Email, Fundraising Tech - Chaos Crew

Feb 23 2023

KHaggard added a comment to T330403: Civi to Acoustic Export: Job Status Failed.

Thank you @LMedley-WMF ! Also adding here the Civi FailMail subject line I saw this morning: "Silverpop emails - Upload files failed with code 1"

Feb 23 2023, 4:43 PM · Fundraising-Backlog, FR-Email, Fundraising Tech - Chaos Crew

Feb 9 2023

KHaggard added a comment to T317929: Civi TY Receipt Unsubscribe form passes email address through the URL.

Hi there, I just wanted to update here that we had a business requirements call about the Preference Center recently, and I think the current experience (auto-populated email address / click submit) is actually the experience that we want instead of the text box idea. We will be sharing more details about this soon.

Feb 9 2023, 8:34 PM · Fundraising-Backlog

Nov 16 2022

KHaggard added a comment to T311438: Deleted Contact Overwriting Current Contact Record.

@Eileenmcnaughton - I just re-enabled your account in Acoustic. Not sure why it keeps disabling - maybe password expiring? Anyway, let me know if you have any issues logging in!

Nov 16 2022, 6:01 PM · Fundraising Tech - Chaos Crew

Sep 28 2022

KHaggard added a comment to T315102: Custom field "AF_has_active_recurring_donation" is showing false positives.

Ah ok, got it. I wasn't sure of the set up. Thanks for explaining @Eileenmcnaughton ! So those dates you listed are the last expected payment dates, and they won't cancel until 60 days after those dates.

Sep 28 2022, 10:48 PM · Fundraising Sprint Recursion Excursion, Fundraising Sprint Quarkery, Fundraising Sprint Potato, Fundraising Sprint Overused petting Zoo Memetics, Fundraising-Backlog
KHaggard added a comment to T318812: Civi process when generating/adding the donor name.

Hi @krobinson - So I looked into the cids and the email address. Confirming that Acoustic sent the Sep 22nd email to CID 51559392 only. The other CID hasn't been sent an email since 2021 and is not pulling up any search results in Acoustic when I search for 6115350.

Sep 28 2022, 4:43 PM · FR-donorservices, Fundraising-Backlog
KHaggard added a comment to T315102: Custom field "AF_has_active_recurring_donation" is showing false positives.

Thanks all for the full file push. It processed successfully and I reran the query that had 70,144 records before and now it's down to 365 records! Woohoo
Query:
WHEN AF_has_active_recurring_donation is equal to Yes
AND AF_recurring_latest_donation_date is before Jul 10, 2022

Sep 28 2022, 4:23 PM · Fundraising Sprint Recursion Excursion, Fundraising Sprint Quarkery, Fundraising Sprint Potato, Fundraising Sprint Overused petting Zoo Memetics, Fundraising-Backlog

Sep 26 2022

KHaggard closed T318234: Unsub Link in "Donation Thank You" email as Resolved.

Hi @DBu-WMF - "instantly" has been removed from the TY email copy in English.
As we have a different ticket (T317929) about the unsub page itself, I think we are all good to close out this ticket. If anything else comes up that I'm missing, please let me know!

Sep 26 2022, 8:47 PM · FR-AutoTY-Email, Fundraising-Backlog