Connect Xandr (AppNexus) to Google Data Studio

Directly connect Xandr (AppNexus) to Google Data Studio, in minutes, and in an easy-to-use format.

data integration

All your marketing data in one place, just in a few clicks.

In just a few clicks, integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Data Automation
data warehouse

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

About Xandr

Xandr, formerly known as AppNexus, offers a cloud-based digital media platform that allows one to buy and sell advertising. Advertisers can buy display and video advertisements based on user demography, time of day, and many more parameters. Publishers can sell their inventory with the same techniques. It offers a range of tools and services for managing digital advertising campaigns, including ad serving, targeting, and measurement. Xandr is a part of Microsoft Advertising.


Learn more about Xandr

About Google Data Studio

Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.


Learn more about Google Data Studio

Why integrate Xandr (AppNexus) with Google Data Studio?

  • Google Data Studio enables you to connect all of your marketing data in one place rather than manually compiling data from various sources, saving time and reducing the risk of errors. You can create reports and dashboards that reflect your overall marketing effort by integrating AppNexus data with other marketing data sources.


  • Using Google Data Studio’s powerful visualization capabilities, you will be able to see details about your traffic and conversions that you would not have previously been able to see, allowing you to identify trends and patterns in your advertising performance and make more informed decisions about your advertising strategy.


  • Google Data Studio allows you to create highly customizable reports which can be tailored to your specific needs and preferences such as monitoring the real-time performance of ads. Ad performance tracking in real-time can help you understand what is and isn’t working, and make adjustments as needed to optimize performance for maximum results.


  • Integrating AppNexus data with Google Data Studio can help improve collaboration by providing a shared platform for analyzing and discussing data, and by making it easier for team members (particularly useful for companies with distributed teams) to work together on reports and make data-driven decisions.

About the AppNexus Google Data Studio Connector

The Xandr (AppNexus) Google Data Studio Connector pulls Metrics and Dimensions for Appnexus Ads. The insights are retrieved at the campaign or ad level.

Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.


To set up the connector, the user should have:

How to connect Xandr (AppNexus) to Google Data Studio?

Select the fields on the right to later use in your data source. For example, you can include metrics such as Placement Name, Spend, or Total Revenue.

select fields on the right

Go to “Select Destination” and choose Google Data Studio.

Once done, select “connect” and authorize access to your data source. Appnexus Google Data Studio connector All your marketing data in one place

Power up your marketing performance with result-driven marketing solutions

  • Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
  • The setup is done in minutes. No coding is required.
  • Currently, we support more than 3000 dimensions and metrics.
  • See the value and return on every marketing touchpoint.
  • Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.

Google Data Studio Templates for AppNexus

Do you plan to connect and visualize AppNexus in Google Data Studio?

These free and customizable Google Data Studio AppNexus templates will assist you in visualizing your data for easy reporting and analysis.

Google Data Studio Tutorials for AppNexus

Would you like to take your Google Data Studio AppNexus dashboards to the next level?

Here are some of our favorite tutorials to help you:

Available Xandr (AppNexus) Metrics and Dimensions

Advertiser nameTEXTThe unique identification number for each advertiser.
Advertiser idTEXTThe unique identification number for each advertiser.
CampaignTEXTThe Campaign Name
Campaign IDTEXTThe Campaign ID
ClicksNUMERICThe Number of Clicks
Video completion rateNUMERICThe ratio of video completions to impressions, expressed as a percentage.
Conversion ratePERCENTThe rate of conversions to impressions.
cpaNUMERICThe cost per acquisition.
cpcNUMERICThe cost per click.
cpmNUMERICThe cost per 1,000 impressions.
Creative IDTEXTThe unique identification number of the creative.
Creative media URLTEXTThe URL of the creative - can be image, flash, HTML, javascript (see format).
Creative nameTEXTThe display name of the creative.
CtrPERCENTThe rate of clicks to impressions.
DateDATEThe Date
Deal nameTEXTThe name of the deal.
EcpaNUMERICThe effective advertiser spend per conversion/acquisition.
EcpcNUMERICThe effective advertiser spend per click.
EcpmNUMERICThe effective advertiser spend per 1000 impressions.
GenderTEXTThe gender of the user. For impressions older than 100 days, the gender will be 'u'.
ImpressionsNUMERICThe Number of Impressions Served
Insertion orderTEXTThe name of the insertion order.
Insertion order IDTEXTThe unique identification number of the insertion order.
Insertion order nameTEXTThe name of the insertion order.
Line item nameTEXTThe name of the line item.
Line item startDATEThe date and time when the non-seamless line item should stop serving. This value reflects the Advertiser's time zone.
Line item IDTEXTThe unique identification number of the line item.
Line item startDATEThe date and time when the non-seamless line item should start serving. This value reflects the Advertiser's time zone.
Media costNUMERICThe total amount spent to purchase all impressions.
Pixel IDNUMERICThe ID of the conversion pixel.
Pixel NameTEXTThe name of the conversion pixel.
Placement IDTEXTPlacement ID
Placement NameTEXTThe name of the placement
Post Click or Post View ConversionTEXTThe type of conversion. If 'Post Click', the conversion is attributed to a user clicking a creative.If 'Post View', the conversion is attributed to a user viewing a creative..
Post Click or Post View RevenueNUMERICThe revenue optionally passed in the conversion pixel using the 'value' parameter.
SpendNUMERICThe Media Spend
Spend for advertiserNUMERICThe total amount spent by the advertiser in the advertiser's preferred currency.
Type of appTEXTThe type of inventory.
Total conversionsNUMERICThe total number of post view and post click conversions.
Total conversionNUMERICThe total number of post view and post click conversions.
Total CostNUMERICThe Media Spend (Duplicate)
Total revenueNUMERICThe total amount of post view and post click revenue.
Viewable impressionsNUMERICThe number of measured impressions that were viewable
Viewability rateNUMERICThe percentage of impressions that were viewable out of the total number of impressions.
View measuremen rateNUMERICThe percentage of impressions measured for viewability out of the total number of impressions.