Affluent fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

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

139 metrics90 dimensions

ACCOUNT

report__account_id
Field label Account ID
Description The unique ID number of your account
Field type dimension
Data type string.text.value
report__account_name
Field label Account name
Description The name of your account
Field type dimension
Data type string.text.value
report__currency
Field label Currency
Field type dimension
Data type string.text.value

ACTIONS

report__action_count_net
Field label Actions
Description Net action count
Field type metric
Data type float.number.value
report__action_count_gross
Field label Actions (gross)
Description Gross action count
Field type metric
Data type float.number.value
report__action_count_approved
Field label Actions (approved)
Description Approved action count
Field type metric
Data type int.number.value
report__action_count_pending
Field label Actions (pending)
Description Pending action count
Field type metric
Data type int.number.value
report__action_count_disputed
Field label Actions (disputed)
Description Disputed action count
Field type metric
Data type int.number.value

BONUSES

report__bonus_count_net
Field label Bonuses (net)
Description Net bonus count
Field type metric
Data type int.number.value
report__bonus_amount_net
Field label Bonus amount (net)
Description Net bonus amount
Field type metric
Data type float.currency.value

BRAND

report__brand_name
Field label Brand name
Description The name of the brand for which advertising is running
Field type dimension
Data type string.text.value
report__brand_id
Field label Brand ID
Description The unique ID of the brand for which advertising is running
Field type dimension
Data type string.text.value
report__brand_group
Field label Brand group
Description The name of the brand group for which advertising is running
Field type dimension
Data type string.text.value
report__brand_vertical
Field label Brand vertical
Description The vertical of the brand for which advertising is running
Field type dimension
Data type string.text.value
report__brand_manager_name
Field label Brand account manager name
Description The name of the account manager
Field type dimension
Data type string.text.value
report__brand_manager_id
Field label Brand account manager ID
Description The ID of the account manager
Field type dimension
Data type string.text.value
report__brand_tags
Field label Brand tags
Description List of tags associated with the brand
Field type dimension
Data type string.text.value

CAMPAIGN

report__campaign
Field label Campaign
Description The name of the campaign
Field type dimension
Data type string.text.value
report__campaign_id
Field label Campaign ID
Description The unique ID of the campaign
Field type dimension
Data type string.text.value

CREATIVE

report__creative
Field label Creative
Description The name of the creative
Field type dimension
Data type string.text.value
report__creative_id
Field label Creative ID
Description The unique ID of the creative
Field type dimension
Data type string.text.value
report__creative_type
Field label Creative type
Description The type of the creative
Field type dimension
Data type string.text.value

CUSTOM METRICS

report__custom_0001
Field label Custom metric 1
Field type metric
Data type float.number.value
report__custom_0002
Field label Custom metric 2
Field type metric
Data type float.number.value
report__custom_0003
Field label Custom metric 3
Field type metric
Data type float.number.value
report__custom_0004
Field label Custom metric 4
Field type metric
Data type float.number.value
report__custom_0005
Field label Custom metric 5
Field type metric
Data type float.number.value
report__custom_0006
Field label Custom metric 6
Field type metric
Data type float.number.value
report__custom_0007
Field label Custom metric 7
Field type metric
Data type float.number.value
report__custom_0008
Field label Custom metric 8
Field type metric
Data type float.number.value
report__custom_0009
Field label Custom metric 9
Field type metric
Data type float.number.value
report__custom_00010
Field label Custom metric 10
Field type metric
Data type float.number.value
report__custom_00011
Field label Custom metric 11
Field type metric
Data type float.number.value
report__custom_00012
Field label Custom metric 12
Field type metric
Data type float.number.value
report__custom_00013
Field label Custom metric 13
Field type metric
Data type float.number.value
report__custom_00014
Field label Custom metric 14
Field type metric
Data type float.number.value
report__custom_00015
Field label Custom metric 15
Field type metric
Data type float.number.value
report__custom_00016
Field label Custom metric 16
Field type metric
Data type float.number.value
report__custom_00017
Field label Custom metric 17
Field type metric
Data type float.number.value
report__custom_00018
Field label Custom metric 18
Field type metric
Data type float.number.value
report__custom_00019
Field label Custom metric 19
Field type metric
Data type float.number.value
report__custom_00020
Field label Custom metric 20
Field type metric
Data type float.number.value
report__custom_00021
Field label Custom metric 21
Field type metric
Data type float.number.value
report__custom_00022
Field label Custom metric 22
Field type metric
Data type float.number.value
report__custom_00023
Field label Custom metric 23
Field type metric
Data type float.number.value
report__custom_00024
Field label Custom metric 24
Field type metric
Data type float.number.value
report__custom_00025
Field label Custom metric 25
Field type metric
Data type float.number.value
report__custom_00026
Field label Custom metric 26
Field type metric
Data type float.number.value
report__custom_00027
Field label Custom metric 27
Field type metric
Data type float.number.value
report__custom_00028
Field label Custom metric 28
Field type metric
Data type float.number.value
report__custom_00029
Field label Custom metric 29
Field type metric
Data type float.number.value
report__custom_00030
Field label Custom metric 30
Field type metric
Data type float.number.value
report__custom_00031
Field label Custom metric 31
Field type metric
Data type float.number.value
report__custom_00032
Field label Custom metric 32
Field type metric
Data type float.number.value
report__custom_00033
Field label Custom metric 33
Field type metric
Data type float.number.value
report__custom_00034
Field label Custom metric 34
Field type metric
Data type float.number.value
report__custom_00035
Field label Custom metric 35
Field type metric
Data type float.number.value
report__custom_00036
Field label Custom metric 36
Field type metric
Data type float.number.value
report__custom_00037
Field label Custom metric 37
Field type metric
Data type float.number.value
report__custom_00038
Field label Custom metric 38
Field type metric
Data type float.number.value
report__custom_00039
Field label Custom metric 39
Field type metric
Data type float.number.value
report__custom_00040
Field label Custom metric 40
Field type metric
Data type float.number.value
report__custom_00041
Field label Custom metric 41
Field type metric
Data type float.number.value
report__custom_00042
Field label Custom metric 42
Field type metric
Data type float.number.value
report__custom_00043
Field label Custom metric 43
Field type metric
Data type float.number.value
report__custom_00044
Field label Custom metric 44
Field type metric
Data type float.number.value
report__custom_00045
Field label Custom metric 45
Field type metric
Data type float.number.value
report__custom_00046
Field label Custom metric 46
Field type metric
Data type float.number.value
report__custom_00047
Field label Custom metric 47
Field type metric
Data type float.number.value
report__custom_00048
Field label Custom metric 48
Field type metric
Data type float.number.value
report__custom_00049
Field label Custom metric 49
Field type metric
Data type float.number.value
report__custom_00050
Field label Custom metric 50
Field type metric
Data type float.number.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

DEVICE

report__device_model
Field label Device model
Description The model of the device
Field type dimension
Data type string.text.value
report__device_type
Field label Device type
Description The type of the device
Field type dimension
Data type string.text.value
report__os
Field label Operating System
Description The operating system
Field type dimension
Data type string.text.value
report__browser
Field label Browser
Description The browser that was used
Field type dimension
Data type string.text.value

GENERAL

report__affluent_id
Field label Affluent ID
Description The unique Affluent ID
Field type dimension
Data type string.text.value
report__affluent_created_at
Field label Created at
Description The time data was recorded in Affluent
Field type dimension
Data type string.time.datetime
report__action_type
Field label Action type
Description The type of the action
Field type dimension
Data type string.text.value
report__status
Field label Action status
Field type dimension
Data type string.text.value
report__action_id
Field label Action ID
Description The unique ID of the action
Field type dimension
Data type string.text.value
report__event_code
Field label Event code
Description The code of the event
Field type dimension
Data type string.text.value
report__event_type_id
Field label Event type ID
Description The unique ID of the event type
Field type dimension
Data type string.text.value
report__event_type_name
Field label Event type name
Description The name of the event type
Field type dimension
Data type string.text.value
report__network_id
Field label Network ID
Description The unique ID of the network
Field type dimension
Data type string.text.value
report__referral_domain
Field label Referral domain
Description The referral domain
Field type dimension
Data type string.text.value
report__referral_url
Field label Referral URL
Description The referral URL
Field type dimension
Data type string.text.url
report__platform_name
Field label Platform name
Description The name of the platform
Field type dimension
Data type string.text.value
report__commission_type
Field label Commission type
Description The type of the commission
Field type dimension
Data type string.text.value
report__cross_device
Field label Cross-device
Field type dimension
Data type string.text.value
report__details
Field label Details/comment
Description Details / comments
Field type dimension
Data type string.text.value
report__landing_page
Field label Landing page
Description The landing page
Field type dimension
Data type string.text.value
report__new_to_file
Field label New to file
Description New to file customer
Field type dimension
Data type string.text.value
report__merchant_id
Field label Merchant ID
Description The unique ID of the merchant
Field type dimension
Data type string.text.value
report__order_id
Field label Order ID
Description The unique ID of the order
Field type dimension
Data type string.text.value
report__promo_code
Field label Promo code
Field type dimension
Data type string.text.value
report__repeat_customer
Field label Repeating customer
Description Whether the customer is a repeating one or not
Field type dimension
Data type string.text.value

GEO

report__country
Field label Country
Field type dimension
Data type string.geo.country
report__country_code
Field label Country code
Description The two-letter code of the country
Field type dimension
Data type string.geo.country.twolettercode
report__city
Field label City
Field type dimension
Data type string.geo.city
report__district
Field label District
Field type dimension
Data type string.text.value
report__post_code
Field label Post code
Field type dimension
Data type string.text.value

LEADS

report__lead_count_net
Field label Leads
Field type metric
Data type int.number.value
report__lead_count_gross
Field label Leads (gross)
Field type metric
Data type int.number.value
report__lead_count_approved
Field label Leads (approved)
Field type metric
Data type int.number.value
report__lead_count_pending
Field label Leads (pending)
Field type metric
Data type int.number.value
report__lead_count_disputed
Field label Leads (disputed)
Field type metric
Data type int.number.value
report__lead_advertiser_revenue_net
Field label Lead revenue
Field type metric
Data type float.currency.value
report__cpl
Field label CPL
Description Cost per lead
Field type metric
Data type float.currency.value
report__lead_cr
Field label Lead CR
Description Lead conversion rate
Field type metric
Data type float.number.ratio

MAIN METRICS

report__click_count
Field label Clicks
Description The count of clicks
Field type metric
Data type int.number.value
report__impression_count
Field label Impressions
Description The count of impressions
Field type metric
Data type int.number.value
report__roas_net
Field label ROAS
Description Return on ad spend
Field type metric
Data type float.number.ratio
report__click_through_rate
Field label CTR
Description Click-through rate
Field type metric
Data type float.number.ratio
report__total_profit_net
Field label Total profit
Field type metric
Data type float.currency.value
report__cpa
Field label CPA
Description Cost per acquisition
Field type metric
Data type float.currency.value
report__cr
Field label CR
Description Conversion rate
Field type metric
Data type float.number.ratio
report__alv
Field label ALV
Description Average lead value
Field type metric
Data type float.currency.value
report__epc
Field label EPC
Field type metric
Data type float.currency.value

NETWORK COMMISSION

report__network_fee_net
Field label Network commission (net)
Field type metric
Data type float.currency.value
report__network_fee_gross
Field label Network commission (gross)
Field type metric
Data type float.currency.value
report__network_fee_approved
Field label Network commission (approved)
Field type metric
Data type float.currency.value
report__network_fee_pending
Field label Network commission (pending)
Field type metric
Data type float.currency.value
report__network_fee_disputed
Field label Network commission (disputed)
Field type metric
Data type float.currency.value

OTHER

report__agency_fee
Field label Agency fee
Field type metric
Data type float.currency.value
report__placement_fee_net
Field label Placement fees
Field type metric
Data type float.currency.value
report__commissionable_click_count_net
Field label Commissionable click count
Description Net commissionable click count
Field type metric
Data type int.number.value
report__non_commissionable_click_count
Field label Non-commissionable click count
Description Non-commissionable click count
Field type metric
Data type int.number.value
report__two_tier_bounty_count_net
Field label Two-tier bounties
Field type metric
Data type int.number.value
report__fee
Field label Fee
Field type metric
Data type float.currency.value

PUBLISHER

report__publisher_name
Field label Publisher name
Description The name of the publisher
Field type dimension
Data type string.text.value
report__publisher_id
Field label Publisher ID
Description A unique ID associated with the publisher
Field type dimension
Data type string.text.value
report__publisher_country
Field label Publisher country
Description The country of the publisher
Field type dimension
Data type string.geo.country
report__publisher_group
Field label Publisher group
Description A description of how the publisher is categorized
Field type dimension
Data type string.text.value
report__publisher_tags
Field label Publisher tags
Description List of tags associated with the publisher
Field type dimension
Data type string.text.value
report__publisher_terms_name
Field label Publisher terms
Description Publisher IO / Contract Name
Field type dimension
Data type string.text.value
report__publisher_terms_id
Field label Publisher terms ID
Description Publisher IO / Contract Id
Field type dimension
Data type string.text.value
report__publisher_type
Field label Publisher type
Description The type of marketing the publisher engages in
Field type dimension
Data type string.text.value
report__publisher_website_name
Field label Publisher website name
Description The name of the publisher website
Field type dimension
Data type string.text.value
report__publisher_website_url
Field label Publisher website URL
Description The URL address of the publisher website
Field type dimension
Data type string.text.url
report__publisher_website_id
Field label Publisher website ID
Description The unique ID of the publisher website
Field type dimension
Data type string.text.value
report__publisher_name_merged
Field label Merged publisher name
Description The merged name of the publisher
Field type dimension
Data type string.text.value

PUBLISHER COMMISSION

report__publisher_commission_net
Field label Publisher commission (net)
Field type metric
Data type float.currency.value
report__publisher_commission_gross
Field label Publisher commission (gross)
Field type metric
Data type float.currency.value
report__publisher_commission_approved
Field label Publisher commission (approved)
Field type metric
Data type float.currency.value
report__publisher_commission_pending
Field label Publisher commission (pending)
Field type metric
Data type float.currency.value
report__publisher_commission_disputed
Field label Publisher commission (disputed)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_net
Field label Publisher commission (excluding bonuses) (net)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_gross
Field label Publisher commission (excluding bonuses) (gross)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_approved
Field label Publisher commission (excluding bonuses) (approved)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_pending
Field label Publisher commission (excluding bonuses) (pending)
Field type metric
Data type float.currency.value
report__publisher_commission_exc_bonus_disputed
Field label Publisher commission (excluding bonuses) (disputed)
Field type metric
Data type float.currency.value

PUBLISHERS

report__active_publisher_count
Field label Active publishers
Description Active publisher count (driving clicks)
Field type metric
Data type int.number.value
report__productive_publisher_count
Field label Productive publishers
Description Productive publisher count (driving actions)
Field type metric
Data type int.number.value
report__new_publisher_count
Field label New publishers
Description New publisher count
Field type metric
Data type int.number.value

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

REVENUE

report__advertiser_revenue_net
Field label Revenue (net)
Field type metric
Data type float.currency.value
report__advertiser_revenue_gross
Field label Revenue (gross)
Field type metric
Data type float.currency.value
report__advertiser_revenue_approved
Field label Revenue (approved)
Field type metric
Data type float.currency.value
report__advertiser_revenue_pending
Field label Revenue (pending)
Field type metric
Data type float.currency.value
report__advertiser_revenue_disputed
Field label Revenue (disputed)
Field type metric
Data type float.currency.value
report__advertiser_revenue_refunded
Field label Revenue (refunded)
Field type metric
Data type float.currency.value
report__advertiser_revenue_rejected
Field label Revenue (rejected)
Field type metric
Data type float.currency.value
report__cost_to_revenue
Field label Cost-to-Revenue
Field type metric
Data type float.currency.value

SALES

report__sale_advertiser_revenue_net
Field label Sales revenue
Field type metric
Data type float.currency.value
report__average_order_value_net
Field label AOV
Description Average order value. Sales revenue / Sales count net
Field type metric
Data type float.currency.value
report__sale_count_net
Field label Sales count (net)
Field type metric
Data type int.number.value
report__sale_count_gross
Field label Sales count (gross)
Field type metric
Data type int.number.value
report__sale_count_approved
Field label Sales count (approved)
Field type metric
Data type int.number.value
report__sale_count_pending
Field label Sales count (pending)
Field type metric
Data type int.number.value
report__sale_count_disputed
Field label Sales count (disputed)
Field type metric
Data type int.number.value

SKU

report__sku_name
Field label SKU product name
Description The name of the product
Field type dimension
Data type string.text.value
report__sku_id
Field label SKU
Description The SKU of the product
Field type dimension
Data type string.text.value
report__sku_affluent_created_at
Field label SKU created at
Description Time SKU was recorded in Affluent
Field type dimension
Data type string.time.datetime
report__sku_affluent_modified_at
Field label SKU modified at
Description Time SKU was modified in Affluent
Field type dimension
Data type string.time.datetime
report__sku_category
Field label SKU product category
Description The name of the product category
Field type dimension
Data type string.text.value
report__sku_category_parent
Field label SKU parent product category
Description The name of the parent product category
Field type dimension
Data type string.text.value
report__sku_category_parent_two
Field label SKU second parent product category
Description The name of the second parent product category
Field type dimension
Data type string.text.value
report__sku_quantity_net
Field label SKU quantity
Field type metric
Data type int.number.value
report__sku_quantity_gross
Field label SKU quantity (gross)
Field type metric
Data type int.number.value
report__sku_quantity_approved
Field label SKU quantity (approved)
Field type metric
Data type int.number.value
report__sku_quantity_disputed
Field label SKU quantity (disputed)
Field type metric
Data type int.number.value
report__sku_advertiser_revenue_net
Field label SKU revenue
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_gross
Field label SKU revenue (gross)
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_approved
Field label SKU revenue (approved)
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_pending
Field label SKU revenue (pending)
Field type metric
Data type float.currency.value
report__sku_advertiser_revenue_disputed
Field label SKU revenue (disputed)
Field type metric
Data type float.currency.value
report__average_item_value
Field label SKU average item value
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_net
Field label SKU commissions
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_gross
Field label SKU commissions (gross)
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_approved
Field label SKU commissions (approved)
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_pending
Field label SKU commissions (pending)
Field type metric
Data type float.currency.value
report__sku_publisher_commissions_disputed
Field label SKU commissions (disputed)
Field type metric
Data type float.currency.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
report__year
Field label Year
Field type dimension
Data type string.time.year
report__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
report__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
report__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
report__month
Field label Month
Field type dimension
Data type string.time.month
report__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
report__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
report__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
report__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
report__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
report__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
report__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
report__date
Field label Date
Field type dimension
Data type string.time.date
report__atom
Field label Datetime
Field type dimension
Data type string.time.datetime

TOTAL COMMISSION

report__total_commission_net
Field label Total commission (net)
Field type metric
Data type float.currency.value
report__total_commission_gross
Field label Total commission (gross)
Field type metric
Data type float.currency.value
report__total_commission_approved
Field label Total commission (approved)
Field type metric
Data type float.currency.value
report__total_commission_disputed
Field label Total commission (disputed)
Field type metric
Data type float.currency.value
report__total_commission_rejected
Field label Total commission (rejected)
Field type metric
Data type float.currency.value

TOTAL SPEND

report__total_spend_net
Field label Total spend (net)
Field type metric
Data type float.currency.value
report__total_spend_gross
Field label Total spend (gross)
Field type metric
Data type float.currency.value
report__total_spend_approved
Field label Total spend (approved)
Field type metric
Data type float.currency.value
report__total_spend_pending
Field label Total spend (pending)
Field type metric
Data type float.currency.value
report__total_spend_disputed
Field label Total spend (disputed)
Field type metric
Data type float.currency.value
report__total_spend_rejected
Field label Total spend (rejected)
Field type metric
Data type float.currency.value