+
Stream marketing data from Taboola to Snowflake
About Taboola
About SnowFlake
Connect Taboola to Snowflake in 2023
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) --Look-back window is configurable per conversion rule (default = 30 days) |
| CPA Actions Num From Views | NUMERIC | Total number of view through actions (conversions) --Look-back window is 24 hours (fixed) |
| CPA Clicks | NUMERIC | Click Cost Per Action (Conversion) = Spent/Click Through Conversions (considers conversions attributed via click throughs only) |
| CPA Conversion Rate | NUMERIC | Conversion Rate (%) = Conversions/Clicks*100 (considers all conversions) |
| CPA Conversion Rate Clicks | NUMERIC | Click Conversion Rate (%) = Click Through Conversions/Clicks (considers conversions attributed via click throughs only) |
| CPA Conversion Rate Views | NUMERIC | 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 |
| Month | TEXT | Number of the month |
| ROAS | PERCENT | Return On Ad Spend (%) |
| 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 |
| 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.