+
Stream marketing data from Taboola to Snowflake
About Taboola
About SnowFlake
Connect Taboola to Snowflake
It is very simple to connect Taboola 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 Taboola 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 Taboola to Snowflake. In case there is an error you will be notified.
Taboola metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| CPA Actions Num (copy of `cpa_actions_num`) | NUMERIC | Total number of actions (conversions) |
| Conversions Value (copy of `conversions_value`) | NUMERIC | Total revenue from conversions |
| Campaign | TEXT | Human-readable campaign name. |
| Campaign | TEXT | A numeric string. Represents the unique ID of a campaign. |
| Campaigns Num | NUMERIC | Number of campaigns (visible for relevant dimensions only e.g. day, week, month). |
| Clicks | NUMERIC | Total clicks |
| Conversions Value | NUMERIC | Total revenue from conversions |
| CPA | NUMERIC | Cost Per Action (Conversion) = Spent/Conversions (considers all conversions) |
| CPA Actions Num | NUMERIC | Total number of actions (conversions) |
| CPA Actions Num From Clicks | NUMERIC | Total number of click through actions (conversions). |
| CPA Actions Num From Views | NUMERIC | Total number of view through actions (conversions) |
| CPA Clicks | NUMERIC | Click Cost Per Action (Conversion) = Spent/Click Through Conversions (considers conversions attributed via click throughs only). |
| CPA Conversion Rate | PERCENT | Conversion Rate (%) = Conversions/Clicks*100 (considers all conversions) |
| CPA Conversion Rate Clicks | PERCENT | Click Conversion Rate (%) = Click Through Conversions/Clicks (considers conversions attributed via click throughs only) |
| CPA Conversion Rate Views | PERCENT | View Conversion Rate (%) = View Through Conversions/Clicks (considers conversions attributed via view throughs only). |
| CPA Views | NUMERIC | View Cost Per Action (Conversion) = Spent/View Through Conversions (considers conversions attributed via view throughs only). |
| CPC | NUMERIC | (Actual) Cost Per Click= spent/clicks |
| CPM | NUMERIC | Cost Per 1000 Impressions= spent/impressions * 1000 |
| CTR | PERCENT | Click Through Rate (%)= clicks/impressions * 100 |
| Currency | TEXT | The currency for columns of type Money |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | The start date for the reporting period. |
| Day of month | TEXT | Day of the month |
| Impressions | NUMERIC | Total impressions, known as Served Ads. Total number of times your ad is loaded on a page |
| Item | TEXT | The unique title (display name) of the Item. |
| Item Custom ID | TEXT | The custom ID of the creative (ad), if you provided one. |
| Item Custom Name | TEXT | The custom name of the creative (ad), if you provided one. |
| Item Description | TEXT | The description of the Item. |
| Item ID | TEXT | The unique id of the Item. (A numeric string) |
| Item Learning Display Status | TEXT | The learning status of the Item. Possible values: EMPTY_DISPLAY (also known as NONE), EXPEDITED_LEARNING, LEARNING, LEARNING_COMPLETE, LEARNING_LIMITED (insufficient events for learning). |
| Item Thumbnail URL | IMAGE_URL | The thumbnail URL of the Item. |
| Item URL | TEXT | The url of the Item. |
| Month | TEXT | Number of the month |
| ROAS | PERCENT | Return On Ad Spend (%) |
| ROAS Clicks | PERCENT | Return On Ad Spend for Click Through Conversions (%) |
| ROAS Views | PERCENT | Return On Ad Spend for View Through Conversions (%) |
| Source | TEXT | The name of the Windsor connector returning the row |
| Spend (duplicate of `spent`) | NUMERIC | Total spent (on campaign bidding) (duplicate) |
| Spent | NUMERIC | Total spent (on campaign bidding) |
| Today | DATE | Today's date |
| Total Cost | NUMERIC | The Media Spend (Duplicate) |
| VCPM | NUMERIC | Cost Per 1000 Viewable Impressions= spent/visible_impressions * 1000 |
| VCTR | PERCENT | Viewable Click Through Rate (%)= clicks/visible_impressions |
| Visible Impressions | NUMERIC | Total viewable impressions. How many times your ad is actually seen by a user |
| 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 Taboola 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.