Skip to content
  • There are no suggestions because the search field is empty.

Awin in Marketing Mix Modeling (MMM)

Sellforte uses Awin data to measure affiliate-driven ecommerce outcomes and associated commission costs. Awin data represents confirmed or pending commercial transactions attributed to affiliate publishers.

Awin outcomes

Use this dataset to measure ecommerce transactions and affiliate-related costs from the Awin affiliate network.

Dataset definition

Ecommerce transaction outcomes from Awin, including sale value and commission-related costs, used for marketing measurement and optimization.

Grain & sample

Each row represents one affiliate transaction.

Example rows (illustrative):

transaction date click date advertiser id publisher id campaign site name customer country sale amount sale currency commission amount commission currency
2025-01-01 2024-12-30 1001 501 Brand_SE siteA.com FI 120.00 EUR 12.00 EUR
2025-01-02 2025-01-01 1001 623 Brand_FI siteB.com SE 85.00 SEK 9.50 SEK
2025-01-03 2025-01-02 1001 744 Brand_UK siteC.com GB 150.00 GBP 15.00 GBP

Dimensions

  • transaction date

  • click date

  • advertiser id

  • publisher id

  • campaign

  • site name

  • advertiser country

  • customer country

  • customer acquisition

  • voucher code used

  • commission status

  • amended

Metrics

Revenue

  • sale amount

Cost

  • commission amount

  • network fee amount

Currency fields

Each monetary metric is accompanied by its own currency field.

  • sale currency

  • commission currency

  • network fee currency

Source retrieval recipe

Source system: Awin
Extract type: Awin Transactions API

Required parameters

  • Advertiser account access

  • Date range

Dimensions queried

  • transaction_date

  • click_date

  • advertiser_id

  • publisher_id

  • campaign

  • site_name

  • advertiser_country

  • customer_country

  • customer_acquisition

  • voucher_code_used

  • commission_status

  • amended

Metrics queried

  • sale_amount

  • commission_amount

  • network_fee_amount

Currency fields queried

  • sale_currency

  • commission_currency

  • network_fee_currency

Derived modeling dimensions

Sellforte also supports business-specific modeling dimensions such as brand and product category. These dimensions are not typically provided as native fields by affiliate platforms, so they need to be derived from other dimensions using one of the following approaches:

  • Account-based differentiation
    When separate advertiser accounts are used for each brand or product category, Sellforte can derive these dimensions from account name or account ID and include them as explicit columns in the dataset.

  • Campaign naming conventions
    Brand or product category can be inferred from structured campaign names and included explicitly as columns in the extracted data.

  • Inline enrichment during data extraction
    Customers may add brand or product category columns as part of their API queries, SQL transformations, or export logic. Use brand and/or product_category as column names.