4 P's analysis: connect the marketing mix to your data

A 4 p's analysis connects product, price, place and promotion to evidence from sales, costs and campaign records. It turns a marketing discussion into a decision about what to sell, at what realized price, through which channel and with what promotional spending.

The four parts belong together. A discount can increase units while channel fees and campaign costs leave less money to cover the business's fixed expenses.

Turn the four Ps into measurable questions

The OpenStax explanation of the marketing mix defines the four Ps as product, price, place and promotion. For a commercial review, give each one a question that your files can answer.

This review describes observed results. It does not assign causal credit to a campaign or estimate how many purchases would have happened without it. Keep that limit visible when a team wants to move a budget based on a single reporting period.

Start with the exports you already have

Use one completed month and one currency. Export fulfilled order lines with order date, order identifier, product code, channel, units and net sales after discounts and credits. Exclude sales tax collected for a taxing authority. List shipping income separately if it is included in reported revenue.

Match the cost of the units sold by product and period. Bring channel fees and variable fulfillment costs from their own reports, then campaign spending from the marketing cost file. Keep actual spending separate from the approved budget.

Join summaries at a common level, such as product and channel. Never attach an entire campaign budget to every order carrying the campaign tag: that repeats the same cost. If a shared cost needs allocation, retain both the allocation rule and an unallocated balance until the owner approves it.

The SBA's marketing and sales guidance recommends tracking marketing costs and measuring the plan against its results. For this analysis, that means recording spending alongside sales rather than presenting a campaign revenue total on its own.

Work the same rows through all four questions

A fictional US kitchenware distributor reviews January 2026. Its two products sell through its website and a marketplace. The following summary contains only fulfilled sales with no returns; campaign spending is assigned once to each commercial group. All monetary columns are USD.

Put these columns in A:G, with the first data row in row 2. Enter the following formulas in H2, I2, J2 and K2 respectively: realized price, gross profit, gross margin and contribution after the listed variable costs.

=D2/C2
=D2-E2
=I2/D2
=D2-E2-F2-G2

Fill down through row 5. Format money to two decimals and margins to one decimal place; keep full precision in the underlying calculations.

The total realized price is total sales divided by total units. It reflects product mix as well as pricing, so it is not a price increase measure. The gross profit margin guide explains the revenue denominator and the difference between margin and markup.

Read the results as connected decisions

Product: Premium contributes $13,800, from $10,800 plus $3,000. Basic contributes $12,000, from $10,000 plus $2,000. That supports checking availability and demand for Premium. It does not prove that removing Basic would improve total profit; customers may buy the products for different reasons.

Price: Basic realizes $40 on the website and $36 on the marketplace. Hold marketplace volume and all listed costs constant, and raising its realized price to $38 produces $15,200 of sales: 400 × $38. Contribution becomes $2,800, from $15,200 − $8,000 − $2,400 − $2,000, an $800 increase. This is a scenario, not evidence that demand would remain unchanged.

Place: Website contribution is $20,800 on $88,000 of sales, or 23.6%. Marketplace contribution is $5,000 on $30,600, or 16.3%. Compare service requirements and customer reach before changing distribution. A channel can earn less per order while reaching buyers the website does not reach.

Promotion: Campaign costs belong in the contribution calculation. A larger tagged revenue total may reflect a larger existing customer base, a different product mix or purchases that would have happened anyway. Use these rows to decide where a controlled campaign comparison is needed, rather than declaring a winning causal return.

Reconcile the answer before presenting it

Summarize the website sales and contribution with conditional totals:

=SUMIFS(D2:D5,B2:B5,"Website")
=SUMIFS(K2:K5,B2:B5,"Website")

The checks are $88,000 and $20,800. The marketplace balance must bring both columns back to the company totals.

The overall identity is $118,600 − $61,000 − $18,300 − $13,500 = $25,800. Tie sales to the sales register, product cost to the corresponding inventory cost report, and campaign spend to the marketing cost file. Document timing differences instead of allocating them away to make the table fit.

Agree which costs sit inside contribution before circulating it. The distinction between gross, contribution and net margins matters because fixed overhead, interest and taxes are outside this example. Put the approved measures into a sales dashboard appropriate to its reader, with a named owner and next action.

Where it goes wrong

• Counting a discount twice. If net sales already deduct the discount, do not subtract it again as campaign spending.
• Mixing periods. A campaign invoice booked later can make the current period look more profitable unless the review states its cost timing.
• Duplicating shared spending. Campaign costs copied onto every order inflate costs and distort channel comparisons.
• Treating tags as proof of causation. Recorded campaign associations do not establish incremental sales.
• Comparing unlike cost scopes. One channel with fulfillment included and another without it cannot support a fair contribution decision.

Review your own marketing mix in Covirage

Bring an order export, matching product costs and a campaign spending file. Covirage maps the columns, and its tools compute and check the figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See how this supports revenue driver analysis.