Awin Data Connection

How to connect:

• Go to the Connections tab
• Click Connect on the Awin tile
• Paste your Awin API key
• Hit 'Connect'
• Connection complete

Awin data model and metrics available in ASK BOSCO®

Awin model

• Date: The specific day for which data is reported.
• Publisher: The affiliate partner (publisher) that drove the activity, as named in Awin.
• Publisher ID: Awin's numeric identifier for the publisher.
• Product: Product name from the transaction basket, where basket tracking is enabled.
• Product SKU: Product SKU from the transaction basket.
• Product Category: Product category from the transaction basket.
• Advertiser ID: Awin's identifier for your advertiser programme.
• Sale Value: Affiliate revenue in reporting currency. Filter by Part Status: approved is realised revenue; declined is never paid.
• Commission Value: Commission owed to publishers in reporting currency. Filter by Part Status.
• Clicks: The number of times users clicked on an ad or link.
• Bonus Commission: Bonus commission payments in reporting currency. The only source of bonus values for Awin.
• Network Fee: The Awin network fee charged per transaction, in reporting currency.
• Product Quantity: Units per basket product line. Indicative product attribution, not a revenue source.
• Product Sale Value: Indicative value of the basket product line. Use Sale Value for revenue reporting.
• Transaction Status: Commission status at transaction level (pending, approved, declined). Use for transaction counts; use Part Status for money.
• Part Status: Commission status of the commission-group part. The status filter for Sale Value and Commission Value.
• Transaction Type: Split orders into the different types; Sale, Return, Shipping, Adjustment
• Transaction Campaign: Campaign attached to the Awin transaction, where the publisher tags one. Sparsely populated.
• Performance Campaign: The name of the marketing campaign that drove traffic to the site, sourced from Google Ads, GA4, or data from other ad platforms.
• Commission Group: The Awin commission group the sale part belongs to.
• Currency: Original transaction currency.
• Click Device: Device of the click that drove the transaction.
• Conversion Device: Device used at the point of purchase.
• Transactions: Distinct affiliate orders (transactions).
• Effective Commission Rate: Commission as a percentage of sale value.
• Average Order Value: Average revenue per conversion event.
• Conversion Rate %: Transactions per click, as a percentage.
• Earnings per Click: Commission earned per click.
• Total Commission: Commission plus bonus - your publishers' total earnings.
• Approved Sale Value: Sale value where the part status is approved (realised revenue).
• Approved Commission Value: Commission where the part status is approved.
• Pending Sale Value: Sale value awaiting Awin validation (pending).
• Pending Commission Value: Commission awaiting Awin validation (pending).
• Declined Sale Value: Sale value that was declined - reversed and never paid.
• Declined Commission Value: Commission that was declined - reversed and never paid.
• Approved Transactions: Distinct transactions with approved status.
• Pending Transactions: Distinct transactions awaiting validation.
• Declined Transactions: Distinct transactions that were declined.
• Deleted Sale Value: Sale value on transactions Awin removed - never paid.
• Deleted Commission Value: Commission on transactions Awin removed - never paid.
• Deleted Transactions: Distinct transactions Awin removed.