Attribute social engagement to campaign

The system aggregates inbound mentions, outbound posts, lead ad submissions, and engagement metrics (likes, comments, shares, click-throughs) against a linked Campaign so marketing can measure ROI.

When this happens: (A) Hourly rollup job. (B) MU opens the Campaign dashboard.

Step by step

  1. 1

    Open Campaign — Social tab — sees per-post engagement, mention timeline, sentiment trend, attributed leads.

    Hourly job queries SocialPost metrics endpoints for each Published post linked to an Active Campaign and updates SocialPostMetricsSnapshot. Counts inbound mentions whose matched rules are linked to the Campaign and aggregates by sentiment. Counts Leads with Source LIKE 'Social%' attributed to the Campaign and rolls up to Campaign-level KPIs (CTR, lead count, MQL count, cost per lead if ad spend is loaded).

Other paths

Manual attribution of a mention

From the Social Inbox, multi-selects mentions — Attribute to Campaign — picks a Campaign. The mention's CampaignId is set and rollups include it on the next cycle.

Good to know

  • Metrics rollups use last-write-wins with a 1-hour cadence.
  • Historical snapshots are retained for 13 months for year-over-year comparisons.