Denormalise channel served boost views
Goal
Create an efficient way to retrieve aggregated channel served views so that we can attribute these to users at a later date
What needs to be done
See goal above
Vitess
Column | Description |
---|---|
served_by_user_guid | PRIMARY KEY |
boost_guid | PRIMARY KEY |
views | integer |
last_viewed_timestamp | timestamp |
Daily job
SELECT served_by_user_guid, SUM(views) as total_views_served, SUM((payment_amount / views) * 1000) as ecpm
FROM boosts_partner_views a
INNER JOIN boosts b ON a.boost_guid = b.guid
WHERE status = 9
AND DATE(completed_timestamp) = :ref_date
GROUP BY served_by_user_guid
QA
UX/Design
Mobile
-
Is Mobile Required?
Personas
Experiments
Add feature flag to control paying rewards flow
Acceptance Criteria
-
Spike task for calculating eCPM for a channel serving boosts -
Build out business rules -
Iterator and partner earning deposits implemented in https://gitlab.com/minds/engine/-/blob/master/Core/Monetization/Partners/Manager.php
Definition of Ready Checklist
-
Definition Of Done (DoD) -
Acceptance criteria -
Weighted -
QA -
UX/Design -
Personas -
Experiments
Edited by Fausto Arcidiacono