Connect AppNexus to Snowflake in 2023

appnexus Field Reference logo
+
snowflake

Stream all data from AppNexus to Snowflake

Connect AppNexus to Snowflake in 2023

It is very simple to connect AppNexus to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. 
  2. Create the WINDSOR_UPLOAD role (name has no importance) 
  3. Create a user and add the previously created role to that user 
  4. Grant rights to the DATABASE to the created user 
  5. Grand the rights to the destination table 
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
  • Get the username 
  • Get the password 
  • Get the account 
  • Get the warehouse 
  • Get the database 
  • Get the schema 
  • Get the table name 

 

Second step

1.You need to select AppNexus as a Data Source and Grant Access to Windsor.ai.

Appnexus Windsor.ai Onboarding Screen

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save

4. Your data will now be streamed from AppNexus to Snowflake. In case there is an error you will be notified.

AppNexus metrics and dimensions available for streaming into Snowflake

Connect your data

 

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 AppNexus to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 70+ 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 AppNexus and Snowflake Integrations