[01:08:03] Fundraising Sprint Asymmetrical Earth Theory, Fundraising Sprint Bermuda Rhombus (where things disappear then reappear), Fundraising Sprint Cottage Cheese isn't Made of Cottages, Fundraising Sprint Dinosaur Cookies co-existed with Gingerbread People, and 2... - https://phabricator.wikimedia.org/T178930 [01:36:14] (CR) Krinkle: [C: 2] "Confirmed via https://github.com/wikimedia/mediawiki-extensions-CentralNotice/search?q="mw.util"" [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/477408 (owner: Fomafix) [01:40:43] (CR) jerkins-bot: [V: -1] Add missing dependencies on core modules [extensions/CentralNotice] - https://gerrit.wikimedia.org/r/477408 (owner: Fomafix) [01:58:16] Fundraising Sprint Sasquatches can't find us either, Fundraising Sprint They Live, Fundraising Sprint USB stands for underhanded socket bureaucracy, Fundraising Sprint Vestigial tails shoot from the hip, and 5 others: Benevity import errors - https://phabricator.wikimedia.org/T204008 (Eileenmcnaug... [01:59:33] Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint XML ate my homework, Fundraising-Backlog, and 2 others: acl for easy export of civi data - https://phabricator.wikimedia.org/T208270 (Eileenmcnaughton) @MBeat33 @leann... [02:00:43] Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint XML ate my homework, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Add payment_token fields to forgetme - https://phabricator.wikimedia.org/T206540 (Eileenmcn... [02:01:46] Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint XML ate my homework, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM, Patch-For-Review: hand update civi thank you email with current text - https://phabricator.wikimedia.org/T209895 (Eileenmcnaughton) @leannes is t... [02:12:05] Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Investigate unsubscribe queue consumer failure - https://phabricator.wikimedia.org/T211846 (Ejegg) [02:15:33] Fundraising-Backlog, FR-Paypal: Paypal refunds missing predecessor - https://phabricator.wikimedia.org/T211847 (Ejegg) [02:17:47] Fundraising Sprint XML ate my homework, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Make a copy of endowment thank you email in civi - https://phabricator.wikimedia.org/T211797 (Eileenmcnaughton) a:Eileenmcnaughton [14:39:11] Fundraising Sprint Vestigial tails shoot from the hip, Fundraising Sprint Window dressing is mostly olive oil, Fundraising Sprint XML ate my homework, Fundraising-Backlog, and 2 others: acl for easy export of civi data - https://phabricator.wikimedia.org/T208270 (MBeat33) Thank you, @Eileenmcnaug... [16:56:45] ejegg: thx for the comment on cn_analytics lib!! If you want a walk-through of how the druid and plot libs are being used, or if there's anything else I could help clarify, please lmk :) [16:57:02] ^ fr-tech same for anyone else peeking at that code :) thx!! [17:00:07] AndyRussG: thanks! Think I'll read a bit more documentation for starters [17:04:23] ejegg: the druid query stuff is pretty straightforward. It just sends a json query to Druid. I think the most confusing bit is that some operators are overloaded somewhere or other, and there are classes that correspond to Druid's data types [17:04:39] More confusing is pandas [17:05:12] I should read a basic tutorial sometime about data frames instead of muddling through as I have done so far [17:05:52] If you want a fun bug to try to verify, you could try to check if the the combined query (rates query) is working when there are some time buckets with no data [17:07:05] I have the sense that it goes all wonky if you use a setting there where there are some time slots that have no data, because of how the join works [17:07:23] (see rates_query.py line 51) [17:08:30] So we may have to ensure all the rows have at least something in them by pre-filling with zeroes (zeros?) [17:09:02] I don't think the same happens with the non-combined queries (pageviews and impression) but it might, actually [17:10:26] AndyRussG: I'm just looking at something in the pandas docs where it says it's good with missing data, and that's represented by NaN in data sets [17:10:38] so... Maybe it's all good? [17:11:14] I'll try some queries with unlikely combinations to see what crops up [17:12:35] ejegg: cool beans! thx! [17:52:55] Fundraising Sprint XML ate my homework, Fundraising-Backlog, Wikimedia-Fundraising-CiviCRM: Investigate unsubscribe queue consumer failure - https://phabricator.wikimedia.org/T211846 (DStrine) [17:55:04] Fundraising Sprint XML ate my homework, Fundraising-Backlog, MediaWiki-extensions-DonationInterface: GatewayFormChooser should geolocate when country is not in URL - https://phabricator.wikimedia.org/T211454 (DStrine) [18:07:38] fundraising-tech-ops, monitoring, Patch-For-Review, User-CDanis: moving from krypton to grafana1001 broke fundraising dashboards - https://phabricator.wikimedia.org/T211712 (cwdent) [20:43:26] (PS1) Cstone: Update ctools to 1.1.4 [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/479533 [20:43:28] (CR) Welcome, new contributor!: "Thank you for making your first contribution to Wikimedia! :) To learn how to get your code changes reviewed faster and more likely to get" [wikimedia/fundraising/crm] - https://gerrit.wikimedia.org/r/479533 (owner: Cstone) [20:44:30] Wow, I don't think I got a gerrit welcom message on my first patch. That must be new. Fancy! [20:44:44] me neither! [20:44:56] pretty neat! [22:02:22] cstone XenoRyet sorry, as this cafe fills up the wifi is going to hell and it's getting really noisy [22:02:35] No worries [22:02:37] gonna have to relocate [22:10:29] Fundraising-Backlog: Changing Bitpay Logo - https://phabricator.wikimedia.org/T211452 (Pcoombe) Open→Resolved Done. [22:40:50] AndyRussG: so as far as I can read it, the analytics library is handling 'missing' data correctly [22:41:26] I tried a rates query for campaign 17:34 -!- You're now known as ejegg [22:41:29] derp [22:41:37] for campaign WMID_WikiNusantara2019 [22:41:51] and language 'fr' [22:42:03] and 17:34 -!- You're now known as ejegg [22:42:07] grr [22:42:27] and date 2018-12-04T00:00Z/P3D, by hour [22:42:45] which had a fair number of hours with 0 impressions [22:43:13] but they were all correctly lined up with the pageviews for the corresponding hours [22:57:02] r/outoftheloop today had "What is going on with the memes about giving Wikipedia three dollars?" https://old.reddit.com/r/OutOfTheLoop/comments/a5mhz7/what_is_going_on_with_the_memes_about_giving/ [22:57:21] https://i.redd.it/o3tl3odcvt321.jpg https://i.redd.it/l0sj01fdov321.jpg [23:17:30] ejegg: wooohoo thanks! [23:27:20] mutante: awesome [23:28:47] if somebody from Fundraising would direct reply to https://old.reddit.com/r/OutOfTheLoop/comments/a5mhz7/what_is_going_on_with_the_memes_about_giving/ebocgfq/ and use the meme in a banner, then it gets max exposure also on /r/beetlejuicing/ [23:29:11] https://i.redd.it/l0sj01fdov321.jpg