Windsor brings all your Taboola data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Taboola Field Reference
Sample
https://connectors.windsor.ai/taboola?api_key=[your API key]&date_preset=last_7d&fields=campaign,campaign_name,campaigns_num,clicks,conversions_value,cpa,cpa_actions_num,cpa_actions_num_from_clicks,cpa_actions_num_from_views,cpa_clicks,cpa_conversion_rate,cpa_conversion_rate_clicks,cpa_conversion_rate_views,cpa_views,cpc,cpm,ctr,currency,date,impressions,roas,spend,spent,totalcost,vcpm,vctr,visible_impressions,&_renderer=csv
Fields
ID | Type | Name | Description |
---|---|---|---|
adnetwork_conversions | NUMERIC | CPA Actions Num (copy of `cpa_actions_num`) | Total number of actions (conversions) |
adnetwork_revenue | NUMERIC | Conversions Value (copy of `conversions_value`) | Total revenue from conversions |
campaign | TEXT | Campaign Name | Human-readable campaign name. |
campaign_id | TEXT | Campaign | A numeric string. Represents the unique ID of a campaign. |
campaigns_num | NUMERIC | Campaigns Num | Number of campaigns (visible for relevant dimensions only e.g. day, week, month) |
clicks | NUMERIC | Clicks | Total clicks |
conversions_value | NUMERIC | Conversions Value | Total revenue from conversions |
cpa | NUMERIC | CPA | Cost Per Action (Conversion) = Spent/Conversions (considers all conversions) |
cpa_actions_num | NUMERIC | CPA Actions Num | Total number of actions (conversions) |
cpa_actions_num_from_clicks | NUMERIC | CPA Actions Num From Clicks | Total number of click through actions (conversions) --Look-back window is configurable per conversion rule (default = 30 days) |
cpa_actions_num_from_views | NUMERIC | CPA Actions Num From Views | Total number of view through actions (conversions) --Look-back window is 24 hours (fixed) |
cpa_clicks | NUMERIC | CPA Clicks | Click Cost Per Action (Conversion) = Spent/Click Through Conversions (considers conversions attributed via click throughs only) |
cpa_conversion_rate | NUMERIC | CPA Conversion Rate | Conversion Rate (%) = Conversions/Clicks*100 (considers all conversions) |
cpa_conversion_rate_clicks | NUMERIC | CPA Conversion Rate Clicks | Click Conversion Rate (%) = Click Through Conversions/Clicks (considers conversions attributed via click throughs only) |
cpa_conversion_rate_views | NUMERIC | CPA Conversion Rate Views | View Conversion Rate (%) = View Through Conversions/Clicks (considers conversions attributed via view throughs only) |
cpa_views | NUMERIC | CPA Views | View Cost Per Action (Conversion) = Spent/View Through Conversions (considers conversions attributed via view throughs only) |
cpc | NUMERIC | CPC | (Actual) Cost Per Click= spent/clicks |
cpm | NUMERIC | CPM | Cost Per 1000 Impressions= spent/impressions * 1000 |
ctr | PERCENT | CTR | Click Through Rate (%)= clicks/impressions * 100 |
currency | TEXT | Currency | The currency for columns of type Money |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
date | DATE | Date | The start date for the reporting period. |
day_of_month | TEXT | Day of month | Day of the month |
impressions | NUMERIC | Impressions | Total impressions |
month | TEXT | Month | Number of the month |
roas | PERCENT | ROAS | Return On Ad Spend (%) |
source | TEXT | Source | The name of the Windsor connector returning the row |
spend | NUMERIC | Spend (duplicate of `spent`) | Total spent (on campaign bidding) (duplicate) |
spent | NUMERIC | Spent | Total spent (on campaign bidding) |
today | DATE | Today | Today's date |
totalcost | NUMERIC | Total Cost | The Media Spend (Duplicate) |
vcpm | NUMERIC | VCPM | Cost Per 1000 Viewable Impressions= spent/visible_impressions * 1000 |
vctr | PERCENT | VCTR | Viewable Click Through Rate (%)= clicks/visible_impressions |
visible_impressions | NUMERIC | Visible Impressions | Total viewable impressions |
week | TEXT | Week | Week (Sun-Sat). |
week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). |
year | TEXT | Year | Year |
year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 |
year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). |
year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). |
year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |