> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/xandr.md).

# Xandr

How to connect Xandr to Roivenue, what the default setup downloads, and how the figures are put together.

Xandr Invest is Microsoft's programmatic buying platform. The Roivenue connector downloads daily impressions, clicks and spend per line item, plus attributed conversions and revenue.

## Setting up the connector

Add a Xandr connector in Roivenue and sign in with your Xandr username and password.

### Setup options

| Option                    | Default    | What it does                                                          |
| ------------------------- | ---------- | --------------------------------------------------------------------- |
| Currency                  | none       | The currency Xandr figures are stamped with.                          |
| Conversion type name      | `purchase` | What Xandr conversions are called inside Roivenue.                    |
| Web source and Web medium | blank      | The UTM source and medium that Xandr traffic should be recognised as. |

## What the default setup downloads

Three jobs. One brings impressions, clicks and spend per line item and day, a second brings conversions and attributed revenue, and a third downloads the hourly feed behind synthetic impressions.

### Where the values land

| Xandr field            | Roivenue column |
| ---------------------- | --------------- |
| `insertion_order_name` | adCampaign      |
| `line_item_name`       | adGroup         |
| `imps`                 | impressions     |
| `clicks`               | clicks          |
| `spend_adv_curr`       | cost            |
| `total_convs`          | conversions     |
| `attributed_revenue`   | conversionValue |

Xandr's insertion order becomes the campaign in Roivenue and the line item becomes the ad group.

Spend arrives in the advertiser's currency, and the currency code is whatever was chosen at setup rather than read from the platform, so the two need to agree.

The jobs reprocess the last three days on every run.

## Available columns

The table above is what the recommended template downloads. Every column this connector can bring back is listed on [Xandr - Supported Columns](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/xandr/xandr-supported-columns.md).

Adding one means editing the connector in the Advanced Editor, which stops that connector receiving template updates.

## How far back the data goes

The connector will request up to three years of history. How much arrives depends on what the platform holds for the account.

## Troubleshooting

<details>

<summary>Costs carry the wrong currency code</summary>

The currency is fixed at setup and stamped onto every row. Xandr reports spend in the advertiser currency, so if the wrong code was chosen the figures are right but labelled wrongly.

</details>

<details>

<summary>Campaign names look like insertion orders</summary>

That is expected. Xandr calls a campaign an insertion order, and that name is what lands in the campaign field.

</details>