Choose a version:

campaign_sessions

The campaign_sessions schema captures what visitors did during online store sessions that came from a marketing campaign. It carries the same engagement and funnel measures as the sessions schema, but only for campaign-driven traffic, with campaign, customer, device, browser, and location detail.

Anchor to Use casesUse cases

Session volume: Group campaign_sessions and campaign_online_store_visitors by campaign_id to see how much traffic each campaign drove and how many were distinct visitors.
Engagement: Show campaign_bounce_rate with campaign_pageviews_per_session to judge whether a campaign's traffic engages or bounces.
Funnel: Track campaign_sessions_with_cart_additions, campaign_sessions_that_reached_checkout, and campaign_sessions_that_completed_checkout to see where campaign traffic drops out of the purchase funnel.
Conversion breakdown: Break down campaign_conversion_rate by session_device_browser, session_device_os, or session_country to see which devices and markets convert campaign traffic best.

Examples

ShopifyQL

View in adminView query results in the ShopifyQL editor

FROM campaign_sessions

SHOW campaign_sessions, campaign_online_store_visitors, campaign_pageviews,

campaign_sessions_with_cart_additions, campaign_sessions_that_reached_checkout,

campaign_sessions_that_completed_checkout,

campaign_sessions_that_reached_and_completed_checkout, campaign_conversion_rate

TIMESERIES day WITH PERCENT_CHANGE

DURING this_month

COMPARE TO previous_period

ORDER BY day ASC

VISUALIZE campaign_sessions TYPE line

Examples

Description

Track the full campaign funnel day by day this month, against the prior period. This example uses [`WITH PERCENT_CHANGE`](/docs/api/shopifyql/latest/syntax/with#percent-change-columns) to show which funnel step is slipping.

ShopifyQL

FROM campaign_sessions
  SHOW campaign_sessions, campaign_online_store_visitors, campaign_pageviews,
    campaign_sessions_with_cart_additions, campaign_sessions_that_reached_checkout,
    campaign_sessions_that_completed_checkout,
    campaign_sessions_that_reached_and_completed_checkout, campaign_conversion_rate
  TIMESERIES day WITH PERCENT_CHANGE
  DURING this_month
  COMPARE TO previous_period
  ORDER BY day ASC
VISUALIZE campaign_sessions TYPE line

Description

Rank the top 10 referring channels over the last 30 days by `campaign_checkout_conversion_rate`. This example uses [`HAVING`](/docs/api/shopifyql/latest/syntax/having) `campaign_sessions > 100` to drop thin-traffic channels from the ranking.

ShopifyQL

FROM campaign_sessions
  SHOW campaign_sessions, campaign_reached_checkout_rate,
    campaign_completed_checkout_rate, campaign_checkout_conversion_rate
  GROUP BY referring_channel WITH TOTALS
  HAVING campaign_sessions > 100
  SINCE startOfDay(-30d) UNTIL today
  ORDER BY campaign_checkout_conversion_rate DESC
  LIMIT 10
VISUALIZE campaign_checkout_conversion_rate TYPE bar

Description
Track daily `campaign_average_session_duration` across last month, with `campaign_pageviews_per_session` and `campaign_bounces`. This example uses [`WITH TOTALS`](/docs/api/shopifyql/latest/syntax/with#total-columns) to add a summary column for last month beside the daily rows.
ShopifyQL
```
FROM campaign_sessions
  SHOW campaign_average_session_duration, campaign_pageviews_per_session,
    campaign_bounces
  TIMESERIES day WITH TOTALS
  DURING last_month
  ORDER BY day ASC
VISUALIZE campaign_average_session_duration TYPE line
```
Description
Rank the 10 `session_api_client` values with the longest `campaign_average_session_duration` last month. This example uses [`GROUP BY`](/docs/api/shopifyql/latest/syntax/group-by) `session_api_client` to collapse sessions into one row per client before `LIMIT 10` trims the result.
ShopifyQL
```
FROM campaign_sessions
  SHOW campaign_average_session_duration
  GROUP BY session_api_client WITH TOTALS
  DURING last_month
  ORDER BY campaign_average_session_duration DESC
  LIMIT 10
VISUALIZE campaign_average_session_duration TYPE horizontal_bar
```

Anchor to MetricsMetrics

Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried.

Metrics you can use when querying FROM campaign_sessions.

Anchor to campaign_added_to_cart_rate campaign_added_to_cart_rate: The share of online store visits from campaigns where a visitor added at least one item to cart.

Campaign added to cart rate = sessions with cart additions / sessions
Anchor to campaign_average_session_duration campaign_average_session_duration: Average duration, in seconds, of campaign-associated online store visits
Anchor to campaign_bounce_rate campaign_bounce_rate: The share of online store visits from campaigns that ended after one pageview.

Campaign bounce rate = bounces / sessions
Anchor to campaign_bounces campaign_bounces: Campaign-associated online store visits that ended after a single pageview
Anchor to campaign_checkout_conversion_rate campaign_checkout_conversion_rate: Among campaign visits that reached checkout, this is the share that completed a purchase.

Campaign checkout conversion rate = sessions that completed checkout / sessions that reached checkout
Anchor to campaign_completed_checkout_rate campaign_completed_checkout_rate: Among campaign visits where a visitor added an item to cart and reached checkout, this is the share that completed a purchase.

Campaign completed checkout rate = sessions with cart additions that reached checkout and completed checkout / sessions with cart additions that reached checkout
Anchor to campaign_conversion_rate campaign_conversion_rate: The share of online store visits from campaigns that ended in a completed checkout.

Campaign conversion rate = sessions that completed checkout / sessions
Anchor to campaign_online_store_visitors campaign_online_store_visitors: Each visitor is counted as a single visitor across their online store visits from campaigns.
Anchor to campaign_pageviews campaign_pageviews: A single online store visit from a campaign can contribute more than one pageview.
Anchor to campaign_pageviews_per_session campaign_pageviews_per_session: Average number of pageviews per campaign-associated online store visit

Campaign-associated store pageviews per session = pageviews / sessions
Anchor to campaign_reached_checkout_rate campaign_reached_checkout_rate: The share of online store visits from campaigns where the visitor reached checkout.

Campaign reached checkout rate = sessions that reached checkout / sessions
Anchor to campaign_sessions campaign_sessions: One visitor can have multiple online store visits from campaigns.
Anchor to campaign_sessions_that_completed_checkout campaign_sessions_that_completed_checkout: Campaign-associated online store visits in which a purchase was completed
Anchor to campaign_sessions_that_reached_and_completed_checkout campaign_sessions_that_reached_and_completed_checkout: Campaign-associated online store visits in which the checkout page was reached, then purchase was completed
Anchor to campaign_sessions_that_reached_checkout campaign_sessions_that_reached_checkout: Campaign-associated online store visits in which the checkout page was reached
Anchor to campaign_sessions_with_cart_additions campaign_sessions_with_cart_additions: Campaign-associated online store visits in which a visitor added an item to cart

PERCENT

A percentage value represented as a decimal, where 0.25 represents 25%.

SECOND_DURATION

A duration measured in seconds.

INTEGER

A whole number without decimal places, used for counts, quantities, and other discrete numeric values.

DECIMAL

A precise decimal number used for calculations where fixed-point precision matters.

Anchor to DimensionsDimensions

Attributes of your data that let you look more granularly at aspects of the data. Group and filter by dimensions to shape the rows your query returns.

Dimensions you can use when querying FROM campaign_sessions.

Anchor to campaign_id campaign_id: Unique identifier for a campaign
Anchor to customer_id customer_id: The unique Shopify identifier for the customer associated with the online store visit.
Anchor to day day: The day an online store visit from a campaign started.
Anchor to day_of_week day_of_week: The day of the week an online store visit from a campaign started, with values Monday through Sunday.
Anchor to hour hour: The hour an online store visit from a campaign started.
Anchor to hour_of_day hour_of_day: The hour of day an online store visit from a campaign started, with values 0 through 23.
Anchor to landing_page_path landing_page_path: The path of the first page a campaign visitor landed on when arriving at your online store. Values contain the part of the page address after your store's domain.
Anchor to landing_page_type landing_page_type: The type of first page a campaign visitor landed on when arriving at your online store, such as a product page, collection page, or the home page.
Anchor to landing_page_url landing_page_url: The full page address where a campaign visitor first arrived at your online store.
Anchor to minute minute: The minute an online store visit from a campaign started.
Anchor to month month: The month an online store visit from a campaign started.
Anchor to month_of_year month_of_year: The month of year an online store visit from a campaign started, with values 1 through 12.
Anchor to quarter quarter: The quarter an online store visit from a campaign started.
Anchor to referrer_domain referrer_domain: The referring domain, with a leading www omitted so visits from www.example.com and example.com appear under the same domain.
Anchor to referrer_name referrer_name: The referring site name appears as lowercase text.
Anchor to referrer_path referrer_path: The path on the referring site that led to the online store visit. Values contain the part of the referring page address after its domain.
Anchor to referrer_site referrer_site: The referring site domain, including any subdomain, that led to the online store visit. Use referrer_site to distinguish traffic from different parts of the same domain.
Anchor to referrer_source referrer_source: The type of referrer that led to the online store visit, such as Direct, Search, Social, or Email.
Anchor to referrer_terms referrer_terms: The search terms from the referring page when they are available. Values are free text, so use referrer_terms to review the queries that brought visitors to your store.
Anchor to referrer_url referrer_url: External page that led to an online store visit
Anchor to referring_channel referring_channel: Channel that led to an online store visit
Anchor to referring_medium referring_medium: The category of marketing channel that brought the visitor to your online store, such as social, email, or paid search.
Anchor to referring_platform referring_platform: Platform that led to an online store visit
Anchor to second second: The second an online store visit from a campaign started.
Anchor to session_api_client session_api_client: The storefront type used for the online store visit from a campaign, such as Hydrogen, headless, or online store.
Anchor to session_bounced session_bounced: Whether the online store visit from a campaign ended after one pageview (true) or had more than one pageview (false).
Anchor to session_city session_city: City where the visitor was located when they browsed your online store
Anchor to session_country session_country: Country where the visitor was located when they browsed your online store
Anchor to session_country_code session_country_code: Country code where the visitor was located when they browsed your online store
Anchor to session_device_browser session_device_browser: Browser used to visit your online store
Anchor to session_device_browser_version session_device_browser_version: Version number of the browser used to visit your online store
Anchor to session_device_os session_device_os: Operating system of the device used for visiting your online store
Anchor to session_device_os_version session_device_os_version: Operating system version of the visitor's device
Anchor to session_device_type session_device_type: The kind of device a visitor used during the online store visit from a campaign, such as Desktop, Mobile, Tablet, or Smart TV.
Anchor to session_duration session_duration: Duration, in seconds, of the online store visit
Anchor to session_id session_id: Shopify identifier for the online store visit
Anchor to session_region session_region: State or province where the visitor was located when they browsed your online store (e.g., California, Ontario)
Anchor to shop_id shop_id: The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.
Anchor to traffic_type traffic_type: The type of traffic that led to the online store visit from a campaign, such as Direct, Paid, Organic, or Unknown.
Anchor to utm_campaign utm_campaign: The campaign name from the UTM tags associated with the online store visit. Values are the text used in your campaign links.
Anchor to utm_content utm_content: The content value from the UTM tags associated with the online store visit. Values are the text used to distinguish links or creative in your campaign URLs. Use utm_content to compare specific campaign content.
Anchor to utm_medium utm_medium: The medium value from the UTM tags associated with the online store visit. Values are the text used in your campaign links, such as email, social, or paid search.
Anchor to utm_source utm_source: The source value from the UTM tags associated with the online store visit. Values are the text used in your campaign links, such as a platform, site, or partner name. Use utm_source to compare where tagged campaign traffic came from.
Anchor to utm_term utm_term: The term value from the UTM tags associated with the online store visit, often used for keywords or targeting terms. Values are the text used in your campaign links.
Anchor to week week: The week an online store visit from a campaign started.
Anchor to week_of_year week_of_year: The week of year an online store visit from a campaign started, with values 1 through 53.
Anchor to year year: The year an online store visit from a campaign started.
Anchor to shop_name shop_name: Name of your store

IDENTITY

A unique identifier for a Shopify resource such as a customer, product, or order.

DAY_TIMESTAMP

A date value truncated to day precision.

DAY_OF_WEEK

A day within a week, used for weekday-based grouping and filtering.

HOUR_TIMESTAMP

A timestamp truncated to hour precision.

HOUR_OF_DAY

An hour within a day, typically represented as an integer from 0 to 23.

STRING

A sequence of characters representing text data.

MINUTE_TIMESTAMP

A timestamp truncated to minute precision.

MONTH_TIMESTAMP

A date value representing the start of a month.

MONTH_OF_YEAR

A month number within a year.

QUARTER_TIMESTAMP

A date value representing the start of a fiscal quarter.

SECOND_TIMESTAMP

A timestamp truncated to second precision.

BOOLEAN

A true or false value representing binary states.

WEEK_TIMESTAMP

A date value representing the start of a week.

WEEK_OF_YEAR

A week number within a year.

YEAR_TIMESTAMP

A date value representing the start of a year.

Anchor to Related schemasRelated schemas

campaign_sales: Downstream order conversion for the same campaign sessions.
campaign_products: Product-level attribution from the same campaign sessions.
marketing_engagements: App-level engagement, ad spend, and impression data paired with sessions.

Was this page helpful?