Custom Excel Functions

Reusable logic for real business work.

Modern Excel functions built for recurring marketing, reporting, and operational calculations.

Reusable Microsoft 365 Excel functions for advertising, campaign reporting, pacing, performance calculations, and recurring marketing analysis.

Marketing

MKT_FREQUENCY

Calculate average ad frequency from impressions and reach for media reporting.

=MKT_FREQUENCY(IMPRESSIONS, REACH, [NUMERIC])

View function

Marketing

MKT_CPA

Calculate cost per acquisition or conversion from spend and conversions in Excel.

=MKT_CPA(SPEND, CONVERSIONS, [NUMERIC])

View function

Marketing

MKT_CPC

Calculate cost per click from spend and clicks with reusable Excel LAMBDA logic.

=MKT_CPC(SPEND, CLICKS, [NUMERIC])

View function

Marketing

MKT_CPCV

Calculate cost per completed view from spend and video completions in Excel.

=MKT_CPCV(SPEND, COMPLETIONS, [NUMERIC])

View function

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])

View function

Marketing

MKT_CTR

Calculate click-through rate from clicks and impressions with formatted percent or numeric decimal output.

=MKT_CTR(CLICKS, IMPRESSIONS, [NUMERIC])

View function

Marketing

MKT_ROAS

Calculate return on ad spend from revenue and spend with a reusable Excel marketing function.

=MKT_ROAS(REVENUE, SPEND, [NUMERIC])

View function

Marketing

MKT_VCR

Calculate video completion rate from completions and starts with formatted percent or numeric decimal output.

=MKT_VCR(COMPLETIONS, STARTS, [NUMERIC])

View function