Connect AppNexus to Looker Studio
Directly connect AppNexus to Looker Studio,in minutes, and in an easy-to-use format.
Analyze Your Marketing Metrics from AppNexus in GDS
About AppNexus
About Looker Studio
Why integrate AppNexus with Looker 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 Looker Studio Connector
The AppNexus Looker Studio Connector pulls metrics and dimensions for AppNexus. The Insights are retrieved at the campaign and ad levels.
Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- A AppNexus advertiser account (Visit our privacy policy and terms of use)
- Google account for AppNexus to Looker Studio integration.
- A Windsor account. Start your free trial now.
How to connect Google Ads to Looker Studio?
Do you plan to connect and visualize your Google Ads in Looker Studio? Follow the Tutorial Below:
Select the fields on the right to later use in your data source. For example, you can include metrics such as Cost per Click, Cost per Action or Total Spend. Go to “Select Destination” and choose Google Data Studio. Once done, select “connect” and authorize access to your data source. 
Google Data Studio Templates for AppNexus
These free and customizable Looker Studio AppNexus templates will assist you in visualizing your data for easy reporting and analysis.
AppNexus metrics & dimensions available for streaming into Google Data Studio
name type description Account ID TEXT The Account ID Advertiser name TEXT The unique identification number for each advertiser. Advertiser id TEXT The unique identification number for each advertiser. Campaign TEXT The Campaign Name Campaign ID TEXT The Campaign ID Clicks NUMERIC The Number of Clicks Video completion rate PERCENT The ratio of video completions to impressions, expressed as a percentage. Conversion rate PERCENT The rate of conversions to impressions. cpa NUMERIC The cost per acquisition. cpc NUMERIC The cost per click. cpm NUMERIC The cost per 1,000 impressions. Creative ID TEXT The unique identification number of the creative. Creative media URL TEXT The URL of the creative - can be image, flash, HTML, javascript (see format). Creative name TEXT The display name of the creative. Ctr PERCENT The rate of clicks to impressions. Date DATE The Date Deal name TEXT The name of the deal. Ecpa NUMERIC The effective advertiser spend per conversion/acquisition. Ecpc NUMERIC The effective advertiser spend per click. Ecpm NUMERIC The effective advertiser spend per 1000 impressions. Gender TEXT The gender of the user. For impressions older than 100 days, the gender will be 'u'. Impressions NUMERIC The Number of Impressions Served Insertion order TEXT The name of the insertion order. Insertion order ID TEXT The unique identification number of the insertion order. Insertion order name TEXT The name of the insertion order. Line item name TEXT The name of the line item. Line item start DATE The date and time when the non-seamless line item should stop serving. This value reflects the Advertiser's time zone. Line item ID TEXT The unique identification number of the line item. Line item start DATE The date and time when the non-seamless line item should start serving. This value reflects the Advertiser's time zone. Media cost NUMERIC The total amount spent to purchase all impressions. Pixel ID NUMERIC The ID of the conversion pixel. Pixel Name TEXT The name of the conversion pixel. Placement ID TEXT Placement ID Placement Name TEXT The name of the placement Post Click or Post View Conversion TEXT The 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 Revenue NUMERIC The revenue optionally passed in the conversion pixel using the 'value' parameter. Spend NUMERIC The Media Spend Spend for advertiser NUMERIC The total amount spent by the advertiser in the advertiser's preferred currency. Type of app TEXT The type of inventory. Total conversions NUMERIC The total number of post view and post click conversions. Total conversion NUMERIC The total number of post view and post click conversions. Total Cost NUMERIC The Media Spend (Duplicate) Total revenue NUMERIC The total amount of post view and post click revenue. Video Completions NUMERIC The total number of times the video creatives played for the entire duration. Viewable impressions NUMERIC The number of measured impressions that were viewable Viewability rate PERCENT The percentage of impressions that were viewable out of the total number of impressions. View measured impressions NUMERIC The total number of impressions that were measured for viewability. View measuremen rate PERCENT The percentage of impressions measured for viewability out of the total number of impressions.
Easily connect Xandr (AppNexus) to Looker Studio
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.