網絡營銷

如何在Google日曆中創建編輯日曆[免費模板]

Screen20Shot202019-10-2320at205.10.0420PM

我們從有抱負的和現在的入境營銷人員那裡得到的最常見問題之一是:“您如何管理所有這些內容?”

當我們告訴他們我們使用編輯日曆時,下一個問題通常是:“哦,這要多少錢?”

Nothing.沒有。 Because, for the most part, we use Google Calendar.因為在大多數情況下,我們使用Google日曆。

(實際上,對於那些是HubSpot客戶的人來說, 內置在HubSpot軟件中的營銷日曆。)但是,在嘗試了許多其他解決方案之後,我們的團隊發現,僅使用一個簡單的Google日曆,我們確實能發揮出最佳的性能。 In fact, this has actually been the longest-running editorial calendar solution our team has ever seen.實際上,這實際上是我們團隊有史以來運行時間最長的編輯日曆解決方案。

這是我們的設置方法。

跟著 免費的編輯日曆模板

HubSpot的博客編輯日曆-Excel中的免費模板免費下載模板

1. 下載HubSpot的免費編輯日曆模板。

First thing's first: Download the calendar templates, above (they're free.) By doing this, you'll have three editorial calendar templates on your computer to use at your leisure: one for Google Calendar, one for Excel, and one for Google Sheets.首先,首先:下載上面的日曆模板(它們是免費的)。這樣做,您可以在計算機上隨意使用三個編輯日曆模板:一個用於Google日曆,一個用於Excel,另一個用於Google表格。 In this blog post, we'll be going over在這篇博客文章中,我們將繼續 如何將Excel模板導入Google日曆.

2.自定義您的模板,並準備導入Google日曆。

默認情況下,您下載的模板上的發布日期將被標記為2016年。可以在電子表格本身中隨意將其更改為當前年份-您還可以將其上傳到文件中之後將其拖動到您選擇的日期。 Google日曆。

Google日曆可以輕鬆地將您可能已經在另一個程序中預先創建的日曆加載到Google中。 This includes Microsoft Excel.這包括Microsoft Excel。 Here's how to import the Excel calendar template you downloaded in the previous step into Google Calendar:以下是將您在上一步中下載的Excel日曆模板導入Google日曆的方法:

3.打開Google日曆。

Once you've downloaded (or, for that matter, created) a calendar that opens in Microsoft Excel, it's time to open Google Calendar.下載(或為此創建)在Microsoft Excel中打開的日曆後,就該打開Google日曆了。 Just make sure you're already logged into the Gmail account you want this calendar to give access to.只要確保您已經登錄了您希望此日曆可以訪問的Gmail帳戶即可。

4.使用左側的下拉菜單創建一個新日曆。

Now it's time to set up your Google Calendar to accommodate the information in your Excel spreadsheet.現在是時候設置您的Google日曆以容納Excel電子表格中的信息了。 First, go into your Google Calendar and click the plus sign to the right of “Other Calendars,” as shown in the screenshot below.首先,進入您的Google日曆,然後單擊“其他日曆”右側的加號,如下面的屏幕快照所示。 In the dropdown menu that appears, select “Create new calendar.”在出現的下拉菜單中,選擇“創建新日曆”。

在Google日曆中添加新日曆

5.填寫新日曆的詳細信息。

Fill out the fields that appear on the next screen.填寫下一個屏幕上顯示的字段。 This includes a brief description of your calendar, as shown below, to give people proper context when you invite them into this calendar.這包括對日曆的簡短描述,如下所示,以便在邀請人們加入該日曆時為他們提供適當的背景信息。 When you're done filling in the details, click “Create calendar.”填寫完詳細信息後,請點擊“創建日曆”。

在Google日曆中添加詳細信息以創建新日曆

6.從同一下拉菜單中導入XLS或CSV文件。

Using the same dropdown menu you used to create your editorial calendar, you'll now import the Excel file itself into Google Calendar.使用與創建編輯日曆相同的下拉菜單,現在將Excel文件本身導入Google日曆。 Click that plus sign and select “Import.”點擊該加號,然後選擇“導入”。

單擊顯示為“從計算機中選擇文件”的上載框,然後找到在上面的步驟1中下載的ZIP文件中包含的標題為“博客編輯日曆– Excel”的文件。

7.選擇要將此文件添加到的日曆。

In the second box below your imported file, click the “Add to calendar” dropdown.在導入文件下方的第二個框中,單擊“添加到日曆”下拉菜單。 Be sure to choose the name of the calendar you just created from the dropdown menu, as shown below.請確保從下拉菜單中選擇剛創建的日曆的名稱,如下所示。 Then, click “Import.”然後,點擊“導入”。

在Google日曆中導入Excel日曆

8.單擊導入。

Once you've uploaded your Excel file and selected the calendar you want to add this file to, click “Import.”上傳完Excel文件並選擇了要添加此文件的日曆後,請點擊“導入”。 You should see an Import calendar dialog box telling you that seven events were successfully imported.您應該看到一個導入日曆對話框,告訴您七個事件已成功導入。 Click “Close.”點擊“關閉”。

Now, if you didn't change the dates of the first seven assignments in the original Excel document, you can now.現在,如果您沒有更改原始Excel文檔中前七個作業的日期,則可以進行操作。 Navigate to January 3, 2016, which is the start of your calendar.導航到3年2016月10日,這是日曆的開始。 Be sure all of your other calendars are temporarily hidden by clicking the colored box to the left of the calendar name.通過單擊日曆名稱左側的彩色框,確保所有其他日曆都被暫時隱藏。 On the week of January 11, XNUMX, you should just see one “Blog TBD” calendar event on each day from XNUMX am to XNUMX am在XNUMX年XNUMX月XNUMX日那一周,您應該每天從上午XNUMX點到上午XNUMX點看到一個“博客待定”日曆活動

Use the edit window of each assignment to change the publish date.使用每個作業的編輯窗口來更改發布日期。 For example, if you're satisfied with the 10 am publish time, you can simply change the date from January X, 2016 to January X, 2019. Each assignment will then appear as event blocks in your 2019 monthly calendar view.例如,如果您對上午XNUMX點發佈時間感到滿意,則可以將日期從XNUMX年XNUMX月X日更改為XNUMX年XNUMX月X日。然後,每個作業將在您的XNUMX年月曆視圖中顯示為事件塊。

9.確定您的發佈時間表。

Now that you have your calendar created, it's time to fill it in with assignments for the year.現在您已經創建了日曆,是時候填寫該年度的作業了。 This is when you have to make some decisions about your blog's publishing schedule.這是您必須對博客的發佈時間表做出一些決定的時候。

閱讀這篇博文 有關公司應多久發布一次博客的一些重要基準數據。)

如果決定減少要發布的天數,請單擊當天的日曆事件,然後選擇“刪除”。

Even if you wanted to publish multiple times a day, updating this calendar is as easy as adding an event.即使您想一天多次發布,更新此日曆也像添加事件一樣容易。 Select a slot on your calendar to add another “Blog TBD” event and copy the default description from another one of the events you imported.在日曆上選擇一個插槽,以添加另一個“博客待定”事件,並從導入的另一個事件中復制默認描述。

Next, it's time for some minor adjustments.接下來,是時候進行一些小的調整了。 Currently, the “Blog TBD” events are set for 10 am Feel free to move these events to whichever time your blog publishes during the day.目前,“博客待定”活動設置為上午XNUMX點。您可以隨時將這些活動移至您博客在白天發布的任何時間。

10.設置重複事件。

Now that you have your publish dates and times set, you can make these recurring events on your calendar.現在您已經設置了發布日期和時間,您可以在日曆上進行這些重複事件。 If you have a regular publishing schedule, like every Monday, Wednesday, and Friday at 10:00 am, then put that in as a recurring “slot” on your calendar.如果您有常規的發佈時間表,例如每個星期一,星期三和星期五的上午XNUMX:XNUMX,則將其作為日曆中的重複“版位”放入。 It's okay if you don't have a piece of completed content — or even a working title — to put there yet.如果您還沒有完整的內容,甚至沒有工作標題,也可以放在那裡。 It's just a reminder that you want to publish只是提醒您您要發布 東西 那天。

To add your recurring slot, click on your first “Blog TBD” event and click the pencil icon to edit your event.要添加定期槽,請單擊第一個“博客待定”事件,然後單擊鉛筆圖標以編輯您的事件。 This will take you to the details of the post, where you can create a custom recurring schedule for each assignment, as shown in the screenshot below.這將帶您到帖子的詳細信息,您可以在其中為每個作業創建自定義重複計劃,如下面的屏幕快照所示。

在Google日曆中為重複活動設置自定義重複計劃您可以將帖子設置為定期發布,這樣它就會在每個星期一,星期三和星期五的上午10:00(或您想要的任何日期和時間)自動顯示。

在Google日曆中為重複事件設置自定義重複

選擇重複日期後,點擊“完成”和“保存”,您將擁有一個可使用的編輯日曆框架。

For now, keep the title of the event as “Blog TBD,” but feel free to customize the description with any extra details you want to be sure you include for each post.現在,將事件的標題保留為“ Blog TBD”,但隨時可以使用您想要確保包含在每個帖子中的任何其他詳細信息來自定義說明。 Wait to invite any guest, as we'll use this to assign posts to an author once you begin filling in your topics.等待邀請任何來賓,因為一旦您開始填寫主題,我們將使用它為作者分配帖子。 With everything complete, click “Save.”完成所有操作後,單擊“保存”。

If you don't have a recurring schedule like this, you might not be in need of an editorial calendar just yet — but it is a good way to set goals for yourself.如果您沒有這樣的定期計劃,則可能還不需要編輯日曆,但這是一個為自己設定目標的好方法。 If you know you want to publish a certain number of posts each week, even if you don't hit every single slot, it's a good reminder for yourself and your team that this is something you should all be striving for.如果您知道您想每週發布一定數量的帖子,即使您沒有按時完成任務,那麼這對您本人和您的團隊也都是一個很好的提醒,那就是大家都應該努力。

11.填寫您的發布位。

現在,您知道了所有插槽 (如果您還沒有主題創意, 看看這個免費的主題創意產生器。 It'll give you some good ideas for content to put in the calendar.)它將為您提供一些將內容放入日曆的好主意。)

Let's say one of the posts you want to write is “10 Surprising Facts About Tapirs,” and one of the posts you've already written and want to publish later is “Think You're Cut Out to Own a Tapir?假設您要撰寫的文章之一是“關於Tap的十個令人驚訝的事實”,而您已經撰寫並要在以後發布的文章之一是“認為您被割讓要擁有a嗎? Read This First.”請先閱讀此內容。” Cool!涼! Just add 'em both to the calendar by clicking on “Post – TBD” on the correct date, choosing “Edit Event,” and then changing the “Post – TBD” text to the actual title of the post.只需在正確的日期單擊“發布-TBD”,然後選擇“編輯事件”,然後將“發布-TBD”文本更改為帖子的實際標題,即可將它們都添加到日曆中。

在Google編輯日曆中更改帖子的名稱

Now, let's say you don't actually want to write “10 Surprising Facts About Tapirs,” and you want your colleague to write it instead.現在,假設您實際上不想寫“關於Tap的十個令人驚訝的事實”,而是希望您的同事來寫。 To assign the post an author, you'll invite them to the event as a guest.要為帖子分配作者,您將以邀請對象的身份邀請他們參加活動。 To do this, click on the event, hit “Edit Event,” then invite that colleague to the post by typing his or her name or email address into the “Add guests” box, selecting “Add” when their name pops up, and hitting “Save” on the event once you're done.為此,請單擊事件,單擊“編輯事件”,然後通過在“添加邀請對象”框中鍵入其姓名或電子郵件地址邀請該同事加入該帖子,並在他們的名字彈出時選擇“添加”,然後完成後,在活動中點擊“保存”。

在Google日曆中添加邀請對象

現在,任何人都可以看到誰負責撰寫該時段內的最新帖子。

You can take it a step further by adding details to the “Description” box of the event, as shown in the large box in the screenshot above.您可以通過將詳細信息添加到事件的“描述”框中來進一步進行操作,如上面的屏幕快照中的大框所示。 You might include a quick synopsis, the keywords you plan to target the post for, the target audience you're trying to reach, and the offer or CTA you will direct the reader to at the end of the post.您可能需要提供一個簡短的摘要,計劃將帖子定位到的關鍵字,您要覆蓋的目標受眾以及將讀者導向到的報價或CTA。 Don't forget a due date for the draft.不要忘記草稿的到期日。

Before Google Calendar will let you save the event, you'll see a dialog box asking if you would like to change just this event or all of the events in the series.在Google日曆允許您保存事件之前,您會看到一個對話框,詢問您是否要僅更改此事件還是更改系列中的所有事件。 Select “Only this event.”選擇“僅此事件”。

編輯週期性事件以僅保存此事件

重複這些步驟以分配今天和將來的每個博客主題。

12.與他人共享您的編輯日曆。

Now that you have your calendar set up, you can start to invite people to see it.現在您已經設置了日曆,就可以開始邀請人們查看日曆了。 I'd recommend you start with your immediate team and regular contributors — as well as anyone who regularly asks you about publishing content on your company blog.我建議您從您的直接團隊和常規貢獻者開始,以及任何經常問您有關在公司博客上發佈內容的人。

To share this editorial calendar with people, simply find your editorial calendar under “My Calendars,” as shown below.要與他人共享此編輯日曆,只需在“我的日曆”下找到您的編輯日曆,如下所示。 Click the three dots next to the calendar name and then select “Settings and sharing” when it appears in the dropdown menu.點擊日曆名稱旁邊的三個點,然後在下拉菜單中選擇“設置和共享”。 You'll be taken to the same screen we saw when you first filled out the details of your editorial calendar in Step 2.您將進入第XNUMX步中首次填寫編輯日曆的詳細信息時所看到的屏幕。

在Google日曆中共享設置然後,您可以添加要與之共享日曆的人員的姓名,並為每個被邀請者設置正確的權限級別。

明智的做法是將那些權限設置保持在最低限度,以便進行更改和共享管理,這樣廚房裡的廚師就不會太多了,但是我建議您讓所有人看到所有事件的詳細信息,以便清楚地了解每個事件的內容。插槽。

Under the “Share with specific people” heading, enter the email addresses of those on your content team and decide if they have viewing, editing, or admin privileges.在“與特定人員共享”標題下,輸入內容團隊中人員的電子郵件地址,並確定他們是否具有查看,編輯或管理權限。 Save your updated settings.保存更新的設置。

為什麼使用Google日曆作為編輯日曆

I mentioned earlier that we tried a lot of different editorial calendar solutions, and this is the only one that's stuck for more than a couple months.前面我提到過,我們嘗試了許多不同的編輯日曆解決方案,這是唯一停留了兩個多月的解決方案。 I think one reason for that is because we use Gmail for our corporate email, which means everyone on our team is already in Gmail (and their calendar, specifically) all day.我認為其原因之一是因為我們將Gmail用於公司電子郵件,這意味著我們團隊中的每個人都已經整天都在Gmail(尤其是他們的日曆)中。 As a result, it isn't hard for people to form a habit of checking the editorial calendar, because it's not difficult for them to find it.結果,人們不難養成檢查編輯日曆的習慣,因為找到它並不困難。

Google日曆還使事情變得非常容易移動和安排,因為……好吧……它已經是一個日曆。 It has all the functionality you need to schedule stuff out and let the people who need to know about it know.它具有您所需的所有功能,可用於安排工作安排並讓需要了解的人員知道。 When we were using other solutions for this, we were trying to hack a calendaring function instead of just relying on one that already existed.當我們為此使用其他解決方案時,我們試圖破解一種日曆功能,而不是僅僅依靠已經存在的功能。

沿著這些思路,添加人員來查看您的日曆非常簡單,這使多個團隊可以輕鬆地進行協作,查看正在發布的內容以及確定何時可以啟動內容和廣告系列。

Finally, this sets a precedent for other teams to coordinate with you in a really simple way.最後,這為其他團隊以非常簡單的方式與您進行協調開創了先例。 You can have a calendar for upcoming campaigns, offers, social media pushes, product launches — you name it.您可以為即將到來的活動,優惠,社交媒體推送,產品發布創建日曆-您可以命名。 And you can all share those calendars with one another for a single-screen view of everything that's going on so you can coordinate more easily.您可以彼此共享這些日曆,以便單屏查看正在發生的一切,從而可以更輕鬆地進行協調。

Are there other solutions of there for maintaining an editorial calendar?那裡還有其他維護編輯日曆的解決方案嗎? Of course.當然。 But if you're looking for a minimum viable product, and a free one at that, this ain't too shabby.但是,如果您正在尋找一款最低限度可行的產品,並且想要一款免費的產品,那麼這還不是很破舊。 It's kept our content team sane, agile, and transparent for quite some time — and I think it could do the same for you.它使我們的內容團隊保持理智,敏捷和透明很長時間了-我認為它可以為您做同樣的事情。

原始文章