Web: code - as a user, i want a quarterly 'my stats' email, so i can see my activity on the platform

[owocki]

User Story

as a user, i want a quarterly 'my stats' email, so i can see my activity on the platform

Designs

See https://github.com/gitcoinco/web/issues/892

and

https://github.com/gitcoinco/web/files/1939643/QuarterlyStatsEmail.zip

Definition of Done

• A management command that sends this email to everyone in the network (look at the EmailSubscriber table. the roundup.py management command is a good one to look at too.
• Should be scheduled for 1x per quarter at beginning of quarter in crontab
• top section 'my stats' should only be shown IFF the user has built something that month
• each stat should be programmatically generated
• do your best with querying the database for the information you need.. please leave TODOs where you need help from @mbeacom and @owocki

[mbeacom]

🙌 - 👍 for TODOs

[gitcoinbot]

__This issue now has a funding of 0.15 ETH (95.93 USD @ $639.52/ETH) attached to it.__

• If you would like to work on this issue you can claim it here.
• If you've completed this issue and want to claim the bounty you can do so here
• Questions? Get help on the Gitcoin Slack
• $5384.22 more Funded OSS Work Available at: https://gitcoin.co/explorer

[vs77bb]

We returned this issue to an open status due to inactivity. Open to contributions 😄

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

__Work has been started__.

These users each claimed they can complete the work by 3 weeks ago. Please review their questions below:

1. CuriousLearner has started work.

[CuriousLearner]

Hi @owocki !

This is my first bounty contribution. Here is the implementation plan for the issue:

• Defining a property such as quarterly_stats on Profile model to get the last 3 month details for total eth earned, bounties funded, funded bounties completed and fulfilled bounties counted.

This shall be used to render the first part of the mail that varies for user to user.

I'm right now having a look at the source code and setting up the project. Will update this soon.

[thelostone-mc]

@CuriousLearner reach out to me / @mbeacom over slack if you get stuck ^_^

This is my first bounty contribution

woohoo 🍾

[CuriousLearner]

Hey I've a question!

I see should_suppress_notification_email in marketing/utils. Just wanted to know the preference for this feature. Should the mails be suppressed at some levels?

[thelostone-mc]

I don't think so! @owocki ?

[CuriousLearner]

Just a heads up that I've started a PR. This is still a work in progress.

[owocki]

Just a heads up that I've started a PR. This is still a work in progress.

yay!

should_suppress_notification_email(to_email, 'transactional') should do the trick. the second param is the email 'level'

[owocki]

just commented on the PR

[gitcoinbot]

@CuriousLearner Hello from Gitcoin Core - are you still working on this issue? Please submit a WIP PR or comment back within the next 3 days or you will be removed from this ticket and it will be returned to an ‘Open’ status. Please let us know if you have questions!

• [x] warning (3 days)
• [ ] escalation to mods (6 days)

Funders only: Snooze warnings for 1 day | 3 days | 5 days | 10 days | 100 days

[CuriousLearner]

Addressed review comments, but unable to work on mobile view since media queries aren't working. Please check the PR for more details.

[owocki]

just commented on the PR

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

@CuriousLearner due to inactivity, we have escalated this issue to Gitcoin's moderation team. Let us know if you believe this has been done in error!

• [x] warning (3 days)
• [x] escalation to mods (6 days)

Funders only: Snooze warnings for 1 day | 3 days | 5 days | 10 days | 100 days

[CuriousLearner]

Yeah, I'm working on this issue. Will post more updates soon.

[owocki]

just committed some fixes to the TODOs for this email

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

@CuriousLearner due to inactivity, we have escalated this issue to Gitcoin's moderation team. Let us know if you believe this has been done in error!

• [x] warning (3 days)
• [x] escalation to mods (6 days)

Funders only: Snooze warnings for 1 day | 3 days | 5 days | 10 days | 100 days

[CuriousLearner]

Hey, I'm still working on this issue

[gitcoinbot]

@CuriousLearner Hello from Gitcoin Core - are you still working on this issue? Please submit a WIP PR or comment back within the next 3 days or you will be removed from this ticket and it will be returned to an ‘Open’ status. Please let us know if you have questions!

• [x] warning (3 days)
• [ ] escalation to mods (6 days)

Funders only: Snooze warnings for 1 day | 3 days | 5 days | 10 days | 100 days

[vs77bb]

@CuriousLearner Mind submitting work on Gitcoin here? If you need a bit of ETH, use the Gitcoin Faucet or reach out to me on Slack and I can send you some!

[CuriousLearner]

@vs77bb Ah, I basically did a transaction a week ago for 1 GWEI

But it wasn't accepted, and then I rejected that. and made another one with 1.2 GWEI: https://etherscan.io/tx/0x3bb605b7b11c2af4a48d92754a16b6ad9b03ca5a74018803efd1b553f9339e4e

This is the maximum I had :P

So, now no idea what to do

[owocki]

@CuriousLearner hit us up on slack and we can send you some more ETH for gas money

[CuriousLearner]

@owocki Done: https://etherscan.io/tx/0xe95d9c81247f82c0c324fa58df1676b07b5623ed851af0923e00eecc4c53b09e

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

__Work for 0.15 ETH (89.94 USD @ $599.58/ETH) has been submitted by__:

1. @CuriousLearner

@owocki please take a look at the submitted work:

• PR by @CuriousLearner

---

• Learn more on the Gitcoin Issue Details page
• Questions? Checkout Gitcoin Help or the Gitcoin Slack
  $26,916.24 more funded OSS Work available on the Gitcoin Issue Explorer

[gitcoinbot]

Issue Status: 1. Open 2. Started 3. Submitted 4. Done

---

__The funding of 0.15 ETH (71.51 USD @ $476.72/ETH) attached to this issue has been approved & issued to @CuriousLearner.__

• Learn more at on the Gitcoin Issue Details page
• Questions? Checkout Gitcoin Help or the Gitcoin Slack
• $24,753.57 more funded OSS Work available on the Gitcoin Issue Explorer