In early October, we introduced an interesting new feature—you can now use Google Sheets
as your data feed. This opened up a whole world of possibilities regarding ways of using this new functionality. One of them is, you guessed it, creating brand campaigns. Let’s take a look at how to go about creating such a campaign in PPC Bee.
The most important thing you need in order to create a brand campaign with PPC Bee is, naturally, a Google Sheets file, even one as simple as the one shown above. What’s essential is that it contains a unique ID, keywords, and final URL.
Add all your brand keywords into the sheet, without matches—you’ll be selecting those later in PPC Bee. The ID column is identical to the Keyword column—you’ll learn why below.
The sheet must be saved to your personal Google Disk. If you keep it in a shared G-Suite drive, you won’t be able to see it after logging into PPC Bee.
Logging into PPC Bee
In data feeds, click Add a Google Sheets data source. Log in with your Google account, give a name to the data feed in PPC Bee, select your account and the correct Google Sheets file where you pick a sheet and the Unique ID column. Save everything and the data feed will synchronize.
Creating the campaign
After that, creating a brand campaign is a piece of cake. The process is exactly the same as if you were creating a standard search campaign. Choose the Google Sheets file you created as a data feed, give the campaign a name, and leave only Product ID in the group’s title under the Hierarchy tab—this makes sure that individual groups are named after keywords.
Now you create a keyword generator, using the keyword variable and selecting match types. An individual group and reporting will be created for each keyword; this makes editing CPC or checking search queries much more comfortable and easy.
Then do the ad texts—don’t forget to create multiple variations and test them to find out which test is the best.
Setting ad systems
The last thing you need to do before launching the campaign is set the ad systems. Don’t forget to set a sufficient budget and max. CPC. If you’d like to manage the budget and CPC directly in your systems, don’t forget to turn off their synchronization.
Launching brand campaigns with PPC Bee is extremely simple and quick. In a few minutes, you can create both the data feed, and the campaigns. There’s nothing difficult about this. And if you’re wondering if there’s any benefit to producing brand campaigns with PPC Bee, there indeed is and not just one:
- If you stumble upon an interesting keyword while browsing search queries, simply add it to the sheet; PPC Bee will automatically create a new group and ad texts;
- The clear structure allows for simple reporting and optimization;
- Changing ads across groups is very easy—simply create or edit an ad, and the change will show in all groups;
- You can synchronize brand campaign to Google Ads, Sklik and even Microsoft Advertising.
You can use this manual for other things, not just creating brand campaigns. With Google Sheets, you can easily create competition campaigns, general campaigns, category campaigns, od DSA campaigns. With this new type of data feed, the sky is the limit.
Both we, and a few selected clients made sure this process of creating brand campaigns actually works. Brand campaigns bring some very promising results: for example, optimization reduces average CPC when compared to campaigns created manually in systems.
We tested the creation of DSA campaigns using Google Sheets and are already looking forward to telling you more about it. If you decide to give Google Sheets data feeds a try, we’ll be glad to hear from you. In similar vein, don’t hesitate to contact us if you come up with other ways of using this type of feed.