Page MenuHomePhabricator

EYener (Erin Yener)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Tuesday

  • Clear sailing ahead.

User Details

User Since
Sep 19 2019, 11:03 PM (22 w, 2 d)
Availability
Available
LDAP User
Erin Yener
MediaWiki User
EYener (WMF) [ Global Accounts ]

Recent Activity

Fri, Feb 21

EYener added a comment to T238394: Automation / optimization of data cubes.

I have a small test cube on dev_analytics pulling down new donation IDs, contact IDs, and utm_medium on a 10 minute interval via a python3 script in my home directory. I will alter the time table to a 1 hour interval to run overnight (through Saturday, possibly the weekend) for additional timing tests, and pick this up again Monday for more full-scale trial of larger data sets.

Fri, Feb 21, 8:14 PM · fundraising-tech-ops, Fundraising-Backlog

Mon, Feb 10

EYener updated subscribers of T238395: Fundraising Analytics Infrastructure and Setup.
Mon, Feb 10, 3:12 PM · fundraising-tech-ops, Fundraising-Backlog

Thu, Feb 6

EYener added a comment to T244484: Issues querying table in Hive.

I'm curious, @Ottomata and @JAllemandou, if there is an elegant solution to dynamically filling partitions. IE, once a table is created with the partition types declared and a main location established, is the best way to fill the table to declare individual ALTER statements by day, hour, etc? Or is there a better way to accomplish this?

Thu, Feb 6, 9:00 PM · Analytics
EYener added a comment to T244484: Issues querying table in Hive.

Thanks for the suggestion, @Ottomata - I'll take it back to the team and see what makes sense. Since we've been using the json_string format since 2016, it might make sense to have the 2019 data in the same format as well.

Thu, Feb 6, 7:56 PM · Analytics
EYener added a comment to T244292: Database creation in Hive.

Thank you, @JAllemandou! I am new to Hive, and was not aware I could do this myself. It worked well, though, and I appreciate the resources. You can close this ticket; much appreciated.

Thu, Feb 6, 6:18 PM · Analytics
EYener added a comment to T244484: Issues querying table in Hive.

Thank you, @JAllemandou! I've learned several new Hive features and commands.

Thu, Feb 6, 3:56 PM · Analytics
EYener created T244484: Issues querying table in Hive.
Thu, Feb 6, 2:23 PM · Analytics

Tue, Feb 4

EYener created T244292: Database creation in Hive.
Tue, Feb 4, 9:30 PM · Analytics

Jan 24 2020

EYener updated subscribers of T243627: Large recurring PayPal txn in Civi but no money collected.
Jan 24 2020, 8:03 PM · FR-PayPal-ExpressCheckout, Fundraising-Backlog

Jan 9 2020

EYener added a comment to T236855: Fix missing email recipient data.

Thank you Eileen!

Jan 9 2020, 2:05 PM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back

Jan 7 2020

EYener added a comment to T236855: Fix missing email recipient data.

Hi @Eileenmcnaughton, could you please backfill data again? That would help me do an en6C wrap up while a fix is being worked on. Thanks!

Jan 7 2020, 4:58 PM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back

Dec 17 2019

EYener added a comment to T238395: Fundraising Analytics Infrastructure and Setup.

This is great; thank you!

Dec 17 2019, 10:02 PM · fundraising-tech-ops, Fundraising-Backlog
EYener added a comment to T238395: Fundraising Analytics Infrastructure and Setup.

@Jgreen that's a good question. What is the usual time frame for a full restore and replace process (worst case scenario)? If we successfully switch over reporting to an analytics server and rely exclusively on it for all reporting during peak times like Big English, that could be a hindrance to a number of work flows.

Dec 17 2019, 3:07 PM · fundraising-tech-ops, Fundraising-Backlog

Dec 11 2019

EYener added a comment to T236855: Fix missing email recipient data.

Great! Thank you, @Eileenmcnaughton!

Dec 11 2019, 9:32 PM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back
EYener added a comment to T236855: Fix missing email recipient data.

Hi @Eileenmcnaughton, do you think I can start working with this data for current (FY1920) mailings, or are things still being investigated?

Dec 11 2019, 7:54 PM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back

Nov 27 2019

EYener added a comment to T236855: Fix missing email recipient data.

This is great! Thank you @Eileenmcnaughton! And thanks for digging on the ESP side, @CCogdill_WMF.

Nov 27 2019, 1:21 PM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back

Nov 21 2019

EYener added a comment to T237605: Create kerberos principals for users.

I would also like to request Kerberos credentials for stat100x and notebook100x machines. My username is eyener. Thank you!

Nov 21 2019, 8:14 PM · Patch-For-Review, Analytics-Kanban, Analytics
EYener added a comment to T238560: Doubts and questions about Kerberos and Hadoop.

To clarify the expected downtime: Is it 45 minutes or 3 to 4 hours?

Nov 21 2019, 3:52 PM · Analytics

Nov 15 2019

EYener added a comment to T238392: Modules for python3 on frdev1001.

@Jgreen can you install SQLAlchemy as well, please?

Nov 15 2019, 4:01 PM · fundraising-tech-ops
EYener created T238395: Fundraising Analytics Infrastructure and Setup.
Nov 15 2019, 1:11 AM · fundraising-tech-ops, Fundraising-Backlog
EYener created T238394: Automation / optimization of data cubes.
Nov 15 2019, 12:58 AM · fundraising-tech-ops, Fundraising-Backlog
EYener created T238392: Modules for python3 on frdev1001.
Nov 15 2019, 12:47 AM · fundraising-tech-ops

Oct 31 2019

EYener added a comment to T236855: Fix missing email recipient data.

Hi Eileen - I completely agree. I would prefer the data coming in to be as raw as possible so that we're future-proofed against any changes we want to make in terms of how we want to analyze the data. So if the donor opens the email multiple times, multiple opens are great to see. That second ask is more to just confirm that (which I think we're both saying) that "what the user does, the data reflects" without any wrangling, cleaning, or summarizing at this stage.

Oct 31 2019, 10:41 AM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back

Oct 29 2019

EYener created T236855: Fix missing email recipient data.
Oct 29 2019, 9:58 PM · Patch-For-Review, FR-Tech-Analytics, Fundraising-Backlog, Fundraising Sprint Visual Basic Instinct, Fundraising Sprint A Wrinkle in Timezones, Fundraising Sprint X-rays, Fundraising Sprint YAMLton, the Musical, Fundraising Sprint Autocorrect Astrology Ascendant, Fundraising Sprint Byzantine Empire Strikes Back

Oct 28 2019

EYener created T236750: R packages to be added to frdev1001 server.
Oct 28 2019, 11:40 PM · fundraising-tech-ops

Oct 15 2019

EYener added a comment to T234529: Requesting access to 'analytics-privatedata-users' and 'researchers' for Erin Yener.

Hi @Nuria is there anything I need to do on my end at this point, or should I wait for the mentioned merge to happen?

Oct 15 2019, 5:21 PM · Patch-For-Review, SRE-Access-Requests, Operations

Oct 14 2019

EYener added a comment to T234529: Requesting access to 'analytics-privatedata-users' and 'researchers' for Erin Yener.

Hi @Nuria and team, is there anything needed from my end on this ticket?

Oct 14 2019, 10:25 PM · Patch-For-Review, SRE-Access-Requests, Operations

Oct 10 2019

EYener added a comment to T234529: Requesting access to 'analytics-privatedata-users' and 'researchers' for Erin Yener.

Hi @herron thanks for the ping. Please let me know if this is what you need:

Oct 10 2019, 8:03 PM · Patch-For-Review, SRE-Access-Requests, Operations

Oct 3 2019

EYener created T234529: Requesting access to 'analytics-privatedata-users' and 'researchers' for Erin Yener.
Oct 3 2019, 12:42 PM · Patch-For-Review, SRE-Access-Requests, Operations

Oct 1 2019

EYener added a comment to T233636: Banner History and page view data access for fundraising analysts - Jerrie and Erin .

Thank you! I also have access to Turnilo. I have two follow-up questions:

Oct 1 2019, 12:12 PM · Analytics, Operations, SRE-Access-Requests, Fundraising-Backlog
EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

Yes! I think we can close this task, as I do have access to the database now. Thank you for your help, @Dwisehaupt and @Cstone! I'll open more specific tickets as questions arise.

Oct 1 2019, 11:04 AM · fundraising-tech-ops, Fundraising-Backlog

Sep 30 2019

EYener added a comment to T233636: Banner History and page view data access for fundraising analysts - Jerrie and Erin .

Hi @Nuria I do have an LDAP account: eyener-ctr
I'm not certain if/what groups I belong to, however.

Sep 30 2019, 3:08 PM · Analytics, Operations, SRE-Access-Requests, Fundraising-Backlog
EYener added a comment to T233636: Banner History and page view data access for fundraising analysts - Jerrie and Erin .

Hi @Nuria I have created a Wikitech account. My username is my full name, Erin Yener. Please let me know if you need anything else.

Sep 30 2019, 12:46 PM · Analytics, Operations, SRE-Access-Requests, Fundraising-Backlog

Sep 23 2019

EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

Hi @Dwisehaupt and thanks for your help today. I can now access the frdev1001 db via ssh shell and wanted to follow up on 2 remaining questions:

Sep 23 2019, 10:53 PM · fundraising-tech-ops, Fundraising-Backlog
EYener added a comment to T233636: Banner History and page view data access for fundraising analysts - Jerrie and Erin .

Thanks for the link, @Ejegg! After reviewing the documentation and other resources, I believe @jkumalah and I need access to the following:

Sep 23 2019, 9:20 PM · Analytics, Operations, SRE-Access-Requests, Fundraising-Backlog
EYener added a project to T233636: Banner History and page view data access for fundraising analysts - Jerrie and Erin : SRE-Access-Requests.
Sep 23 2019, 9:10 PM · Analytics, Operations, SRE-Access-Requests, Fundraising-Backlog
EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

After speaking with @jrobell, I will also need access to:
Turnilo
Banner data
Pageview data

Sep 23 2019, 3:09 PM · fundraising-tech-ops, Fundraising-Backlog

Sep 22 2019

EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

Thanks for the instructions - I'm encountering some issues and can't identify which step in the process I'm missing/mis-applying. Would you be able to jump on a screen share at some point tomorrow (Monday) to assist?

Sep 22 2019, 10:47 PM · fundraising-tech-ops, Fundraising-Backlog

Sep 20 2019

EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

Thank you very much @Ejegg - I have logged in now. It looks like I am able to view reports and navigate around the Civi UI. How can I query the Civi database?

Sep 20 2019, 11:53 PM · fundraising-tech-ops, Fundraising-Backlog
EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

Hello team,

Sep 20 2019, 11:23 PM · fundraising-tech-ops, Fundraising-Backlog
EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

What credentials do I use to log into Civi (username/password). My ldap credentials don't seem to be correct. Please let me know who I would ask for this information.

Sep 20 2019, 10:56 PM · fundraising-tech-ops, Fundraising-Backlog
EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

@Dwisehaupt here is the public SSH key:

Sep 20 2019, 9:26 PM · fundraising-tech-ops, Fundraising-Backlog
EYener added a comment to T232982: Access and onboarding for new fundraising analyst (contractor) - Erin Yener .

Hi Dallas,

Sep 20 2019, 7:04 PM · fundraising-tech-ops, Fundraising-Backlog