Dashboard channel reporting

[SushankSinha]

Summary

The dashboard's channel reporting has several gaps that make the numbers inconsistent and incomplete. Per-channel tabs do not sum to the Overview, paid Google Ads is counted together with organic Google, several real channels are misclassified into "Other", and the channel tabs have no trend chart.

Problems

1. Tabs do not reconcile with the Overview. The YouTube / LinkedIn / Google tabs classify sessions by the converting session's first pageview only and are driven by the redirect join, so conversions recovered by the session-source attribution get dropped. Each tab's conversion total reads lower than the Overview's count for that channel.

2. Google Ads and organic Google are merged. Paid clicks (utm_source=google, utm_medium=cpc / demand_gen) land in the same "Google" bucket as organic search, so paid performance cannot be read on its own.

3. Real channels leak into "Other". Several signals are not routed to their channel:

   • utm_source=google (Google Ads with no google referrer)
   • utm_medium=youtube / utm_medium=linkedin on links mis-tagged utm_source=description (a video-description link, where utm_medium carries the real channel)
   • Brevo click-tracking subdomains (e.g. *-brevo.net) not matched by the email rule
   • utm_source values for AI chat (chatgpt / perplexity / copilot) that only the referrer rule caught
   • regional search engines (ecosia, regional Yahoo)

Expected behaviour

• Each channel tab's conversion total equals the Overview's count for that channel.
• Google Ads is its own channel (Overview card + sidebar tab + endpoint), separate from organic Google.
• utm_source / utm_medium / referrer signals route to the correct channel, and the Other drill-down labels are accurate (no real channel sitting raw in Other).
• Each channel tab shows the same growth chart as the Overview, populated with that channel's daily + all-time-cumulative conversions.