---
title: "Adtraction report building guide"
slug: "adtraction-report-building-guide"
description: "Get affiliate marketing metrics with the Adtraction data source connector. Analyze clicks, transactions, and create detailed reports by segments and channels."
updated: 2026-03-25T15:39:10Z
published: 2026-03-26T09:08:19Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Adtraction report building guide

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](/v1/docs/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](/v1/docs/adtraction-fields).

## 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, Data 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:

- [Supermetrics report template gallery](https://supermetrics.com/template-gallery)
- [Adtraction metrics and dimensions](/v1/docs/adtraction-fields)