Page MenuHomePhabricator

CCogdill_WMF (Caitlin Cogdill)
WMF Fundraising Email Manager

Projects

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

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

Recent Activity

Wed, May 22

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

Awesome, thanks!

Wed, May 22, 4:56 PM · 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.

Wed, May 22, 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

Tue, May 21

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

Awesome @Ejegg!! Thank you!

Tue, May 21, 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

Wed, May 15

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

Okay great, thanks!

Wed, May 15, 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.

Wed, May 15, 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

Wed, May 15, 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

Fri, May 10

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!

Fri, May 10, 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.

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

Thu, May 9

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

Cool, seems fine to me!

Thu, May 9, 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

Wed, May 8

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.

Wed, May 8, 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?

Wed, May 8, 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.

Wed, May 8, 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?

Wed, May 8, 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

Thu, May 2

CCogdill_WMF updated subscribers of T222001: Outage to reload triggers.

@TSkaff confirmed that Monday works for the banner team!

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

Wed, May 1

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

Redundant (see T222220)

Wed, May 1, 9:40 PM · Fundraising-Backlog
CCogdill_WMF updated the task description for T222311: Create separate email export file for emails gathered from failed attempts.
Wed, May 1, 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.
Wed, May 1, 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?

Wed, May 1, 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.

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

Tue, Apr 30

CCogdill_WMF added a comment to T222220: record failed payments.

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

Tue, Apr 30, 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.

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

Mon, Apr 29

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:

Mon, Apr 29, 6:02 PM · 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 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 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 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 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 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
CCogdill_WMF added a comment to T217254: Hide opt_in radio buttons when the choice has been provided on the query string.

We have translations for Italian already--they ran on donate wiki in the
itIT email fundraiser. Not sure where the translation lives.

Mar 5 2019, 6:12 PM · Fundraising Sprint Ewoks Take Manhattan, MW-1.33-notes (1.33.0-wmf.21; 2019-03-12), Patch-For-Review, MediaWiki-extensions-DonationInterface, Fundraising Sprint Da Vinci Coder, Fundraising-Backlog
CCogdill_WMF added a comment to T217254: Hide opt_in radio buttons when the choice has been provided on the query string.

Yeah, good thinking! We should add all EU / UK countries to the list where
translations exist. Do you need an exhaustive list or is that directive
clear enough?

Mar 5 2019, 4:55 PM · Fundraising Sprint Ewoks Take Manhattan, MW-1.33-notes (1.33.0-wmf.21; 2019-03-12), Patch-For-Review, MediaWiki-extensions-DonationInterface, Fundraising Sprint Da Vinci Coder, Fundraising-Backlog
CCogdill_WMF added a comment to T161761: Reflect all undeliverables via Silverpop in CiviCRM.

@Eileenmcnaughton, does this mean there are 4.2 million records with one of
these event_type? That seems very high to me.

Mar 5 2019, 1:02 AM · Patch-For-Review, Fundraising Sprint Da Vinci Coder, FR-Email, Wikimedia-Fundraising-CiviCRM, Epic, Fundraising-Backlog

Mar 4 2019

CCogdill_WMF added a comment to T207674: Thank You email: revise how we specify local currency.

Let's remove the amount from the TY email subject line while we're at it. I think the currency code will look funky there.

Mar 4 2019, 5:36 PM · Patch-For-Review, Fundraising Sprint Ewoks Take Manhattan, Fundraising-Backlog

Feb 27 2019

CCogdill_WMF added a comment to T170972: Re-add fields to Silverpop export.

Sounds good!

Feb 27 2019, 10:41 PM · Fundraising-Backlog
CCogdill_WMF updated subscribers of T170972: Re-add fields to Silverpop export.

5000 per day lines up with what we're seeing. Thanks, that makes sense!

Feb 27 2019, 10:17 PM · Fundraising-Backlog
CCogdill_WMF updated subscribers of T170972: Re-add fields to Silverpop export.
Feb 27 2019, 8:54 PM · Fundraising-Backlog
CCogdill_WMF updated subscribers of T170972: Re-add fields to Silverpop export.

Okay that makes sense. Should we be seeing the unsubscribes file grow
proportionately? Is there any amount of variance we should flag?

Feb 27 2019, 8:54 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T170972: Re-add fields to Silverpop export.

I've noticed the number of rows imported to IBM nightly has decreased over the last two days. It's only about 5k rows smaller each day, but that's an odd phenomenon. Is it because someone is working on this task?

Feb 27 2019, 5:42 PM · Fundraising-Backlog

Feb 26 2019

CCogdill_WMF updated subscribers of T161761: Reflect all undeliverables via Silverpop in CiviCRM.

Hey Eileen, I'm in agreement with what you proposed in your earlier comment!

Feb 26 2019, 3:48 PM · Patch-For-Review, Fundraising Sprint Da Vinci Coder, FR-Email, Wikimedia-Fundraising-CiviCRM, Epic, Fundraising-Backlog

Feb 22 2019

CCogdill_WMF updated subscribers of T143429: EPIC: Recurring upsell for donors.

I don't actually see that in the slides for option 1 or 2 -- but yes, I
agree, the donor should be able to select a different amount. I believe
Trilogy had an amounts grid which suggests a different, lower recurring
amount than the donor's one-time donation.

Feb 22 2019, 6:36 PM · Epic, Fundraising-Backlog

Feb 21 2019

CCogdill_WMF added a comment to T170972: Re-add fields to Silverpop export.

We met today and discussed making the fields numerical rather than Y/N, which is good! We talked about the benefits of including the native amount rather than USD, but after considering that further, I've changed my mind. Supporting the native amount would just require too many fields and it would make the data harder to work with.

Feb 21 2019, 1:20 AM · Fundraising-Backlog

Feb 20 2019

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

We adjusted the copy in the regular TY email to reflect the fact that
they'll only get an EOY receipt. That's why I want to make sure that text
is translated before this goes live.

Feb 20 2019, 6:21 PM · 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 T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

We're trying to figure out how high of a priority this should be. Maybe less people are being left on the table than I thought. Is it easy to figure out these stats?

Feb 20 2019, 5:20 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

Feb 19 2019

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

We'd definitely want to talk about how to integrate these folks into our Civi and IBM databases. I might suggest these are imported into IBM through in a separate file but happy to discuss pros and cons of either option.

Feb 19 2019, 5:11 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

Feb 15 2019

CCogdill_WMF added a comment to T170972: Re-add fields to Silverpop export.

Awesome, thanks!

Feb 15 2019, 11:10 PM · Fundraising-Backlog
CCogdill_WMF updated subscribers of T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .

Adding a few potentially interested parties: @Pcoombe @spatton @MBeat33

Feb 15 2019, 10:45 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 T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 as High priority.
Feb 15 2019, 10:45 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 created T216293: Send message to opt-in queue on failed payments attempts with opt_in=1 .
Feb 15 2019, 10:44 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 T161761: Reflect all undeliverables via Silverpop in CiviCRM.

Just making sure--is there anything else you need on this task?

Feb 15 2019, 10:42 PM · Patch-For-Review, Fundraising Sprint Da Vinci Coder, FR-Email, Wikimedia-Fundraising-CiviCRM, Epic, Fundraising-Backlog
CCogdill_WMF added a comment to T173538: Make Silverpop export leaner.

Hey there, sorry I'm just coming back to this task now! I just modified the task description to make the nouns clearer--I think you all thought I was talking about the opposite end of the process. @Eileenmcnaughton does this clarify my intention?

Feb 15 2019, 10:40 PM · FR-Email, Fundraising-Backlog
CCogdill_WMF updated the task description for T173538: Make Silverpop export leaner.
Feb 15 2019, 10:39 PM · FR-Email, Fundraising-Backlog
CCogdill_WMF raised the priority of T170972: Re-add fields to Silverpop export from Normal to High.

Hi, I'm changing this task to High priority because the topic of increased email segmentation has been brought up numerous times by Lisa and other managers as a way for us to grow revenue in the future. The kind of segmentation they're talking about is totally dependent on us having these fields available in the database. Can we please add these fields back?

Feb 15 2019, 10:35 PM · Fundraising-Backlog
CCogdill_WMF closed T162197: Silverpop import processed twice as Invalid.

Out of date, closing!

Feb 15 2019, 10:29 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T213209: Reduce recurring TY emails.

I think it’s okag that we’re still using the old TY email copy, if we need
to, but we should at least get the new recurring paragraph added.

Feb 15 2019, 1:58 AM · 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 T213209: Reduce recurring TY emails.

Hey there! Just checking to see if we have the new text translated in
Italian (and in bundle countries?) before making this change live, since
we'll need to notify any new recurring donors they won't be receiving
future emails.

Feb 15 2019, 12:36 AM · 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

Feb 14 2019

CCogdill_WMF added a comment to T215340: research recurring upsell.

Do we know what that looks like on the PP side? It's not ideal but it makes
sense. We could compare it to the CC conversion rate and see if returning
to the payment flow really hurts.

Feb 14 2019, 8:10 PM · Fundraising Sprint Casino Royale With Cheese, Recurring-Donations, Fundraising-Backlog

Feb 5 2019

CCogdill_WMF added a comment to T215340: research recurring upsell.

Hey David,

Feb 5 2019, 8:18 PM · Fundraising Sprint Casino Royale With Cheese, Recurring-Donations, Fundraising-Backlog

Jan 18 2019

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

It's still in the copy, it's just higher up. Here is the paragraph we're
proposing we add under the first paragraph, only to display to recurring
donors:

Jan 18 2019, 7:13 PM · 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

Jan 17 2019

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

So that is actually included in the paragraph we're adding in the body of
the email. Can we remove it from the footer altogether?

Jan 17 2019, 10:12 PM · 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

Jan 15 2019

CCogdill_WMF closed T213862: Check Civi email export is working as Resolved.

Elliott checked, upload is working fine. Confirmed filenames.

Jan 15 2019, 8:27 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T213862: Check Civi email export is working.

Making this unbreak now because I can't send without a good suppression list :(

Jan 15 2019, 8:21 PM · Fundraising-Backlog
CCogdill_WMF triaged T213862: Check Civi email export is working as Unbreak Now! priority.
Jan 15 2019, 8:20 PM · Fundraising-Backlog
CCogdill_WMF created T213862: Check Civi email export is working.
Jan 15 2019, 8:20 PM · Fundraising-Backlog
CCogdill_WMF added a comment to T213209: Reduce recurring TY emails.

This works for me! Michael added this suggestion as a comment in the doc
because we weren't sure of the easiest way to represent it in the copy.

Jan 15 2019, 7:32 PM · 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

Jan 9 2019

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

Apologies, I just updated the sharing settings.

Jan 9 2019, 8:51 PM · 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