Key product fields: user_id, event_name, session_id, event_timestamp, order_id, amount


In product and growth analytics, certain fields appear repeatedly across tables because they help connect user behavior, engagement, and business outcomes. These key fields allow analysts to track users, understand actions, and measure conversions across the entire product journey.

The user_id is the most important identifier. It represents a unique user and is used to connect data across tables such as users, sessions, events, and orders. Without user_id, it would not be possible to track behavior across different parts of the system.

The event_name field describes what action a user performed, such as login, view_dashboard, or purchase. This field is essential for understanding how users interact with the product.

The session_id groups multiple events into a single visit. It helps analysts understand what happens during one user session and measure engagement over time.

The event_timestamp records when an action occurred. This allows analysts to analyze behavior over time, such as identifying peak usage hours or tracking user journeys.

The order_id represents a transaction or conversion. It is used to identify purchases and link them to users.

The amount field represents the value of a transaction. It is used to calculate revenue and measure business performance.

For beginners, the goal is to:

• Understand the purpose of key fields in product data
• Recognize how these fields connect different tables
• Identify which fields are used for behavior vs. transactions
• Learn how to retrieve these fields using SQL

• User identifiers across tables
• Actions users perform
• Session activity
• Transaction values

---

The Basic Pattern

SELECT column_name
FROM table_name;
  

---

Examples

Example 1 — View User Identifiers

Example 2 — View Event Actions

Example 3 — View Transaction Values

---

Practice Tasks (Your Turn!)

Task 1

View the user ID and acquisition channel from the users table.

Task 2

View the session ID and session duration from the sessions table.

Task 3

View the order ID and order date from the orders table.