Event Hour

event_hour

string

The hour of the day the ad was run, according to a 24-hour clock. Based on the time zone of the shop at the moment of publishing.

Example values: 07, 16, 21

Event Date

event_date

date

The date the ad was run. Based on the time zone of the shop at the moment of publishing.

Event Day

event_date.day

date

The day on which the event occurred. Derived from event_date.

Event Week

event_date.week

date

The Sunday of the week during which the event occurred. Derived from event_date.

Event Month

event_date.month

date

The month during which the event occurred. Derived from event_date.

Event Quarter

event_date.quarter

date

The first month of the quarter during which the event occurred. Derived from event_date.

Event Year

event_date.year

date

The year during which the event occurred. Derived from event_date.

Ad Bid Amount

ad_bid_amount

string

The bid amount for the ad.

Example values: 15, 28, 30

Ad Copy

ad_copy

string

The full text (copy) of the ad.

Ad ID

ad_id

string

The unique ad ID. Assigned by the ad platform.

Example value: 120210439891110007

Ad Image URL

ad_image_url

string

The URL of the ad image.

Example value: https://www.example.com/ad-image.jpg

Ad Name

ad_name

string

The name of the specific ad.

Example values: Kids Ad 1, Read Our Latest Blog 03/12/2023, 8 best fall looks

Ad Status

ad_status

string

The status of the ad.

Example values: ACTIVE, PAUSED

Ad Type

ad_type

string

The format of the ad.

Example values: video, image, copy

Ad Set Bid Amount

adset_bid_amount

string

The bid amount for the ad set.

Example values: 25, 35, 40

Ad Set Bid Strategy

adset_bid_strategy

string

The bidding strategy for the ad set.

Example values: LOWEST_COST_WITHOUT_CAP, LOWEST_COST_WITH_BID_CAP, COST_CAP, LOWEST_COST_WITH_MIN_ROAS

Ad Set Daily Budget

adset_daily_budget

string

The daily budget (in cents) set for the ad set within a campaign. By default shown in the shop's currency.

Example values: 1750, 6000, 40000

Ad Set ID

adset_id

string

The unique ID for the ad set associated with the ad click. Assigned by the ad platform.

Example value: 120210439890740003

Ad Set Lifetime Budget

adset_lifetime_budget

string

The total budget (in cents) set for the ad set within a campaign over its lifetime. By default shown in the shop's currency.

Example values: 5000, 10000, 20000

Ad Set Name

adset_name

string

The name of the ad set within a campaign.

Example values: Broad Audience, Bracelets, Wellness

Ad Set Status

adset_status

string

The status of the ad set.

Example values: ACTIVE, PAUSED

Ad Set Targeting

adset_targeting

record repeated

Details on targeting parameters for the ad set, including specific audience segments. Learn more about ad set targeting data

Target Key

adset_targeting.target_key

string

The targeting category key within the ad set (e.g., location, age, gender). Learn more about ad set targeting data

Example values: age_min, age_max, geo_locations_countries, device_platforms, genders

Target Values

adset_targeting.target_values

record repeated

The specific values associated with the targeting category key, returned as an array. Learn more about ad set targeting data

Amazon Marketplace ID

amazon_marketplace_id

string

The Amazon marketplace ID for the marketplace associated with the order. See list of marketplace IDs.

Amazon Report Type

amazon_report_type

string

The type of report generated for Amazon advertising activities (e.g. sponsored products, sponsored brands, sponsored display).

Breakdown Dimension

breakdown_dimension

string

The dimension used to break down the data, e.g., Country, Gender, Age, Ad Platform, Frequency.

Breakdown Value

breakdown_value

string

The value of the breakdown dimension.

Campaign Bid Strategy

campaign_bid_strategy

string

The bidding strategy for the campaign.

Example values: LOWEST_COST_WITHOUT_CAP, LOWEST_COST_WITH_BID_CAP, COST_CAP, LOWEST_COST_WITH_MIN_ROAS

Campaign Daily Budget

campaign_daily_budget

string

The daily budget (in cents) for the campaign.

Example values: 8000, 10000, 15000

Campaign ID

campaign_id

string

The unique ID for the marketing campaign associated with the ad. Assigned by the ad platform.

Example values: 23852438666180053, 531011533, 20620285829

Campaign Lifetime Budget

campaign_lifetime_budget

string

The lifetime budget (in cents) for the campaign.

Example values: 5000, 10000, 20000

Campaign Name

campaign_name

string

The name of the marketing campaign associated with the ad.

Example values: Catalog Retargeting, US Generic Search, Breakfast of Champions Campaign

Campaign Status

campaign_status

string

The status of the campaign.

Example values: ACTIVE, PAUSED

Channel

channel

string

The platform through which the ad was delivered.

Example values: facebook-ads, google-ads, tiktok-ads

Currency

currency

string

The currency used in the ad platform.

Example values: USD, GBP, EUR

Destination URL

destination_url

string

The destination URL where users land after clicking the ad.

Example value: https://www.myshop.com/products/productA

URL Template

url_template

string

A template URL used to dynamically populate ad URLs with relevant tracking parameters.

Example value: utm_source=facebook&utm_campaign={{campaign.name}}

Video URL

video_url

string

The URL of the ad video.

Example values: https://www.youtube.com/embed/example

All Cost Per Acquisition (All CPA)

all_cpa

formula

Cost per conversion of all types (e.g. purchases, registrations, subscriptions, applications).

All CPA = Ad Spend / All Conversions

All Return on Ad Spend

all_roas

formula

Revenue generated per dollar spent on ads, for channel-reported conversions of all types (e.g. purchases, registrations, subscriptions, applications).

All ROAS = All Conversion Value / Ad Spend

Average Order Value

aov

formula

The average order value as reported by the ad channel.

Channel-Reported AOV = Channel-Reported Conversion Value / Number of Channel-Reported Conversions

Conversion Rate

conversion_rate

formula

The percentage of visits that convert into orders, as reported by the channel.

Channel-Reported Conversion Rate = Number of Channel-Reported Conversions / Number of Visits

Cost Per Acquisition

cpa

formula

The cost to acquire a single conversion, as reported by the channel.

Channel-Reported CPA = Ad Spend / Number of Channel-Reported Conversions

Cost Per Click

cpc

formula

The average cost for each ad click.

CPC = Ad Spend / Clicks

Cost Per Mille

cpm

formula

The cost for 1,000 ad impressions.

CPM = Ad Spend / Impressions x 1000

Cost Per Outbound Click

cpoc

formula

Cost for each click leading out from the ad platform to an external website.

CPOC = Ad Spend / Outbound Clicks

Cost Per Visit

cpv

formula

The cost for each visit driven by ads.

CPV = Ad Spend / Number of Visits

Click-Through Rate

ctr

formula

The percentage of impressions that result in a click.

Click-Through Rate (CTR) = Clicks / Impressions

Revenue Per Link Click

revenue_per_link_click

formula

Average revenue generated from each outbound click on the ad.

Revenue Per Link Click = Conversion Value / Outbound Clicks

Channel-Reported Return on Ad Spend

roas

formula

Revenue generated per dollar spent on ads, as reported by the channel.

Channel-Reported ROAS = Channel-Reported Conversion Value / Ad Spend