🏓 Ping Table
Official Ping Documentation
Columns
Name
|
Purpose
|
Notes
|
identity
|
Row key
|
|
timestamp
|
Self-explanatory
|
|
url
|
URL the end user visited
|
|
ip
|
User's IP address
|
|
ua
|
User Agent
|
|
hash
|
Unique cookie value?
|
|
record
|
GUID if the [person] record, if known.
|
Record matching happens in a nightly job.
|
quality
|
?
|
|
duration
|
Dwell time on the page
|
Calculated as duration between hits in the same [ping].[ping] group? |
record_timestamp
|
When [record] column was populated?
|
|
referrer
|
Browser header
|
|
utm_source
|
https://en.wikipedia.org/wiki/UTM_parameters
|
|
utm_medium
|
Ditto |
|
utm_term
|
Ditto
|
|
utm_content
|
Ditto
|
|
utm_campaign
|
Ditto
|
|
ping
|
Appears to group rows in a session.
|
|
No Comments