Excel and Google sheets are every PPC account manager’s best friend. As a newbie, getting familiar with these tools and knowing their applications for everyday PPC is super important. In order to help you along, I’ve outlined some helpful tips and how to apply them to your PPC account management. Essentially, I’m helping you *excel* at your job. You’re welcome!
Disclaimer: I have a personal preference for Google sheets, so you’ll notice that’s where the screenshots in this post come from. All of these tips are still applicable for excel lovers!
Concat & Concatenate: The Greatest Function of All Time
Okay, if you don’t know about concat and concatenate, then I am about to blow. your. mind. Concatenate lets you combine a number of different strings of text, while it’s little sister, concat, let’s you combine two strings of text.
Concatenate has a plethora of applications in the PPC word. For one, using concatenate to combine different elements of ad copy is super helpful! For example, you can insert locations into your ad copy to make your ads seem more relevant to the user. (A more advanced way to do this is with geographic customizers, but this post is for newbies!).
Warning: This technique requires good campaign naming conventions, which you can learn more about here.
1. Create an excel or sheets doc with the campaign names and ad groups you’d like to create ads for. Duplicate your campaign name column and add three or more columns directly…