Windsor brings all your Simpli.fi data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Simpli.fi Field Reference

Fields
ID | Type | Name | Description |
---|---|---|---|
account_id | TEXT | Account ID | Account ID. |
account_name | TEXT | Account Name | Account Name. |
ad_count | NUMERIC | Ad Count | Ad Ad Count |
ad_file_reporting_type | TEXT | Ad File Type | Ad Ad File Type |
ad_id | TEXT | Ad ID | Ad Ad ID |
ad_key | TEXT | Ad Key | Ad Ad Key |
ad_name | TEXT | Ad Name | Ad Ad Name |
ad_size | TEXT | Ad Size | Ad Ad Size |
advertiser_name | TEXT | Advertiser Name | Campaign Advertiser Name |
behavioral_cost | NUMERIC | Behavioral Cost | Margins by Spend Behavioral Cost |
behavioral_cpm | NUMERIC | Behavioral CPM | Margins by CPM Behavioral CPM |
billing_organization | TEXT | Billing Organization | Companies Billing Organization |
billing_organization_id | TEXT | Billing Organization ID | Companies Billing Organization ID |
budget_plan_end_date | DATE | Budget Plan End Date | Campaign Budget Plan End Date |
budget_plan_id | TEXT | Budget Plan ID | Campaign Budget Plan ID |
budget_plan_start_date | DATE | Budget Plan Start Date | Campaign Budget Plan Start Date |
budget_plan_total_budget | NUMERIC | Plan Budget | Campaign Plan Budget |
budget_plan_total_impressions | NUMERIC | Plan Impressions | Campaign Plan Impressions |
campaign_count | NUMERIC | Campaign Count | Campaign Campaign Count |
campaign_custom_id | TEXT | Campaign Custom ID | Campaign Campaign Custom ID |
campaign_daily_budget | NUMERIC | Campaign Daily Budget | Campaign Daily Budget |
campaign_daily_estimated_budget | NUMERIC | Campaign Daily Estimated Budget | Campaign Daily Estimated Budget |
campaign_daily_impression_cap | NUMERIC | Campaign Daily Impression Cap | Campaign Daily Impression Cap |
campaign_end_date | DATE | Campaign End Date | Campaign End Date |
campaign_goal_type | TEXT | Campaign Goal Type | Campaign Goal Type |
campaign_goal_value | NUMERIC | Campaign Goal Value | Campaign Goal Value |
campaign_group_id | TEXT | Campaign Group ID | Campaign Campaign Group ID |
campaign_group_name | TEXT | Campaign Group Name | Campaign Campaign Group Name |
campaign_id | TEXT | Campaign ID | Campaign Campaign ID |
campaign_key | TEXT | Campaign Key | Performance Trending Campaign Key |
campaign_max_bid | NUMERIC | Campaign Max Bid | Campaign Max Bid |
campaign_media_type | TEXT | Campaign Media Type | Campaign Media Type |
campaign_monthly_budget | NUMERIC | Campaign Monthly Budget | Campaign Monthly Budget |
campaign_monthly_impression_cap | NUMERIC | Campaign Monthly Impression Cap | Campaign Monthly Impression Cap |
campaign_name | TEXT | Campaign Name | Campaign Campaign Name |
campaign_status | TEXT | Campaign Status | Campaign Campaign Status |
campaign_total_budget | NUMERIC | Campaign Total Budget | Campaign Total Budget |
campaign_total_impression_cap | NUMERIC | Campaign Total Impression Cap | Campaign Total Impression Cap |
campaign_type | TEXT | Campaign Type | Campaign Campaign Type |
cart_value | NUMERIC | Transaction Value | Performance Transaction Value |
clicks | NUMERIC | Clicks | Performance Clicks |
clickthrough_leads | NUMERIC | Clickthrough Leads | Conversions Clickthrough Leads |
clickthrough_other | NUMERIC | Clickthrough Other | Conversions Clickthrough Other |
clickthrough_sales | NUMERIC | Clickthrough Sales | Conversions Clickthrough Sales |
clickthrough_signups | NUMERIC | Clickthrough Signups | Conversions Clickthrough Signups |
clickthrough_total | NUMERIC | Clickthrough Total | Conversions Clickthrough Total |
clickthrough_visits | NUMERIC | Clickthrough Visits | Conversions Clickthrough Visits |
client_id | TEXT | Client ID | Companies Client ID |
client_logo | TEXT | Client Logo | Companies Client Logo |
client_name | TEXT | Client Name | Companies Client Name |
company_count | NUMERIC | Company Count | Companies Company Count |
company_id | TEXT | Company ID | Companies Company ID |
company_logo | TEXT | Company Logo | Companies Company Logo |
company_name | TEXT | Company Name | Companies Company Name |
context_cost | NUMERIC | Context Cost | Margins by Spend Context Cost |
context_cpm | NUMERIC | Contextual CPM | Margins by CPM Contextual CPM |
conversion_segment_name | TEXT | Conversion Segment Name | Conversions Conversion Segment Name |
cpa | NUMERIC | CPA | Conversions CPA |
ctr | PERCENT | CTR | Performance CTR |
custom_id | TEXT | Custom ID | Companies Custom ID |
daily_impression_cap | NUMERIC | Daily Impression Cap | Campaign Daily Impression Cap |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
date | DATE | Date | Date. |
day_of_month | TEXT | Day of month | Day of the month |
demographic_cost | NUMERIC | Demographic Cost | Margins by Spend Demographic Cost |
demographic_cpm | NUMERIC | Demographic CPM | Margins by CPM Demographic CPM |
ecpc | NUMERIC | eCPC | Performance eCPC |
ecpm | NUMERIC | eCPM | Performance eCPM |
event_month | TEXT | Event Month | Time Event Month |
event_quarter | TEXT | Event Quarter | Time Event Quarter |
event_week | TEXT | Event Week | Time Event Week |
geo_cost | NUMERIC | Geo Cost | Margins by Spend Geo Cost |
geo_cpm | NUMERIC | Geographic CPM | Margins by CPM Geographic CPM |
impressions | NUMERIC | Impressions | Performance Impressions |
is_ctv | BOOLEAN | Is CTV | Details Is CTV (true / false) |
media_cost | NUMERIC | Media Cost | Margins by Spend Media Cost |
media_cpm | NUMERIC | Media CPM | Margins by CPM Media CPM |
month | TEXT | Month | Number of the month |
order_id | TEXT | Order ID | Conversions Order ID |
organization_id | TEXT | Organization ID | Companies Organization ID |
platform_cost | NUMERIC | Platform Cost | Margins by Spend Platform Cost |
platform_cpm | NUMERIC | Platform CPM | Margins by CPM Platform CPM |
platform_id | TEXT | Platform ID | Companies Platform ID |
platform_logo | TEXT | Platform Logo | Companies Platform Logo |
platform_name | TEXT | Platform Name | Companies Platform Name |
retail_cpa | NUMERIC | Retail CPA | Retail Markup Retail CPA |
retail_cpc | NUMERIC | Retail CPC | Retail Markup Retail CPC |
retail_markup | NUMERIC | Retail Markup | Retail Markup Retail Markup |
retail_markup_cpm | NUMERIC | Retail Markup CPM | Retail Markup Retail Markup CPM |
retail_total | NUMERIC | Total Retail Cost | Retail Markup Total Retail Cost |
retail_total_ecpm | NUMERIC | Total Retail CPM | Retail Markup Total Retail CPM |
salesall | NUMERIC | Total Sales | Conversions Total Sales |
search_term_cost | NUMERIC | Search Term Cost | Margins by Spend Search Term Cost |
search_term_cpm | NUMERIC | Search CPM | Margins by CPM Search CPM |
segment_cost | NUMERIC | Segment Cost | Margins by Spend Segment Cost |
segment_cpm | NUMERIC | Segment CPM | Margins by CPM Segment CPM |
sifi_cost | NUMERIC | Sifi Cost | Margins by Spend Sifi Cost |
source | TEXT | Source | The name of the Windsor connector returning the row |
start_date | DATE | Start Date | Campaign Start Date |
third_party_retail_markup | NUMERIC | Third Party Markup | Retail Markup Third Party Markup |
third_party_retail_markup_cpm | NUMERIC | Third Party Markup CPM | Retail Markup Third Party Markup CPM |
today | DATE | Today | Today's date |
total_leads | NUMERIC | Total Leads | Conversions Total Leads |
total_other | NUMERIC | Total Other | Conversions Total Other |
total_sifi | NUMERIC | Total Sifi | Margins by Spend Total Sifi |
total_signups | NUMERIC | Total Signups | Conversions Total Signups |
total_spend | NUMERIC | Total Spend | Performance Total Spend |
total_visits | NUMERIC | Total Visits | Conversions Total Visits |
viewability_cost | NUMERIC | Viewability Cost | Margins by Spend Viewability Cost |
viewability_cpm | NUMERIC | Viewability CPM | Margins by CPM Viewability CPM |
viewthrough_leads | NUMERIC | Viewthrough Leads | Conversions Viewthrough Leads |
viewthrough_other | NUMERIC | Viewthrough Other | Conversions Viewthrough Other |
viewthrough_sales | NUMERIC | Viewthrough Sales | Conversions Viewthrough Sales |
viewthrough_signups | NUMERIC | Viewthrough Signups | Conversions Viewthrough Signups |
viewthrough_total | NUMERIC | Viewthrough Total | Conversions Viewthrough Total |
viewthrough_visits | NUMERIC | Viewthrough Visits | Conversions Viewthrough Visits |
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). |
weighted_actions | NUMERIC | Weighted Actions | Conversions Weighted Actions |
white_label_client_logo_path | TEXT | White Label Client Logo Path | Companies White Label Client Logo Path |
white_label_company_logo_path | TEXT | White Label Company Logo Path | Companies White Label Company Logo Path |
white_label_platform_logo_path | TEXT | White Label Platform Logo Path | Companies White Label Platform Logo Path |
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 |