1 files changed, 28 insertions, 0 deletions
diff --git a/Biz/PodcastItLater/Core.py b/Biz/PodcastItLater/Core.py
index 7b48ac2..c625e11 100644
--- a/Biz/PodcastItLater/Core.py
+++ b/Biz/PodcastItLater/Core.py
@@ -1028,6 +1028,34 @@ class Database:  # noqa: PLR0904
             return cursor.fetchone() is not None
 
     @staticmethod
+    def track_episode_metric(
+        episode_id: int,
+        event_type: str,
+        user_id: int | None = None,
+    ) -> None:
+        """Track an episode metric event.
+
+        Args:
+            episode_id: ID of the episode
+            event_type: Type of event ('added', 'played', 'downloaded')
+            user_id: Optional user ID (None for anonymous events)
+        """
+        with Database.get_connection() as conn:
+            cursor = conn.cursor()
+            cursor.execute(
+                "INSERT INTO episode_metrics (episode_id, user_id, event_type) "
+                "VALUES (?, ?, ?)",
+                (episode_id, user_id, event_type),
+            )
+            conn.commit()
+            logger.info(
+                "Tracked %s event for episode %d (user: %s)",
+                event_type,
+                episode_id,
+                user_id or "anonymous",
+            )
+
+    @staticmethod
     def get_user_episodes(user_id: int) -> list[dict[str, Any]]:
         """Get all episodes in a user's feed."""
         with Database.get_connection() as conn: