+
Stream marketing data from Adform to Snowflake
About Adform
About SnowFlake
Connect Adform to Snowflake in 2023
It is very simple to connect Adform to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- 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 Adform as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
4. Your data will now be streamed from Adform to Snowflake. In case there is an error you will be notified.
Adform metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Average Engagement Time | NUMERIC | This metric shows the average engagement time of visible banners. A banner is visible when at least X % of its area is visible in user's screen. X parameter is collected from Campaign Details page. Three timed events are considered during calculation - mouse-over time, video play time, and expansion time. Measurement is based on sampled data. |
| Average Viewability Time | NUMERIC | This metric shows the average amount of time that users actually saw a viewable banner in their screen. TIP: A viewable impression is defined in the Ad Viewability settings, visible in the Campaign Details. |
| Banner | TEXT | This dimension groups information by banner for Display campaigns, or by Adgroup for Search campaigns. Banner is an advertisement vehicle. The banner is displayed through different medias/publishers on different placements. Adgroup contains one or more keywords used in Search Engine campaigns. |
| Banner Attribute1 | TEXT | This dimension groups information by Banner Attribute 1. Banner attribute is a user-defined property of a banner. Banner Attribute 1 is usually assigned to the banner batch column in Banner Overview page. |
| Banner Size | TEXT | This dimension groups information by banner size. Banner size is shown as "width x height" in pixels, e.g. 300 x 250. |
| Banner Type | TEXT | This dimension groups information by creative material type. Most common banner types include Flash, Image, Rich Media, Link, Keyword and other. |
| Buy Type | TEXT | This dimension indicates the booking/buy types of the selected placement. Possible values - Impressions (CPM), Clicks (CPC), Viewable Impressions (vCPM), Days, Weeks, Months and Conversions. |
| Campaign | TEXT | This dimension shows and groups information by campaign. The campaign is the base item in Adform system, it contains media, placements, banners. |
| Campaign_ID | TEXT | This dimension groups data by Adform campaign ID. |
| Campaign Type | TEXT | This dimension groups information by campaign type. Campaign type can be assigned in Campaign Details page, possible values - Display, Affiliate, Email, Social Media and other. |
| Clicks | NUMERIC | This metric shows the number of clicks for the selected dimension. A click occurs when a user interacts with the advertisement by engaging a mouse button (usually the left) while the mouse pointer is hovering over the advertisement. |
| Clicks To Landing Page | PERCENT | This metric shows the percentage of clicks ending up as visits on the landing page for the selected dimension. |
| Clicks Cross Device | NUMERIC | This metric shows the number of times that users clicked on a banner and were directed to an advertiser's destination. When selecting uniqueness levels, a user is considered unique across all their devices and identifiers. TIP - User engagements with rich media banners, e.g., click on video play start button, are not taken into account. |
| Client | TEXT | Displays client/advertiser information. Used to group campaigns, in benchmarking reports etc. |
| Conversions | NUMERIC | A tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made. This metric shows the number of all Conversion pageviews displayed as a sum for all tracked conversion pages. |
| Conversions for all Campaign interactions only | NUMERIC | Display site tracking statistics for all Campaign ad interaction only |
| Conversions for all Non Campaign interactions only | NUMERIC | Display site tracking statistics for all Non Campaign ad interaction only |
| Conversions for Download Pages | NUMERIC | Display statistics for Download page category only |
| Conversions for Home Pages | NUMERIC | Display statistics for Home page category only |
| Conversions for Info Pages | NUMERIC | Display statistics for Info Pages page category only |
| Conversions for Landing Pages | NUMERIC | Display statistics for Landing Pages page category only |
| Conversions for None defined category of Pages | NUMERIC | Display statistics for None defined page category only |
| Conversions for post Click interactions only | NUMERIC | Display site tracking statistics for post Click ad interaction only |
| Conversions for post Impression interactions only | NUMERIC | Display site tracking statistics for post Impression ad interaction only |
| Conversions for Product Pages | NUMERIC | Display statistics for Product page category only |
| Conversions for recent Click interactions only | NUMERIC | Display site tracking statistics for recent Click ad interaction only |
| Conversions for recent Impression interactions only | NUMERIC | Display site tracking statistics for recent Impression ad interaction only |
| Conversions for Sign Up Pages | NUMERIC | Display statistics for Sign Up page category only |
| Conversions for Thank you Pages | NUMERIC | Display statistics for Thank you page category only |
| Conversions Type 1 | NUMERIC | |
| Conversions Type 2 | NUMERIC | |
| Conversions Type 3 | NUMERIC | |
| Conversions (all) | NUMERIC | A tracked page can be defined as a Conversion - usually a page where a sign-up is confirmed or a sale is made. This metric shows the number of all Conversion pageviews, displayed as a sum for all tracked conversion pages. It has predefined Uniqueness of 'No Repeat', which means that Conversion pageviews, generated by the same user within 15 minutes, are excluded. |
| Cost | NUMERIC | This metric shows the cost value for the selected dimension (usually on a media, placement (line item) level). Please check documentation for more details. |
| Cost By Sales | NUMERIC | This metric shows Cost value divided by Sales value. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign. Sales is a system variable and represents the returned value of a campaign. |
| Cost Non View | NUMERIC | This metric shows the cost value taking into account the percentage of non-viewable and undetermined impressions. TIP - Check documentation for more details. |
| Cost Post Click | NUMERIC | This metric shows the post click conversions cost. |
| Cost View | NUMERIC | This metric shows the cost value taking into account the percentage of viewable impressions. TIP - Check documentation for more details. |
| Country | COUNTRY | Geographical dimension, groups information by visitor's country e.g. Denmark, UK, USA, etc. |
| Cov | NUMERIC | This metric shows the conversion rate for the selected dimension. Calculated as conversions divided from clicks, in percent. |
| CTR | PERCENT | This metric shows click-through rate for the selected dimension. It is a percentage of users who have been exposed to an advertisement and then clicked. Calculated as clicks divided from impressions, in percent. |
| CTR Adjusted | PERCENT | This metric shows click-through rate for the selected dimension. It is a percentage of users who have been exposed to an advertisement and then clicked. Calculated as clicks divided from impressions, in percent. This metric considers all tag serving types such as Impressions, Invisible, Offile, etc. except for Clicks in order to assure consistent metric values. |
| CTR Unique | PERCENT | This metric shows unique click-through rate for the selected dimension. It is a percentage of unique users who have been exposed to an advertisement and then clicked. Calculated as campaign unique clicks divided from campaign impressions, in percent. |
| CTR View | PERCENT | This metric shows the percentage of impressions that resulted in a click, taking into account only those impressions that were actually in the users' screens. |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | This dimension groups information by date when a transaction happened. |
| Day of month | TEXT | Day of the month |
| Device type | TEXT | Technical dimension, groups data by device type, which can be - Desktop and Laptop, Small Screen Phone, Smart Phone, Tablet, Other Mobile, Media Hub, Console, TV, eReader, Smart Watch, Smart Speaker. It shows what share of traffic comes from different device types. |
| Effective Cost per Action | NUMERIC | This metric shows effective Cost per Conversion (ID Fusion) with the conversion pages listed as a sum. Here, the user may have interacted with the campaign and website on different devices. |
| Effective Cost per Click | NUMERIC | This metric shows cost per click for the selected dimension. Cost is either booked or accumulated cost for the selected dimension, or RTB Budget Spent in case of Real Time Bidding campaign. |
| Effective Cost per Thousand Impressions | NUMERIC | This metric shows cost per mille (thousand impressions) for the selected dimension. TIP: to report on eCPM (Reach) metric set Uniqueness as “Campaign Unique” and Cost type as “RTB” in metric settings. |
| Engagements | NUMERIC | This metric shows the count of user interactions with a banner. User interactions are tracked as user-initiated banner events for Rich Media, Flash and Image banner types. Examples of user-initiated banner events are mouse-over (only if > 1 sec.), video play button press, close button press, etc. Not user-initiated banner events are not included into this metric, except for auto-expand event. Examples of not user-initiated banner event are Floating Banner Shown, 25% of Video Play, etc. |
| EngagingImpressions | NUMERIC | This metric shows the sum of impressions, where at least one engagement occurred during each impression. Engagements are tracked as user-initiated banner events for Rich Media, Flash and Image banner types. Examples of user-initiated banner events are mouse-over (only if > 1 sec.), video play button press, close button press, etc. |
| Event | TEXT | This dimension groups information by banner event name. Banner events can be implemented in flash banners in order to track user interactions with banners, such as expands, clicks on play button, etc. |
| Events | NUMERIC | This metric shows how many times an event has been invoked in a banner. Events can be implemented in flash banners in order to track user interactions with banners, such as expands, clicks on play button, etc. Tip - use with dimension Event Name if several different events are implemented. |
| Hour | TEXT | Time dimension, groups information by hour of the day (values from 0 to 23). |
| Impressions | NUMERIC | This metric shows the number of tracked ads (formerly known as impressions) and includes both rendered and served-but-not-rendered ads. Both client-initiated and server-initiated measurement is taken into account. Only client-initiated measurement is compliant with Media Rating Council (MRC) guidelines. |
| LineItem | TEXT | This dimension groups information by Line Item. Line Item is an advertisement spot on a media/publisher. |
| Line Item End Date | DATE | This dimension displays Line Item end date collected from Mediaplan scheduler. |
| Line Item ID | TEXT | This dimension groups data by Adform Line Item ID. |
| Line Item Label 01 | TEXT | This dimension groups data by Line Item Label 01 |
| Line Item Label 1 | TEXT | This dimension groups data by Line Item Label 10 |
| Line Item Label 11 | TEXT | This dimension groups data by Line Item Label 11 |
| Line Item Label 12 | TEXT | This dimension groups data by Line Item Label 12 |
| Line Item Label 13 | TEXT | This dimension groups data by Line Item Label 13 |
| Line Item Label 14 | TEXT | This dimension groups data by Line Item Label 14 |
| Line Item Label 15 | TEXT | This dimension groups data by Line Item Label 15 |
| Line Item Label 16 | TEXT | This dimension groups data by Line Item Label 16 |
| Line Item Label 17 | TEXT | This dimension groups data by Line Item Label 17 |
| Line Item Label 18 | TEXT | This dimension groups data by Line Item Label 18 |
| Line Item Label 19 | TEXT | This dimension groups data by Line Item Label 19 |
| Line Item Label 02 | TEXT | This dimension groups data by Line Item Label 02 |
| Line Item Label 20 | TEXT | This dimension groups data by Line Item Label 20 |
| Line Item Label 03 | TEXT | This dimension groups data by Line Item Label 03 |
| Line Item Label 04 | TEXT | This dimension groups data by Line Item Label 04 |
| Line Item Label 05 | TEXT | This dimension groups data by Line Item Label 05 |
| Line Item Label 06 | TEXT | This dimension groups data by Line Item Label 06 |
| Line Item Label 07 | TEXT | This dimension groups data by Line Item Label 07 |
| Line Item Label 08 | TEXT | This dimension groups data by Line Item Label 08 |
| Line Item Label 09 | TEXT | This dimension groups data by Line Item Label 09 |
| Line Item Start Date | DATE | This dimension displays Line Item start date collected from Mediaplan scheduler. |
| Measurable Impressions | NUMERIC | This metric shows the part of measured impressions that were actually in the users' screens, calculated as the percentage of viewable impressions in relation to measurable impressions |
| Media | TEXT | Media/publisher is the provider of online advertising space, such as an online newspaper, social network site or other. |
| Month | TEXT | Number of the month |
| Media Plan Amount | NUMERIC | This metric shows the spent amount visible in the Mediaplan. It can be set to show gross amount or net amount. Could be used to report on the cost and fee breakdown of a campaign. |
| Media Plan Net Amount | NUMERIC | This metric shows the net spent amount visible in the Mediaplan. |
| Total Pageviews | NUMERIC | This metric shows the number of all tracked pages (tracking points) pageviews, displayed as a sum for all tracked pages. |
| ROI | PERCENT | This metric shows the return of investment. A positive value corresponds to capital growth, a negative value corresponds to capital decay, and a value of 0% corresponds to no change. It is calculated as (Sales - Cost) / Cost * 100%, or as (Sales - RTB Budget Spent) / RTB Budget Spent * 100% in case of Real Time Bidding campaign. |
| Rtb Domain | TEXT | This dimension groups data by RTB domain. RTB domains show 2nd level URLs of publisher sites (e.g. cnn.com), where a banner was displayed when impression was registered. RTB domain values are tracked and sent to Adform by AdExchanges. |
| Rtb Inventory Source | TEXT | Groups information by RTB Inventory Source. Inventory source is an ad exchange, which can be selected for running a Real Time Bidding campaign, e.g. Admeld, Microsoft Ad Exchange, etc. |
| Real-Time Bidding Bids | NUMERIC | This metric shows the number of offers done by Adform in attempt to win an impression on an ad exchange auction. |
| Real-Time Bidding Win Rate | PERCENT | This metric shows the proportion of impressions (won bids) in total number of bids (attempts to win an impression). Calculated as Impressions / Bids in %. |
| Sales | NUMERIC | This metric shows the sales value collected from all visits on tracked pages and is an Order level variable. Collected only if variable is implemented in Tracking points. It has predefined Uniqueness of 'No Repeat', which means that sales value form pageviews, generated by the same user within 15 minutes, are excluded. |
| Total Sales | NUMERIC | This metric shows the sales value collected from all visits on tracked pages. Collected only if variable is implemented in Tracking points. |
| Source | TEXT | The name of the Windsor connector returning the row |
| Tag | TEXT | Tag is a small piece of code used to track online advertisements. This dimension groups information in relations to tags, it could be used to show rotators information. |
| Today | DATE | Today's date |
| Total Cost | NUMERIC | This metric shows the cost value for the selected dimension (usually on a media, placement (line item) level). Please check documentation for more details. (Duplicate) |
| Unique Impressions Percent | PERCENT | This metric shows the percentage of unique tracked ads(formerly known as impressions) in relation to all registered tracked ads |
| Video views 100 | NUMERIC | This metric shows 100% of the interactions with video banners,where banner events are implemented. Interactions such as Play, Pause, Stop, Sound On,and others can be reported |
| Video views 25 | NUMERIC | This metric shows at least 25% of the interactions with video banners,where banner events are implemented. Interactions such as Play, Pause, Stop, Sound On,and others can be reported |
| Video views 50 | NUMERIC | This metric shows at least 50% of the interactions with video banners,where banner events are implemented. Interactions such as Play, Pause, Stop, Sound On,and others can be reported |
| Video views 75 | NUMERIC | This metric shows at least 75% of the interactions with video banners,where banner events are implemented. Interactions such as Play, Pause, Stop, Sound On,and others can be reported |
| Viewable Impressions | NUMERIC | This metric shows the number of eligible impressions that were actually in the users' screens. According to IAB standards, an impression is counted as viewable when at least 50 % of the banner area is visible in the user's screen for at least 1 second; at least 30% of the large (greater than 242,000 pixels) banner area is visible in the user's screen for at least 1 second; at least 50% of the in-stream video is visible in the user's screen for at least 2 seconds. This metric is accredited by Media Rating Council (MRC) only when reported together with 'Ad Creative Type' dimension. |
| Visitors | NUMERIC | Shows the number of unique visitors in advertiser's website for the selected tracking setup. |
| Visits | NUMERIC | Shows the number of visits in advertiser's website for the selected tracking setup. |
| Week | TEXT | Week (Sun-Sat). |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | Year |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
Easily connect Adform to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ 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.