Skip to content
Email Campaign Calendar cover: a sample sheet with campaigns planned, emails sent and average open rate and a column chart, beside the Dashboard tab

Email Campaign Calendar

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Email Campaign Calendar is for a marketer or small business owner who sends newsletters, promotions and welcome messages on a regular cycle. The Campaigns tab lists each send with its date, type, audience segment, the number sent, opened and clicked, and a status from Planned to Sent. Open and click rates calculate themselves. The Segments tab holds the size of each audience, how often it is emailed and when it was last cleaned.

Plan the next six weeks of sends before the month begins, so audiences are not emailed too often. Enter the counts within a day or two of each send, because the email tool's figures change over the first few days. Review the segment table each quarter and remove addresses that bounce, then compare the open rate of each segment before choosing the next offer to test.

Useful for

  • Plan a holiday run of promotions and event invitations
  • Check how often each audience is emailed in a month
  • Compare open and click rates by campaign type and segment

What's included

  • 4 tabs: Dashboard, Campaigns, Segments, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Campaigns: a table
  • Segments: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Campaigns tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Why do the open and click rates show zero for planned sends?

The rates divide clicks and opens by the number sent, so they stay at zero until the sent count is filled in. Enter the figures after the send, and the rate appears on its own. The dashboard averages only include rows with the status Sent.

Should I count opens from one segment as a single figure?

Keep each segment separate, since an offer that works for lapsed customers may do poorly with new sign-ups. The segment table shows the average open rate for each group, which is more useful than one figure for the whole list.

How do I record a campaign that was sent to two segments?

Add one row for each segment, with the same campaign name and send date. Then the totals and averages on the dashboard reflect each audience. Use the same campaign name on both rows so you can filter them together later.

  • #content-calendar
  • #email-campaign-calendar
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More content calendar templates

See all 8

Also in Marketing

All marketing templates
Get this template

Preparing your template…