Simpli.fi Field Reference


Fields

IDTypeNameDescription
account_idTEXTAccount IDAccount ID.
account_nameTEXTAccount NameAccount Name.
ad_countNUMERICAd CountAd Ad Count
ad_file_reporting_typeTEXTAd File TypeAd Ad File Type
ad_idTEXTAd IDAd Ad ID
ad_keyTEXTAd KeyAd Ad Key
ad_nameTEXTAd NameAd Ad Name
ad_sizeTEXTAd SizeAd Ad Size
advertiser_nameTEXTAdvertiser NameCampaign Advertiser Name
behavioral_costNUMERICBehavioral CostMargins by Spend Behavioral Cost
behavioral_cpmNUMERICBehavioral CPMMargins by CPM Behavioral CPM
billing_organizationTEXTBilling OrganizationCompanies Billing Organization
billing_organization_idTEXTBilling Organization IDCompanies Billing Organization ID
budget_plan_end_dateDATEBudget Plan End DateCampaign Budget Plan End Date
budget_plan_idTEXTBudget Plan IDCampaign Budget Plan ID
budget_plan_start_dateDATEBudget Plan Start DateCampaign Budget Plan Start Date
budget_plan_total_budgetNUMERICPlan BudgetCampaign Plan Budget
budget_plan_total_impressionsNUMERICPlan ImpressionsCampaign Plan Impressions
campaign_countNUMERICCampaign CountCampaign Campaign Count
campaign_custom_idTEXTCampaign Custom IDCampaign Campaign Custom ID
campaign_daily_budgetNUMERICCampaign Daily BudgetCampaign Daily Budget
campaign_daily_estimated_budgetNUMERICCampaign Daily Estimated BudgetCampaign Daily Estimated Budget
campaign_daily_impression_capNUMERICCampaign Daily Impression CapCampaign Daily Impression Cap
campaign_end_dateDATECampaign End DateCampaign End Date
campaign_goal_typeTEXTCampaign Goal TypeCampaign Goal Type
campaign_goal_valueNUMERICCampaign Goal ValueCampaign Goal Value
campaign_group_idTEXTCampaign Group IDCampaign Campaign Group ID
campaign_group_nameTEXTCampaign Group NameCampaign Campaign Group Name
campaign_idTEXTCampaign IDCampaign Campaign ID
campaign_keyTEXTCampaign KeyPerformance Trending Campaign Key
campaign_max_bidNUMERICCampaign Max BidCampaign Max Bid
campaign_media_typeTEXTCampaign Media TypeCampaign Media Type
campaign_monthly_budgetNUMERICCampaign Monthly BudgetCampaign Monthly Budget
campaign_monthly_impression_capNUMERICCampaign Monthly Impression CapCampaign Monthly Impression Cap
campaign_nameTEXTCampaign NameCampaign Campaign Name
campaign_statusTEXTCampaign StatusCampaign Campaign Status
campaign_total_budgetNUMERICCampaign Total BudgetCampaign Total Budget
campaign_total_impression_capNUMERICCampaign Total Impression CapCampaign Total Impression Cap
campaign_typeTEXTCampaign TypeCampaign Campaign Type
cart_valueNUMERICTransaction ValuePerformance Transaction Value
clicksNUMERICClicksPerformance Clicks
clickthrough_leadsNUMERICClickthrough LeadsConversions Clickthrough Leads
clickthrough_otherNUMERICClickthrough OtherConversions Clickthrough Other
clickthrough_salesNUMERICClickthrough SalesConversions Clickthrough Sales
clickthrough_signupsNUMERICClickthrough SignupsConversions Clickthrough Signups
clickthrough_totalNUMERICClickthrough TotalConversions Clickthrough Total
clickthrough_visitsNUMERICClickthrough VisitsConversions Clickthrough Visits
client_idTEXTClient IDCompanies Client ID
TEXTClient LogoCompanies Client Logo
client_nameTEXTClient NameCompanies Client Name
company_countNUMERICCompany CountCompanies Company Count
company_idTEXTCompany IDCompanies Company ID
TEXTCompany LogoCompanies Company Logo
company_nameTEXTCompany NameCompanies Company Name
context_costNUMERICContext CostMargins by Spend Context Cost
context_cpmNUMERICContextual CPMMargins by CPM Contextual CPM
conversion_segment_nameTEXTConversion Segment NameConversions Conversion Segment Name
cpaNUMERICCPAConversions CPA
ctrPERCENTCTRPerformance CTR
custom_idTEXTCustom IDCompanies Custom ID
daily_impression_capNUMERICDaily Impression CapCampaign Daily Impression Cap
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate.
day_of_monthTEXTDay of monthDay of the month
demographic_costNUMERICDemographic CostMargins by Spend Demographic Cost
demographic_cpmNUMERICDemographic CPMMargins by CPM Demographic CPM
ecpcNUMERICeCPCPerformance eCPC
ecpmNUMERICeCPMPerformance eCPM
event_monthTEXTEvent MonthTime Event Month
event_quarterTEXTEvent QuarterTime Event Quarter
event_weekTEXTEvent WeekTime Event Week
geo_costNUMERICGeo CostMargins by Spend Geo Cost
geo_cpmNUMERICGeographic CPMMargins by CPM Geographic CPM
impressionsNUMERICImpressionsPerformance Impressions
is_ctvBOOLEANIs CTVDetails Is CTV (true / false)
media_costNUMERICMedia CostMargins by Spend Media Cost
media_cpmNUMERICMedia CPMMargins by CPM Media CPM
monthTEXTMonthNumber of the month
order_idTEXTOrder IDConversions Order ID
organization_idTEXTOrganization IDCompanies Organization ID
platform_costNUMERICPlatform CostMargins by Spend Platform Cost
platform_cpmNUMERICPlatform CPMMargins by CPM Platform CPM
platform_idTEXTPlatform IDCompanies Platform ID
TEXTPlatform LogoCompanies Platform Logo
platform_nameTEXTPlatform NameCompanies Platform Name
retail_cpaNUMERICRetail CPARetail Markup Retail CPA
retail_cpcNUMERICRetail CPCRetail Markup Retail CPC
retail_markupNUMERICRetail MarkupRetail Markup Retail Markup
retail_markup_cpmNUMERICRetail Markup CPMRetail Markup Retail Markup CPM
retail_totalNUMERICTotal Retail CostRetail Markup Total Retail Cost
retail_total_ecpmNUMERICTotal Retail CPMRetail Markup Total Retail CPM
salesallNUMERICTotal SalesConversions Total Sales
search_term_costNUMERICSearch Term CostMargins by Spend Search Term Cost
search_term_cpmNUMERICSearch CPMMargins by CPM Search CPM
segment_costNUMERICSegment CostMargins by Spend Segment Cost
segment_cpmNUMERICSegment CPMMargins by CPM Segment CPM
sifi_costNUMERICSifi CostMargins by Spend Sifi Cost
sourceTEXTSourceThe name of the Windsor connector returning the row
start_dateDATEStart DateCampaign Start Date
third_party_retail_markupNUMERICThird Party MarkupRetail Markup Third Party Markup
third_party_retail_markup_cpmNUMERICThird Party Markup CPMRetail Markup Third Party Markup CPM
todayDATETodayToday's date
total_leadsNUMERICTotal LeadsConversions Total Leads
total_otherNUMERICTotal OtherConversions Total Other
total_sifiNUMERICTotal SifiMargins by Spend Total Sifi
total_signupsNUMERICTotal SignupsConversions Total Signups
total_spendNUMERICTotal SpendPerformance Total Spend
total_visitsNUMERICTotal VisitsConversions Total Visits
viewability_costNUMERICViewability CostMargins by Spend Viewability Cost
viewability_cpmNUMERICViewability CPMMargins by CPM Viewability CPM
viewthrough_leadsNUMERICViewthrough LeadsConversions Viewthrough Leads
viewthrough_otherNUMERICViewthrough OtherConversions Viewthrough Other
viewthrough_salesNUMERICViewthrough SalesConversions Viewthrough Sales
viewthrough_signupsNUMERICViewthrough SignupsConversions Viewthrough Signups
viewthrough_totalNUMERICViewthrough TotalConversions Viewthrough Total
viewthrough_visitsNUMERICViewthrough VisitsConversions Viewthrough Visits
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
weighted_actionsNUMERICWeighted ActionsConversions Weighted Actions
white_label_client_logo_pathTEXTWhite Label Client Logo PathCompanies White Label Client Logo Path
white_label_company_logo_pathTEXTWhite Label Company Logo PathCompanies White Label Company Logo Path
white_label_platform_logo_pathTEXTWhite Label Platform Logo PathCompanies White Label Platform Logo Path
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20