Measure email campaign traffic

The product team needs the email-driven traffic numbers by Monday. Pull the last 14 days for the email newsletter campaign, report sessions, new users, bounce rate, and conversion rate on the promotional landing page. Export the data, check that the email medium was tagged as email and that the landing page event matches the email CTA, then send the CSV to Priya and paste a two-paragraph summary in Slack.

Before I send the email performance summary to the head of retention, make it reviewer-friendly. Surface opens-driven sessions and the top three landing pages by conversion up front, show the drop-off point in the funnel, and call out any email links that drove clicks but landed on pages without the expected tracking. Add a short line on whether the list segment performed above or below baseline.

Our email open rate is healthy, but sessions from the campaign have low conversion on the promoted landing page. The retention lead will blame the creative, but I suspect tracking or mismatched landing pages. I don’t know if a redirect or parameter stripping is happening. What should I check first and what wording should I use to update the retention lead while we investigate?

I keep rebuilding the same email performance view by joining click and landing-page metrics across different reports. It wastes my Fridays. What consistent habit, naming convention, or small automation would remove this repetitive work and make email campaign traffic visible with one query?