Social media marketing analytics: activity and outcomes

Social media marketing analytics compares campaign activity with matched orders, net revenue, and contribution. Keep engagement measures separate from commercial outcomes so a busy campaign does not automatically look like a profitable one. The practical starting point is your existing campaign, order, and cost exports.

Set the comparison before combining exports

Choose a reporting period, an order cutoff, and a campaign ID that stays stable across the files. State whether the comparison covers orders placed during the campaign or orders linked to campaign visits within an agreed window. Those populations can differ.

Prepare a campaign export with spend, impressions, engagements, and link clicks. Prepare an order export with unique order ID, campaign ID under your chosen matching rule, order date, net revenue, and variable cost. Use net revenue after discounts and returns, with the same treatment of shipping and sales tax for every campaign.

Campaign identifiers are useful because names can change. Google's campaign parameter documentation distinguishes campaign ID, source, medium, and campaign name. Retain those fields when they are present in your prepared exports; this analysis does not require collecting or publishing social content.

For the broader definitions, use social media marketing metrics. Keep this workbook focused on comparing the campaign results already recorded.

Build a campaign summary in your spreadsheet

For a US business comparing two campaigns, use columns A through H for campaign, spend, impressions, engagements, link clicks, matched orders, net revenue, and variable cost. The following tables show those columns in two groups so the activity and sales measures remain readable.

Aggregate orders before putting their totals beside campaign spend. A campaign cost repeated on every order row will overstate spend when summed.

Suppose the Orders sheet has campaign ID in B, order date in C, net revenue in D, and variable cost in E. Set N2 to the first included date and N3 to the first excluded date. Net revenue for the campaign in A2 is:

=SUMIFS(Orders!$D$2:$D$5000,Orders!$B$2:$B$5000,$A2,Orders!$C$2:$C$5000,">="&$N$2,Orders!$C$2:$C$5000,"<"&$N$3)

Use the same conditions against column E for variable cost. This follows the SUMIFS definition: sum a range only where all specified criteria match. Ensure the export fits inside the referenced range and dates are actual spreadsheet dates.

Covirage is not affiliated with Google or Microsoft.

Calculate activity and contribution separately

Use columns I through L for engagement rate, click-to-order rate, contribution before media, and contribution after media. Enter these Excel or Google Sheets formulas and fill down.

In I2, calculate engagement rate:

=IF(C2=0,"",D2/C2)

In J2, calculate click-to-order rate:

=IF(E2=0,"",F2/E2)

In K2, calculate contribution before media:

=G2-H2

In L2, subtract media spend:

=K2-B2

Rates are rounded to one decimal place; dollars are exact. The total engagement rate is 18,000 / 400,000 = 4.5%, and the total click-to-order rate is 110 / 5,000 = 2.2%. Divide totals rather than averaging campaign percentages.

The seasonal offer has higher engagement and click-to-order rates, but its matched contribution does not cover media spend. Product launch contributes $18,000 minus $10,800 minus $6,000 = $1,200 after media. Seasonal offer contributes $12,500 minus $8,750 minus $4,000 = negative $250.

These are recorded comparisons, not incremental profit estimates. Use social media marketing ROI for the separate return calculation and its cost boundary.

Prove the match and use the result

Reconcile the $30,500 of matched net revenue to the same orders in the sales export. The contribution check is $30,500 minus $19,550 = $10,950; subtracting $10,000 of spend leaves $950. Both campaign rows must reproduce that total.

Also show what did not match. The prepared order population contains the following counts:

Campaign coverage is 110 / 130 = 84.6%, rounded to one decimal place.

Do not assign the unmatched orders by guesswork. Marketing owns campaign definitions and activity totals; sales operations owns order matching; finance owns net revenue and cost reconciliation. Together they can investigate the seasonal offer's discount or product mix before changing spend. Social media audience analysis addresses the separate question of who responds.

Where it goes wrong

• Different engagement definitions. Reactions alone and reactions plus comments and shares are different measures. Document the included actions.
• Mixed denominators. Reach, impressions, followers, and clicks answer different questions. Never compare their rates under one label.
• Duplicated orders. One order appearing under multiple campaigns inflates commercial outcomes unless an explicit allocation rule preserves the total.
• Incomplete cost or return periods. Recent orders may lack returns or fulfillment costs. Mark the period provisional until those records mature.

Compare your social exports in Covirage

Bring your campaign summary and prepared order and cost export, or a Google Sheet with those rows, to Covirage; its columns are mapped and its tools compute and check activity rates, matched revenue, and contribution. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; account creation takes about a minute.

See sales insights for the business context behind these comparisons.