Use the Adtraction data source connector to get affiliate marketing metrics like impressions, clicks, transactions, and commission. Create reports where you split data by markets, channels, ads, devices, and segments.
Before you begin
Before you build reports, you need to connect the data source to Supermetrics.
Connection instructions: See our Adtraction connection guide.
Available metrics and dimensions: For a full list of the fields you can use in your reporting, see our Adtraction field documentation.
Query types
With this data source, you need to select a query type to get the right type of data:
Adtraction query types
Advertiser: Channels
Advertiser: Clicks
Advertiser: Transactions
Advertiser: Statistics
Advertiser: Statistics by ad
Advertiser: Statistics by channel
Advertiser: Statistics by day
Advertiser: Statistics by segment
Affiliate: Markets
Affiliate: Channels
Affiliate: Currencies
Affiliate: Applications
Affiliate: Clicks
Affiliate: Transactions
Affiliate: Latest transactions
Affiliate: Statistics
Affiliate: Statistics by ads
Affiliate: Statistics by channel
Affiliate: Statistics by day
Affiliate: Statistics by EPI
Affiliate: Statistics by program
Popular queries
These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.
See cost, orders, and sales
Take a look at how your cost, orders, and sales have developed over the year. In this example, we explore the data on the daily level.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Query type | Advertiser: Statistics by day |
Date range | Year to date |
Metrics | Cost, Order value, Sales |
Dimensions | Date |
Suggested visualization | Line chart or time series |
Understanding the data
Cost: Shows the total cost of the transaction, including affiliate commission and network fee.
Order value: Shows the order value of the sale transactions.
Sales: Shows the number of sales transactions
See transactions cost
View how your costs have evolved over time. In this example, we take a look at the data for the ongoing month and compare it to the previous month.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Query type | Advertiser: Transactions |
Date range | This month to date |
Date range comparison | Previous period |
Metrics | Cost |
Suggested visualization | Scorecard |
Understanding the data
Cost: Shows the total cost of the transaction, including affiliate commission and network fee.
See clicks and impressions
See clicks and impressions from last week to understand user interactions.
To fetch this data, use the following settings in your reporting or visualization tool:
Setting | Value |
|---|---|
Query type | Advertiser: Statistics by day |
Date range | Last week |
Metrics | Clicks unique, Impressions |
Dimensions | Date |
Suggested visualization | Line chart or time series |
Understanding the data
Clicks unique: Shows the number of unique clicks.
Impressions: Shows the number of banner/link impressions.
More resources
You might also be interested in: