+
Stream marketing data from Teads to Snowflake
About Teads
About Teads
Connect Teads to Snowflake in 2023
It is very simple to connect Teads 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 Teads 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 Teads to Snowflake. In case there is an error you will be notified.
Teads metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Campaign ID | TEXT | Teads id of the campaign |
| Seat id | TEXT | Teads Ad Manager Seat id |
| Seat name | TEXT | Teads Ad Manager Seat name |
| Billable impressions | NUMERIC | Number of results delivered |
| Advertiser ID | TEXT | Teads id of the advertiser |
| Advertiser | TEXT | Name of the advertiser |
| Auction has billable | TEXT | Auction has billable - TRUE if the impression was billed, FALSE otherwise. Computing if an event (impression, click, etc) was tracked as part of a billable session is based on a 30 minute window and could contain false negatives, when an event is part of a billable session but was tracked in a different time window. There are no false positives. |
| Browser | TEXT | Name of browser |
| Browser version | TEXT | Version of browser |
| Budget delivered Total Ad Cost - Cost per result | NUMERIC | Average price of each result, based on the budget_delivered_advertising. This is the cost per result considering only the advertising cost. |
| Budget delivered Total Ad Cost - CPC | NUMERIC | Average price of a click, based on the budget_delivered_advertising. This is the CPC value considering only the advertising cost. |
| Budget delivered Total Ad Cost - CPM | NUMERIC | Average price of a thousand impressions (display) or starts (video), based on the budget_delivered_advertising. This is the CPM value considering only the advertising cost. |
| Budget delivered Total Ad Cost | NUMERIC | Advertising value (media & data) delivered by Teads. Includes Added Value budget. Does not include Ad Manager fee nor Agency fee. |
| Budget delivered Agency Fee | NUMERIC | Agency fee. Not invoiced by Teads. |
| Budget delivered - Cost per result | NUMERIC | Average price of each result, based on the budget_delivered. This is the cost per result paid by the advertiser, including advertising cost, Ad Manager fee and Agency fee. |
| Budget delivered - CPC | NUMERIC | Average price of a click, based on the budget_delivered. This is the CPC value paid by the Advertiser, including advertising cost, Ad Manager fee and Agency fee. |
| Budget delivered - CPM | NUMERIC | Average price of a thousand impressions (display) or starts (video), based on the budget_delivered. This is the CPM value paid by the advertiser, including advertising cost, Ad Manager fee and Agency fee. |
| Budget delivered Fee | NUMERIC | Ad Manager fee |
| Budget delivered Teads - Cost per result | NUMERIC | Average price of each result, based on the budget_delivered_teads. This is the cost per result delivered by Teads, including advertising cost and Ad Manager fee. |
| Budget delivered Teads - CPC | NUMERIC | Average price of a click, based on the budget_delivered_teads. This is the CPC value delivered by Teads, including advertising cost and Ad Manager fee. |
| Budget delivered Teads - CPM | NUMERIC | Average price of a thousand impressions (display) or starts (video), based on the budget_delivered_teads. This is the CPM value delivered by Teads, including advertising cost and Ad Manager fee. |
| Budget delivered Teads | NUMERIC | Total value delivered by Teads. Includes Added Value budget and Ad Manager fee. Does not include Agency fee. |
| Budget delivered | NUMERIC | Advertiser budget consumed. Includes Added Value budget, Ad Manager fee and Agency fee. |
| Campaign IO budget | TEXT | Total budget of the campaign |
| Campaign Name | TEXT | Name of the campaign |
| Clickthrough rate | PERCENT | Clickthrough rate |
| Clicks | NUMERIC | Clicks |
| Country code | COUNTRY | Country code of the user - ISO 3166-1 alpha-2 format, ex: US, FR |
| Country name | COUNTRY | Country name of the user |
| Creative external integration code | TEXT | Code for integrating with another reporting system |
| Creative ID | TEXT | Teads id of the creative |
| Creative name | TEXT | Name of the creative |
| Creative size | TEXT | Creative size. Possible values: landscape, square, vertical, social. |
| Creative type | TEXT | Creative type (Carousel, Scroller, etc) |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | Alias for Day but in %Y-%m-%d format. |
| Day | TEXT | Day for the data |
| Day of month | TEXT | Day of the month |
| Device | TEXT | Device. Possible values: Desktop, SmartTV, Smartphone, Tablet. |
| Display 1 second view | NUMERIC | Display 1 second view |
| Display 10 second view | NUMERIC | Display 10 second view |
| Display 11 second view | NUMERIC | Display 11 second view |
| Display 12 second view | NUMERIC | Display 12 second view |
| Display 13 second view | NUMERIC | Display 13 second view |
| Display 14 second view | NUMERIC | Display 14 second view |
| Display 15 second view | NUMERIC | Display 15 second view |
| Display 16 second view | NUMERIC | Display 16 second view |
| Display 17 second view | NUMERIC | Display 17 second view |
| Display 18 second view | NUMERIC | Display 18 second view |
| Display 19 second view | NUMERIC | Display 19 second view |
| Display 2 second view | NUMERIC | Display 2 second view |
| Display 20 second view | NUMERIC | Display 20 second view |
| Display 21 second view | NUMERIC | Display 21 second view |
| Display 22 second view | NUMERIC | Display 22 second view |
| Display 23 second view | NUMERIC | Display 23 second view |
| Display 24 second view | NUMERIC | Display 24 second view |
| Display 25 second view | NUMERIC | Display 25 second view |
| Display 26 second view | NUMERIC | Display 26 second view |
| Display 27 second view | NUMERIC | Display 27 second view |
| Display 28 second view | NUMERIC | Display 28 second view |
| Display 29 second view | NUMERIC | Display 29 second view |
| Display 3 second view | NUMERIC | Display 3 second view |
| Display 30 second view | NUMERIC | Display 30 second view |
| Display 4 second view | NUMERIC | Display 4 second view |
| Display 5 second view | NUMERIC | Display 5 second view |
| Display 6 second view | NUMERIC | Display 6 second view |
| Display 7 second view | NUMERIC | Display 7 second view |
| Display 8 second view | NUMERIC | Display 8 second view |
| Display 9 second view | NUMERIC | Display 9 second view |
| Creative family | TEXT | Creative family (Video, Viewable Display, etc) |
| Hour | TEXT | Hour for the data |
| Impressions | NUMERIC | Impressions |
| Campaign currency | TEXT | Currency of the campaign |
| Line item budget | TEXT | Budget of the line item |
| Line item ID | TEXT | Teads id of the line item |
| Line item name | TEXT | Name of the line item |
| MOAT - 10 Sec In-View Impressions | NUMERIC | MOAT - 10 Sec In-View Impressions |
| MOAT - 11 Sec In-View Impressions | NUMERIC | MOAT - 11 Sec In-View Impressions |
| MOAT - 12 Sec In-View Impressions | NUMERIC | MOAT - 12 Sec In-View Impressions |
| MOAT - 13 Sec In-View Impressions | NUMERIC | MOAT - 13 Sec In-View Impressions |
| MOAT - 14 Sec In-View Impressions | NUMERIC | MOAT - 14 Sec In-View Impressions |
| MOAT - 15 Sec In-View Impressions | NUMERIC | MOAT - 15 Sec In-View Impressions |
| MOAT - 16 Sec In-View Impressions | NUMERIC | MOAT - 16 Sec In-View Impressions |
| MOAT - 17 Sec In-View Impressions | NUMERIC | MOAT - 17 Sec In-View Impressions |
| MOAT - 18 Sec In-View Impressions | NUMERIC | MOAT - 18 Sec In-View Impressions |
| MOAT - 19 Sec In-View Impressions | NUMERIC | MOAT - 19 Sec In-View Impressions |
| MOAT - 1 Sec In-View Impressions | NUMERIC | MOAT - 1 Sec In-View Impressions |
| MOAT - 20 Sec In-View Impressions | NUMERIC | MOAT - 20 Sec In-View Impressions |
| MOAT - 21 Sec In-View Impressions | NUMERIC | MOAT - 21 Sec In-View Impressions |
| MOAT - 22 Sec In-View Impressions | NUMERIC | MOAT - 22 Sec In-View Impressions |
| MOAT - 23 Sec In-View Impressions | NUMERIC | MOAT - 23 Sec In-View Impressions |
| MOAT - 24 Sec In-View Impressions | NUMERIC | MOAT - 24 Sec In-View Impressions |
| MOAT - 25 Sec In-View Impressions | NUMERIC | MOAT - 25 Sec In-View Impressions |
| MOAT - 26 Sec In-View Impressions | NUMERIC | MOAT - 26 Sec In-View Impressions |
| MOAT - 27 Sec In-View Impressions | NUMERIC | MOAT - 27 Sec In-View Impressions |
| MOAT - 28 Sec In-View Impressions | NUMERIC | MOAT - 28 Sec In-View Impressions |
| MOAT - 29 Sec In-View Impressions | NUMERIC | MOAT - 29 Sec In-View Impressions |
| MOAT - 2 Sec In-View Impressions | NUMERIC | MOAT - 2 Sec In-View Impressions |
| MOAT - 30 Sec In-View Impressions | NUMERIC | MOAT - 30 Sec In-View Impressions |
| MOAT - 3 Sec In-View Impressions | NUMERIC | MOAT - 3 Sec In-View Impressions |
| MOAT - 4 Sec In-View Impressions | NUMERIC | MOAT - 4 Sec In-View Impressions |
| MOAT - 5 Sec In-View Impressions | NUMERIC | MOAT - 5 Sec In-View Impressions |
| MOAT - 6 Sec In-View Impressions | NUMERIC | MOAT - 6 Sec In-View Impressions |
| MOAT - 7 Sec In-View Impressions | NUMERIC | MOAT - 7 Sec In-View Impressions |
| MOAT - 8 Sec In-View Impressions | NUMERIC | MOAT - 8 Sec In-View Impressions |
| MOAT - 9 Sec In-View Impressions | NUMERIC | MOAT - 9 Sec In-View Impressions |
| MOAT - Impressions Analyzed (unfiltered for IVT) | NUMERIC | MOAT - Impressions Analyzed (unfiltered for IVT) |
| MOAT - Impressions Analyzed (filtered for IVT) | NUMERIC | MOAT - Impressions Analyzed (filtered for IVT) |
| MOAT - Average In-View Time (ms) | NUMERIC | MOAT - Average In-View Time (ms) |
| MOAT - Complete In-View Impressions | NUMERIC | MOAT - Complete In-View Impressions |
| MOAT - In-View Measurable Impressions | NUMERIC | MOAT - In-View Measurable Impressions |
| MOAT - Valid and Viewable Impressions | NUMERIC | MOAT - Valid and Viewable Impressions |
| MOAT - Total Ad Length (ms) | NUMERIC | MOAT - Total Ad Length (ms) |
| MOAT - Total In-View Time (ms) | NUMERIC | MOAT - Total In-View Time (ms) |
| MOAT - Average Ad Length (ms) | NUMERIC | MOAT - Average Ad Length (ms) |
| MOAT - Valid and Viewable % | NUMERIC | MOAT - Valid and Viewable % |
| Month | TEXT | Month for the data (ISO8601 format containing first day in month) |
| Creative portfolio item | TEXT | Commercial name of the creative type |
| Post click conversions | NUMERIC | Post click conversions |
| Post view conversions | NUMERIC | Post view conversions |
| Line item billable event | TEXT | Billable event for the line item |
| 1 second view | NUMERIC | 1 second view |
| 10 second view | NUMERIC | 10 second view |
| 11 second view | NUMERIC | 11 second view |
| 12 second view | NUMERIC | 12 second view |
| 13 second view | NUMERIC | 13 second view |
| 14 second view | NUMERIC | 14 second view |
| 15 second view | NUMERIC | 15 second view |
| 16 second view | NUMERIC | 16 second view |
| 17 second view | NUMERIC | 17 second view |
| 18 second view | NUMERIC | 18 second view |
| 19 second view | NUMERIC | 19 second view |
| 2 second view | NUMERIC | 2 second view |
| 20 second view | NUMERIC | 20 second view |
| 21 second view | NUMERIC | 21 second view |
| 22 second view | NUMERIC | 22 second view |
| 23 second view | NUMERIC | 23 second view |
| 24 second view | NUMERIC | 24 second view |
| 25 second view | NUMERIC | 25 second view |
| 26 second view | NUMERIC | 26 second view |
| 27 second view | NUMERIC | 27 second view |
| 28 second view | NUMERIC | 28 second view |
| 29 second view | NUMERIC | 29 second view |
| 3 second view | NUMERIC | 3 second view |
| 30 second view | NUMERIC | 30 second view |
| 4 second view | NUMERIC | 4 second view |
| 5 second view | NUMERIC | 5 second view |
| 6 second view | NUMERIC | 6 second view |
| 7 second view | NUMERIC | 7 second view |
| 8 second view | NUMERIC | 8 second view |
| 9 second view | NUMERIC | 9 second view |
| Source | TEXT | The name of the Windsor connector returning the row |
| Today | DATE | Today's date |
| Total ad cost | NUMERIC | Budget spent on advertising cost. Does not include Added Value Budget, nor Ad Manager fee, nor Agency fee. |
| Budget spent - Cost per result | NUMERIC | Average price of each result, considering the budget spent (invoiced by Teads) and the total volume delivered. |
| Budget spent - CPC | NUMERIC | Average price of each click, considering the budget spent (invoiced by Teads) and the total volume delivered. |
| Budget spent - CPM | NUMERIC | Average price of a thousand impressions, considering the budget spent (invoiced by Teads) and the total volume delivered. |
| Fee | NUMERIC | Budget spent on Ad Manager fee cost |
| Budget spent | NUMERIC | Budget spent (i.e. invoiced by Teads). Includes Ad Manager fee. Does not include Added Value budget nor Agency fee. |
| Unique Viewers impression | NUMERIC | Estimated number of unique Teads IDs exposed to the ad. |
| Video completes | NUMERIC | Video completes |
| Video complete rate | NUMERIC | Video completion rate |
| Video first quartile | NUMERIC | Video first quartile |
| Video midpoint | NUMERIC | Video midpoint |
| Video progress 1 second | NUMERIC | Video progress 1 second |
| Video progress 10 second | NUMERIC | Video progress 10 second |
| Video progress 11 second | NUMERIC | Video progress 11 second |
| Video progress 12 second | NUMERIC | Video progress 12 second |
| Video progress 13 second | NUMERIC | Video progress 13 second |
| Video progress 14 second | NUMERIC | Video progress 14 second |
| Video progress 15 second | NUMERIC | Video progress 15 second |
| Video progress 16 second | NUMERIC | Video progress 16 second |
| Video progress 17 second | NUMERIC | Video progress 17 second |
| Video progress 18 second | NUMERIC | Video progress 18 second |
| Video progress 19 second | NUMERIC | Video progress 19 second |
| Video progress 2 second | NUMERIC | Video progress 2 second |
| Video progress 20 second | NUMERIC | Video progress 20 second |
| Video progress 21 second | NUMERIC | Video progress 21 second |
| Video progress 22 second | NUMERIC | Video progress 22 second |
| Video progress 23 second | NUMERIC | Video progress 23 second |
| Video progress 24 second | NUMERIC | Video progress 24 second |
| Video progress 25 second | NUMERIC | Video progress 25 second |
| Video progress 26 second | NUMERIC | Video progress 26 second |
| Video progress 27 second | NUMERIC | Video progress 27 second |
| Video progress 28 second | NUMERIC | Video progress 28 second |
| Video progress 29 second | NUMERIC | Video progress 29 second |
| Video progress 3 second | NUMERIC | Video progress 3 second |
| Video progress 30 second | NUMERIC | Video progress 30 second |
| Video progress 4 second | NUMERIC | Video progress 4 second |
| Video progress 5 second | NUMERIC | Video progress 5 second |
| Video progress 6 second | NUMERIC | Video progress 6 second |
| Video progress 7 second | NUMERIC | Video progress 7 second |
| Video progress 8 second | NUMERIC | Video progress 8 second |
| Video progress 9 second | NUMERIC | Video progress 9 second |
| Video starts | NUMERIC | Video starts |
| Video third quartile | NUMERIC | Video third quartile |
| Website domain | TEXT | The domain of the website |
| 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 for the data (ISO8601 format containing first day in 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 Teads 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.