Brand marketing analytics compares coded survey measures with sales for the same regions and periods. Build a checked spreadsheet comparison, distinguish percentage points from growth rates, and avoid treating an association as proof of incremental sales.
Brand marketing analytics compares coded brand survey scores with sales trends for the same regions and periods. Calculate the survey measure from valid responses, reconcile net sales independently, and then place the results side by side. The comparison can guide investigation and budget questions; it cannot prove sales caused by brand activity.
Start with one question and a written coding rule. In this example, a US household-cleaning brand measures aided awareness: respondents are shown the brand name and asked whether they have heard of it. Code valid yes responses as numeric 1 and valid no responses as numeric 0. Exclude skipped and invalid responses from the denominator.
Do not combine aided awareness with an unaided recall question under the same label. Keep wording, audience eligibility and collection method consistent between periods. Record any questionnaire change next to the result, because a different question may measure something different even when the chart heading stays the same.
For the broader survey design and evidence questions, see marketing research analytics. This article covers the narrower task of comparing an already coded survey export with commercial results.
Create a Survey tab with response ID in A, region in B, period in C, and the numeric awareness code in D. Each row represents one eligible respondent's completed questionnaire. Resolve repeated response IDs under a documented rule before totaling responses.
Use E for a valid-answer flag and F for an aware-answer flag. In E2, enter this Google Sheets formula and fill down:
=IF(AND(ISNUMBER(D2),OR(D2=0,D2=1)),1,0)
In F2, enter this formula and fill down:
=IF(E2=1,D2,0)
The numeric test prevents a blank from being treated as a valid zero. An invalid value remains flagged out even if it looks like a score. Retain the original answer code so a reviewer can inspect exclusions rather than accepting a cleaned total without evidence.
Create a Sales tab with invoice or credit ID in A, region in B, period in C, and net sales in USD in D. Enter credits with the sign used by your reconciliation and apply one consistent period rule. Tie the included sales to the finance report for the same business scope.
The survey region should describe the market being measured; the sales region should cover the same territory. Do not multiply invoice rows by respondent rows. Aggregate each export first, then compare the region-period totals. Choosing analytics software for CPG brands covers related file and business-boundary questions.
On a Summary tab, put region in A, period in B, valid responses in C, aware responses in D, awareness rate in E, and net sales in F. Count valid responses in C2:
=SUMIFS(Survey!$E$2:$E$5000,Survey!$B$2:$B$5000,A2,Survey!$C$2:$C$5000,B2)
Count aware responses in D2:
=COUNTIFS(Survey!$B$2:$B$5000,A2,Survey!$C$2:$C$5000,B2,Survey!$D$2:$D$5000,1,Survey!$E$2:$E$5000,1)
Calculate the awareness rate in E2:
=IF(C2=0,"",D2/C2)
Sum net sales in F2:
=SUMIFS(Sales!$D$2:$D$5000,Sales!$B$2:$B$5000,A2,Sales!$C$2:$C$5000,B2)
Google documents COUNTIFS for counting rows that meet multiple criteria, and SUMIFS for summing values under multiple criteria. Extend the ranges to include your full export. Covirage is not affiliated with Google.
The illustrative company has the following unweighted survey counts and net sales for the first and second quarters of 2026. The survey is a respondent comparison, with no claim that it represents every purchaser in the market.
| Region | Period | Valid responses | Aware responses | Aided awareness | Net sales (USD) |
|---|---|---|---|---|---|
| East | Q1 | 200 | 100 | 50.0% | 1,000,000 |
| East | Q2 | 250 | 150 | 60.0% | 1,100,000 |
| West | Q1 | 100 | 40 | 40.0% | 800,000 |
| West | Q2 | 200 | 100 | 50.0% | 840,000 |
East's first-quarter score is 100 / 200 = 50.0%; its second-quarter score is 150 / 250 = 60.0%. Sales grew by (1,100,000 − 1,000,000) / 1,000,000 = 10.0%. West's score rises from 40 / 100 to 100 / 200 while sales growth is (840,000 − 800,000) / 800,000 = 5.0%.
Awareness change in percentage points = (Later awareness rate − Earlier awareness rate) × 100
Sales growth = (Later net sales − Earlier net sales) / Earlier net sales
| Region | Awareness change (percentage points) | Sales change (USD) | Sales growth |
|---|---|---|---|
| East | 10.0 | 100,000 | 10.0% |
| West | 10.0 | 40,000 | 5.0% |
| Combined, using actual response counts | 8.9 | 140,000 | 7.8% |
The combined first-quarter survey rate is (100 + 40) / (200 + 100) = 46.7%. The second-quarter rate is (150 + 100) / (250 + 200) = 55.6%. Their difference, calculated before rounding, is 8.9 percentage points. All displayed percentages and point changes are rounded to one decimal place.
Sales reconcile to $1,800,000 in Q1 and $1,940,000 in Q2. The change is $140,000, matching 100,000 + 40,000. Growth is 140,000 / 1,800,000 = 7.8%. Divide summed dollars for the total; do not average regional growth rates.
Why is combined awareness growth smaller than either regional increase? The regional mix of respondents changed. Holding the Q1 response mix fixed gives a Q2 score of (60% × 200 + 50% × 100) / 300 = 56.7%, a 10.0-point increase from the unrounded Q1 score. This diagnostic holds the observed regional mix constant; it does not establish population representativeness.
Both regions show the same awareness increase but different sales growth. Ask about pricing, distribution, customer mix and availability before allocating the difference to brand work. The brand lead owns the question and coding; the research owner checks respondent comparability; finance or sales operations owns the revenue reconciliation.
As NIST explains, association does not establish causality. A causal claim needs evidence beyond these regional aggregates. Describe the result as observed awareness and sales movement, and identify what additional investigation would change the commercial decision. An analytics RFP built around decisions and deliverables can make that evidence requirement explicit.
Bring a sample of your own coded survey export and regional sales file to Covirage. Covirage maps the columns; its tools compute and check the comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring your own files.
See sales insights in Covirage for the supporting business context.
Yes, if the geography, period, target audience and sales coverage are compatible. Aggregate each source separately, then compare the regional results. A survey respondent does not need to be matched to a customer record for this aggregate comparison, and association does not establish causation.
Keep missing answers distinguishable from valid negative responses. For a binary awareness question, a valid no can be coded zero, while a skipped or invalid answer stays outside the denominator. Publish the coding rule and valid response count with each score.
Subtracting one percentage score from another gives a change in percentage points. Sales growth divides the change in dollars by starting sales and is a percentage. Label the two measures separately so a reader does not mistake a score difference for a relative growth rate.