MKT_
Marketing Excel Functions
Reusable Microsoft 365 Excel functions for advertising, campaign reporting, pacing, performance calculations, and recurring marketing analysis.
The MKT_ prefix identifies functions from the Marketing library.
Marketing
MKT_FREQUENCY
Calculate average ad frequency from impressions and reach for media reporting.
=MKT_FREQUENCY(IMPRESSIONS, REACH, [NUMERIC])Marketing
MKT_CPA
Calculate cost per acquisition or conversion from spend and conversions in Excel.
=MKT_CPA(SPEND, CONVERSIONS, [NUMERIC])Marketing
MKT_CPC
Calculate cost per click from spend and clicks with reusable Excel LAMBDA logic.
=MKT_CPC(SPEND, CLICKS, [NUMERIC])Marketing
MKT_CPCV
Calculate cost per completed view from spend and video completions in Excel.
=MKT_CPCV(SPEND, COMPLETIONS, [NUMERIC])Marketing
MKT_CPM
Calculate cost per thousand impressions from campaign spend and impressions using a reusable Microsoft 365 function that supports single cells, ranges, Trim References, spilled arrays, and optional numeric output.
=MKT_CPM(SPEND, IMPRESSIONS, [NUMERIC])Marketing
MKT_CTR
Calculate click-through rate from clicks and impressions with formatted percent or numeric decimal output.
=MKT_CTR(CLICKS, IMPRESSIONS, [NUMERIC])Marketing
MKT_ROAS
Calculate return on ad spend from revenue and spend with a reusable Excel marketing function.
=MKT_ROAS(REVENUE, SPEND, [NUMERIC])Marketing
MKT_VCR
Calculate video completion rate from completions and starts with formatted percent or numeric decimal output.
=MKT_VCR(COMPLETIONS, STARTS, [NUMERIC])