campaign_sales

Count of orders for the first cross-device attribution model

Total average order value for the first click cross-device attribution model

Total sales for the first cross-device attribution model

The number of orders credited by last click attribution to the final marketing touchpoint before purchase.

Total average order value for the last click attribution model

Total sales for the last click attribution model

Count of orders for the last non-direct click cross-device attribution model

Total average order value for the last non-direct click cross-device attribution model

Total sales for the last non-direct cross-device attribution model

The weighted number of orders under linear cross-device attribution. Values can include fractional order credit because linear attribution shares credit across campaign sessions.

Total average order value using the linear cross-device attribution model

Total sales using the linear cross-device attribution model

Average order value for the first click cross-device attribution model

First click average order value = (gross sales - discounts) / orders

Sales for the first cross-device attribution model

First click sales = gross sales - discounts

Average order value for the last click attribution model

Last click average order value = (gross sales - discounts) / orders

Sales for the last click attribution model

Last click sales = gross sales - discounts

Average order value for the last non-direct click cross-device attribution model

Last non-direct click average order value = (gross sales - discounts) / orders

Sales for the last non-direct cross-device attribution model

Last non-direct click sales = gross sales - discounts

Average order value using the linear cross-device attribution model

Linear average order value = (gross sales - discounts) / orders

Sales using the linear cross-device attribution model

Linear sales = gross sales - discounts

The campaign identifier tied to the session that led to the order.

The tracking tag associated with the click ID for the campaign-driven session.

The unique Shopify identifier for the customer on the order.

Indicates if this is a repeat order from the customer

The day an order from a campaign-driven session was processed.

The day of the week an order from a campaign-driven session was processed, with values Monday through Sunday.

The hour an order from a campaign-driven session was processed.

The hour of day an order from a campaign-driven session was processed, with values 0 through 23.

Indicates if this is the first session in the customer journey across devices

Indicates if this is the last session in the customer journey

Indicates if this is the last non-direct session in the customer journey across devices

The share of order credit assigned to the campaign-driven session by the linear cross-device model.

The URL parameter name tied to the marketing activity for the session. Values are free-text parameter keys from your campaign links.

The URL parameter value tied to the marketing activity for the session. Values are free text from your campaign links.

Identifier for the API client of the Marketing Event associated with the session

The marketing event identifier associated with the session that led to the order.

The month an order from a campaign-driven session was processed.

The month of year an order from a campaign-driven session was processed, with values 1 through 12.

Whether an order came from the customer's first purchase (New) or a later purchase (Returning).

The page URL for the session, with query parameters and fragments removed so the same page groups together. Use normalized_page_url to see which pages led to campaign-driven sales.

The unique Shopify identifier for the order. Use order_id with order_name to show readable order labels.

Name of the order

The exact date and time the order was processed, reported in your store's time zone.

The quarter an order from a campaign-driven session was processed.

The referring page that brought the visitor to your store. The same page groups together regardless of tracking parameters.

Channel that led to an online store session

Category of referring channel that led to an online store session

Platform that led to an online store session

The session token tied to campaign attribution for the order.

The unique Shopify identifier for your store. Use shop_id with shop_name to show readable store labels.

The type of traffic that led to the online store session, such as Direct, Paid, Organic, or Unattributed.

The campaign name from the UTM tracking on the session. Values are free text from your campaign links.

UTM content associated with the session

The medium value from the UTM tracking on the session. Values are free text from your campaign links.

The source value from the UTM tracking on the session. Values are free text from your campaign links.

The term value from the UTM tracking on the session. Values are free text from your campaign links, often used for keywords or search terms.

The week an order from a campaign-driven session was processed.

The week of year an order from a campaign-driven session was processed, with values 1 through 53.

The year an order from a campaign-driven session was processed.

The customer's all-time spend is shown in your store's currency.

The day the customer most recently placed an order, reported in your store's time zone.

Number of orders the customer has placed across all time

Name of your store

Indicates if this is the customer's first order

Type of the marketing event