Connect AppNexus to Looker Studio

Directly connect AppNexus to Looker Studio,in minutes, and in an easy-to-use format.

appnexus google data studio integration

Analyze Your Marketing Metrics from AppNexus in GDS

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:

How to connect AppNexus to Looker Studio?

Do you plan to connect and visualize your AppNexus 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.select fields on the right

Go to “Select Destination” and choose Looker Studio.

select looker studio

Once done, select “connect” and authorize access to your data source.

Windsor.ai Appnexus Google Data Studio connector

 

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

nametypedescription
Account IDTEXTThe Account ID
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 ratePERCENTThe 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.
Data SourceTEXTThe name of the Windsor connector returning the row
DateDATEThe Date
Day of monthTEXTDay of the month
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.
MonthTEXTNumber of the month
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.
SourceTEXTThe name of the Windsor connector returning the row
SpendNUMERICThe Media Spend
Spend for advertiserNUMERICThe total amount spent by the advertiser in the advertiser's preferred currency.
Type of appTEXTThe type of inventory.
TodayDATEToday's date
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.
Video CompletionsNUMERICThe total number of times the video creatives played for the entire duration.
Viewable impressionsNUMERICThe number of measured impressions that were viewable
Viewability ratePERCENTThe percentage of impressions that were viewable out of the total number of impressions.
View measured impressionsNUMERICThe total number of impressions that were measured for viewability.
View measuremen ratePERCENTThe percentage of impressions measured for viewability out of the total number of impressions.
WeekTEXTWeek (Sun-Sat).
Day of week and day numberTEXTWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
Day of week and day number, ISOTEXTWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
Week ISOTEXTWeek, ISO format (Mon-Sun).
YearTEXTYear
YearmonthTEXTYear and month, e.g. 2024|3
Year of weekTEXTThe year that contains first day of the week (Sun-Sat).
Year of week, ISOTEXTThe year that contains first day of the ISO week (Mon-Sun).
Year weekTEXTYear and week for US weeks (Sun-Sat), e.g. 2024|15
Year week ISOTEXTYear and week for ISO weeks (Mon-Sun), e.g. 2024|20

Easily connect Xandr (AppNexus) to Looker Studio

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Xandr (AppNexus) and Google Data Studio Integrations