449267 - Create quarterly affiliates drawing

Status: RESOLVED FIXED

(Websites Graveyard :: spreadfirefox.com, defect, P1)

Description

[Alex Buchanan [:abuchanan]]

From Juliana Chea,

> 5 winners will be chosen at random out of the top 250 affiliates each quarter to receive a t-shirt and to be featured on SFx. We'd like to make this process as automatic as possible in terms of choosing the winners and featuring them on the website in the Winners Module.

This will need...
  - a block on the front page that will show the winners
  - content describing drawing
  - a cron script
      - run on a configurable interval
      - pick 5 affiliates at random from the top 250 ordered by affiliate points
      - record who has won, so they can't be picked again
          - we mentioned clearing past winners after a year
      - send an email to winners
          - need email content
              - need a way to send out t-shirts, so in email ask "if you want a t-shirt, please send an email to [e-mail] with your name, address, etc"??
      - email appropriate admins
          - notify of new winners
          
I think the plan is to launch this with the affiliates relaunch

Comment 1

[Juliana]

You got it mostly right. Here's some more info: 

- Winners will be emailed the following message from alias [e-mail] (has already been created; David R., Polvi, and Alix are on this);

Hi (username), 

Congrats, you’ve been randomly selected as a SFx Featured Fox! To thank you for promoting Firefox through the Affiliates Program, we’ll be sending you a t-shirt and featuring you on the SFx Affiliates Homepage. Please reply to this email indicating if you would or would not like to accept and we will send you a one-time use code for the Mozilla Store for your t-shirt. 

Thanks again for helping to spread Firefox!

Sincerely, 
The Spread Firefox Team

- Once the winner have replied saying they would like to accept, they will be emailed a special code to redeem their t-shirt through the Mozilla Store and their profiles will be featured in the winners block 
- David R. is in content with the Mozilla Store to get this code 
- The block is to be titled "Featured Foxes" (image attached)

Comment 2

[Juliana]

Attachment: Featured Foxes Winners Block

Comment 3

[David Rolnitzky]

Slight modification to the above auto-response in comment #1:

Hi (username), 

Congratulations!  As a member of the Spread Firefox Affiliates Program,
you’ve been randomly selected as a Featured Fox! 

To thank you for promoting Firefox through the Affiliates Program, we’ll be
sending you a t-shirt and featuring you on the SFx Affiliates Homepage. Please
reply to this email [send to: [e-mail]] indicating you would like
to be accepted as a Featured Fox and we will send you a one-time use code at
the Mozilla Store for your t-shirt. 

Thanks again for helping to spread Firefox!

Sincerely, 
The Spread Firefox Team

Comment 4

[Paul Booker]

Taking this, will begin work later this afternoon.

Comment 5

[Paul Booker]

Shall we do this as follows ..

1. Every quarter (perhaps beginning of Dec, Mar, June and Sept) we send out an email  to 5 winners as described above with a link to a spreadfirefox page to accept their prizes

2. When an affiliate follows the above link and accepts their prize (also giving their postage details etc) we update the "Featured Foxes" block content adding the new affiliate member.

3. Then either..
3a A moderator sends out an email from an administrative page to the affiliate with a 1-time user code at the mozilla store
3b or better we automate this step and request a 1-time user code for a given user UID and then have the email sent out without any moderator intervention  

-Paul   

Comment 6

[David Rolnitzky]

Some good ideas(In reply to comment #5)
> Shall we do this as follows ..
> 
> 1. Every quarter (perhaps beginning of Dec, Mar, June and Sept) we send out an
> email  to 5 winners as described above with a link to a spreadfirefox page to
> accept their prizes
> 
> 2. When an affiliate follows the above link and accepts their prize (also
> giving their postage details etc) we update the "Featured Foxes" block content
> adding the new affiliate member.
The only issue here is that, even if they don't accept, they should still show up in the featured foxes area.  I'd hate to penalize an affiliate just because they didn't respond/accept a prize.
> 
> 3. Then either..
> 3a A moderator sends out an email from an administrative page to the affiliate
> with a 1-time user code at the mozilla store
> 3b or better we automate this step and request a 1-time user code for a given
> user UID and then have the email sent out without any moderator intervention  
> 
I like the possibility of making this as automatic as possible.  We can have these codes ready to go in batches ahead of time.  We should make sure that we have some admin access here so we can tell which affiliates have clicked through and accepted the offer.

>The code process might be a bit manual at first. 
That's ok.
> -Paul   
> 

Comment 7

[Paul Booker]

Thanks David ,

Ill see if i can get this functionality working by Friday .

Comment 8

[Paul Booker]

Attachment: Functionality to implement Featured Foxes

Everything works as discussed with the exception of mail scripts that have been written but cannot be tested presently on my local machine, i intend to look into this over the weekend.

You can get to the affiliate administrative pages @ admin/affiliates

Hopefully nearly everything that you need has now been written but if there is anything further you need please let me know and ill get onto this Monday at 
which time i will do some further testing

Paul

Comment 9

[David Rolnitzky]

Great, thanks Paul.  What's next steps here?  I'm assuming I need to provide you with the codes for the t-shirts.  In the admin interface, is there a way to edit/show what the actual email will look like?

Comment 10

[Paul Booker]

Hi David,

You can enter the store codes on the back end administrative pages against  each "featured foxes" winner and these will then be automatically sent out in an email.

All emails can be adjusted @ admin/settings/affiliates 

The next step ideally will be some kind of review of the implemented UI and some feedback / suggestions ( Alex is currently reviewing the code that i am writing) .  

If you would like to run spreadfirefox on your local machine and test the patch. Please go to ..

https://wiki.mozilla.org/Spreadfirefox 

..for more information

Paul

Comment 11

[David Rolnitzky]

Is there a way to see these back-end admin pages where we could imput store codes?

Comment 12

[Paul Booker]

Attachment: email configuration page

Comment 13

[Paul Booker]

Attachment: View featured foxes

Comment 14

[Paul Booker]

Attachment: Sending a mozilla store code to a featured winner

Comment 15

[Paul Booker]

Attachment: Featured foxes graphic

Comment 16

[Alex Buchanan [:abuchanan]]

committed functionality in r18769

includes
  - featured fox block
  - quarterly drawing cron job
  - email subject/body settings
  - run manually option

doesn't include
  - automatically sending codes to the winners

we can revisit making this completely automated, but for right now, the code and content just isn't there

Comment 17

[Paul Booker]

Any change of status for this bug and its dependencies .

Great work Alex in pulling everything together for the new affiliate pages! 

Best, Paul

Comment 18

[Alex Buchanan [:abuchanan]]

Comment on attachment 336047 [details] [diff] [review]
Functionality to implement Featured Foxes 

cleaning out my requests queue, this review is no longer needed