Page MenuHomePhabricator
Create Task
Maniphest T412307

utm weirdness - different values in contribution tracking, on the donation message, and in the logs
Closed, ResolvedPublic
Actions

Description

examples:
ct id = 240769987.1
contribution id 134483551
contribution id 134733746

data for 240769987.1 is really interesting:
In contribution tracking utms are empty

on donate message: "utm_campaign":"WMF_FR_C2526_en6C_m_1201","utm_medium":"sitenotice","utm_source":"..cc"

in logs:
wmf_campaign=WMF_FR_C2526_en6C_m_1201
wmf_source=B2526_120118_en6C_m_p2_sm_txt_cnt.no-LP.cc
wmf_key=otherAmt_0%7EclickedNag_1%7EchangedAmt_1%7Eptf_1%7Evw_320%7Evh_572%7Etime_113

The transaction also went through the pending transaction resolver

Details

Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Add script to update Contribution Tracking row for contributions with missing UTM parameters in tracking table using UTM parameters that are available in the logs.wikimedia/fundraising/SmashPigmaster+186 -0
Customize query in gerrit

Related Objects

Event Timeline

Cstone created this task.Dec 10 2025, 11:02 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 10 2025, 11:02 PM
Cstone updated the task description. (Show Details)Dec 10 2025, 11:03 PM
Cstone updated the task description. (Show Details)Dec 11 2025, 3:18 AM
AKanji-WMF triaged this task as Medium priority.Dec 16 2025, 8:25 PM
AKanji-WMF moved this task from Triage to Chaos Crew Backlog on the Fundraising-Backlog board.
AKanji-WMF added a project: Fundraising Tech - Chaos Crew.
Damilare claimed this task.Dec 17 2025, 1:47 PM
Damilare moved this task from Backlog to User Bug Backlog on the Fundraising Tech - Chaos Crew board.
gerritbot added a comment.Jan 9 2026, 7:56 PM

Change #1225015 had a related patch set uploaded (by Damilare Adedoyin; author: Damilare Adedoyin):

[wikimedia/fundraising/SmashPig@master] Add script to update Contribution Tracking row for contributions with missing UTM parameters in tracking table using UTM parameters that are available in the logs.

https://gerrit.wikimedia.org/r/1225015

gerritbot added a project: Patch-For-Review.Jan 9 2026, 7:56 PM
Damilare added a comment.Jan 12 2026, 1:21 PM

Thanks for reporting this @Cstone. Looking at the logs and searchkit, I've been able to discover over 3K contributions since October last year without the UTM parameters,here's the associated SearchKit. Though most of these transactions were Braintree Venmo, there were about 300+ from CC. Though I'm yet to find a way to reproduce the bug, however I did notice the Venmo transactions were logging URLs with no query parameters and no record in the pending DB.

I've pushed a patch to ensure Braintree Venmo transactions have records in the pending DB and another patch to backfill the data on the contribution tracking DB using data retrieved from the logs where available.

Damilare raised the priority of this task from Medium to High.Jan 12 2026, 8:50 PM
Damilare moved this task from User Bug Backlog to In Progress on the Fundraising Tech - Chaos Crew board.
Damilare moved this task from In Progress to Ready for Review on the Fundraising Tech - Chaos Crew board.
Damilare lowered the priority of this task from High to Medium.Jan 12 2026, 9:35 PM
AnnWF moved this task from Ready for Review to Being Reviewed on the Fundraising Tech - Chaos Crew board.Jan 20 2026, 9:09 PM
gerritbot added a comment.Jan 23 2026, 2:28 AM

Change #1225015 merged by jenkins-bot:

[wikimedia/fundraising/SmashPig@master] Add script to update Contribution Tracking row for contributions with missing UTM parameters in tracking table using UTM parameters that are available in the logs.

https://gerrit.wikimedia.org/r/1225015

Maintenance_bot removed a project: Patch-For-Review.Jan 23 2026, 2:31 AM
AnnWF moved this task from Being Reviewed to Pending Deployment on the Fundraising Tech - Chaos Crew board.Jan 29 2026, 4:49 PM
AnnWF moved this task from Pending Deployment to Done on the Fundraising Tech - Chaos Crew board.Jan 29 2026, 6:51 PM
XenoRyet closed this task as Resolved.Feb 9 2026, 9:10 PM
XenoRyet set Final Story Points to 2.
Damilare mentioned this in T415719: Fundraising Sprint B Priorities.Feb 10 2026, 3:56 PM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits