Beeswax fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Beeswax data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

37 metrics66 dimensions

ACCOUNT

account_id
Field label Account ID
Description Unique identifier for the account
Field type dimension
Data type string.text.value
account_name
Field label Account name
Description Name of the account
Field type dimension
Data type string.text.value
currency
Field label Currency
Description Currency of the account
Field type dimension
Data type string.currency.code

ADVERTISER

advertiser_id
Field label Advertiser ID
Description Unique identifier for the advertiser
Field type dimension
Data type string.text.value
advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
advertiser_domain
Field label Advertiser domain
Description Website domain of the advertiser
Field type dimension
Data type string.text.value
advertiser_category
Field label Advertiser category
Description Category of the advertiser
Field type dimension
Data type string.text.value

CAMPAIGN

campaign_id
Field label Campaign ID
Description Unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_budget
Field label Campaign budget
Description Total budget allocated for the campaign
Field type dimension
Data type string.text.value
campaign_budget_type
Field label Campaign budget type
Description Type of budget used for the campaign
Field type dimension
Data type string.text.value
campaign_start_date
Field label Campaign start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
campaign_start_datetime
Field label Campaign start datetime
Description Start date and time of the campaign
Field type dimension
Data type string.time.datetime
campaign_end_date
Field label Campaign end date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaign_end_datetime
Field label Campaign end datetime
Description End date and time of the campaign
Field type dimension
Data type string.time.datetime

CREATIVE

creative_id
Field label Creative ID
Description Unique identifier for the creative
Field type dimension
Data type string.text.value
creative_name
Field label Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
creative_size
Field label Creative size
Description Dimensions of the creative
Field type dimension
Data type string.text.value
video_duration
Field label Video duration
Description Length of the video creative in seconds
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEAL

deal_id
Field label Deal ID
Description Unique identifier for the deal
Field type dimension
Data type string.text.value
deal_name
Field label Deal name
Description Name of the deal
Field type dimension
Data type string.text.value
deal_auction_type
Field label Deal auction type
Description Auction type of the deal
Field type dimension
Data type string.text.value

EVENT

event_id
Field label Event ID
Description Unique identifier for the event
Field type dimension
Data type string.text.value
event_name
Field label Event name
Description Name of the event
Field type dimension
Data type string.text.value
event_alternative_id
Field label Event alternative ID
Description The alternative ID of the event
Field type dimension
Data type string.text.value

FLIGHT

flight_id
Field label Flight ID
Description Unique identifier for the flight
Field type dimension
Data type string.text.value
flight_name
Field label Flight name
Description Name of the flight
Field type dimension
Data type string.text.value
flight_budget
Field label Flight budget
Description Total budget allocated for the flight
Field type dimension
Data type string.text.value
flight_start_date
Field label Flight start date
Description Start date of the flight
Field type dimension
Data type string.time.date
flight_start_datetime
Field label Flight start datetime
Description Start date and time of the flight
Field type dimension
Data type string.time.datetime
flight_end_date
Field label Flight end date
Description End date of the flight
Field type dimension
Data type string.time.date
flight_end_datetime
Field label Flight end datetime
Description End date and time of the flight
Field type dimension
Data type string.time.datetime

LINE ITEM

line_item_id
Field label Line item ID
Description Unique identifier for the line item
Field type dimension
Data type string.text.value
line_item_name
Field label Line item name
Description Name of the line item
Field type dimension
Data type string.text.value
line_item_budget
Field label Line item budget
Description Total budget allocated for the line item
Field type dimension
Data type string.text.value
line_item_budget_type
Field label Line item budget type
Description Type of budget used for the line item
Field type dimension
Data type string.text.value
line_item_start_date
Field label Line item start date
Description Start date of the line item
Field type dimension
Data type string.time.date
line_item_start_datetime
Field label Line item start datetime
Description Start date and time of the line item
Field type dimension
Data type string.time.datetime
line_item_end_date
Field label Line item end date
Description End date of the line item
Field type dimension
Data type string.time.date
line_item_end_datetime
Field label Line item end datetime
Description End date and time of the line item
Field type dimension
Data type string.time.datetime

PERFORMANCE

impressions
Field label Impressions
Description Total number of ad impressions
Field type metric
Data type int.number.value
clicks
Field label Clicks
Description Total number of clicks
Field type metric
Data type int.number.value
spend
Field label Spend
Description Total amount spent on the campaign
Field type metric
Data type float.currency.value
spend_usd
Field label Spend (USD)
Description Total amount spent on the campaign in USD
Field type metric
Data type float.currency.value
Services Currency conversion
spend_eur
Field label Spend (EUR)
Description Total amount spent on the campaign in EUR
Field type metric
Data type float.currency.value
Services Currency conversion
spend_gbp
Field label Spend (GBP)
Description Total amount spent on the campaign in GBP
Field type metric
Data type float.currency.value
Services Currency conversion
media_spend
Field label Media spend
Description Total amount spent on media placements
Field type metric
Data type float.currency.value
media_spend_usd
Field label Media spend (USD)
Description Total amount spent on media placements in USD
Field type metric
Data type float.currency.value
Services Currency conversion
media_spend_eur
Field label Media spend (EUR)
Description Total amount spent on media placements in EUR
Field type metric
Data type float.currency.value
Services Currency conversion
media_spend_gbp
Field label Media spend (GBP)
Description Total amount spent on media placements in GBP
Field type metric
Data type float.currency.value
Services Currency conversion
inventory_cost
Field label Inventory cost
Description Total cost of inventory
Field type metric
Data type float.currency.value
inventory_cost_usd
Field label Inventory cost (USD)
Description Total cost of inventory in USD
Field type metric
Data type float.currency.value
Services Currency conversion
inventory_cost_eur
Field label Inventory cost (EUR)
Description Total cost of inventory in EUR
Field type metric
Data type float.currency.value
Services Currency conversion
inventory_cost_gbp
Field label Inventory cost (GBP)
Description Total cost of inventory in GBP
Field type metric
Data type float.currency.value
Services Currency conversion
cpm
Field label CPM
Description Cost per mille. (spend / impressions) x 1000
Field type metric
Data type float.currency.value
cpc
Field label CPC
Description Cost per click. (spend / clicks)
Field type metric
Data type float.currency.value
ctr
Field label CTR
Description Click-through rate. (clicks / impressions)
Field type metric
Data type float.number.ratio

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

REACH

reach
Field label Reach
Description Total number of unique users exposed to the ad
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
frequency
Field label Frequency
Description Number of times each user saw the ad
Field type metric
Data type float.number.value

REVENUE

revenue
Field label Revenue
Description Total revenue generated from the campaign
Field type metric
Data type float.currency.value
gross_margin
Field label Gross margin
Description Total profit before deducting expenses
Field type metric
Data type float.currency.value
net_margin
Field label Net margin
Description Total profit after deducting all expenses
Field type metric
Data type float.currency.value
vendor_fees
Field label Vendor fees
Description Fees paid to vendors
Field type metric
Data type float.number.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

VIDEO

video_companion_clicks
Field label Video companion clicks
Description Total number of clicks on video companion
Field type metric
Data type int.number.value
video_companion_views
Field label Video companion views
Description Total number of views of video companion
Field type metric
Data type int.number.value
video_completes
Field label Video completes
Description Total number of times the video has been watched to completion
Field type metric
Data type int.number.value
video_midpoints
Field label Video midpoints
Description Total number of times the video has been watched to midpoint
Field type metric
Data type int.number.value
video_plays
Field label Video plays
Description Total number of times the video has been played
Field type metric
Data type int.number.value
video_q1s
Field label Video Q1s
Description Total number of times the video has been watched to the first quartile
Field type metric
Data type int.number.value
video_q3s
Field label Video Q3s
Description Total number of times the video has been watched to the third quartile
Field type metric
Data type int.number.value
video_skips
Field label Video skips
Description Total number of times the video has been skipped
Field type metric
Data type int.number.value
video_companion_ctr
Field label Video companion CTR
Description Click-through rate for video companion. (Video companion clicks / video companion views)
Field type metric
Data type float.number.ratio
video_completion_rate
Field label Video completion rate
Description Percentage of people who watched the video to completion. (Video Completes / Video companion views)
Field type metric
Data type float.number.ratio

VIEWABILITY

viewable_impressions
Field label Viewable impressions
Description Total number of impressions considered viewable
Field type metric
Data type int.number.value
measurable_impressions
Field label Measurable impressions
Description Total number of impressions that could be measured for viewability
Field type metric
Data type int.number.value
invalid_impressions
Field label Invalid impressions
Description Total number of impressions flagged as invalid
Field type metric
Data type int.number.value
measurable_invalid_impressions
Field label Measurable invalid impressions
Description Total number of invalid impressions that were measurable
Field type metric
Data type int.number.value