Page MenuHomePhabricator

CCogdill_WMF (Caitlin Cogdill)
WMF Fundraising Email Manager

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Thursday

  • Clear sailing ahead.

User Details

User Since
Oct 29 2014, 10:26 PM (245 w, 5 d)
Availability
Available
IRC Nick
ccogdill
LDAP User
Unknown
MediaWiki User
CCogdill (WMF) [ Global Accounts ]

Recent Activity

Tue, Jul 9

CCogdill_WMF added a comment to T227499: List all data types in the email export to IBM.

I can get the column headers for you super easily from IBM. If you actually
want to see the SQL that builds it, that's a different story. Should I get
you the column headers?

Tue, Jul 9, 5:03 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T226572: add tracking to opt in page.

Awesome! You think we might be able to get new data in by EOW?

Tue, Jul 9, 12:27 AM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
CCogdill_WMF added a comment to T227499: List all data types in the email export to IBM.

@DStrine is this about figuring out the different email preferences in Civi? i.e. On hold or Do Not Mail? Or is this about something else?

Tue, Jul 9, 12:12 AM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T226572: add tracking to opt in page.

Hey all! I see something happened with this task last week. Should I be checking for data?

Tue, Jul 9, 12:00 AM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog

Mon, Jul 8

CCogdill_WMF added a comment to T226571: List all emails that may have been mistakenly opted out.

Ah, duplicating my comment from T223935 here:

Mon, Jul 8, 11:57 PM · Fundraising-Backlog, FR-Email
CCogdill_WMF added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

Last week, we performed the process I outlined above in silverpop and purged anyone from our Master Suppression List (MSL) who had been opted-out by the unsubscribes import. That removed 1.25M records. Then, the nightly import imported 936k new rows, which suggests that we successfully removed about 310k records from the MSL that were not supposed to be there. This feels like a big win!

Mon, Jul 8, 11:48 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog
CCogdill_WMF added a comment to T125272: [EPIC] Create Preference Center for donors to manage email subscription preferences.

Cool, when would it make sense to discuss this further? Happy to outline
our expectations and see what might work within the constraints of our
system.

Mon, Jul 8, 6:55 PM · Epic, Fundraising-Backlog

Fri, Jul 5

CCogdill_WMF renamed T227363: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data) from Add more silverpop data to Civi (query names, segment data) to Add more silverpop data to Civi (query names, query criteria, segment data).
Fri, Jul 5, 9:28 PM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF triaged T227363: Investigate: Add more silverpop data to Civi (query names, query criteria, segment data) as High priority.
Fri, Jul 5, 9:27 PM · Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Wed, Jul 3

CCogdill_WMF added a comment to T225544: Rename Field in IBM export.

Would it be possible to time this change with T170972 so we only have to remap the fields once?

Wed, Jul 3, 8:27 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Fundraising-Backlog

Fri, Jun 28

CCogdill_WMF added a comment to T226572: add tracking to opt in page.

Hmm I guess in a totally ideal world, we would keep a record of all engagements, but I could work with just the latest.

Fri, Jun 28, 7:29 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
CCogdill_WMF added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

We sent a big bulk email blast on Thursday, so yeah, that seems entirely
possible.

Fri, Jun 28, 4:20 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog
CCogdill_WMF added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

Shouldn't be related to the opt-out pages. We aren't sending traffic there
until that tracking task is done.

Fri, Jun 28, 3:51 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog
CCogdill_WMF added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

Awesome! Am I right in thinking we should have seen decreases in... both export files last night? Or just the Main Database import? @KHaggard can you advise how the IBM imports looked from last night?

Fri, Jun 28, 3:20 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog

Thu, Jun 27

CCogdill_WMF added a comment to T195907: Annual totals receipt thank you email for recurring donors.

We met with Katherine this week! We have a follow-up meeting in a couple weeks and should finalize copy at that point. Putting a reminder on my calendar to update y;all the week of July 15 :)

Thu, Jun 27, 3:21 PM · Fundraising-Backlog, Recurring-Donations, FR-Email

Wed, Jun 26

CCogdill_WMF added a comment to T226571: List all emails that may have been mistakenly opted out.

Sounds great, thank you! :)

Wed, Jun 26, 1:57 PM · Fundraising-Backlog, FR-Email

Tue, Jun 25

CCogdill_WMF updated subscribers of T226571: List all emails that may have been mistakenly opted out.

Hmm, I guess I could do all of this with what we have in IBM. I could create a copy of the main database in silverpop and then purge all the people who have opted out using silverpop forms from it. I will then purge the remaining list from the master suppression list, and then the nightly unsubscribe import will re-import anyone we missed. Whew! @MNoorWMF does that all make sense to you? Would like to sanity check the method.

Tue, Jun 25, 10:12 PM · Fundraising-Backlog, FR-Email
CCogdill_WMF added a comment to T226572: add tracking to opt in page.

Assuming 'the variant of the page' = utm_source, yes! In other words, we
need to track our 3 main utms:
utm_medium
utm_campaign
utm_source

Tue, Jun 25, 8:37 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising-Backlog
CCogdill_WMF added a comment to T226571: List all emails that may have been mistakenly opted out.

A related question has been bumping around in my mind: which contacts
*were* considered
opted out and are no longer? I.e. were there *on hold* people who were once
opted out and should be opted back in? I don't actually know if these cases
exist, but wondered if combining those into this request would allow us to
accomplish two goals at once.

Tue, Jun 25, 8:35 PM · Fundraising-Backlog, FR-Email
CCogdill_WMF added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

So does that mean a bunch of opt-ins have been added to the unsubscribe
list? When an email gets added to IBM's master suppression list (which is
where the unsubscribes import points), it stays there, even if the next
night's file doesn't include that email. Can I get a list of people who
have been erroneously added to the suppression list? I think I can purge a
whole csv from the list as a bulk job.

Tue, Jun 25, 4:54 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog

Mon, Jun 24

CCogdill_WMF updated subscribers of T226450: Import US Census zip code data into Civi.
Mon, Jun 24, 9:01 PM · Fundraising-Backlog
CCogdill_WMF triaged T226450: Import US Census zip code data into Civi as Normal priority.
Mon, Jun 24, 9:01 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T225844: Epic: Tracking stats for opt-in page.

Thanks for looking at this @DStrine. The question of hits was only one part of this ask. The Unbreak now portion was this:

Mon, Jun 24, 7:58 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T225844: Epic: Tracking stats for opt-in page.

Bumping this!

Mon, Jun 24, 5:14 PM · Fundraising-Backlog

Jun 14 2019

CCogdill_WMF updated the task description for T225844: Epic: Tracking stats for opt-in page.
Jun 14 2019, 5:53 PM · Fundraising-Backlog
CCogdill_WMF triaged T225844: Epic: Tracking stats for opt-in page as Unbreak Now! priority.
Jun 14 2019, 5:51 PM · Fundraising-Backlog

Jun 13 2019

CCogdill_WMF closed T169364: Can we add recurring information to TY email? as Resolved.

I think this is extraneous now. Closing :)

Jun 13 2019, 3:24 PM · FR-Email, Fundraising-Backlog
CCogdill_WMF added a comment to T195907: Annual totals receipt thank you email for recurring donors.

Hey all, update on copy. We're meeting with Katherine in two weeks to draft new copy for the annual TY email and will get this email together after that meeting. I will update this task by Friday, June 28.

Jun 13 2019, 3:23 PM · Fundraising-Backlog, Recurring-Donations, FR-Email

Jun 11 2019

CCogdill_WMF added a comment to T219401: Opt-in numbers in IBM not as expected.

Yeah, I think so. Thank you so much!

Jun 11 2019, 4:57 PM · Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog
CCogdill_WMF updated subscribers of T219401: Opt-in numbers in IBM not as expected.

cc @KHaggard, I'm going to tag you in a trello card with some next steps but here is the context if you're curious.

Jun 11 2019, 4:15 PM · Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog
CCogdill_WMF added a comment to T219401: Opt-in numbers in IBM not as expected.

Sigh... so this definitely seems to be a field mapping issue on the IBM side. My apologies! I think I know how the problem originated: the field that civi passes over in the export is called opted_in which is the same name as an IBM system field. When we set up new imports (i.e. if it breaks and we need to kick the job, or if we add a new column and need to remap fields), IBM defaults to overwriting whatever data is in this field in place of their system data. There is a manual way to override this, but it is easy to miss and with more people joining the team, the likelihood this mistake repeats itself is high.

Jun 11 2019, 4:13 PM · Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog

Jun 6 2019

CCogdill_WMF added a comment to T170972: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop.

Er, weird! I sent this reply via email yesterday morning but it looks like it didn't post:

Jun 6 2019, 4:14 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 31 2019

CCogdill_WMF added a comment to T219401: Opt-in numbers in IBM not as expected.

Hey @XenoRyet, yeah, it's pretty easy to rerun the queries. Looks like the numbers haven't really changed.

May 31 2019, 3:05 PM · Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog

May 28 2019

CCogdill_WMF updated subscribers of T170972: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop.

@MNoorWMF ccing you so you can help me implement this when ready! :)

May 28 2019, 7:36 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T195907: Annual totals receipt thank you email for recurring donors.

Talked with David about this last week. He confirmed this auto-email will come from Civi, just need to get fr-tech the copy. We will get a draft to you by Friday, June 7!

May 28 2019, 5:53 PM · Fundraising-Backlog, Recurring-Donations, FR-Email
CCogdill_WMF added a comment to T170972: Add calendar year totals fields to CiviCRM & export ? some? of them to silverpop.

Hey all,

May 28 2019, 4:58 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 22 2019

CCogdill_WMF created T224190: IBM segment data in Civi?.
May 22 2019, 10:05 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T223935: SPIKE: Unsubscribes import decreasing in size over 2 days.

Awesome, thanks!

May 22 2019, 4:56 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Patch-For-Review, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising-Backlog
CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

Doh! Embarrassed I missed that and grateful for your keen eyes, @MBeat33.

May 22 2019, 4:54 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog

May 21 2019

CCogdill_WMF updated subscribers of T218240: Create variants for fancy new opt in pages on payments wiki.

Awesome @Ejegg!! Thank you!

May 21 2019, 10:51 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog

May 15 2019

CCogdill_WMF added a comment to T160949: Import email-only contacts from 'remind me later' links into CiviCRM.

Okay great, thanks!

May 15 2019, 7:18 PM · Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint RadioActivewear, Fundraising Sprint Quill Pencil, Fundraising Sprint Prank Seatbelt, Fundraising Sprint Outie Inverter, Fundraising Sprint Navel Warfare, Patch-For-Review, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

Good catch, Sam! +1 to adding validation.

May 15 2019, 3:20 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog
CCogdill_WMF updated subscribers of T160949: Import email-only contacts from 'remind me later' links into CiviCRM.

Thanks for working on this! cc @MBeat33

May 15 2019, 2:58 PM · Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint RadioActivewear, Fundraising Sprint Quill Pencil, Fundraising Sprint Prank Seatbelt, Fundraising Sprint Outie Inverter, Fundraising Sprint Navel Warfare, Patch-For-Review, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 10 2019

CCogdill_WMF added a comment to T185326: Display accepted card types on donate.wikimedia.org.

Awesome! It's in trello for email 1. Thanks again!

May 10 2019, 3:38 PM · donate.wikimedia.org
CCogdill_WMF added a comment to T185326: Display accepted card types on donate.wikimedia.org.

Per your suggestion @Pcoombe, I'd love to test this in Spain! It's ideal timing because we need big lists sizes for landing page tests and we have the room to just cut the esES list in half.

May 10 2019, 3:01 PM · donate.wikimedia.org

May 9 2019

CCogdill_WMF added a comment to T160949: Import email-only contacts from 'remind me later' links into CiviCRM.

Cool, seems fine to me!

May 9 2019, 6:04 AM · Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint RadioActivewear, Fundraising Sprint Quill Pencil, Fundraising Sprint Prank Seatbelt, Fundraising Sprint Outie Inverter, Fundraising Sprint Navel Warfare, Patch-For-Review, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 8 2019

CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

I think we should go with whatever behavior the dedupe process uses--I think it makes the old email secondary and the new one primary? But I'm not sure.

May 8 2019, 4:38 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog
CCogdill_WMF added a comment to T160949: Import email-only contacts from 'remind me later' links into CiviCRM.

Oh okay. As long as Civi logs once that they are RML, it doesn’t matter if
it gets overwritten, right?

May 8 2019, 4:16 AM · Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint RadioActivewear, Fundraising Sprint Quill Pencil, Fundraising Sprint Prank Seatbelt, Fundraising Sprint Outie Inverter, Fundraising Sprint Navel Warfare, Patch-For-Review, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T160949: Import email-only contacts from 'remind me later' links into CiviCRM.

Ah, I don’t think I’m relying on the silverpop group—we automatically add
data into some database fields when someone opts in for RML and that data
stays there (unless it gets overwritten by a new sign up). Totally okay to
overwrite that.

May 8 2019, 2:46 AM · Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint RadioActivewear, Fundraising Sprint Quill Pencil, Fundraising Sprint Prank Seatbelt, Fundraising Sprint Outie Inverter, Fundraising Sprint Navel Warfare, Patch-For-Review, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T160949: Import email-only contacts from 'remind me later' links into CiviCRM.

Sorry, which bit? It seemed like the numbers you were coming up with above
made sense but I don't really understand the process of running commands on
group IDs. I don' think it matters to me if their group ID is reassigned,
but maybe I'm missing something?

May 8 2019, 12:59 AM · Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint RadioActivewear, Fundraising Sprint Quill Pencil, Fundraising Sprint Prank Seatbelt, Fundraising Sprint Outie Inverter, Fundraising Sprint Navel Warfare, Patch-For-Review, FR-Email, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 2 2019

CCogdill_WMF updated subscribers of T222001: Outage to reload triggers.

@TSkaff confirmed that Monday works for the banner team!

May 2 2019, 6:58 PM · Fundraising-Backlog, fundraising-tech-ops

May 1 2019

CCogdill_WMF closed T220645: Where and how to record opt-ins on payment attempts as Declined.

Redundant (see T222220)

May 1 2019, 9:40 PM · Fundraising-Backlog
CCogdill_WMF updated the task description for T222311: Create separate email export file for emails gathered from failed attempts.
May 1 2019, 9:39 PM · Fundraising Sprint Greps of Wrath, Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF triaged T222311: Create separate email export file for emails gathered from failed attempts as Normal priority.
May 1 2019, 9:37 PM · Fundraising Sprint Greps of Wrath, Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF added a comment to T222220: record failed payments.

Cool, that all sounds great! Is there any chance we can also satisfy this
ask in T220645?

May 1 2019, 9:26 PM · Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF added a comment to T222001: Outage to reload triggers.

Remind me--will this be affecting payments or only Civi? If only Civi, emails can run whenever.

May 1 2019, 7:23 PM · Fundraising-Backlog, fundraising-tech-ops

Apr 30 2019

CCogdill_WMF added a comment to T222220: record failed payments.

I think this is a duplicate of this task? https://phabricator
.wikimedia.org/T220645

Apr 30 2019, 8:00 PM · Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF added a comment to T221914: New dedupe blocking issue - on hold.

I think we should drop the on_hold for mail block cases. Mail blocks mean
the user’s email client blocked us, either because the user marked our send
domain as undesirable, because the email client blacklisted our IP, or
because the email client requires whitelisting. It isn’t always indicative
of a user preference.

Apr 30 2019, 7:31 PM · Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Apr 29 2019

CCogdill_WMF updated subscribers of T219401: Opt-in numbers in IBM not as expected.

I just reran the queries in IBM per @Ejegg's suggestion and am seeing basically the same numbers as before:

Apr 29 2019, 6:02 PM · Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog

Apr 25 2019

CCogdill_WMF added a comment to T215865: Re-run omnirecipient repair to catch the few missed ones.

Hey @Eileenmcnaughton, thank you! When you say "I think these are pretty
much caused by email clients polling", do you mean this is just reporting
gross events vs unique, and some email clients might be overreporting?

Apr 25 2019, 6:18 AM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising Sprint Da Vinci Coder, Patch-For-Review, Fundraising-Backlog

Apr 24 2019

CCogdill_WMF triaged T221803: iDEAL opt-ins not recording as Unbreak Now! priority.
Apr 24 2019, 7:58 PM · Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog

Apr 19 2019

CCogdill_WMF added a comment to T220645: Where and how to record opt-ins on payment attempts.

Hi! I see this is in sprint +1 which is fine by me. I'm wondering if it's possible to get an answer on if #2 is even possible--will we be able to record the amount?

Apr 19 2019, 7:01 PM · Fundraising-Backlog

Apr 18 2019

CCogdill_WMF added a comment to T220636: Civi: harmonize currency & amount in TY emails.

You mean removing the symbol from the first sentence? Is that to reduce
donor confusion? I'd prefer not to change that part unless you think we
should for clarity.

Apr 18 2019, 10:31 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

Talked with Elliott today, he said item #2 above is what is hanging this up. My over-simplified summary: the page was designed to require an email address so he needs to rewrite some of the code to make it work without one.

Apr 18 2019, 4:55 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog

Apr 17 2019

CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

Great re: point 3! Thanks for plugging away. I have sql access again but am
having trouble figuring out how to read the civicrm_value_1_communication_4
table to actually check if the opt-ins are happening. Which of the ID
fields can I tie back to a contact record? I tried querying where id or
entity_id = 16134285 (my contactID I'm testing on) and I get an empty set
back.

Apr 17 2019, 7:16 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog

Apr 16 2019

CCogdill_WMF added a comment to T220192: Inaccurate placement for the currency symbol (SEK) in Sweden Thank you letter.

Wonderful!

Apr 16 2019, 7:54 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising-Backlog
CCogdill_WMF added a comment to T220647: ccogdill has new yubikey, need to update frdev server access.

I'm in! Thanks again, Casey.

Apr 16 2019, 6:47 PM · fundraising-tech-ops, Fundraising-Backlog
CCogdill_WMF added a comment to T220647: ccogdill has new yubikey, need to update frdev server access.

Hmm I left off the "caitlincogdill@ccogdillWMF615-3.local" at the end of the ssh key. Is that why? Just updated my office wiki page.

Apr 16 2019, 6:38 PM · fundraising-tech-ops, Fundraising-Backlog
CCogdill_WMF added a comment to T220647: ccogdill has new yubikey, need to update frdev server access.

@cwdent do you need more than just the first 12 digits? I pasted those
first 12 on office wiki already but can put in the full output if you need
it.

Apr 16 2019, 6:09 PM · fundraising-tech-ops, Fundraising-Backlog

Apr 15 2019

CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

Per T220647 my yubikey access is pending so I haven't been able to check again if the data is appearing differently in the back-end. Either way, I see the below as outstanding items or questions. Would it be good to get on a call to talk through these last details?

Apr 15 2019, 4:11 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog
CCogdill_WMF added a comment to T220647: ccogdill has new yubikey, need to update frdev server access.

Bump! I need yubikey access so I can run queries related to T218240 and
help ensure we're getting opt-in data when we need it.

Apr 15 2019, 4:05 PM · fundraising-tech-ops, Fundraising-Backlog

Apr 10 2019

CCogdill_WMF triaged T220647: ccogdill has new yubikey, need to update frdev server access as High priority.
Apr 10 2019, 7:28 PM · fundraising-tech-ops, Fundraising-Backlog
CCogdill_WMF created T220645: Where and how to record opt-ins on payment attempts.
Apr 10 2019, 7:19 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T220636: Civi: harmonize currency & amount in TY emails.

Looks great, Michael! To confirm, this would be the ideal situation for the
donor Michael referenced in his example:

Apr 10 2019, 6:01 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T219401: Opt-in numbers in IBM not as expected.

Bumping this ticket as I think this might be an important bug!

Apr 10 2019, 4:31 PM · Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog

Apr 9 2019

CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

I'm pasting two of your items back in here to reply in-line:

Apr 9 2019, 11:07 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog
CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

Thanks so much, @Ejegg, this looks great! My notes are below--each of Sam's items are included so you don't have to hop back and forth:

Apr 9 2019, 9:21 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog

Apr 8 2019

CCogdill_WMF updated subscribers of T220192: Inaccurate placement for the currency symbol (SEK) in Sweden Thank you letter.

Can we just remove the amount from the subject line altogether? I talked
to @MBeat33 and he is okay with it. I'm happy to update the task
description.

Apr 8 2019, 8:12 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising-Backlog
spatton awarded T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 a Burninate token.
Apr 8 2019, 7:22 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog

Apr 5 2019

CCogdill_WMF added a comment to T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

Ahh awesome, thanks for the update, @Ejegg! I want to bump this additional
question:

Apr 5 2019, 6:52 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF added a comment to T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

@DStrine can we meet to discuss this task? I have a few outstanding questions and am concerned we're collecting opt-ins for folks who are not getting the double opt-in right now.

Apr 5 2019, 6:39 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog

Mar 28 2019

CCogdill_WMF added a comment to T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

I'm also curious what information we're recording about these folks--is
there a sql table I can peek at? Looking at the contact record Michael
cited above, here's some additional info I'd like to see:

Mar 28 2019, 11:07 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF triaged T219574: Create separate export file for non-donor opt-in contacts as Normal priority.
Mar 28 2019, 10:58 PM · Fundraising-Backlog
CCogdill_WMF created T219574: Create separate export file for non-donor opt-in contacts.
Mar 28 2019, 10:58 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

I think it's important the double opt-in email happens almost concurrently
with signup. Otherwise it happens out of context and I don't think will be
appropriate.

Mar 28 2019, 9:36 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF added a comment to T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

Ah @Ejegg <T217712+public+7ba0a0e50372df47@phabricator.wikimedia.org> can
we roll this out more slowly? I'm sorry, I didn't know it would be done so
quickly. I think it's essential these people get a double opt-in email and
I don't have that translated anywhere yet.

Mar 28 2019, 6:19 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog
CCogdill_WMF added a comment to T217712: Update Silverpop export to include opted in records with no donations.

Ah @Ejegg <T217712+public+7ba0a0e50372df47@phabricator.wikimedia.org> can
we roll this out more slowly? I'm sorry, I didn't know it would be done so
quickly. I think it's essential these people get a double opt-in email and
I don't have that translated anywhere yet.

Mar 28 2019, 6:19 PM · Fundraising Sprint Ewoks Take Manhattan, FR-Email, Fundraising-Backlog

Mar 27 2019

CCogdill_WMF triaged T219401: Opt-in numbers in IBM not as expected as High priority.
Mar 27 2019, 3:02 PM · Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising-Backlog
CCogdill_WMF added a comment to T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

Hey @Ejegg, I see this is done! How is it working on the IBM side? I should expect to see new records show up with blank donation details but opt-ins?

Mar 27 2019, 2:49 PM · Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, MW-1.33-notes (1.33.0-wmf.24; 2019-04-02), Fundraising Sprint Fistful of $variables, Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog

Mar 21 2019

CCogdill_WMF added a comment to T218240: Create variants for fancy new opt in pages on payments wiki.

Re translations, yes, we will be getting them, starting with Italian but moving on to Swedish and likely Dutch in April and May. I don't know what the merits are of using translate wiki vs doing them as one-offs. Can you help us decide what would be the best an ongoing workflow?

Mar 21 2019, 9:27 PM · MW-1.34-notes (1.34.0-wmf.7; 2019-05-28), Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Patch-For-Review, Fundraising Sprint Fistful of $variables, Fundraising-Backlog

Mar 15 2019

CCogdill_WMF added a comment to T217712: Update Silverpop export to include opted in records with no donations.

Ah okay. I'd be curious where those are coming from. We have more than 400k
on the RML lists so I would guess that's something else.

Mar 15 2019, 4:55 PM · Fundraising Sprint Ewoks Take Manhattan, FR-Email, Fundraising-Backlog
CCogdill_WMF added a comment to T217712: Update Silverpop export to include opted in records with no donations.

Hey @Ejegg, just checking--we are already recording opted-in (failed)
payment attempts in Civi? It was my assumption that we weren't creating
Civi records for those folks, so they wouldn't appear in the export.

Mar 15 2019, 4:41 PM · Fundraising Sprint Ewoks Take Manhattan, FR-Email, Fundraising-Backlog

Mar 13 2019

CCogdill_WMF added a comment to T213209: Reduce recurring TY emails.

#1 - There's actually another open task about this. We can just drop the amount from the SL and it should still make sense. "Your gift = free knowledge for billions"

Mar 13 2019, 3:36 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising Sprint Da Vinci Coder, Patch-For-Review, Fundraising Sprint Casino Royale With Cheese, Fundraising Sprint Bert and Ernie's Excellent Adventure, Fundraising Sprint A series of unfortunate event handlers, Recurring-Donations, FR-Email, Fundraising-Backlog

Mar 7 2019

CCogdill_WMF added a comment to T200240: Mailing data double counting in CiviCRM?.

Fair point, I'll let Jasmeet know. Thank you!

Mar 7 2019, 4:45 AM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Patch-For-Review, Fundraising Sprint Owls, Fundraising-Backlog
CCogdill_WMF added a comment to T200240: Mailing data double counting in CiviCRM?.

Ah great, thanks! OPEN would be the other event type I want to focus on in
the near-term.

Mar 7 2019, 1:56 AM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Patch-For-Review, Fundraising Sprint Owls, Fundraising-Backlog
CCogdill_WMF added a comment to T213209: Reduce recurring TY emails.

Hm, I'll need to check with @jrobell on that. I don't think we were
planning on putting the whole TY letter in the translation request as that
will be more expensive and time-consuming, but maybe it's worth killing two
birds...

Mar 7 2019, 1:39 AM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising Sprint Da Vinci Coder, Patch-For-Review, Fundraising Sprint Casino Royale With Cheese, Fundraising Sprint Bert and Ernie's Excellent Adventure, Fundraising Sprint A series of unfortunate event handlers, Recurring-Donations, FR-Email, Fundraising-Backlog
CCogdill_WMF added a comment to T200240: Mailing data double counting in CiviCRM?.

Ah okay, thanks for explaining re those frequent jobs.

Mar 7 2019, 1:37 AM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Patch-For-Review, Fundraising Sprint Owls, Fundraising-Backlog
CCogdill_WMF added a comment to T161761: Reflect all undeliverables via Silverpop in CiviCRM.

That 737k number makes sense to me. The distinct seems important.

Mar 7 2019, 12:41 AM · Patch-For-Review, Fundraising Sprint Da Vinci Coder, FR-Email, Wikimedia-Fundraising-CiviCRM, Epic, Fundraising-Backlog

Mar 6 2019

CCogdill_WMF added a comment to T213209: Reduce recurring TY emails.

@Ejegg thanks for bumping! Jessica and I just checked-in. This is such a huge translation request that it'll take a bit more time to get ready. All translations should be ready and on Meta by EOM. Jessica wants to confirm fr-tech will be ready to publish the new TY email in every language at that time. Is that in the plan?

Mar 6 2019, 7:07 PM · Fundraising Sprint Never Ending Query, Fundraising Sprint Men In Slack, Fundraising Sprint Land before Timeouts, Fundraising Sprint King Kong vs. Mozilla, Fundraising Sprint James Bond: Licensed to Share, Fundraising Sprint It Came From Out of Scope, Fundraising Sprint Hansel and grep -l, Fundraising Sprint Greps of Wrath, Fundraising Sprint Fistful of $variables, Fundraising Sprint Ewoks Take Manhattan, Fundraising Sprint Da Vinci Coder, Patch-For-Review, Fundraising Sprint Casino Royale With Cheese, Fundraising Sprint Bert and Ernie's Excellent Adventure, Fundraising Sprint A series of unfortunate event handlers, Recurring-Donations, FR-Email, Fundraising-Backlog

Mar 5 2019

CCogdill_WMF added a comment to T200240: Mailing data double counting in CiviCRM?.

Thanks for continuing to check on this, Eileenmcnaughton! Do you have an
estimate on when this follow up job will finish? And should we expect the
data to need to be cleaned up on a consistent basis?

Mar 5 2019, 6:45 PM · Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint Raw data can give you salmonella, Fundraising Sprint Queue is pronounced GJif, Fundraising Sprint Pluto is still a planet, Patch-For-Review, Fundraising Sprint Owls, Fundraising-Backlog