Digital Marketing Calendar

• All-in-One Marketing View
  Track emails, social, paid media, merchandising, events, and more in one central place
• Auto-Updating Dates
  Choose your year from a dropdown and the calendar updates automatically
• Today Highlighted
  Instantly see where you are in the calendar with a green-highlighted column for today’s date
• Past Days Marked
  Completed dates automatically turn black with a strikethrough so you can stay focused on what’s next
• Month Colour Coding
  Each month header has its own colour to help you visually navigate the calendar with ease
• Dropdown Status Options
  Easily update the progress of each activity with statuses like Proposed, In Progress, Scheduled, Sent, and more
• Email Category Dropdowns
  Categorise each email (Promo, SMS, Blog, Loyalty, etc.) for a clearer view of your strategy
• Easy to Duplicate for New Years
  Just duplicate the tab, rename it, and select the new year - everything updates automatically
• Works for Teams or Solo Use
  Whether you're coordinating with internal teams or external partners, this template helps everyone stay aligned

This Google Sheets template is built to make your marketing planning simple, visual, and efficient:

1. Choose Your Year - Select the year from a dropdown in Cell A1 - the calendar dates update automatically.
2. Track Daily Activity - Use the daily columns to input key marketing tasks: emails, social posts, paid campaigns, website updates, events and more.
3. Stay Organised with Status Dropdowns - Update progress with dropdown options like Proposed, Approved, In Progress, Subject to Change, Scheduled, Done or Sent.
4. Categorise Emails - Use the email section’s category dropdown to label each message as Promo, SMS, Blog, Loyalty, Regional, etc.
5. Visual Cues for Clarity - Today’s date is highlighted in green, past dates are blacked out with a strikethrough, and each month is colour-coded to help you scan quickly.
6. Duplicate for New Years - Simply duplicate the tab, rename it, and select a new year from the dropdown - the calendar will refresh automatically.

• A fully interactive Google Sheets marketing calendar
• Year selector with auto-updating daily dates
• Sections for Emails, Social Media, Paid Ads, Merchandising, Website Updates & Events
• Status dropdowns to keep track of each task’s progress
• Colour-coded months and visual highlights for today/past dates
• Email category dropdown for better organisation
• Instructions built in for easy use and duplication each year
• Placeholder logo cell (easily replace with your own)

Once you’ve completed checkout, you’ll receive an email with a link to access the Google Sheets template.

To start using it:

1. Open the link from your email
2. Make a Copy to save your own editable version in Google Drive
3. (Optional) Rename your copy if you need to
4. In Cell A1, select the desired year from the dropdown - the dates in row 1 will update automatically
5. To add your logo, click the placeholder image cell, then go to Insert > Image > Image in cell
6. You're all set - happy planning!