timothyfcook commented 10 years ago

✈️ This is the flight deck for the Recognize companies project. ✈️

The top givers (often times companies) who are giving to Git... Gratipay should be shown on the main page.

This is an easy way to thank top givers for supporting projects and a good way to associate our brand with theirs.

Showing Heroku, Khan Academy, Bountysource, etc. on the front pages shows new users who is behind Gratipay and gives them a free advertisement saying "Hey, these folks are cool, they support open source, etc."

This list should change on each load and be drawn randomly from a mix of:

the top 25 givers
specifically curated givers with a unique story

Obviously, open to discussion. Just getting the ball rolling.

✈️ This is the flight deck for the Recognize companies project. ✈️

timothyfcook commented 10 years ago

This is related to #1513

chadwhitacre commented 9 years ago

+1 from @jdorfman in private email.

chadwhitacre commented 9 years ago

How about this? I'm thinking we weight the impressions by amount giving.

=> select username, giving from participants where not anonymous_giving and 
-> giving > 0 and not is_suspicious and number='plural' order by giving desc;
┌──────────────────────┬────────┐
│       username       │ giving │
├──────────────────────┼────────┤
│ MaxCDN               │ 637.50 │
│ stripe               │ 625.00 │
│ balanced             │ 320.00 │
│ 7MacawMedia          │  70.00 │
│ khanacademy          │  66.00 │
│ saxifrageschool      │  51.75 │
│ cos.io               │  40.00 │
│ certifiedtorock      │  38.00 │
│ getsentry            │  35.00 │
│ openconcept_ca       │  29.25 │
│ Runscope             │  28.00 │
│ domainr              │  21.00 │
│ pusher               │  18.00 │
│ Gratipay             │  17.00 │
│ modernmsg            │  15.00 │
│ ukd1                 │  13.29 │
│ marioivan            │  12.00 │
│ sirenwendy           │  10.00 │
│ TriggitEng           │  10.00 │
│ crate                │   9.60 │
│ BenDiscoe            │   7.00 │
│ neocities            │   7.00 │
│ nestoria             │   7.00 │
│ ElijahLynn           │   6.20 │
│ MC COAL LLC          │   5.50 │
│ RokkinCat            │   5.00 │
│ FreeScholar          │   5.00 │
│ missionpinball       │   3.00 │
│ realtimeprojects     │   2.00 │
│ JustinMaxwell        │   2.00 │
│ fewerhassles         │   2.00 │
│ slidecaptain         │   2.00 │
│ PieterMarres         │   2.00 │
│ Aquaponics Lab       │   1.00 │
│ TrustedSugar         │   1.00 │
│ happyseaurchin       │   0.50 │
│ PublishBiyuti        │   0.50 │
│ Citizens Cooperative │   0.50 │
│ boris.ljevar         │   0.35 │
│ davidryal            │   0.25 │
│ roscminni            │   0.25 │
│ davidpinto0          │   0.25 │
│ FinancialBest        │   0.04 │
└──────────────────────┴────────┘
(43 rows)

chadwhitacre commented 9 years ago

"Select random row from a PostgreSQL table with weighted row probabilities" http://stackoverflow.com/questions/13040246/select-random-row-from-a-postgresql-table-with-weighted-row-probabilities

chadwhitacre commented 9 years ago

To avoid gaming, I'd rather base the weighting on how much each actually gave last week (giving is an estimate for next payday), but that can come later, I suppose.