User Details
- User Since
- Jul 20 2021, 1:41 PM (168 w, 10 h)
- Availability
- Available
- LDAP User
- Unknown
- MediaWiki User
- JMando (WMF) [ Global Accounts ]
Jul 11 2024
Awesome! I see them now! I added it to the teams dashboard and asked that they QA it. Will comment here if anything looks off from the acoustic UI.
Jul 2 2024
@Cstone This should be fine for reporting, so long as
Jun 13 2024
May 30 2024
@AKanji-WMF The clicks columns are still not populating. clicked_total and clicked_unique in civicrm_mailing_stats.
Do we need to backfill for the time we were not getting data in civicrm_mailing_provider_data, civicrm_mailing, or civicrm_mailing_stats?
May 13 2024
Just for more context:
Apr 10 2024
Closing this as it is quite old now.
Apr 2 2024
@Ejegg task we chatted about.
Mar 1 2024
I just finished qa'ing and all the donors I checked (a few from each status and segment) were correct:
donor_segment_id 100 - checked and passed 200 - checked and passed 400 - checked and passed 500 - checked and passed 600 - checked and passed 900 - checked and passed 1000 - checked and passed
Feb 15 2024
@Ejegg if this refers to the Blackbaud reports, it would be the same logic that determines new vs repeat in both their report and and in the query I provided in that task you linked. Blackbaud works on a data set I pull, clean, and provide to them.
Feb 14 2024
Just checking in here. Let me know if anymore info is needed.
Feb 9 2024
Did another round of QA.
Feb 7 2024
Feb 6 2024
@Eileenmcnaughton just wanted to check in here and see if the changes had happened and the data was ready to be QA'd again? @Ejegg mentioned the process may need to be re-ran.
Jan 30 2024
@MSuijkerbuijk_WMF so sp73859020 and sp73859018 had donation asks/links and they both shared the same utm_campaign name (C2324_ThankYou-Recurring)?
Jan 29 2024
@MSuijkerbuijk_WMF @RLopez-WMF do each of these individual emails ('sp73859018','sp73859020','sp73863609','sp73863614') have a different utm_campaign? If so, I can fake the mailing_identifier on the donations and bring them into email stats.
Jan 26 2024
If it helps, for payment_method name I do:
Jan 24 2024
@Eileenmcnaughton
See below for some possible errors I found. Note some of these could come down to what dates the donation history is being compared to (today, this month, this fiscal year, etc):
Jan 23 2024
@Eileenmcnaughton I'll make a task for myself to get those into superset!
Jan 10 2024
Hey there. I still have one data cube that is referencing drupal.contribution_tracking. I will switch it to the new one this month and comment here when it is done if that is okay?
Dec 11 2023
Hey all, not sure this is fixed. I checked the query I provided in T351651 and still see them marked refund without a corresponding original charge:
Dec 5 2023
@MDemosWMF I think that works. Could you add me to the invite?
Yeah, I think realized gifts do come into normal reporting cubes but I am not sure I am labeling them in such a way that surfaces them in views. @MDemosWMF could we meet and discuss?
Nov 21 2023
Note I see paypal and adyen gateways in that query's output.
So here are the positive refunds I see since the start of this fiscal year:
Nov 20 2023
Oct 27 2023
It looks like this is happening for sp73528716 and sp73532353 as well (no clicks in pgehres.donatewiki_counts). Could we investigate if this is the same issue? @NNgu-WMF could you comment the links from the send as Noah did for the previous ones?
Oct 13 2023
Sep 26 2023
Sep 5 2023
Preferably all changes would only go back as far as July 1, 2023 so as to not require anymore reporting code changes.
Jul 13 2023
Currently I derive whether a recurring donation (gift/contribution/etc.) is a sign up or further recurring donation after the sign-up in my reporting cubes/queries using functions like:
Jun 23 2023
We are mostly using civicrm.civicrm_contribution_tracking these days, so I am not worried about it.
Jun 15 2023
@Ejegg That would be great! Thank you!
@Ejegg I think so long as I can see that an upgrade happened, the amount added, and currency then that should be enough. However is easiest for you to store, I can work with.
May 2 2023
I just re-ran the provided queries and these are still showing low clicks compared to the donations.
Apr 20 2023
That code looks correct to me. I do not see any data in the table, but I do see the new columns in there. Once there is data to look at, I can do a more thorough QA, but nothing is jumping out as wrong to me.
Apr 3 2023
@Eileenmcnaughton are there any gifts currently imported with this new process in the database? I could do a normal data pull with our usual queries and make sure they look right for reporting.
@Eileenmcnaughton @MDemosWMF That depends on what would be lost if not creating a record in ContributionTracking. So long as I can tell where the gift comes from (country sourced from address), if it is endowment or not (financial_type_id=26 for example), gateway, and other relevant payment info then it should be fine for these gifts. I do not believe we use ContributionTracking for that in instances really outside of banner, email, and other online gifts where we need to tie back to a specific campaign.
Mar 3 2023
Here is an abbreviated version of the query that the referenced superset chart pulls from:
Feb 15 2023
Feb 8 2023
Jan 3 2023
Dec 13 2022
@jgleeson This query gives the same results as yours, but broken out by banner, landing page, and campaign. I also added in the minimum receive date:
Dec 9 2022
Not sure if it helps, but it does look like many of these do have a utm_source (from drupal.contribution_tracking):
Nov 10 2022
Sounds good! Thank you!
Nov 1 2022
Here are some more I have come across today: 43750645, 30337455, 14720652, 13303304, and 11247109.
@Eileenmcnaughton I unfortunately do not know how many total rows are affected. I lucked into finding the instances I did while working on a new data cube.
Oct 28 2022
Oct 11 2022
@Ejegg do you mean the drupal.contribution_tracking.utm_source field? That is the one we usually pull into reporting (and I do not see a utm_source in civicrm.wmf_contribution_extra).
@EMartin do we need a backfill for these? Or is having it on a go forward basis fine for reconciliation?
Oct 7 2022
I think I see this coming through for October (Google Pay: American Express and Apple Pay: American Express for example). Will we see these for previous transactions as well (like for august)?
Sep 2 2022
Aug 19 2022
That is right. With the addition that we would also want to limit to the language wiki we fundraised in for the campaign (like en.wikipedia for en6c).
Aug 11 2022
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.).
May 12 2022
@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.
Apr 8 2022
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.
Following up from a comment from @EYener and @HNordeenWMF on https://phabricator.wikimedia.org/T305694.
Feb 16 2022
Confirming what @AndyRussG said above about is_banner_beacon and device_family at hourly granularity.
Jan 28 2022
Jan 6 2022
I am also able to see the SQL Lab drop down menu as well as run queries. Thank you!
Dec 13 2021
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 9 2021
Hey there, I do not believe this has been resolved, but tagging @EYener to confirm?
Nov 3 2021
Thank you! I updated the superset views based on the corrected query and the data is aligned!
Oct 28 2021
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 22 2021
Oct 20 2021
Sep 3 2021
I am in now. I can access those UI's and successfully ssh into stat1007. Thank you!
Aug 26 2021
@jcrespo Right now that date is July 19, 2022.
Aug 25 2021
Aug 24 2021
Aug 6 2021
Public yubikey: ccccccvkhvbn
Jul 20 2021
Public yubikey: ccccccvkhvbn