(Web|Mobile) Analytics - User (Visitor Identity)
Table of Contents
About
A website/product visitor
Articles Related
Identity
Identification
Logical Data Modeling - Identification
Users can be identified with one of the following ways:
- By submitting a form with an id (email)
- By clicking a email link (campaign)
- By authentification in a login form.
MUV
Website size is generally determined by the MUV (Monthly Unique Visitor)
- < 99K UVs
- 100K - 250K UVs
- 251K - 500K UVs
- 501K - 750K UVs
- > 750K UVs
Tool
- https://www.hull.io/ - User profile sync
Table example
Segment
The identifies table holds all user data.
Column | Description |
---|---|
Anonymous_id | The anonymous ID of the user |
user_id | The unique ID of the user |
context_<key> | Non-user-related context fields sent with each page or screen call - Google Analytics - Browsing Context ( URL , screen, ) |
id | he unique ID of the identify call itself |
received_at | When the page or screen call was received |
sent_at | When the page or screen call was triggered by the user |
<trait> | Each trait of the user you record is created as it’s own column, and the column type is automatically inferred from your data. For example, you might have columns like email and first_name. |
Example:
- number of unique users by each day:
SELECT DATE(sent_at) AS Day, COUNT(DISTINCT(user_id)) AS Users
FROM <source>.identifies
GROUP BY day
ORDER BY day