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.).

@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.

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.

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

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

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

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

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

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)

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

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

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

Public yubikey: ccccccvkhvbn

Public yubikey: ccccccvkhvbn