Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Lay ground work for personalized show recommendations based on past user actions. #10

Open
shawnCaza opened this issue Jun 26, 2024 · 0 comments
Labels
data issues related to MySQL database and PHP api / feed generator enhancement New feature or request NextJS - UI Issues related to the NextJS UI portion of the code base

Comments

@shawnCaza
Copy link
Owner

As a starting point:

UUID:

  • Lets assign new visitors a unique user ID when visiting for the first time.
  • Store ID to DB and local storage.

Track actions:

  • The following behaviours might help us make personalized recommendations:

    • Tag visits
    • Search Terms
    • Clicks to subscribe
    • Show page visits
  • New DB table for user_activity could include columns for:

    • UUID
    • Action type
    • Action itself: ID of the tag / show the action was performed on, or the search term
    • DateTime.

    Do we store unique search terms in a separate table so we can refer to them by ID in user_activity? Or keep search out of this now for simplicity?

@shawnCaza shawnCaza added enhancement New feature or request NextJS - UI Issues related to the NextJS UI portion of the code base data issues related to MySQL database and PHP api / feed generator labels Jun 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
data issues related to MySQL database and PHP api / feed generator enhancement New feature or request NextJS - UI Issues related to the NextJS UI portion of the code base
Projects
None yet
Development

No branches or pull requests

1 participant