Visits schema

You can see information about your Online Store visitors, such as their landing page, the device that they use, and which marketing campaign they can be attributed to.

Using SINCE and UNTIL will filter your store's visits by the date that they took place. A query that filters with SINCE -1m UNTIL today will return all visits that took place in the last month.

Example visits query - visits over time

SHOW total_visitors, total_sessions
OVER day(timestamp) AS day
FROM visits
SINCE -7d
UNTIL today ORDER
BY day ASC

Behaviour properties

The following properties show information about your visitors' behaviour on your Online Store:

PropertiesTypeDescription
Aggregate properties - used in the SHOW clause
avg_duration duration The average duration of the sessions in the result set (in seconds).
total_pageviews number The count of page views across the sessions in the result set.
total_sessions number The count of sessions in the result set.
total_visitors number The count of unique visitors across the sessions in the result set.

Device properties

The following properties show information about the devices that your visitors use to view your Online Store:

PropertiesTypeDescription
Non-aggregate properties - used in the BY clause
ua_browser_version string The device browser version.
ua_os string The device operating system.
ua_form_factor string The device type.
ua_os_version string The device operating system version.
ua_browser string The device browser name.

Landing page

The following properties show information on which pages of your Online Store your visitors are landing on:

PropertiesTypeDescription
Non-aggregate properties - used in the BY clause
page_type string The type of page for the landing page (starting page for the session).
page_path string The path for the landing page (starting page for the session).
page_url string The URL for the landing page (starting page for the session).
page_resource_id string The resource identifier for the landing page. For example, if the landing page was a product page, then the resource identifier would be the ID for the product that was viewed.

Referral traffic properties

The following properties show information about how your visitors got to your Online Store:

PropertiesTypeDescription
Non-aggregate properties - used in the BY clause
referrer_host string The full domain of the referrer.
referrer_name string The domain of the referrer in a human-readable form
referrer_path string The URL path of the referrer.
referrer_url string The full URL of the referrer.
referrer_source string The referrer type (search or unknown).

Marketing campaign properties

The following properties show information about the marketing campaign that your Online Store visitors can be attributed to:

PropertiesTypeDescription
Non-aggregate properties - used in the BY clause
utm_campaign_content string A/B testing and content-targeted ads to differentiate ads or links that point to the same URL.
utm_campaign_term string The keywords associated with an ad.
utm_campaign_medium string The ad medium, such as email or cost-per-click (cpc).
utm_campaign_source string Identifies a search engine, a newsletter name, or other source.
utm_campaign_name string The name that you give a promotion or campaign to identify it.

Location properties

The following properties show information about where your Online Store visitors are located:

PropertiesTypeDescription
Non-aggregate properties - used in the BY or OVER clause
location_country string The country where your visitors are located.
location_region string The state or province where your visitors are located.
location_city string The city where your visitors are located.

Time properties

The following properties show information about the date and time of visits to your Online Store:

PropertiesTypeDescription
Non-aggregate properties - used in the BY or OVER clause
year year The year of a session.
month month The month of a session.
week week The week of a session.
day day The day of a session.
hour hour The hour of a session.