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.

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

Costs carry the wrong currency code

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.

Campaign names look like insertion orders

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