Affluent data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: BRAND_PUBLISHER

dataSourceName
Display name 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
report__account_id
Display name Account ID
Description The unique ID number of your account
Field type dimension
Data type string.text.value
report__account_name
Display name Account name
Description The name of your account
Field type dimension
Data type string.text.value
report__action_count_approved
Display name Actions (approved)
Description Approved action count
Field type metric
Data type int.number.value
report__action_count_disputed
Display name Actions (disputed)
Description Disputed action count
Field type metric
Data type int.number.value
report__action_count_gross
Display name Actions (gross)
Description Gross action count
Field type metric
Data type float.number.value
report__action_count_net
Display name Actions
Description Net action count
Field type metric
Data type float.number.value
report__action_count_pending
Display name Actions (pending)
Description Pending action count
Field type metric
Data type int.number.value
report__advertiser_revenue_approved
Display name Revenue (approved)
Field type metric
Data type float.currency.value
report__advertiser_revenue_disputed
Display name Revenue (disputed)
Field type metric
Data type float.currency.value
report__advertiser_revenue_gross
Display name Revenue (gross)
Field type metric
Data type float.currency.value
report__advertiser_revenue_net
Display name Revenue (net)
Field type metric
Data type float.currency.value
report__advertiser_revenue_pending
Display name Revenue (pending)
Field type metric
Data type float.currency.value
report__advertiser_revenue_refunded
Display name Revenue (refunded)
Field type metric
Data type float.currency.value
report__advertiser_revenue_rejected
Display name Revenue (rejected)
Field type metric
Data type float.currency.value
report__affluent_id
Display name Affluent ID
Description The unique Affluent ID
Field type dimension
Data type string.text.value
report__agency_fee
Display name Agency fee
Field type metric
Data type float.currency.value
report__bonus_amount_net
Display name Bonus amount (net)
Description Net bonus amount
Field type metric
Data type float.currency.value
report__bonus_count_net
Display name Bonuses (net)
Description Net bonus count
Field type metric
Data type int.number.value
report__brand_group
Display name Brand group
Description The name of the brand group for which advertising is running
Field type dimension
Data type string.text.value
report__brand_id
Display name Brand ID
Description The unique ID of the brand for which advertising is running
Field type dimension
Data type string.text.value
report__brand_manager_id
Display name Brand account manager ID
Description The ID of the account manager
Field type dimension
Data type string.text.value
report__brand_manager_name
Display name Brand account manager name
Description The name of the account manager
Field type dimension
Data type string.text.value
report__brand_name
Display name Brand name
Description The name of the brand for which advertising is running
Field type dimension
Data type string.text.value
report__brand_tags
Display name Brand tags
Description List of tags associated with the brand
Field type dimension
Data type string.text.value
report__brand_vertical
Display name Brand vertical
Description The vertical of the brand for which advertising is running
Field type dimension
Data type string.text.value
report__campaign
Display name Campaign
Description The name of the campaign
Field type dimension
Data type string.text.value
report__campaign_id
Display name Campaign ID
Description The unique ID of the campaign
Field type dimension
Data type string.text.value
report__click_count
Display name Clicks
Description The count of clicks
Field type metric
Data type int.number.value
report__commissionable_click_count_net
Display name Commissionable click count
Description Net commissionable click count
Field type metric
Data type int.number.value
report__country
Display name Country
Field type dimension
Data type string.geo.country
report__country_code
Display name Country code
Description The two-letter code of the country
Field type dimension
Data type string.geo.country.twolettercode
report__creative
Display name Creative
Description The name of the creative
Field type dimension
Data type string.text.value
report__creative_id
Display name Creative ID
Description The unique ID of the creative
Field type dimension
Data type string.text.value
report__creative_type
Display name Creative type
Description The type of the creative
Field type dimension
Data type string.text.value
report__currency
Display name Currency
Field type dimension
Data type string.text.value
report__date
Display name Date
Field type dimension
Data type string.time.date
report__impression_count
Display name Impressions
Description The count of impressions
Field type metric
Data type int.number.value
report__lead_advertiser_revenue_net
Display name Lead revenue
Field type metric
Data type float.currency.value
report__lead_count_approved
Display name Leads (approved)
Field type metric
Data type int.number.value
report__lead_count_disputed
Display name Leads (disputed)
Field type metric
Data type int.number.value
report__lead_count_gross
Display name Leads (gross)
Field type metric
Data type int.number.value
report__lead_count_net
Display name Leads
Field type metric
Data type int.number.value
report__lead_count_pending
Display name Leads (pending)
Field type metric
Data type int.number.value
report__network_fee_approved
Display name Network commission (approved)
Field type metric
Data type float.currency.value
report__network_fee_disputed
Display name Network commission (disputed)
Field type metric
Data type float.currency.value
report__network_fee_gross
Display name Network commission (gross)
Field type metric
Data type float.currency.value
report__network_fee_net
Display name Network commission (net)
Field type metric
Data type float.currency.value
report__network_fee_pending
Display name Network commission (pending)
Field type metric
Data type float.currency.value
report__placement_fee_net
Display name Placement fees
Field type metric
Data type float.currency.value
report__publisher_commission_approved
Display name Publisher commission (approved)
Field type metric
Data type float.currency.value
report__publisher_commission_disputed
Display name Publisher commission (disputed)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_approved
Display name Publisher commission (excluding bonuses) (approved)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_disputed
Display name Publisher commission (excluding bonuses) (disputed)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_gross
Display name Publisher commission (excluding bonuses) (gross)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_net
Display name Publisher commission (excluding bonuses) (net)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_pending
Display name Publisher commission (excluding bonuses) (pending)
Field type metric
Data type float.currency.value
report__publisher_commission_gross
Display name Publisher commission (gross)
Field type metric
Data type float.currency.value
report__publisher_commission_net
Display name Publisher commission (net)
Field type metric
Data type float.currency.value
report__publisher_commission_pending
Display name Publisher commission (pending)
Field type metric
Data type float.currency.value
report__publisher_country
Display name Publisher country
Description The country of the publisher
Field type dimension
Data type string.geo.country
report__publisher_group
Display name Publisher group
Description A description of how the publisher is categorized
Field type dimension
Data type string.text.value
report__publisher_id
Display name Publisher ID
Description A unique ID associated with the publisher
Field type dimension
Data type string.text.value
report__publisher_name
Display name Publisher name
Description The name of the publisher
Field type dimension
Data type string.text.value
report__publisher_name_merged
Display name Merged publisher name
Description The merged name of the publisher
Field type dimension
Data type string.text.value
report__publisher_tags
Display name Publisher tags
Description List of tags associated with the publisher
Field type dimension
Data type string.text.value
report__publisher_terms_id
Display name Publisher terms ID
Description Publisher IO / Contract Id
Field type dimension
Data type string.text.value
report__publisher_terms_name
Display name Publisher terms
Description Publisher IO / Contract Name
Field type dimension
Data type string.text.value
report__publisher_type
Display name Publisher type
Description The type of marketing the publisher engages in
Field type dimension
Data type string.text.value
report__publisher_website_id
Display name Publisher website ID
Description The unique ID of the publisher website
Field type dimension
Data type string.text.value
report__publisher_website_name
Display name Publisher website name
Description The name of the publisher website
Field type dimension
Data type string.text.value
report__publisher_website_url
Display name Publisher website URL
Description The URL address of the publisher website
Field type dimension
Data type string.text.url
report__sale_advertiser_revenue_net
Display name Sales revenue
Field type metric
Data type float.currency.value
report__sale_count_approved
Display name Sales count (approved)
Field type metric
Data type int.number.value
report__sale_count_disputed
Display name Sales count (disputed)
Field type metric
Data type int.number.value
report__sale_count_gross
Display name Sales count (gross)
Field type metric
Data type int.number.value
report__sale_count_net
Display name Sales count (net)
Field type metric
Data type int.number.value
report__sale_count_pending
Display name Sales count (pending)
Field type metric
Data type int.number.value
report__sku_advertiser_revenue_approved
Display name SKU revenue (approved)
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_disputed
Display name SKU revenue (disputed)
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_gross
Display name SKU revenue (gross)
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_net
Display name SKU revenue
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_pending
Display name SKU revenue (pending)
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_approved
Display name SKU commissions (approved)
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_disputed
Display name SKU commissions (disputed)
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_gross
Display name SKU commissions (gross)
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_net
Display name SKU commissions
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_pending
Display name SKU commissions (pending)
Field type metric
Data type float.currency.value
report__sku_quantity_approved
Display name SKU quantity (approved)
Field type metric
Data type int.number.value
report__sku_quantity_disputed
Display name SKU quantity (disputed)
Field type metric
Data type int.number.value
report__sku_quantity_gross
Display name SKU quantity (gross)
Field type metric
Data type int.number.value
report__sku_quantity_net
Display name SKU quantity
Field type metric
Data type int.number.value
report__two_tier_bounty_count_net
Display name Two-tier bounties
Field type metric
Data type int.number.value