# Awin Data Connector User Guide

> **Note:** Awin is a global affiliate marketing network that connects advertisers with publishers to drive commission-based sales. This guide will walk you through setting up the Awin data connector in Power My Analytics, creating reports in Data Studio, and understanding the transaction, publisher, and creative data Awin provides.

> **Note:** **Awin is a Beta connector.** It is available in every Hub and appears in your Hub's source gallery with a **BETA** label. While it is in Beta, some fields and behavior may still change as we continue to improve it.

## Prerequisites

Before you begin, ensure you have:

- An active Awin advertiser account
- An **OAuth2 API access token** generated in your Awin account
- A user role with permission to generate API tokens
- The region of your Awin program (shown on your Awin program profile page) and the timezone your Awin account reports in

> **Note:** Power My Analytics reports on Awin advertiser accounts. If your token can reach only publisher accounts, there are no accounts to select. Your API token is shown only once when you create it, so copy it right away.

## Adding Awin as a Data Source

1. In your Awin account, open your profile, go to **Account**, select the **API credentials** tab, and create a new token. Copy it right away, since it is shown only once. You can also contact your Awin account manager to obtain your OAuth2 token.
2. Navigate to your Power My Analytics hub and select **Sources** from the menu.
3. Click **\+ Add new source** and choose Awin from the gallery.
4. Enter your **API Token**.
5. Enter a name for your Awin account and click **Connect**.
6. In the **Confirm AWIN Account Settings** step, choose the **Region** and **Timezone** for each Awin advertiser account (the timezone is preselected from the region), then click **Save and continue**. You can fill in only the accounts you know, or click **Skip for now**.
7. Select the Awin accounts you want to sync.

Accounts with a saved region and timezone are stored in Power My Analytics: they are backfilled 90 days when first added and then kept current by the daily Data Sync. Accounts you skip show **Live** in **Sources** and pull their data straight from Awin each time a report loads, until you save their region and timezone.

For step-by-step connection instructions, see [How to Connect to Awin](https://knowledge.powermyanalytics.com/application/sources/how-to-connect-to-awin/).

## Changing Region and Timezone

1. In your Power My Analytics hub, select **Sources** from the menu.
2. Click the three dots beside your Awin source to open the **Action** menu, and select **Edit region and timezone**.
3. Set the **Region** and **Timezone** for each account and click **Save changes**.

Saving pulls the data again for any account you change, back to the earliest date stored (at least 90 days). A timezone change refreshes all three report tables; a region change refreshes only Creatives. Awin's rate limit makes this take a while, but it runs in the background.

> **Note:** Region and timezone settings belong to the Awin login and are shared by every Hub that uses it. A Hub can change an account's settings only if it syncs that account, or if no Hub syncs it. Otherwise the account is read-only in your Hub, and someone in a Hub that syncs it needs to make the change.

## Creating a Data Studio Report

Follow these steps to create a Data Studio report using your Awin data:

1. In the PMA hub, navigate to **Reports > Data Studio**.
2. Select Awin under Create Data Studio Report (this will open the official Data Studio application in a new window).

    - Name your data source (e.g., "Awin - Organization Name").
    - **Power My Analytics Hub:** Choose your PMA hub from the dropdown.
    - **User Account:** Select your PMA user account.
    - **Accounts:** Select the Awin account you want to report on (for example, "Power My Analytics (advertiser)").
    - **Region:** Defaults to GB. Used only for accounts without a saved region and timezone; select the region of your Awin program.
    - **Timezone:** Defaults to UTC. Used only for accounts without a saved region and timezone; select the timezone you report in.
    - Optional: Check **Allow to be modified in reports** beside Accounts, Region, or Timezone to let report editors change them inside Data Studio.
    - Optional: Leave "Use report template for new reports" checked to use the PMA report template.
    - Click **Connect** (top right) to complete the data source configuration.
    - Click **Create Report** (top right).

> **Note:** Accounts that sync use the region and timezone saved in your Hub. The **Region** and **Timezone** fields here apply only to accounts that are still live: set them to match your Awin account, or your report can show mismatched or empty data.

## Key Reports and Fields

The Awin connector provides three report tables: **Transactions** (one row per individual sale, lead, or other commissionable event), **Publishers** (aggregated publisher performance), and **Creatives** (aggregated performance for banners, links, and other promotional assets). Some popular metrics include:

- **Transaction Detail Metrics:** Sale Amount, Commission Amount, Advertiser Cost, and Network Fee by Transaction ID, Order Ref, Commission Status, Type, Campaign, Voucher Code, and Customer Country
- **Publisher Performance Metrics:** Clicks, Impressions, Total Value, and Total Comm by Publisher Name and Publisher ID; Pending, Confirmed, Declined, and Bonus transaction counts, values, and commissions by Publisher Name
- **Creative Performance Metrics:** Clicks, Impressions, Confirmed Value, and Confirmed Comm by Creative Name, Creative ID, and Tag Name
- **Commission Status Metrics:** Pending Comm, Confirmed Comm, Declined Comm, and Bonus Comm by Date and Publisher Name, to watch commissions mature from pending to confirmed
- **Device and Attribution Metrics:** Sale Amount and Commission Amount by Click Device, Transaction Device, Customer Country, and Voucher Code

For a complete list of available Awin fields, refer to the [Schema Explorer](https://hub.powermyanalytics.com/resources/schema/awin).

> **Note:** When building a "cost" or "spend" column, use **Advertiser Cost**. This is the total cost the advertiser incurs for a transaction, and it already includes the publisher commission plus the Awin network fee. Adding Commission Amount and Network Fee to it would double-count your costs.

## Limitations and Important Considerations

- **Synced once region and timezone are saved:** Once an account's region and timezone are saved in your Hub, it is stored in the Power My Analytics warehouse, backfilled 90 days, and kept current by the daily Data Sync. Use **Backfill data range** in **Sources** for older dates. Until its settings are saved, an account is live: each report pulls data straight from the Awin API, with no stored history and no backfill.
- **Region and Timezone:** Awin's API needs a region and timezone that cannot be read from your account. Timezone affects all three report tables; Region affects only Creatives. Accounts without saved settings use the Data Studio **Region** and **Timezone** fields, which default to GB and UTC, so set them to match your Awin account or your reports can return mismatched or empty data.
- **API rate:** Awin caps requests at 20 API calls per minute per user. Reports on synced accounts read stored data and call Awin only for dates not stored yet, such as today. A live report that needs many calls at once (several accounts, or a long date range) can reach the limit, and the request then fails instead of returning data.
- **Transaction status maturation:** Transactions move from pending to confirmed or declined as Awin validates them, so confirmed revenue and commission for recent dates keep changing until they settle. This is expected behavior, not a data error. The daily Data Sync refreshes the last 7 days, so a change Awin makes to an older transaction appears after a backfill.
- **Advertiser accounts only:** Power My Analytics reports on Awin advertiser accounts; the Publishers table is the advertiser's view of publisher performance. Publisher accounts are not listed.
- **Daily trends for Publishers and Creatives:** For synced accounts, these tables are stored one day at a time, so they show a daily trend. For live accounts, they return one total for the date range, dated with the range start date.
- **Amended transactions:** When Awin amends a transaction, the Amended field is set to 1 and the previous values are preserved in Old Sale Amount and Old Commission Amount, alongside the Amend Date and Amend Reason.
- **Currency fields:** Monetary fields have companion currency-code dimensions (such as Sale Currency and Commission Currency). If your account spans multiple currencies, group or filter by the currency dimension before totaling monetary metrics.
- **Beta connector:** While Awin is in Beta, fields, configuration options, and behavior may change. If a field is renamed or removed, you may need to update the reports that use it.

### Unavailable Data

The following Awin data is not available through Awin's standard reporting API and therefore is not available in Power My Analytics:

- Basket or product-level line items (the individual products within a transaction)
- Creative attribution on individual transactions (creative performance is available as aggregates in the Creatives table, but the Transactions table does not include a creative dimension)
- Transaction validation actions (approving or declining transactions is an action performed in Awin; PMA reporting is read-only)

If there are additional Awin fields or reports you would like to see in Power My Analytics, please [submit a ticket](https://knowledge.powermyanalytics.com/support/submit-a-ticket/) with screenshots of the reports you would like to build.

## Troubleshooting

- **Invalid or expired API token:** The connection returns an authorization error. Regenerate the token in your Awin account (profile > **Account** > **API credentials**) and reconnect the source.
- **No accounts to select, or no data returned:** Power My Analytics lists only Awin advertiser accounts, so a token that reaches only publisher accounts has nothing to select. Connect with a token for an Awin advertiser account. If accounts are listed but return no data, check their region and timezone.
- **Totals do not match the Awin UI:** Usually a Region or Timezone difference. For synced accounts, correct them with **Edit region and timezone** in **Sources**; for live accounts, set them in the Data Studio configuration. Then compare over the same date range.
- **Pending versus confirmed differences:** Recent transaction, revenue, and commission figures can look lower than expected because they are still maturing. This is expected, not a fault, and confirmed values settle over Awin's validation window.
- **Rate limit reached:** A live report that needs many calls at once can reach Awin's 20 calls per minute limit, and the request fails. Retry with fewer accounts or a shorter date range, or save the accounts' region and timezone so they sync.
- **An account shows Live in Sources:** Its region and timezone have not been saved yet. Save them with **Edit region and timezone** so the account syncs.
- **Can't change an account's region and timezone:** The settings are shared by every Hub that uses the same Awin login, and only a Hub that syncs the account can change them (or any Hub, if none syncs it). Sync the account in your Hub, or ask someone in a Hub that syncs it to make the change.

See our article [Basic Troubleshooting](https://knowledge.powermyanalytics.com/application/troubleshooting/basic-troubleshooting/) for information on general issues that may affect the Awin connector.
