The roles and responsibilities of all marketers are expanding. Publicists are conducting keyword research. SEOs are guiding media outreach. These are crazy times.
This article is designed for professionals who wish to streamline their media outreach by creating many semi-personalized pitch letters in Excel using the concatenation function. If you are new to pitching and are simply searching for a way to get a pesky product launch off your plate as soon as possible, please review the Golden Rule below before moving on to the screenshots.
Pitch Letter Golden Rule
As (part-time) publicists, we should never send a form “Dear Reporter” pitch letter to every reporter on our list, even if this blog post makes it really easy to do that. It is not successful, it cheapens the brand and PR people will hate us for doing a disservice to their field. Instead, take time to personalize each pitch, even if there is just one line that speaks to the writer or publication.
The tactics discussed in this article might bend the boundaries of the golden rule but, as the Dalai Lama said, “Know the rules well, so you can break them effectively.” While I believe that is especially true with all writing, it is also a valid lesson in public relations. Liberties taken from a solid foundation create unique, engaging PR outreach. Liberties taken from ignorance are slop.
When Pitch Letter Concatenation Works
For most story pitches, publicists contact a short list of journalist who report on the particular topic and tailor each pitch to its recipient. A streamlining process like this one might not be necessary. Other times, we need a method for organizing letter writing and distribution.
An example might be an article that identifies the best in your industry. Since this is a SEO blog, our sample article title will be “Top 50 SEO Bloggers.” We will rank the bloggers by a series of quantitative and qualitative metrics, maybe open it up to voting to increase engagement. Once we have the finalists, it is time to contact each one to let them know they made the top 50. We have three options:
- 50 personalized emails
- “Congratulations Blogger” form email
- Semi-personalized letters in Excel
Creating Pitch Letters with Excel
Our semi-personalized email will have two elements: the subject line and the body. We don’t want to use a standard subject line like “Congratulations SEO Blogger” because open rate would suffer–I wouldn’t open it. Instead, let’s us each blogger’s first name.