Simpli.fi Field Reference


Fields

IDTypeNameDescription
account_idTEXTAccount IDAccount ID.
account_nameTEXTAccount NameAccount Name.
ad_idTEXTAd IDAd Ad ID
ad_nameTEXTAd NameAd Ad Name
behavioral_cpmNUMERICBehavioral CPMMargins by CPM Behavioral CPM
clicksNUMERICClicksPerformance Clicks
clickthrough_leadsNUMERICClickthrough LeadsConversions Clickthrough Leads
clickthrough_otherNUMERICClickthrough OtherConversions Clickthrough Other
clickthrough_salesNUMERICClickthrough SalesConversions Clickthrough Sales
clickthrough_signupsNUMERICClickthrough SignupsConversions Clickthrough Signups
context_cpmNUMERICContextual CPMMargins by CPM Contextual CPM
cpaNUMERICCPAConversions CPA
ctrPERCENTCTRPerformance CTR
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate.
day_of_monthTEXTDay of monthDay of the month
demographic_cpmNUMERICDemographic CPMMargins by CPM Demographic CPM
ecpcNUMERICeCPCPerformance eCPC
ecpmNUMERICeCPMPerformance eCPM
geo_cpmNUMERICGeographic CPMMargins by CPM Geographic CPM
impressionsNUMERICImpressionsPerformance Impressions
media_cpmNUMERICMedia CPMMargins by CPM Media CPM
monthTEXTMonthNumber of the month
platform_cpmNUMERICPlatform CPMMargins by CPM Platform CPM
search_term_cpmNUMERICSearch CPMMargins by CPM Search CPM
segment_cpmNUMERICSegment CPMMargins by CPM Segment CPM
sourceTEXTSourceThe name of the Windsor connector returning the row
todayDATETodayToday's date
total_spendNUMERICTotal SpendPerformance Total Spend
viewthrough_leadsNUMERICViewthrough LeadsConversions Viewthrough Leads
viewthrough_otherNUMERICViewthrough OtherConversions Viewthrough Other
viewthrough_salesNUMERICViewthrough SalesConversions Viewthrough Sales
viewthrough_signupsNUMERICViewthrough SignupsConversions Viewthrough Signups
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
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