Page MenuHomePhabricator

JMando (Joseph Mando)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Saturday

  • Clear sailing ahead.

User Details

User Since
Jul 20 2021, 1:41 PM (56 w, 1 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
JMando (WMF) [ Global Accounts ]

Recent Activity

Thu, Aug 11

JMando added a comment to T304571: [REQUEST] Edit access: druid.pageviews_daily & druid.pageviews_hourly.

I believe we wanted to be able to add fiscal year (FY1920, FY2021, FY2122, etc.) along with groupings for our fundraising campaigns using a combo of project and country_code (en6c, India, Japan, Bundle, etc.).

Thu, Aug 11, 5:56 PM · Product-Analytics (Kanban)

May 12 2022

JMando added a comment to T305659: Account creation: Thank You Page landing pages.

@Sgs Since that comment was made, some of the data collection/evaluation plans have changed. Fundraising is tracking donation and banner impression data, and I believe product will be handling the account creation/pageview data. So long as Product is able to track what they need with the current setup, I do not think my comment is relevant anymore.

May 12 2022, 6:37 PM · MW-1.39-notes (1.39.0-wmf.13; 2022-05-23), Patch-For-Review, Growth-Team (Current Sprint)

Apr 8 2022

JMando added a comment to T305694: Account creation: Thank You Banner landing pages.

If any and all URL's (thank you page and account creation) we want tracked could be parameterized similar to how the thank you page was parameterized last time (https://thankyou.wikipedia.org/wiki/Recurring_donor_page/en?wprov=arde1), that is preferred as it was easily tracked through here.

Apr 8 2022, 4:18 PM · Patch-For-Review, Growth-Team (Current Sprint)
JMando added a comment to T305659: Account creation: Thank You Page landing pages.

Following up from a comment from @EYener and @HNordeenWMF on https://phabricator.wikimedia.org/T305694.

Apr 8 2022, 4:18 PM · MW-1.39-notes (1.39.0-wmf.13; 2022-05-23), Patch-For-Review, Growth-Team (Current Sprint)
JMando added a comment to T305694: Account creation: Thank You Banner landing pages.
Apr 8 2022, 4:11 PM · Patch-For-Review, Growth-Team (Current Sprint)

Feb 16 2022

JMando added a comment to T300164: Pageview Data loss due to wrong version of package installed on some varnishkafka instances.

Confirming what @AndyRussG said above about is_banner_beacon and device_family at hourly granularity.

Feb 16 2022, 6:12 PM · Data-Engineering-Kanban, Data-Engineering

Jan 28 2022

JMando added a comment to T300390: Engage import should prevent: Incorrect datetime value: '0202-01-10 00:00:00' in civicrm.civicrm_contribution.

D91A0AA3-26F4-4F45-AD60-1C9E80B58E61_4_5005_c.jpeg (114×234 px, 5 KB)

Jan 28 2022, 5:34 PM · Wikimedia-Fundraising-CiviCRM, FR-Tech-Analytics, Fundraising-Backlog
JMando created T300390: Engage import should prevent: Incorrect datetime value: '0202-01-10 00:00:00' in civicrm.civicrm_contribution.
Jan 28 2022, 5:33 PM · Wikimedia-Fundraising-CiviCRM, FR-Tech-Analytics, Fundraising-Backlog

Jan 6 2022

JMando added a comment to T298699: Superset SQL Lab error.

I am also able to see the SQL Lab drop down menu as well as run queries. Thank you!

Jan 6 2022, 6:35 PM · Data-Engineering-Kanban, Superset, Data-Engineering

Dec 13 2021

JMando added a comment to T293926: Email Send with Low Clicks.

These emails are also showing a similar issue in that they are actually not showing up in either the clicks or donations queries above:

Dec 13 2021, 10:10 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog, FR-Tech-Analytics

Dec 9 2021

JMando added a comment to T293926: Email Send with Low Clicks.

Hey there, I do not believe this has been resolved, but tagging @EYener to confirm?

Dec 9 2021, 7:17 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog, FR-Tech-Analytics

Nov 3 2021

JMando added a comment to T294145: Low Traffic Test Difference in impressions between event_sanitized.centralnoticebannerhistory and pgehres.bannerimpressions.

Thank you! I updated the superset views based on the corrected query and the data is aligned!

Nov 3 2021, 6:07 PM · fundraising sprint Universal Cereal Bus, Fundraising Sprint Technical debt house of horrors, Fundraising-Backlog, FR-Tech-Analytics
JMando closed T294145: Low Traffic Test Difference in impressions between event_sanitized.centralnoticebannerhistory and pgehres.bannerimpressions as Resolved.
Nov 3 2021, 6:05 PM · fundraising sprint Universal Cereal Bus, Fundraising Sprint Technical debt house of horrors, Fundraising-Backlog, FR-Tech-Analytics

Oct 28 2021

JMando added a comment to T293926: Email Send with Low Clicks.

20211006_UnitedStates_English(en)_MGEvents_LastChance_EST_Paid: https://donate.wikimedia.org/w/index.php?title=Special:LandingPage&country=US&uselang=&[…]ote&hpc=100&contact_id=%25%25ContactID%25%25&link_id=1&1=1
20200909_MajorGifts_VirtualEvent1_MatchingGift: https://donate.wikimedia.org/w/index.php?title=Special:LandingPage&country=US&uselang=&[…]myQuote&hpc=100&contact_id=%25%25ContactID%25%25&link_id=1
20201008_MajorGifts_VirtualEvent2_MatchingGift: https://donate.wikimedia.org/w/index.php?title=Special:LandingPage&country=US&uselang=&utm_medium=MGEventEmail&utm_source=sp%%MAILING_ID%%&utm_campaign=VirtualEvent2_20&appeal=Appeal-JimmyQuote&hpc=100&contact_id=%25%25ContactID%25%25&link_id=1)
20201123_MajorGifts_VirtualEvent3_MatchingGift: https://donate.wikimedia.org/w/index.php?title=Special:LandingPage&country=US&uselang=&utm_medium=MGEventEmail&utm_source=sp%%MAILING_ID%%&utm_campaign=VirtualEvent3_20&appeal=Appeal-JimmyQuote&hpc=100&contact_id=%25%25ContactID%25%25&link_id=1)

Oct 28 2021, 7:28 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog, FR-Tech-Analytics

Oct 22 2021

JMando created T294145: Low Traffic Test Difference in impressions between event_sanitized.centralnoticebannerhistory and pgehres.bannerimpressions.
Oct 22 2021, 6:44 PM · fundraising sprint Universal Cereal Bus, Fundraising Sprint Technical debt house of horrors, Fundraising-Backlog, FR-Tech-Analytics

Oct 20 2021

JMando updated the task description for T293926: Email Send with Low Clicks.
Oct 20 2021, 6:59 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog, FR-Tech-Analytics
JMando created T293926: Email Send with Low Clicks.
Oct 20 2021, 6:58 PM · Wikimedia-Fundraising-CiviCRM, FR-Email, Fundraising-Backlog, FR-Tech-Analytics

Sep 3 2021

JMando added a comment to T289606: Requesting access to Stat1007 for jmando.
Sep 3 2021, 8:56 PM · SRE, SRE-Access-Requests
JMando closed T289606: Requesting access to Stat1007 for jmando as Resolved.
Sep 3 2021, 2:39 PM · SRE, SRE-Access-Requests
JMando added a comment to T289606: Requesting access to Stat1007 for jmando.

I am in now. I can access those UI's and successfully ssh into stat1007. Thank you!

Sep 3 2021, 2:36 PM · SRE, SRE-Access-Requests

Aug 26 2021

JMando added a comment to T289606: Requesting access to Stat1007 for jmando.

@jcrespo Right now that date is July 19, 2022.

Aug 26 2021, 2:25 PM · SRE, SRE-Access-Requests

Aug 25 2021

JMando added a comment to T289606: Requesting access to Stat1007 for jmando.

@jcrespo I spoke with @EYener and it looks like I will need kerberos access. Should I make a separate ticket for that?

Aug 25 2021, 3:51 PM · SRE, SRE-Access-Requests

Aug 24 2021

JMando created T289606: Requesting access to Stat1007 for jmando.
Aug 24 2021, 5:54 PM · SRE, SRE-Access-Requests

Aug 6 2021

JMando added a comment to T286556: Fundraising Access for Joseph Mando.

Public yubikey: ccccccvkhvbn

Aug 6 2021, 3:16 PM · FR-Tech-Analytics, fundraising-tech-ops, Fundraising-Backlog

Jul 20 2021

JMando added a comment to T286556: Fundraising Access for Joseph Mando.

Public yubikey: ccccccvkhvbn

Jul 20 2021, 7:51 PM · FR-Tech-Analytics, fundraising-tech-ops, Fundraising-Backlog
JMando created T287026: Fundraising access request for Joseph Mando.
Jul 20 2021, 4:31 PM · fundraising-tech-ops