Connect with us

Marketing

How to (Easily) Make Perfect Content Calendars in Google Sheets

Published

on

How to (Easily) Make Perfect Content Calendars in Google Sheets


What do you use spreadsheets for? If you’re anything like me, you likely use them to collect data, track campaign or blog post analytics, or keep track of weekly assignments.

But have you ever thought about using spreadsheets to make a calendar? If not, let me tell you why Google Sheets is the perfect tool for your content calendar.

If you often work on campaigns for a few different clients, creating individual calendars in Google Sheets could be uniquely useful for ensuring the client understands when certain content will go live. Alternatively, perhaps you need to create an internal Google Sheet calendar for your team to keep track of upcoming projects.

Making a calendar in a tool that’s commonly used for spreadsheets sounds a little intimidating, but don’t worry, the process is actually pretty intuitive. And with the help of some tips, you can easily make a functional calendar that you can sync your schedule with.

Below, we’ll go over how to make a calendar in Google Sheets and include some tips that’ll help you elevate the design. At the end, your calendar will look something like this:

Google Sheets calendar January to MayOpen up Google Sheets and get ready to create your very own calendar. 📅

1. Open a new spreadsheet and choose your month.

First, open a new spreadsheet

Then, choose your month. For this example, I decided to do January 2022, so I filled that into the first cell. What’s great about Google Sheets is that it automatically recognizes dates, so typing in a month, followed by the year in YYYY format will tell Google that you’re going to be working with dates.

2. Begin to format your calendar.

Next, format your calendar. I selected the text, January 2022, in Column A, Row 1. I highlighted seven columns (A-G), and clicked Merge to make that cell span across the entire column. You can find this button to the right of the Fill tool.

Formatting the January title in a Google Sheets calendar

Here, I also center-aligned my text using the tool next to Merge. Then, I increased the font size and bolded the month.

3. Use a formula to fill in the days of the week.

Next, fill in the days of the week in each column (A-G). You can do this manually but I decided to use a formula. Sheets has a function that lets you type in formulas to complete certain actions at once.

To fill in days of the week, in the cell where you want your first weekday to be, type: =TEXT(1, “DDDD”). What this tells Google is that your number will be replaced by a date or time and the format you’re using is weekdays.

Entering the weekday formula in a Google Sheets calendarHighlight the number 1 in the formula and replace it with: COLUMN(). Then, press enter and select your first day. You’re going to copy the formula in Sunday’s cell by dragging the selector to the end of your row, (A-G), and pressing enter again.

Filling in the weekdays in a Google Sheets calendarPressing enter should automatically fill in the rest of the week. Remember, if this doesn’t work for you, you can always fill in the days manually.

Pressing enter should automatically fill in the rest of the week. Remember, if this doesn’t work for you, you can always fill in the days manually.

4. Fill in the numbers.

Excellent! You have your days of the week. Now we’re going to fill in the numerical values. Before this step, I took the time to add color to the days row and changed the font to one I liked a little more.

For the numerical values, we’ll simply identify the first day of the month and click and drag to fill in the rest.

How?

Place the number 1 on the box right underneath the first day of the month, then click and drag horizontally. Depending on the day of the week, you may need to follow this process using the second day of the month so you can click and drag horizontally.

Putting the first day of the month in a Google Sheets calendar

5. Fill in the rest of the numbers.

Note: In this step, I filled in the calendar numbers every other row to help with my formatting later.

Now that you’ve filled out your first row, it’s time to fill in the rest. Manually insert the next number under “Sunday,” then click and drag horizontally to fill in the rest.

Repeat the process for the next rows. You’ll insert the first number manually, then click and drag down the row. Here’s what that looks like for the next row in January.

Filling in the next row of day numbers in a Google Sheets calendar Note: Make sure to end the month on the right number! For January, that would be the 31st.

6. Reformat your calendar if necessary.

Everything is starting to look like a calendar, right? At this stage, I reformatted things to clean up the look of my calendar a little.

Remember those extra rows in between the numbered rows? I expanded those rows to create boxes underneath the numbers. To do this, I simply dragged the rows down to make those cells bigger.

Expanding the cells in a Google Sheets calendarHere are some additional formatting tips:

  • Select the empty rows underneath your numbers and center them using the center text alignment tool.
  • Select your entire calendar and vertically align all elements so that they’re in the center of their cells. To do this, use the vertical alignment tool.
  • Bold your day numbers.
  • If desired, lightly shade your numbered rows.
  • If desired, gray out the Saturday and Sunday columns so that your workdays stand out.

7. Add design elements to professionalize the look.

Finally, you can add in some fun design elements to personalize the look and feel of your calendar. If it’s for a client or upcoming project, you’ll want to incorporate the necessary launch days here.

Completed Google Sheets calendarFor this step, I added in a few fun images, included a few hypothetical calendar events, and played with font sizes.

8. Repeat the process from February to December.

It’s time to repeat for the month of February to December. Simply duplicate your January calendar once you’ve designed it how you want it to look. To do this, right-click the sheet’s tab and select Duplicate from the menu.

Duplicate tab option in Google Sheets To fill in the numbers, you’ll only need to know the beginning day, then click and drag to fill in the rest of the rows. Here are the first days for every month for the year 2022:

  • January: Saturday
  • February: Tuesday
  • March: Tuesday
  • April: Friday
  • May: Sunday
  • June: Wednesday
  • July: Friday
  • August: Monday
  • September: Thursday
  • October: Saturday
  • November: Tuesday
  • December: Thursday

Next, you’ll want to know how many days you’ll need to fill in. Here are the number of days you’ll need for each month:

  • January: 31
  • February: 28 or 29
  • March: 31
  • April: 30
  • May: 31
  • June: 30
  • July: 31
  • August: 31
  • September: 30
  • October: 31
  • November: 30
  • December: 31

And then, you’re done!

It’s handy to use Sheets because you can open your calendar right on your browser. You can also keep track of your schedule in a place that’s separate from your phone.

Alternatively, you can create important business documents such as social and editorial calendars. Below, I share a template that’s perfect for the task.

Google Sheets Calendar Template

Here’s an editorial calendar template for all of your editorial planning needs. This template helps you lay out a strong editorial strategy on a daily basis.

Featured Resource: Free Editorial Calendar Templates

Content Calendar Template Google Sheets

Download the Free Templates

Use a Google Sheets Calendar to Organize Your Tasks

If you’re handy with Sheets and want to give it a shot, create a Google Sheets calendar. It’s a great option if you need to create a clean calendar to track an internal marketing campaign, organize a client’s upcoming projects, or share an event calendar with key stakeholders. But if you don’t want to create one from scratch, use our editorial calendar template to jumpstart your planning and organization efforts immediately.

Editor’s note: This post was originally published in May 2020 and has been updated for comprehensiveness.

marketing editorial calendar templates



Source link

Continue Reading
Comments

Marketing

ActionIQ rebrands and launches CX Hub

Published

on

ActionIQ rebrands and launches CX Hub


Enterprise customer data platform ActionIQ has announced the launch of a new product, CX Hub. The company has also rebranded as AIQ. The CX Hub is designed as a set of modules offering self-service access to customer data, allowing users to build audiences and orchestrate experiences at scale.

After eight years of growth as a CDP serving B2C, media and other sectors, the changes represent a “new approach to our product and brand,” said CEO and co-founder Tasso Argyros in a release. The modular framework will ingest data from any source, integrate with any activation channel, and also allow components to be used with a third-party CDP.

The modules. CX Hub is comprised of four solutions:

  • Customer data platform.
  • Audience center.
  • Journey management.
  • Real-time CX.

The Hub is also designed to be accessible to business users with a friendly UI and extensive automation capabilities.


Get the daily newsletter digital marketers rely on.


Why we care. This is a significant development in the CDP space — a space that has been transforming rapidly, with many of the early established CDPs being acquired and ingested by more extensive suites such as digital experience platforms.

ActionIQ, one of the leading B2C CDPs, is now describing itself as “the leading CX solution.” It seems to be future-proofing itself by extending its capabilities across orchestration and execution channels, not by acquiring or building those solutions, but by seeking to provide modular integration between its (or a third-party’s) customer data management tool and orchestration and execution channels.

Sometimes we wonder how many independent, traditional CDPs will be left standing a year from now.

Read next: Deep changes in the CDP space


About The Author

Kim Davis is the Editorial Director of MarTech. Born in London, but a New Yorker for over two decades, Kim started covering enterprise software ten years ago. His experience encompasses SaaS for the enterprise, digital- ad data-driven urban planning, and applications of SaaS, digital technology, and data in the marketing space.

He first wrote about marketing technology as editor of Haymarket’s The Hub, a dedicated marketing tech website, which subsequently became a channel on the established direct marketing brand DMN. Kim joined DMN proper in 2016, as a senior editor, becoming Executive Editor, then Editor-in-Chief a position he held until January 2020.

Prior to working in tech journalism, Kim was Associate Editor at a New York Times hyper-local news site, The Local: East Village, and has previously worked as an editor of an academic publication, and as a music journalist. He has written hundreds of New York restaurant reviews for a personal blog, and has been an occasional guest contributor to Eater.



Source link

Continue Reading

Marketing

Old Navy to drop NFTs in July 4th promo update

Published

on

Old Navy to drop NFTs in July 4th promo update


Old Navy will update its yearly Fourth of July promotions by saluting the metaverse with an NFT drop, going live June 29.

In honor of the year they were founded, the retailer will release 1,994 common NFTs, each selling for $0.94. The NFTs will feature the iconic Magic the Dog and t include a promo code for customers to claim an Old Navy t-shirt at Old Navy locations or online.

“This launch is Old Navy’s first activation in web3 or with NFTs,” an Old Navy spokesperson told MarTech. “As a brand rooted in democratization and inclusivity, it was essential that we provide access and education for all with the launch of our first NFT collection. We want all our customers, whether they have experience with web3, to be able to learn and participate in this activation.”

Accessible and user-friendly. Any customer can participate by visiting a page off of Old Navy’s home site, where they’ll find step-by-step instructions.

There will also be an auction for a unique one-of-one NFT. All proceeds for the NFT and shirt sales go to Old Navy’s longtime charitable partner, Boys & Girls Clubs of America.

Additionally, 10% of NFT resales on the secondary market will also go to Boys & Girls Clubs.

Support. This activation is supported by Sweet, who’s played a major role in campaigns for other early NFT adopters like Burger King.

The Old Navy NFTs will be minted on the Tezos blockchain, known for its low carbon footprint.

“This is Old Navy’s first time playing in the web3 space, and we are using the launch of our first NFT collection to test and learn,” said Old Navy’s spokesperson. “We’re excited to enable our customers with a new way to engage with our iconic brand and hero offerings and look forward to exploring additional consumer activations in web3 in the future.”

Read next: 4 key strategies for NFT brand launches

Why we care. Macy’s also announced an NFT promotion timed to their fireworks show. This one will award one of 10,000 NFTs to those who join their Discord server.

Old Navy, in contrast, is keeping customers closer to their owned channels, and not funneling customers to Discord. Old Navy consumers who don’t have an NFT wallet can sign up through Sweet to purchase and bid on NFTs.

While Macy’s has done previous web3 promotions, this is Old Navy’s first. They’ve aligned a charity partner, brand tradition and concern for the environment with a solid first crack at crypto.


Get the daily newsletter digital marketers rely on.



About The Author

Chris Wood draws on over 15 years of reporting experience as a B2B editor and journalist. At DMN, he served as associate editor, offering original analysis on the evolving marketing tech landscape. He has interviewed leaders in tech and policy, from Canva CEO Melanie Perkins, to former Cisco CEO John Chambers, and Vivek Kundra, appointed by Barack Obama as the country’s first federal CIO. He is especially interested in how new technologies, including voice and blockchain, are disrupting the marketing world as we know it. In 2019, he moderated a panel on “innovation theater” at Fintech Inn, in Vilnius. In addition to his marketing-focused reporting in industry trades like Robotics Trends, Modern Brewery Age and AdNation News, Wood has also written for KIRKUS, and contributes fiction, criticism and poetry to several leading book blogs. He studied English at Fairfield University, and was born in Springfield, Massachusetts. He lives in New York.



Source link

Continue Reading

Marketing

Are you still using spreadsheets to manage your work? Take our poll

Published

on

Are you still using spreadsheets to manage your work? Take our poll


Earlier this year, revenue orchestration platform LeanData released a report suggesting that lead management remains a “heavily manual” process. Based on a survey of more than 1,700 sales, marketing and operations professionals, the results showed that, despite all the talk of digital transformation, the number two challenge for revenue teams was too many manual processes and not enough automation (the number one challenge was insufficient pipeline).

LeanData, which partnered with Sales Hacker, Outreach and Heinz Marketing in conducting the survey, is interested in that result, of course, because lead management is precisely the process they offer to automate. We were struck by the contrast with Scott Brinker’s recent statement that we are arriving at a post-digital-transformation era: “(C)ompanies are no longer planning to become ‘digital.’ They are digital.”

And then we got the results of our 2022 MarTech Career and Salary Survey. Among the surprising nuggets to be mined from our findings was that 77% of respondents identify spreadsheets as the tool they spend most time (10 or more hours a week) working with. That doesn’t mean that spreadsheets are a marketer’s most important tool, but it does suggest that manual processes remain a key part of daily life for marketing managers and staff.

We wanted to extend the opportunity to all our readers — B2B, B2C, agencies — to give us a reality check on spreadsheet use. MarTech is marketing, we like to say, and certainly today’s marketing is fundamentally data-driven and digital. But is it too soon to say that marketers are working in a digital and largely automated environment?

Download the 2022 MarTech Career and Salary Survey here


Get the daily newsletter digital marketers rely on.



About The Author

Kim Davis is the Editorial Director of MarTech. Born in London, but a New Yorker for over two decades, Kim started covering enterprise software ten years ago. His experience encompasses SaaS for the enterprise, digital- ad data-driven urban planning, and applications of SaaS, digital technology, and data in the marketing space.

He first wrote about marketing technology as editor of Haymarket’s The Hub, a dedicated marketing tech website, which subsequently became a channel on the established direct marketing brand DMN. Kim joined DMN proper in 2016, as a senior editor, becoming Executive Editor, then Editor-in-Chief a position he held until January 2020.

Prior to working in tech journalism, Kim was Associate Editor at a New York Times hyper-local news site, The Local: East Village, and has previously worked as an editor of an academic publication, and as a music journalist. He has written hundreds of New York restaurant reviews for a personal blog, and has been an occasional guest contributor to Eater.



Source link

Continue Reading

Trending

Copyright © 2021 Liveseo.com