Page MenuHomePhabricator

CCogdill_WMF (Caitlin Cogdill)
Disabled

Projects

User does not belong to any projects.

User Details

User Since
Oct 29 2014, 10:26 PM (316 w, 6 d)
Roles
Disabled
IRC Nick
ccogdill
LDAP User
Unknown
MediaWiki User
CCogdill (WMF) [ Global Accounts ]
This account has been disabled.

Recent Activity

Aug 31 2020

CCogdill_WMF updated subscribers of T188561: SSL cert for links.email.wikimedia.org.
Aug 31 2020, 6:30 AM · FR-Email, Fundraising-Backlog, Operations, Traffic, fundraising-tech-ops
CCogdill_WMF added a project to T188561: SSL cert for links.email.wikimedia.org: FR-Email.
Aug 31 2020, 6:29 AM · FR-Email, Fundraising-Backlog, Operations, Traffic, fundraising-tech-ops

Aug 27 2020

CCogdill_WMF added a comment to T188561: SSL cert for links.email.wikimedia.org.

Update! The link tracking domain removed support for TLS 1.0 and 1.1, so now score higher:

Aug 27 2020, 7:26 PM · FR-Email, Fundraising-Backlog, Operations, Traffic, fundraising-tech-ops

Aug 18 2020

CCogdill_WMF added a comment to T257597: Add two additional fields to silverpop export.

Is there a new task for backfilling the data? If not, can we keep this one
open?

Aug 18 2020, 8:01 PM · Fundraising Sprint Pseudopretzels, Fundraising-Backlog

Aug 10 2020

CCogdill_WMF added a comment to T259935: Unsubscribe footer copy error in ES + email question.

Also, re: question A -- this actually helps point out a funny inconsistency in our unsubscribe rules. Because Legal has tested our forms more than once, the privacy@wikimedia.org contact record has inconsistent data:

  • country = MX
  • RML_country = IN
Aug 10 2020, 5:11 PM · fr-donorservices, Fundraising-Backlog
CCogdill_WMF updated subscribers of T259935: Unsubscribe footer copy error in ES + email question.

@MNoorWMF can help or delegate this to trilogy. Thanks!

Aug 10 2020, 5:04 PM · fr-donorservices, Fundraising-Backlog

Aug 3 2020

CCogdill_WMF updated subscribers of T256184: Add utm_medium to failed recur email.

Hmm, basing off what email does, I might do something like:
utm_medium=civi-mail
utm_campaign=FailedRecur
utm_source=FY2021_FailedRecur

Aug 3 2020, 8:54 PM · Fundraising Sprint Pseudopretzels, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jul 30 2020

CCogdill_WMF added a comment to T255692: New Acoustic domain rollout - Change URLs.

Just adding a little more info from Acoustic--it seems like the API calls we're using with the old URLs are related to GDPR. This could potentially be problematic for France if we aren't accurately handling GDPR requests. The France campaign launches in two weeks.

Jul 30 2020, 4:51 PM · fundraising Sprint Quackery limited to ducks, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jul 16 2020

CCogdill_WMF added a comment to T254809: Export Matching Gifts data to acoustic.

Bump! See Moska's Q above.

Jul 16 2020, 4:05 PM · Fundraising Sprint MySQL is YourSQL and WeSQL, Patch-For-Review, Fundraising Sprint Lazy Loading Life, Fundraising-Backlog

Jul 9 2020

CCogdill_WMF renamed T257597: Add two additional fields to silverpop export from Add one additional field to silverpop export to Add two additional fields to silverpop export.
Jul 9 2020, 5:08 PM · Fundraising Sprint Pseudopretzels, Fundraising-Backlog
CCogdill_WMF updated subscribers of T257597: Add two additional fields to silverpop export.
Jul 9 2020, 5:05 PM · Fundraising Sprint Pseudopretzels, Fundraising-Backlog
CCogdill_WMF triaged T257597: Add two additional fields to silverpop export as High priority.
Jul 9 2020, 5:04 PM · Fundraising Sprint Pseudopretzels, Fundraising-Backlog

Jul 8 2020

CCogdill_WMF added a comment to T255805: TS update import back into Civi.

Great, thank you!

Jul 8 2020, 7:39 PM · Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T255805: TS update import back into Civi.

Sorry, one more question: Will this data automatically be included in the
Acoustic export once it's imported? Or is there a separate task for that?

Jul 8 2020, 4:30 PM · Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T255805: TS update import back into Civi.

Okay great, thanks for the confirmation!

Jul 8 2020, 4:14 PM · Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T255805: TS update import back into Civi.

Awesome, thank you! Let us know your ETA so we can get our ducks in a row
and prepare for the next steps in our targeting projections :)

Jul 8 2020, 4:03 PM · Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jul 7 2020

CCogdill_WMF added a comment to T255805: TS update import back into Civi.

Cool! So are we expecting this will take a few days to complete? Should we
expect it in the email export by EOW, or what do you think?

Jul 7 2020, 6:08 PM · Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jul 2 2020

CCogdill_WMF added a comment to T255805: TS update import back into Civi.

Ah got it, I didn’t realize how the process worked. We may just have to
move some deadlines set for us to review the targeting strategy with
leadership. Pats said that’s fine so just keep us posted on an ETA.

Jul 2 2020, 11:45 PM · Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T252245: Add and delete fields from the _all_Wikimedia database (civi export to ESP).

Yay!! Thank you both, Katie and Eileen, for the great work and
communication this week.

Jul 2 2020, 10:06 PM · Fundraising Sprint Nyan cats for everyone, Patch-For-Review, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Lazy Loading Life, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
CCogdill_WMF added a comment to T255805: TS update import back into Civi.

Thanks for working on this, @mepps! Any chance we'll be able to resolve
this during this week? We're hoping to have all the data we need by Monday
so we restart our targeting work.

Jul 2 2020, 5:39 PM · Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jun 27 2020

CCogdill_WMF added a comment to T256522: Small number of contacts being inappropriately put on the suppression list.

Option #2 shouldn’t be a possibility... we want it to be easy for someone
to switch their opt-in preferences, which means we handle them on the
Acoustic side. If they are added to the suppression list, how will they get
removed from the Acoustic list if they opt back in?

Jun 27 2020, 3:29 PM · Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Lazy Loading Life, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Jun 25 2020

CCogdill_WMF added a comment to T256162: Missing "unsubscribe" link in automatic recurring failure email.

I'm fine with using the Acoustic link as long as it works for y'all in
testing.

Jun 25 2020, 3:56 PM · Fundraising Sprint Octopus hugs, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog
CCogdill_WMF added a comment to T253152: Q4 FY2019/20 investigate export and upload issues with the silverpop export .

Yeah to put a fine point on it, we *can't* map to a field that doesn't yet
exist in the import. We need you to add it before we can map it.

Jun 25 2020, 2:17 PM · Fundraising Sprint Pseudopretzels, Fundraising Sprint Octopus hugs, Fundraising Sprint Nyan cats for everyone, Patch-For-Review, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising Sprint Lazy Loading Life, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Jun 23 2020

CCogdill_WMF added a comment to T256162: Missing "unsubscribe" link in automatic recurring failure email.

Can she provide a sample Zendesk ticket? It should be easy enough to tell
what type of email this is.

Jun 23 2020, 7:51 PM · Fundraising Sprint Octopus hugs, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog
CCogdill_WMF added a comment to T256162: Missing "unsubscribe" link in automatic recurring failure email.

Which email was this from? I read the title of this task and thought it was referring to a Civi TY email.

Jun 23 2020, 7:37 PM · Fundraising Sprint Octopus hugs, Fundraising Sprint Nyan cats for everyone, Fundraising Sprint MySQL is YourSQL and WeSQL, Fundraising-Backlog
CCogdill_WMF updated subscribers of T256073: Silverpop export: move the suppression list to a different job.
Jun 23 2020, 12:16 AM · FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
CCogdill_WMF added a comment to T256073: Silverpop export: move the suppression list to a different job.

Makes sense!

Jun 23 2020, 12:14 AM · FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Jun 22 2020

CCogdill_WMF added a comment to T256073: Silverpop export: move the suppression list to a different job.

Jumping in since Katie is having a busy week. I want to add a response to
your question along with a few process notes:

Jun 22 2020, 11:58 PM · FR-Q2-FY2020-21-cleanup-list, Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog

Jun 17 2020

CCogdill_WMF added a comment to T255692: New Acoustic domain rollout - Change URLs.

Thank you, Moska! Re your last comment, we are on Pod 4 so we will be affected.

Jun 17 2020, 6:30 PM · fundraising Sprint Quackery limited to ducks, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jun 16 2020

CCogdill_WMF added a comment to T238156: Dedupe suggestion: track down OG contact records for "new" donors.

I can't think of anything else! If fr-tech thinks this still works, can
y'all perform your own test or jump on a screenshare with Katers to
show her how to confirm it works? Seems like something might not be working
here.

Jun 16 2020, 5:36 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jun 11 2020

CCogdill_WMF added a comment to T254809: Export Matching Gifts data to acoustic.

I think I still want to defer to Nora here :) I don't know what is in each
of these fields.

Jun 11 2020, 9:15 PM · Fundraising Sprint MySQL is YourSQL and WeSQL, Patch-For-Review, Fundraising Sprint Lazy Loading Life, Fundraising-Backlog
CCogdill_WMF added a comment to T254809: Export Matching Gifts data to acoustic.

I think I want to defer to Nora for what fields we need, as I haven't seen
the HEP data and don't know what all is at our disposal. The purpose of the
emails we're going to send is to connect donors to their relevant matching
gifts portals.

Jun 11 2020, 8:41 PM · Fundraising Sprint MySQL is YourSQL and WeSQL, Patch-For-Review, Fundraising Sprint Lazy Loading Life, Fundraising-Backlog

Jun 9 2020

CCogdill_WMF added a comment to T254809: Export Matching Gifts data to acoustic.

Please get us the column headers and demo data whenever you can! That will allow the email team to get to work while y'all do your side.

Jun 9 2020, 6:15 PM · Fundraising Sprint MySQL is YourSQL and WeSQL, Patch-For-Review, Fundraising Sprint Lazy Loading Life, Fundraising-Backlog

Jun 3 2020

CCogdill_WMF triaged T254304: Conflicting fields in some Acoustic contact records as High priority.

Thanks so much for catching this, Katie! This seems like a big deal so I am setting the priority at High.

Jun 3 2020, 8:03 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T249925: Create template for automated matching gift email.

Per my comment on the parent task T228765, I don't think fr-tech owns this portion of the task. Should we keep it open and have someone from my team claim it, or close?

Jun 3 2020, 7:35 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF updated subscribers of T249926: Create a job to send automatic matching gifts emails.

Per my update on the parent task T228765, I think this task description needs to be updated to instead Create a job to export HEP data to Acoustic on an employer-ID level.

Jun 3 2020, 7:34 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF updated subscribers of T228765: Epic: matching gifts HEP integration (was employer field V2).

Adding my notes here from our meeting just now with fr-tech and MGF to confirm next steps for email integration. I'm adding @MNoorWMF and @KHaggard to this task as I'll need their help with implementation.

Jun 3 2020, 7:32 PM · Epic, Fundraising-Backlog

Jun 2 2020

CCogdill_WMF updated subscribers of T238156: Dedupe suggestion: track down OG contact records for "new" donors.

@MNoorWMF will be taking the lead on this! We will need to make a change to all urls in all templates which will take a bit of time. We are committing to wrapping this by EOQ.

Jun 2 2020, 3:25 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 27 2020

CCogdill_WMF added a comment to T238156: Dedupe suggestion: track down OG contact records for "new" donors.

Seems like we can resolve this on the email side by adding the contact_hash, along with contactID, to all urls. Will discuss this with the email team next Tuesday and confirm when we implement

May 27 2020, 9:16 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 6 2020

CCogdill_WMF added a comment to T251833: Figure out how to check regularly on screen scrape data coming in.

This seems like a great idea! Monthly makes sense to me unless @EYener sees
a reason to do it more frequently.

May 6 2020, 7:07 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

May 5 2020

CCogdill_WMF added a comment to T125272: Epic: Create Preference Center for donors to manage email subscription preferences.

Checked in with David and Dylan today and bumped Mariana's question above
re: hosting multiple versions of the form for small dollar and major
donors. Dylan said fr-tech was aware this was a desired feature and are
hoping to be able to support it. fr-creative will proceed assuming we can
maintain multiple versions of the form, and fr-tech will let us know if
that changes.

May 5 2020, 6:51 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog

Apr 6 2020

CCogdill_WMF added a comment to T230064: generate generic email for failed recurring donations .

I just updated the url for "starter text" in the task description. The copy is actually the same as it was in the original link, but I've stripped out some confusing bits from the OG doc.

Apr 6 2020, 8:42 PM · Fundraising Sprint Lazy Loading Life, Fundraising Sprint Kavascript: the chill new language, Fundraising Sprint Just space out, Fundraising Sprint Ice cream cures everything, Fundraising Sprint Heaven is a page on Wikipedia, fundraising Sprint Grep works IRL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF updated the task description for T230064: generate generic email for failed recurring donations .
Apr 6 2020, 8:39 PM · Fundraising Sprint Lazy Loading Life, Fundraising Sprint Kavascript: the chill new language, Fundraising Sprint Just space out, Fundraising Sprint Ice cream cures everything, Fundraising Sprint Heaven is a page on Wikipedia, fundraising Sprint Grep works IRL, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mar 18 2020

CCogdill_WMF added a comment to T248019: New Custom Field - Opt Out Endowment Emails.

Thanks, Nora! This is a good argument for the preference center for sure.

Mar 18 2020, 7:44 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Mar 3 2020

CCogdill_WMF updated subscribers of T237715: Opt in - remove from suppression list.

Ccing @KHaggard so she can track changes to the imports as a result of this
task (when completed).

Mar 3 2020, 4:50 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF updated subscribers of T173538: Make Silverpop export leaner.

Ccing @KHaggard so she can follow changes on this task.

Mar 3 2020, 4:38 PM · Wikimedia-Fundraising-CiviCRM, FR-Q2-FY2019-20-cleanup-list, FR-Email, Fundraising-Backlog

Feb 21 2020

CCogdill_WMF added a comment to T245087: Delete contacts deleted before 2017.

Confirmed!

Feb 21 2020, 3:02 AM · Fundraising Sprint Evil Twins For Everyone, Fundraising Sprint Dampness, Fundraising Sprint CAPS LOCK CULTS, Fr-planning-ahead, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog, fundraising-tech-ops

Feb 12 2020

CCogdill_WMF updated subscribers of T244873: Plural in fundraising email with "badges".

@MNoorWMF @CDenes_WMF

Feb 12 2020, 8:35 PM · I18n, Fundraising-Backlog

Feb 6 2020

CCogdill_WMF added a comment to T244397: Civi: make EN TY emails specify one-time donation.

Thanks so much for jumping on this, Peter :)

Feb 6 2020, 8:06 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Feb 5 2020

CCogdill_WMF added a comment to T244397: Civi: make EN TY emails specify one-time donation.

Fine with me!

Feb 5 2020, 10:11 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF updated subscribers of T244397: Civi: make EN TY emails specify one-time donation.

Okay thanks, English-only seems super doable. Does it seem fair to update
the task description to reflect that?

Feb 5 2020, 8:43 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T244397: Civi: make EN TY emails specify one-time donation.

This *could* be a big translation ask and we're running a little low on budget for that. Just checking, what's the priority on this? Would it be good enough to address for the next TY, or does it need to be changed now?

Feb 5 2020, 8:10 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Jan 16 2020

CCogdill_WMF added a comment to T239375: Follow up with DS to determine if silverpop contact's were likely privacy deletes.

Ooh thanks for all the digging, Eileen. That copy is from an RML email for
sure!

Jan 16 2020, 6:00 AM · Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, FR-Tech-Analytics

Dec 17 2019

CCogdill_WMF added a comment to T238620: Figure out why sp60563358 is not imported - Emjois?.

Hmm, that mailing is a remind me later mailing. Those are special cases
because they're sent as automated programs on timers based on user
behavior, rather than as bulk sends. We use different reports to get the
performance data for automated programs. Maybe that's why you can't see the
sent numbers?

Dec 17 2019, 3:42 PM · Fundraising Sprint YAMLton, the Musical, Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog, FR-Tech-Analytics

Dec 6 2019

CCogdill_WMF updated the task description for T238156: Dedupe suggestion: track down OG contact records for "new" donors.
Dec 6 2019, 5:26 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Dec 5 2019

spatton awarded T239889: Update TY email copy, pt 2 a Love token.
Dec 5 2019, 2:37 PM · Fundraising Sprint X-rays, Fundraising-Backlog
CCogdill_WMF added a comment to T239889: Update TY email copy, pt 2.

Thank you! That looks good to me.

Dec 5 2019, 2:35 PM · Fundraising Sprint X-rays, Fundraising-Backlog
Pcoombe awarded T239889: Update TY email copy, pt 2 a Like token.
Dec 5 2019, 12:02 PM · Fundraising Sprint X-rays, Fundraising-Backlog
CCogdill_WMF triaged T239889: Update TY email copy, pt 2 as High priority.
Dec 5 2019, 8:58 AM · Fundraising Sprint X-rays, Fundraising-Backlog
CCogdill_WMF updated the task description for T239889: Update TY email copy, pt 2.
Dec 5 2019, 8:58 AM · Fundraising Sprint X-rays, Fundraising-Backlog
CCogdill_WMF created T239889: Update TY email copy, pt 2.
Dec 5 2019, 8:58 AM · Fundraising Sprint X-rays, Fundraising-Backlog

Dec 2 2019

CCogdill_WMF added a comment to T239126: Huge decrease in contacts from the main database update.

Ah, there must be duplicate rows on that import or something. We show
3,065,196 in IBM now. Higher than when I last checked :)

Dec 2 2019, 2:09 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
CCogdill_WMF added a comment to T239126: Huge decrease in contacts from the main database update.

@Ejegg nope, that sounds really high. We have a total suppression list of
about 2M -- 426k would be a 25% increase in our total suppression list.

Dec 2 2019, 2:03 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 27 2019

CCogdill_WMF added a comment to T236855: Fix missing email recipient data.

Thanks so much for all the digging, Eileen! Looking forward to seeing how
things look tomorrow. I'll be happy to research the mailings that you think
may be deleted or do any other QA on the ESP side. Let me know how I can
help!

Nov 27 2019, 6:27 AM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back

Nov 26 2019

CCogdill_WMF added a comment to T238684: Update English TY email text based on donor feedback.

Wonderful, thank you!

Nov 26 2019, 6:33 AM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 25 2019

CCogdill_WMF added a comment to T239126: Huge decrease in contacts from the main database update.

They should be... we aren't able to access the files after upload.

Nov 25 2019, 11:14 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
CCogdill_WMF added a comment to T239126: Huge decrease in contacts from the main database update.

And the file we upload has no duplicate email addresses?

Nov 25 2019, 11:10 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 20 2019

CCogdill_WMF added a comment to T238689: Civi to IBM export: Ensure CIDs ordered in reverse chronological order.

Okay thanks for digging into this and explaining the current prcess! @MBeat33 please have your team chime in if they have other examples they wanted us to look at. It sounds like these were cases of email address typos.

Nov 20 2019, 4:04 PM · Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 19 2019

CCogdill_WMF added a comment to T238689: Civi to IBM export: Ensure CIDs ordered in reverse chronological order.

Some sample CIDs:
24041039
30066653
5396632

Nov 19 2019, 9:22 PM · Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
CCogdill_WMF added a comment to T238684: Update English TY email text based on donor feedback.

The new copy has been reviewed and approved by Sam, Michael, and Camille as well. This should be ready to go live :)

Nov 19 2019, 7:09 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
CCogdill_WMF triaged T238684: Update English TY email text based on donor feedback as High priority.
Nov 19 2019, 7:06 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog
CCogdill_WMF created T238684: Update English TY email text based on donor feedback.
Nov 19 2019, 7:05 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising-Backlog

Nov 13 2019

CCogdill_WMF added a comment to T125272: Epic: Create Preference Center for donors to manage email subscription preferences.

Cool suggestion! I like it.

Nov 13 2019, 9:02 PM · Fr-planning-ahead, Fundraising Sprint Princess Mongodb, Epic, Fundraising-Backlog

Nov 12 2019

CCogdill_WMF triaged T238156: Dedupe suggestion: track down OG contact records for "new" donors as Medium priority.
Nov 12 2019, 9:52 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF created T238156: Dedupe suggestion: track down OG contact records for "new" donors.
Nov 12 2019, 9:52 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Nov 9 2019

CCogdill_WMF added a comment to T237715: Opt in - remove from suppression list.

Here are the API details!

Nov 9 2019, 12:04 AM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Nov 8 2019

CCogdill_WMF added a comment to T237338: Civi: how to exclude recent Stripe donors from fundraising email sends?.

Fwiw, I don't think the problem is the filtering scan, I think it's the timing of when this stripe donation got added to Civi. If I'm reading their contribution record right, their contribution was Enqueued At Timestamp Oct 24, 2019 16:10, which was 2 days after the email went out and 7 days after they donated.

Nov 8 2019, 10:48 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog
CCogdill_WMF added a comment to T237715: Opt in - remove from suppression list.

Thanks for opening the ticket! If there's an API call to IBM to remove
people on the suppression list, that would be our best bet, though I don't
know if that exists. Should I ask our consultants?

Nov 8 2019, 3:28 PM · Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Nov 6 2019

CCogdill_WMF added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Ah, I see. Here's the current login page:
https://www.customer-engagement.ibm.com/marketing/launch/

Nov 6 2019, 9:32 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
CCogdill_WMF added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

You don't have to actually reset the IBM id, IIRC, only the campaign
automation login. Let me know if you need us to check with our consultant
on this.

Nov 6 2019, 9:28 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
CCogdill_WMF added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Thanks, Elliott! We didn't realize this was a requirement with the system.
We learned our lesson ;)

Nov 6 2019, 9:23 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Nov 4 2019

CCogdill_WMF added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Wonderful, thank you all for the help!

Nov 4 2019, 7:01 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
CCogdill_WMF added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

Okay, I saved the pw in a file called silverpop.txt as suggested.

Nov 4 2019, 5:21 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
CCogdill_WMF raised the priority of T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM from High to Unbreak Now!.

Hey y'all,

Nov 4 2019, 3:26 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Nov 1 2019

CCogdill_WMF renamed T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM from Email team can't become user silverpop-upload@wikimedia.org in IBM to Need to reset password for user silverpop-upload@wikimedia.org in IBM.
Nov 1 2019, 1:29 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog
CCogdill_WMF added a comment to T237100: Need to reset password for user silverpop-upload@wikimedia.org in IBM.

I just reset the password on the account so Katie could get in and try to re-run the file imports, but now y'all need to reset the pw again on your side. I'm going to update the task title to reflect that.

Nov 1 2019, 1:29 PM · Fundraising Sprint Visual Basic Instinct, Fundraising-Backlog

Oct 31 2019

CCogdill_WMF added a comment to T232037: We need merge handling for opt in.

Okay, then we need to find a way to use the silverpop API to remove people
from the suppression list when they opt back in.

Oct 31 2019, 11:58 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, FR-Q2-FY2019-20-cleanup-list, FR-Civi-Dedupe, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM
CCogdill_WMF updated subscribers of T232037: We need merge handling for opt in.

That looks right to me! I want to note that from a silverpop perspective, scenario 2 would require an extra step of us removing a contact from the Suppression list. I think that has to be done manually, though maybe there's an API call for it.

Oct 31 2019, 1:37 PM · Fundraising Sprint X-rays, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint Visual Basic Instinct, FR-Q2-FY2019-20-cleanup-list, FR-Civi-Dedupe, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM

Oct 24 2019

CCogdill_WMF added a comment to T234925: Problem with email opt-outs reaching Civi as unsubscribes.

I think my preference is option 2. I know we were concerned about people
who opted in NO and some point and changed their response to YES in the
future. It seems easier to me to set up an annual workflow where we remove
anyone from the unsubscribes list who has changed their response to YES.
Does that seem sensible?

Oct 24 2019, 2:19 PM · Fundraising Sprint Visual Basic Instinct, Fundraising Sprint Usual Subscripts, Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-Banners, Fundraising-Backlog

Oct 23 2019

CCogdill_WMF added a comment to T234446: Update English Thank You email.

So awesome! Thanks, everyone :)

Oct 23 2019, 11:39 AM · Fundraising Sprint Usual Subscripts, Fundraising-Backlog

Oct 16 2019

CCogdill_WMF added a comment to T234925: Problem with email opt-outs reaching Civi as unsubscribes.

Huh, I remember us discussing that latest_optin_response field but I
thought we settled on opting these people out. I think that's what we need
to do--turn the opt out on the banner into a hard no.

Oct 16 2019, 7:15 AM · Fundraising Sprint Visual Basic Instinct, Fundraising Sprint Usual Subscripts, Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-Banners, Fundraising-Backlog

Oct 8 2019

CCogdill_WMF added a comment to T234925: Problem with email opt-outs reaching Civi as unsubscribes.

Definitely, the expected behavior is if someone opts-out of bulk email
while donating, they should be marked as opted-out in Civi and added to the
unsubscribes file that gets sent to IBM each night.

Oct 8 2019, 6:16 PM · Fundraising Sprint Visual Basic Instinct, Fundraising Sprint Usual Subscripts, Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-Banners, Fundraising-Backlog

Oct 4 2019

CCogdill_WMF added a comment to T233744: Update IBM with TargetSmart Age data.

Thank you all so much.

Oct 4 2019, 5:39 PM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Oct 3 2019

CCogdill_WMF added a comment to T232633: fundraising dev/database access request for Mariana Suijkerbuijk.

Yeah, you'll need a CiviCRM cert to access the dash (
https://dash.frdev.wikimedia.org) at the least. Sorry, I take for granted
that we just set this up for fundraising people :)

Oct 3 2019, 3:45 PM · fundraising-tech-ops, Fundraising-Backlog
CCogdill_WMF added a comment to T233744: Update IBM with TargetSmart Age data.

Cool, we must've missed the cutoff time. Thanks, Katie!

Oct 3 2019, 2:43 PM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T233744: Update IBM with TargetSmart Age data.

Never manually add if it's data we're importing from Civi :) You should see
it when setting up the import. If you don't, just hit run on today's import
and we'll try again tomorrow.

Oct 3 2019, 12:00 PM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T233744: Update IBM with TargetSmart Age data.

I'm optimistic we caught it in time :) otherwise we'll try again tomorrow.
Thanks!

Oct 3 2019, 7:05 AM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T233744: Update IBM with TargetSmart Age data.

Hey Eileen, my mistake, I thought it had been deployed! We had already put
the import on pause last night so we could import the new data today. Is it
possible to squeeze it into today's import?

Oct 3 2019, 6:58 AM · Fundraising Sprint Trojan Horse Wisperer, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog

Oct 1 2019

CCogdill_WMF added a comment to T230509: Scrape HTML from IBM UI and bring queries into civi.

Ooh awesome, sounds like hardly any lag at all, even in the event of a
failure.

Oct 1 2019, 8:52 PM · Fundraising Sprint Sysadmin Kane, Fundraising Sprint Rocky Horror Presentation Layer, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog
CCogdill_WMF added a comment to T230509: Scrape HTML from IBM UI and bring queries into civi.

Thanks so much for this! Just one last question--how often will this be
updated? Daily? Will there ever be a lag?

Oct 1 2019, 8:18 PM · Fundraising Sprint Sysadmin Kane, Fundraising Sprint Rocky Horror Presentation Layer, Fundraising Sprint Office  , Fundraising Sprint Never Ending Query, Wikimedia-Fundraising-CiviCRM, Fundraising-Backlog