Send-Time Analysis: Average CTR and RPR by Hour with AVERAGEIFS
This lesson is part of the course
In this lesson
You summarise 16 sends by hour with AVERAGEIFS, add a second condition for weekdays, find the best hour with INDEX/MATCH and colour the result with a colour scale.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- List Growth & Opt-in Sources: Rates, Shares and Cost per Opt-in Locked
- Message Segments & Cost per Send: Character Count, GSM-7 vs Unicode Locked
- Delivery Rate & Click-Through Rate per Campaign Locked
- Opt-out Rate & List Fatigue: How Often Is Too Often? Locked
- Revenue per Recipient, ROAS & ROI per Campaign Locked
- Automated Flows vs Campaigns: Abandoned Cart, Welcome & Broadcasts Locked
- Send-Time Analysis: Average CTR and RPR by Hour with AVERAGEIFS Locked
- SMS vs Email: Revenue, Cost & 12-Month Profit per Subscriber Locked