Set up Payouts Table that is accessible via web browser

[dmtrjsg]

Context

Currently the Payouts widget on YPP dashboard is only linked to the Payments Dasboard, that display the de-facto paid out rewards (as part of the payments). Originally the design implied that the payments would link to Airtable.. and I think It would be great to have a way to display the payments that channels are qualified for but not yet received.

As if not, all of the actions/ video uploads that channels do are not reflected anywhere, so channels are flying blind on their progress.

I've put together a draft version of how the payouts are calculated : https://www.notion.so/joystream/YPP-programme-d492c2eb88ff4ace955b5f2902ec21fb#b3d1ea2c89894efaa382408429b4c408

And how rewards are paid: https://www.notion.so/joystream/YPP-programme-d492c2eb88ff4ace955b5f2902ec21fb#0c8ab793bc42467580e0a4fe751cd312

We need a way to display the rewards qualified for in a public DB for all channels linking to this table from their Dashboard.

Scope

⚠️ FE ticket to update link from payments to point to Airtable is reuqired.

• [ ] Set up Airtable and automatically populate it with the following data on a daily basis (once per day)

Table structure:

1. Council Period
2. Starting Block
3. Starting datetime
4. Finishing block
5. Finishing datetime
6. JS channel title
7. Total Rewards qualified (based on formula described in the How rewards are calculated: https://www.notion.so/joystream/YPP-programme-d492c2eb88ff4ace955b5f2902ec21fb#ddc5f46ed36440d8b92fd728829a9df2)
8. new sign up reward qualified
9. referral reward qualified
10. new content reward qualified
11. joystream promo content reward qualified ⚠️ this will be accompanied by a specific hashtag in description for easier parsing.

[dmtrjsg]

Superceded by

• https://github.com/Joystream/marketing/issues/327