Connect AppNexus to Snowflake in 2023

appnexus Field Reference logo
+
snowflake

Stream all your 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. Snowflake Integration 1
  2. Create the WINDSOR_UPLOAD role (name has no importance) Snowflake Integration 2
  3. Create a user and add the previously created role to that user Snowflake Integration 3
  4. Grant rights to the DATABASE to the created user Snowflake Integration 4
  5. Grand the rights to the destination table Snowflake Integration 5
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form

 

  • Get the username Import Snowflake 1

 

  • Get the password Import Snowflake 2

 

  • Get the account Import Snowflake 3

 

  • Get the warehouse Import Snowflake 4

 

  • Get the database Import Snowflake 5

 

  • Get the schema Import Snowflake 6

 

  • Get the table name Import Snowflake 7

 

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
Snowflake connector

 

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.
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.
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.

Easily connect AppNexus to Snowflake

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