Connect with us

MARKETING

The Ultimate Guide to Google Sheets

Published

on

The Ultimate Guide to Google Sheets

Google Sheets is one of the best tools you can use to store data, track performance metrics, and create dashboards and reports.

But while it’s a wondrous tool with countless features and functionalities, it can be hard to grasp for beginners — especially if you need to create a marketing report or dashboard, fast.

Not to worry. If you’re looking to get started with Google Sheets, you’re in the right place. In this guide, we’ll be looking at the benefits of Google Sheets and walking you through some of the basics so you can get up to speed quickly and efficiently.

Advertisement

Benefits of Google Sheets for Marketing

Saying that marketers are data-centric people is an understatement. Between return on investment, cost per acquisition, and more, they’re always looking at different metrics and reporting on progress.

Advertisement

It can be tricky to keep all of those numbers straight, though. That’s where spreadsheets come in handy. With a well-organized spreadsheet, marketers can quickly analyze robust data sets and make smarter, more informed decisions about their efforts.

Originally introduced by Microsoft in 1987, Excel was the go-to tool for years for building spreadsheets. But when collaborative, cloud-based tool Google Sheets was introduced in 2012, many users made the switch over to this new (free!) resource.

Let’s talk about the benefits of using Google Sheets for marketing purposes before we discuss more traditional options (like a standard Excel spreadsheet).

  • It’s cloud-based. Cloud-based spreadsheets are automatically saved, stored, and maintained via a remote server. That means that you can access it online from anywhere, any time. Plus: Google Sheets is also available offline.
  • It’s free. No expensive software required — Google Sheets is always 100% free.
  • It works across devices. Modern marketers switch between devices throughout the day — and Google Sheets accommodates that behavior. You can access and edit Google Sheet data from a wide variety of devices (like your smartphone, tablet, and computer).
  • Add-ons are available. We’ll get into the specifics of add-ons for Google Sheets a bit later, but the increased functionality and flexibility of these additional features makes this spreadsheet tool even more versatile and powerful.

You might be wondering: What’s the difference between Google Sheets and Excel? The short answer is: price, collaboration, and flexibility.

While Excel requires a software subscription (which costs about $130), Google Sheets is free for all Google account holders. In terms of collaboration, Excel requires you to save and send a new version when edits are made, while Google Sheets automatically updates a single shared file for all team members. And lastly, because Google Sheets has the ability to accommodate many different integrations, it’s often more flexible than a standalone software solution like Excel.

Common Google Sheets Terms to Know

Next, let’s get familiar with some of the language and common terms used when referencing data within Google Sheets.

Advertisement
  • Column: Columns are vertical cell sets.
  • Row: Rows are horizontal cell sets.
  • Cell: Cells are the single data points within a Google Sheet.
  • Range: Range refers to a selection of cells across a column, row, or both.
  • Function: Function refers to built-in operations for the Google Sheet that can be used to quickly calculate values, to manipulate data, and more.
  • Formula: Formulas combine functions, rows, cells, columns, and ranges to generate a particular end result.

How to Use Google Sheets

Now we’re ready to dive into the more advanced how-to’s and lessons on using Google Sheets.

Understanding the Google Sheets Toolbar

One of the very first things to do is master the icons located in the Google Sheets toolbar. Doing so will help ensure you’re getting the most out of its abilities and that you’re saving time with shortcuts. Take a look at the screenshot below to identify some of the basic icons and their purposes within the toolbar.

google-sheets-toolbar

Image Source

How to Create a New Spreadsheet

When you’re ready to create a new spreadsheet, you’ll just need to follow a few quick steps to get started. Open Google Sheets and click “File” > “New” > “Spreadsheet”.

create-new-google-sheet

Once you create your new spreadsheet, you can start adding data. If you want to work with an existing spreadsheet from Excel instead, you’ll need to import that data into your new Google Sheet.

google-sheets-import-file

From there, your file will be uploaded and automatically converted into a Google Sheet.

Sharing and Protecting Your Data

Once your Google Sheet is set up and populated, you’ll want to think about how to share and protect your data. Data is automatically saved, so you don’t need to worry about that part. You can select who you share your file with and whether they have edit, comment, or view permissions. You can also protect specific data within your sheet so that those who have access can only edit certain cells.

To share a file:

  1. Go to “File” > “Share” (or just click the blue Share button in the top right corner)
  2. Enter the email address of who you’ll be sharing the spreadsheet with
  3. Assign permission levels (such as “View only” or “Can edit”)
  4. Click “Advanced” and select any additional privacy conditions needed

To protect data:

  1. Navigate to “Data” > “Protected Sheets and Ranges”
  2. Choose “Range” or “Sheet” (to protect an entire sheet)
  3. Select the data you’d like to protect
  4. Click “Set Permissions”
  5. Choose to show an error warning to anyone who attempts to edit or customize editing permissions for certain people.

Organizing Data in Google Sheets

Google Sheets is a powerful tool that can hold a ton of data. That means the more data you have, the harder it becomes to find it — that’s when filtering comes in handy. Google Sheets has several filters that allow you to select the data you want to see and hide what you don’t.

How to Hide Data

Google allows you to hide entire rows or columns. This becomes useful when you want to restrict views for sharing, or when you’d like to control the amount of data you’re viewing at any given time. To hide a column, right-click the column you want to hide, then select “Hide Column”. When you hide a column, two arrows will appear on the previous and subsequent columns. Click these to restore the column to full view.=

Advertisement
1643805669 775 The Ultimate Guide to Google Sheets

How to Freeze Rows and Columns

Freezing will create a floating row or column as you scroll and keeps the data in those fields within your line of sight. For example, if you use the first row to label your columns, you can freeze that row so you don’t have to remember what each column is as you scroll.

To freeze a row, select “View” > “Freeze” > “1 row” (or up to X rows).google sheets hack: freeze row

How to Filter Data

What if you’d like to view all of the data in a single column that fits a certain criteria? Apply a filter. Filters allow you to select a criteria and how that criteria applies to your data. For example, you can filter your ‘Site Visits’ column to show all values greater than 1000, or filter your sheet for all cells that have the word “cat”.

To set up a filter, select “Data” > “Create a Filter.” Click the funnel icon that appears in the column, then choose to filter by condition, value, or alpha or numeric order. Your sheet will only display data that satisfies your criteria.

Advertisement

google sheets hack: creating filters

Learn about other filtering options below.

How to Setup and Use Google Sheets Offline

If you need to use Google Sheets offline, just follow the steps outlined here to turn on offline access to your spreadsheets.

Keep in mind:

  • You must be connected to the internet.
  • You’ll need to use the Google Chrome browser (don’t use incognito mode)
  • You’ll need to install and enable the Google Docs Offline Chrome extension.
  • Make sure you have enough free space on your device to save all your files.

From there:

  1. Open Chrome and make sure you’re signed in.
  2. Go to drive.google.com/drive/settings.
  3. Check the box next to “Sync Google Docs, Sheets, Slides & Drawings files to this computer so that you can edit offline.”
  4. To work on files offline from a computer, learn how to install Backup and Sync.

Advanced Google Sheets Tips

Now that you understand the basics of Google Sheets, let’s get into some advanced tips so you can start using Sheets like a pro. These tips are helpful to have in your back pocket … even if you don’t need them just yet.

Conditional Formatting and Heatmaps

Conditional formatting will automatically apply formatting to a cell based on a preset condition. For example, you can select to highlight a cell in red if the value entered is below 100 or reads “Error”.

Advertisement

Heatmaps work similarly in that they apply a color scale to cells based on a median criteria (values greater than the median will appear darker while values lesser will appear lighter). This helps you view values on a gradient and identifies areas of concern on which to focus your attention.

google sheets hack: creating conditional formatting

Array Formulas

Array formulas can perform multiple calculations at once and output a value based on those calculations. Whereas most formulas require you to perform each step independently (e.g. sum one row then add it to the sum of the subsequent row), arrays make calculations much more efficient. This helps when working with large amounts of data.

Macros

The Macros feature records a series of steps that you’d like Google Sheets to repeat on command. For instance, if you work with a new data set each month, and need to manipulate that data in the same sequence each time, then you can record a Macro, and have Google do the work for you.

 

10 Must-Know Google Sheets Formulas

When you’ve entered your data and you need to do some quick number-crunching, basic formulas can help you find the answers you need. Here are a few commonly used Google Sheets formulas to speed up your data analysis.

Advertisement

1. SUM

This formula adds all values within a selected range.

=SUM(range)

2. AVERAGE

This formula calculates the average of values within a range.

=AVERAGE(range)

Advertisement

3. FILTER

This formula returns a filtered version of the source range, returning only rows or columns which meet the specified conditions. This is helpful when segmenting data by year or month.

FILTER(range, condition1, [condition2])

4. FIND

This formula returns the position at which a string is first found within the text. The Find formula is case sensitive.

FIND(search_for, text_to_search, [starting_at])

Advertisement

5. COUNTIF

This formula returns a conditional count across a range.

=COUNTIF(range, criterion)

6. CONCATENATE

This formula allows you to combine values of multiple cells into one cell, e.g., first and last name.

=CONCATENATE(Value1, “ ”,Value2)

Advertisement

7. VLOOKUP

This stands for vertical lookup. This formula searches down the first column of a range for a key and returns the value of a specific cell in the row found.

=VLOOKUP(search_key, range, index, [is_sorted]).

Learn how to do a VLOOKUP in less than a minute.

8. SPLIT

This formula divides text around a specified character or string, and puts each fragment into a separate cell in the row. Use this when you want to break up first names from last names in a list of customers or prospects.

Advertisement

=SPLIT(text, delimiter, [split_by_each])

9. SUBSTITUTE

This formula replaces existing text with new text in a string. For example: You could replace a product name with a new one in a sheet of ad copy.

=SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])

10. PROPER

This formula edits text within a cell to title case so you don’t have to format each entry manually.

Advertisement

=PROPER (text)

For more formulas you can use in Google Sheets, use the search tool on the spreadsheet functions list and find the one you need.

Google Sheets Functions & Skills You Should Know

How to Create a Pivot Table

  1. Select the cells with source data you want to use in your pivot table. Note: Each column will need a header.
  2. In the menu at the top, click “Data” > “Pivot table.” Click the pivot table sheet (if it’s not already open).
  3. In the side panel, next to “Rows” or “Columns,” click “Add” and then choose a value. Note: Sometimes you will see recommended pivot tables based on the data you’ve selected. To add a pivot table, under “Suggested,” select a pivot table.
  4. In the side panel, next to “Values,” click “Add”, then choose the value you want to see over your rows or columns. You can change how your data is listed, sorted, summarized, or filtered.
  5. Next to what you want to change, click the down arrow.
google-sheets-pivot-table

How to Remove Duplicates

  1. Select the cell in which you’d like to remove the duplicated info.
  2. Enter the function =UNIQUE(
  3. Select the cells you would like to pull data from
  4. Close the parentheses. Your function should look something like this: =UNIQUE(A:A)

How to Create a Drop-Down List

  1. Next to “Criteria,” choose an option:
  2. Click “Data” > “Data validation”.
  3. Select the cell or cells in which you want to create a drop-down list. List from a range: Choose the cells that will be included in the list.
  4. List of items: Enter items, separated by commas and no spaces.
  5. The cells will have a down arrow. To remove the arrow, uncheck “Display in-cell button to show list”.
  6. If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning. If you want people to only enter items from the list, choose “Reject input” next to “On invalid data”.
  7. Click “Save”. The cells will show a drop-down list. To change the color of a cell based on the option, use conditional formatting (refer to section above).

How to Make a Graph

  1. Select the cells you want to include in your chart. To label your chart, add a header row or column.
  2. Click “Insert” > “Chart”.
  3. In the side panel, click “Data” > under “Chart type,” choose a chart.
  4. To edit your chart, click “Customize.”
google-sheets-create-chart

How to Merge Cells

  1. Highlight or select a range of cells.
  2. Right-click on the highlighted cells and select “Format Cells”.
  3. Click the “Merge” button in the toolbar, then select the merge option you need.
google-sheets-merge-cells

How to Download Google Sheets

If you want to use Excel or another tool for analyzing data sets with your file, you can easily export the file. Go to “File” > “Download as”. Then decide which format you need.

download-google-sheets

If you need more help getting started, the quickest way to get a crash course in using Google Sheets is to access the free Google Sheets Cheat Sheet, which outlines the basics on:

  • Customizing spreadsheet data
  • Working with rows, columns, and cells
  • Sharing/collaborating within your spreadsheet
  • Saving and protecting your information
  • Utilizing key functions

You can also access the Tips Library for more advice on using Google Sheets.

Where to Find the Best Google Sheets Templates

Building new spreadsheets from scratch can be extremely time-consuming, so don’t reinvent the wheel if you don’t have to. Instead, look for pre-existing Google Sheets templates that you can customize and use for your own efforts. Let’s look at a few different places where you can find ready-to-use templates for your marketing efforts.

1. HubSpot

where to find google sheets templates: hubspot

HubSpot’s library of Google Sheets templates is a gold mine of resources for the professional who needs to set up a spreadsheet quickly. In this library, you’ll find a template for any type of document you might need, including a business budget, competitive analysis, expense report, marketing dashboard, and more. You only have to plug in the numbers and personalize the fields. This option is a great fit if you’re looking for an individual template.

Otherwise, you might enjoy downloading HubSpot’s free template kits. The below bundles contain Google Sheets templates designed to supercharge a high-functioning marketing team.

  • Free Google Sheets Template Bundle: Don’t want to look through an entire library and download templates one-by-one? Download this starter kit to jumpstart your spreadsheet creation process.
  • Free Marketing Budget Templates: These customizable marketing budget templates are ideal for tracking your spending on product marketing, content, paid advertising, and more.
  • Free Editorial Calendar Templates: You don’t need expensive software to start planning your publication calendar. Use these templates to get started. They also sync with Google Calendar so that no post goes unpublished or accidentally passed over.
  • Email Marketing Planning Template: This email marketing planning template helps you conceptualize, refine, and schedule your campaigns to increase ROI and optimize your results.

2. Google Template Gallery

where to find google sheets templates: google template gallery add-on

This free Google Sheets add-on gives you access to dozens of different templates right within Google Sheets. There’s no need to download an external document or make a copy from a publisher you might not trust. In this tool, you can access templates for project management, timekeeping, and budgeting. The only downside is that it’s hard to look at the previews of the templates, because the thumbnails are quite small.

Advertisement

3. Template.net

where to find google sheets templates: template.net

Template.net has a vast library of Google Sheets templates that you can easily preview and customize for your needs. While the library is not as marketing-specific, it still offers plenty for marketers to track their campaigns’ ROI, such as this social media marketing budget template. We recommend spending some time digging through this resource to find a template that works for you.

4. Blockspring

where to find google sheets templates: blockspring

Out of all the resources in this list, this one is the most unique. Why? Because these aren’t plain old templates where you can plug in the numbers and go. Blockspring’s templates are connected with third-party services to pull data into your spreadsheet. Instead of you having to manually link your spreadsheet to these third-party services, Blockspring’s templates do it for you.

For example, the template titled “Get content ideas on a topic using ‘Skyscraper’ analysis” uses data from Moz and Bing to get you a list of content ideas right on the spreadsheet — without you having to actually use either Moz or Bing. You only have to place the topic into the appropriate field, and the spreadsheet will populate on its own.

The only downside to using Blockspring’s templates is that you have to take a few extra steps for them to work. You have to download the Blockspring add-on onto Google Sheets, and then follow a few simple instructions to get the template up and running.

Haven’t found the Google Sheets templates that work best for you? Check out a few roundups we recommend:

The Best Google Sheets Add-Ons

To boost your efficiency in Google Sheets, consider using add-ons. Here are a few suggestions:

Advertisement

TapClicks

Pull your paid search and social advertising data into one spreadsheet, and turn them into beautiful reporting dashboards you’ll be proud to show your team managers and directors. This is a paid tool that starts at $29/month.

Google Apps Script

Google Apps Scripts offers a way to extend the functionality of your Google Sheets workspace beyond the basics. The cloud-scripting language allows you to create, edit, and read your Google Sheet through an integration with other Google apps. Recommended for advanced users and developers. Check out the documentation here.

DataEverywhere

Share data between Excel, local databases, Salesforce, and Google Sheets, without importing or exporting any files. That means that if you’re using Excel and want to automatically sync the data with Google Sheets, you can do so without needing to re-upload the document into Sheets.

XLMiner Analysis ToolPak

Do statistical analysis with functions. Because Analysis ToolPak was originally a Microsoft Excel add-on, this is a great tool for you if you’re getting into Google Sheets after being an Excel user.

Power Tools Add-On for Google Sheets

Streamline routine operations, such as clearing out duplicates and searching for specific values. You can also compare sheets, which is highly useful if you’re working off of two similar spreadsheets. This is a paid tool that starts at $29.95/year.

SuperMetrics

Create a business reporting system for SEM, SEO, web analytics, and social media. Not only does SuperMetrics turn a large amount of data into a more digestible format, but it also carries out automatic refreshes — so there’s no need to manually pull in the data every time you want to see a summary of your performance.

Advertisement

Clearbit Sheets

Create targeted email lists and qualify leads quickly. This add-on is a great option if you’re already familiar with a tool such as LinkedIn Sales Navigator. It fulfills a similar role, only the data lives on your own private spreadsheet, so there’s no need to sign in to LinkedIn every time you want to see prospect data.

Google Sheets is a Must-Have for Every Team

This quick guide to Google Sheets should help you get a running start as you leverage it for your marketing efforts. From more efficient tracking of different metrics to better planning around your content to easier collaboration with your team, this tool can help you make smarter, more data-backed choices that drive meaningful results for your brand.

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

business google sheets templates


Source link
Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address

MARKETING

How To Combine PR and Content Marketing Superpowers To Achieve Business Goals

Published

on

A figure pulls open a dress shirt to reveal the term PR on a Superman-like costume, reflecting the superpower resulting from combining content and PR.

A transformative shift is happening, and it’s not AI.

The aisle between public relations and content marketing is rapidly narrowing. If you’re smart about the convergence, you can forever enhance your brand’s storytelling.

The goals and roles of content marketing and PR overlap more and more. The job descriptions look awfully similar. Shrinking budgets and a shrewd eye for efficiency mean you and your PR pals could face the chopping block if you don’t streamline operations and deliver on the company’s goals (because marketing communications is always first to be axed, right?).

Yikes. Let’s take a big, deep breath. This is not a threat. It’s an opportunity.

Advertisement

Reach across the aisle to PR and streamline content creation, improve distribution strategies, and get back to the heart of what you both are meant to do: Build strong relationships and tell impactful stories.

So, before you panic-post that open-to-work banner on LinkedIn, consider these tips from content marketing, PR, and journalism pros who’ve figured out how to thrive in an increasingly narrowing content ecosystem.

1. See journalists as your audience

Savvy pros know the ability to tell an impactful story — and support it with publish-ready collateral — grounds successful media relationships. And as a content marketer, your skills in storytelling and connecting with audiences, including journalists, naturally support your PR pals’ media outreach.

Strategic storytelling creates content focused on what the audience needs and wants. Sharing content on your blog or social media builds relationships with journalists who source those channels for story ideas, event updates, and subject matter experts.

“Embedding PR strategies in your content marketing pieces informs your audience and can easily be picked up by media,” says Alex Sanchez, chief experience officer at BeWell, New Mexico’s Health Insurance Marketplace. “We have seen reporters do this many times, pulling stories from our blogs and putting them in the nightly news — most of the time without even reaching out to us.”

Acacia James, weekend producer/morning associate producer at WTOP radio in Washington, D.C., says blogs and social media posts are helpful to her work. “If I see a story idea, and I see that they’re willing to share information, it’s easier to contact them — and we can also backlink their content. It’s huge for us to be able to use every avenue.” 

Advertisement

Kirby Winn, manager of PR at ImpactLife, says reporters and assignment editors are key consumers of their content. “And I don’t mean a news release that just hit their inbox. They’re going to our blog and consuming our stories, just like any other audience member,” he says. “Our organization has put more focus into content marketing in the past few years — it supports a media pitch so well and highlights the stories we have to tell.”

Storytelling attracts earned media that might not pick up the generic news topic. “It’s one thing to pitch a general story about how we help consumers sign up for low-cost health insurance,” Alex says. “Now, imagine a single mom who just got a plan after years of thinking it was too expensive. She had a terrible car accident, and the $60,000 ER bill that would have ruined her financially was covered. Now that’s a story journalists will want to cover, and that will be relatable to their audience and ours.” 

2. Learn the media outlet’s audience

Seventy-three percent of reporters say one-fourth or less of the stories pitched are relevant to their audiences, according to Cision’s 2023 State of the Media Report (registration required).

PR pros are known for building relationships with journalists, while content marketers thrive in building communities around content. Merge these best practices to build desirable content that works for your target audience and the media’s audiences simultaneously.

WTOP’s Acacia James says sources who show they’re ready to share helpful, relevant content often win pitches for coverage. “In radio, we do a lot of research on who is listening to us, and we’re focused on a prototype called ‘Mike and Jen’ — normal, everyday people in Generation X … So when we get press releases and pitches, we ask, ‘How interested will Mike and Jen be in this story?’” 

3. Deliver the full content package (and make journalists’ jobs easier)

Cranking out content to their media outlet’s standards has never been tougher for journalists. Newsrooms are significantly understaffed, and anything you can do to make their lives easier will be appreciated and potentially rewarded with coverage. Content marketers are built to think about all the elements to tell the story through multiple mediums and channels.

Advertisement

“Today’s content marketing pretty much provides a package to the media outlet,” says So Young Pak, director of media relations at MedStar Washington Hospital Center. “PR is doing a lot of storytelling work in advance of media publication. We (and content marketing) work together to provide the elements to go with each story — photos, subject matter experts, patients, videos, and data points, if needed.”   

At WTOP, the successful content package includes audio. “As a radio station, we are focused on high-quality sound,” Acacia James says. “Savvy sources know to record and send us voice memos, and then we pull cuts from the audio … You will naturally want to do someone a favor if they did you one — like providing helpful soundbites, audio, and newsworthy stories.”  

While production value matters to some media, you shouldn’t stress about it. “In the past decade, how we work with reporters has changed. Back in the day, if they couldn’t be there in person, they weren’t going to interview your expert,” says Jason Carlton, an accredited PR professional and manager of marketing and communications at Intermountain Health. “During COVID, we had to switch to virtual interviewing. Now, many journalists are OK with running a Teams or Zoom interview they’ve done with an expert on the news.”

BeWell’s Alex Sanchez agrees. “I’ve heard old school PR folks cringe at the idea of putting up a Zoom video instead of getting traditional video interviews. It doesn’t really matter to consumers. Focus on the story, on the timeliness, and the relevance. Consumers want authenticity, not super stylized, stiff content.”

4. Unite great minds to maximize efficiency

Everyone needs to set aside the debate about which team — PR or content marketing — gets credit for the resulting media coverage.

At MedStar Washington Hospital Center, So Young and colleagues adopt a collaborative mindset on multichannel stories. “We can get the interview and gather information for all the different pieces — blog, audio, video, press release, internal newsletter, or magazine. That way, we’re not trying to figure things out individually, and the subject matter experts only have to have that conversation once,” she says.

Advertisement

Regular, cross-team meetings are essential to understand the best channels for reaching key audiences, including the media. A story that began life as a press release might reap SEO and earned media gold if it’s strategized as a blog, video, and media pitch.

“At Intermountain Health, we have individual teams for media relations, marketing, social media, and hospital communications. That setup works well because it allows us to bring in the people who are the given experts in those areas,” says Intermountain’s Jason Carlton. “Together, we decide if a story is best for the blog, a media pitch, or a mix of channels — that way, we avoid duplicating work and the risk of diluting the story’s impact.”

5. Measure what matters

Cutting through the noise to earn media mentions requires keen attention to metrics. Since content marketing and PR metrics overlap, synthesizing the data in your team meetings can save time while streamlining your storytelling efforts.

“For content marketers, using analytical tools such as GA4 can help measure the effectiveness of their content campaigns and landing pages to determine meaningful KPIs such as organic traffic, keyword rankings, lead generation, and conversion rates,” says John Martino, director of digital marketing for Visiting Angels. “PR teams can use media coverage and social interactions to assess user engagement and brand awareness. A unified and omnichannel approach can help both teams demonstrate their value in enhancing brand visibility, engagement, and overall business success.”

To track your shared goals, launch a shared dashboard that helps tell the combined “story of your stories” to internal and executive teams. Among the metrics to monitor:

  • Page views: Obviously, this queen of metrics continues to be important across PR and content marketing. Take your analysis to the next level by evaluating which niche audiences are contributing to these views to further hone your storytelling targets, including media outlets.
  • Earned media mentions: Through a media tracker service or good old Google Alerts, you can tally the echo of your content marketing and PR. Look at your site’s referral traffic report to identify media outlets that send traffic to your blog or other web pages.
  • Organic search queries: Dive into your analytics platform to surface organic search queries that lead to visitors. Build from those questions to develop stories that further resonate with your audience and your targeted media.
  • On-page actions: When visitors show up on your content, what are they doing? What do they click? Where do they go next? Building next-step pathways is your bread and butter in content marketing — and PR can use them as a natural pipeline for media to pick up more stories, angles, and quotes.

But perhaps the biggest metric to track is team satisfaction. Who on the collaborative team had the most fun writing blogs, producing videos, or calling the news stations? Lean into the natural skills and passions of your team members to distribute work properly, maximize the team output, and improve relationships with the media, your audience, and internal teams.

“It’s really trying to understand the problem to solve — the needle to move — and determining a plan that will help them achieve their goal,” Jason says. “If you don’t have those measurable objectives, you’re not going to know whether you made a difference.”

Advertisement

Don’t fear the merger

Whether you deliberately work together or not, content marketing and public relations are tied together. ImpactLife’s Kirby Winn explains, “As soon as we begin to talk about (ourselves) to a reporter who doesn’t know us, they are certainly going to check out our stories.”

But consciously uniting PR and content marketing will ease the challenges you both face. Working together allows you to save time, eliminate duplicate work, and gain free time to tell more stories and drive them into impactful media placements.

Register to attend Content Marketing World in San Diego. Use the code BLOG100 to save $100. Can’t attend in person this year? Check out the Digital Pass for access to on-demand session recordings from the live event through the end of the year.

HANDPICKED RELATED CONTENT:

Cover image by Joseph Kalinowski/Content Marketing Institute

Source link

Advertisement
Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

Trends in Content Localization – Moz

Published

on

Trends in Content Localization - Moz

Multinational fast food chains are one of the best-known examples of recognizing that product menus may sometimes have to change significantly to serve distinct audiences. The above video is just a short run-through of the same business selling smokehouse burgers, kofta, paneer, and rice bowls in an effort to appeal to people in a variety of places. I can’t personally judge the validity of these representations, but what I can see is that, in such cases, you don’t merely localize your content but the products on which your content is founded.

Sometimes, even the branding of businesses is different around the world; what we call Burger King in America is Hungry Jack’s in Australia, Lays potato chips here are Sabritas in Mexico, and DiGiorno frozen pizza is familiar in the US, but Canada knows it as Delissio.

Tales of product tailoring failures often become famous, likely because some of them may seem humorous from a distance, but cultural sensitivity should always be taken seriously. If a brand you are marketing is on its way to becoming a large global seller, the best insurance against reputation damage and revenue loss as a result of cultural insensitivity is to employ regional and cultural experts whose first-hand and lived experiences can steward the organization in acting with awareness and respect.

Source link

Advertisement
Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

MARKETING

How AI Is Redefining Startup GTM Strategy

Published

on

How AI Is Redefining Startup GTM Strategy

AI and startups? It just makes sense.

(more…)

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending

Follow by Email
RSS