Media User Ratings Systems

Media Usage Reporting


Object_Object TABLE
: ID
: (URL?)

User::Media JOIN TABLE
: User ID
: Media ID
: Media Menu Position
: Media User Rating Score
: Media Global Rating Score
: Visit Start TimeStamp
: Visit End TimeStamp

User::Media JOIN TABLE is this Sattinger's Traffic Table?
user ID
Object ID (URL?)
1st visit Time
Last Visit Time
total Visit Sessions
H Visits: if New Time-Last Time < H, then N + 1 visits; else, 1 visit
D Visits if New Time-Last Time < D, then N + 1 visits; else, 1 visit
W Visits if New Time-Last Time < D, then N + 1 visits; else, 1 visit
M Visits if New Time-Last Time < D, then N + 1 visits; else, 1 visit


Objekt_Traffic Snapshot Table
H Visits: if New Last Visit Time-Last Visit Time < H, then N + 1 visits; else, 1 visit
D Visits if New Time-Last Time < D, then N + 1 visits; else, 1 visit
W Visits if New Time-Last Time < D, then N + 1 visits; else, 1 visit
M Visits if New Time-Last Time < D, then N + 1 visits; else, 1 visit
total Visit Sessions: N+1

Needlessly Complicated Calclulations

Total Attempts: game/session BaseWeight*each Record where GameID=GameID
Total Playtime: game/session sum(TimeEnd-TimeLaunch) for each Record where GameID=GameID
Last H,D,W,M Launches (90 mins): game/session H,D,W,Mmultt*each Record where GameID=GameID AND Time Launch is < H,D,W,M
Playtime H,D,W,M: game/session H,D,W,Mmultt*sum(TimeEnd-TimeLaunch) for each Record where GameID=GameID AND Time Launch is < H,D,W,M
- User UP/DOWN

Needlessly Complicated Game Fields

Editor Skew
Rating per month: thumb up, thumb down:N + (Wmult)firstclick+1eachaddedclickmax(Dmult)
Rating Weight (determines Game Slot)
Score: Editor Skew+Ratings This month+rating last month+Launches+H+D+W+M+Playtime+H+D+W+M
Publish Date
Active: Binary
Notes: track active/inactive dates

Attempt to Weight Visits by visit age

Baseweight:1
H period
H mult: 40
D mult:10
W mult: 5
Second weight:.006
Publish / Unpublish

Attempt to Weight Visits by Menu Position

Slot Handicaps:
1group: .25
2group: .8
3group. .9
4group. 1
etc
5. 1.2
6. 1.5
7. 2
8. 4
9. 4
10. 4