Email Segments: Opt-Ins, Segment Rules and Contacts per Region
Lessons in this course
- Campaign Budget Tracker: Planned vs SpentFree
- Paid Channel Metrics: CTR, CPC, CPM, Conversion Rate, CPA and ROAS Locked
- Email Campaign Stats: Delivered, Open, Click and Unsubscribe Rates Locked
- Social Media Content Calendar: Posts per Platform and Week Locked
- Lead Funnel: Step Conversion and Visitors Needed Locked
- A/B Test: Rates, Lift and a Sanity Check Locked
- Cleaning a Lead List: TRIM, PROPER, LOWER and Duplicates Locked
- UTM Link Builder: Joining Text into Tracking Links Locked
- Event and Webinar ROI: Costs, Show-up Rate and Return Locked
- Monthly Marketing Report: Growth %, Conversion and a Trend Chart Locked
- Q3 Marketing Dashboard: ROAS by Channel, Chart and Highlights Locked
- From Raw Export to Summary: SUMIFS by Channel and Month Locked
- Mapping Table: Grouping Messy Source Names with XLOOKUP and IFNA Locked
- Campaign Timeline: Durations, Creative Deadlines with WORKDAY and Campaigns Live per Week Locked
- Vendor Invoices: Matching to Purchase Orders with XLOOKUP and Days Overdue Locked
- Social Post Performance: Engagement Rate, Averages by Format and the Top Post Locked
- Email Segments: Opt-Ins, Segment Rules and Contacts per Region Locked
- Event Kit Inventory: Needed Quantities, Shortfalls and Orders in Full Packs Locked
- Event Feedback Survey: Score Groups, the Score Distribution and NPS Locked
- Final Project: The Quarterly Marketing Pack – Budget Use, CPA, ROAS, Review Flags and a Combo Chart Locked