Connect with us

SEO

Build your PPC campaigns with this mini campaign builder script for Google Ads

Published

on


Need to quickly build a campaign or add keywords to an existing one? This script will do the work for you!

All you need to do is input a few keywords and headlines in a spreadsheet and BAM! You’ve got yourself the beginnings of a great campaign.

I’m a firm believer in Single Keyword per Ad Group (SKAG) structure – it increases ad/keyword relevance and therefore improves quality score, makes CPCs cheaper, gets you a higher ad rank and a better CTR.

Sadly, building out SKAG structures is a pretty time-consuming endeavor. You can’t implement millions of keywords and ads without PPC tech powering your builds.

But if a client just needs a couple of new keywords after updating their site with new content, this script is a quick and easy solution.

And that’s exactly what I love about PPC. There’s a special place in my heart for simple scripts anyone can use to achieve tasks that are otherwise repetitive or near-impossible.

What does the script do?

This tool will save a lot of time with small-scale builds where you know exactly which keywords and ad copy you need, for example when you’re adding a few keywords to an existing campaign.

You input your campaign name, keywords, headlines, descriptions, paths and final URL, and it will output three tabs for you: one with keyword combinations, one with negatives, and ads to upload to Google Ads Editor.

It creates one exact and one broad match modifier campaign and creates a list of keywords as exact negatives in the broad campaign to make sure that search terms that match exactly will go through the exact keyword.

I’m sure you’re dying to give it a whirl, so let’s get cracking!

How do you use it?

Make a copy of this spreadsheet (note: you’ll need to authorize the script to run). You’ll find all the instructions there as a future reminder.

Once you’ve got the spreadsheet ready, input the following:

  • The campaign name
  • The campaign name delimiter to distinguish between broad and exact campaigns
  • Headline 1 (if this cell is not specified, then it will be the same as the keyword)
  • Headline 2
  • Optionally, headline 3
  • Description 1
  • Optionally, description 2
  • Optionally, path 1 and path 2
  • The final URL
  • The keywords (you can keep going outside of the box with these!)

You’ll see a handy character counter which will go red if you exceed the character limit. Bear in mind that this tool will assume that you’re using it correctly and so you’ll need to make sure that you’re staying within the limit!

You can also optionally create a second ad variant by choosing the part of your text you want to vary (e.g., headline 2 or description 2) and inputting the copy. Otherwise, just select “None” from the dropdown menu.

Once you’re done, click the gigantic “Go!” Button, and wait for the magic to happen.

It will generate three tabs labelled “Keywords,” “Negatives” and “Ads.” If you want to run the script again with different keywords, make sure you save these tabs elsewhere or rename them to prevent the script from overriding them.

Finally, you can paste these tabs into Editor and update all the relevant settings and adjustments. Job done!

DOWNLOAD: You’ll need to authorize the script to run after you make a copy of this spreadsheet.


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.


About The Author

Daniel Gilbert is the CEO at Brainlabs, the best paid media agency in the world (self-declared). He has started and invested in a number of big data and technology startups since leaving Google in 2010.

Continue Reading
Click to comment

You must be logged in to post a comment Login

Leave a Reply

SEO

Want to speak at SMX West? Here’s how

Published

on


Want to showcase your knowledge of search marketing to our SMX West attendees? We’d love to hear from you, and if you wow us with your proposal we’ll invite you to speak at the conference. To increase the odds of being selected, be sure to read the agenda. Understand what the sessions are about. Ensure that your pitch is on target to the show’s audience and the session. Please also be very specific about what you intend to cover. Also, if you do not see a particular session listed, this is because there are no openings for that session. Use this form to submit your request.

PLEASE NOTE: We have changed the pitch process. We’ve put together session titles that we plan to run at the show, and we’re looking for you to tell us what key learning objectives and takeaways you’ll offer to attendees. Detailed instructions are on the pitch form.

As you might guess, interest is high in speaking at SMX conferences. We literally sift through hundreds of submissions to select speakers for the show. Here are some tips that will increase your chances of being selected.

Pitch early: Submitting your pitch early gives you a better chance of being selected. Coordinators accept speakers as soon as they identify a pitch that they think best fits the session, just like colleges that use a rolling admissions policy. So pitching early increases the likelihood you’ll be chosen.

Use the form: The speaker pitch form (http://marketinglandevents.com/speaker-form/) is the way to ask to speak. There’s helpful information there about how your pitch should be written and what it should contain.

Write it yourself and be specific: Lots of pitches come in that are not specific to the session. This is the most effective ways to ensure that your pitch is ignored. And this year, we’re no longer accepting pitches written by anyone other than a proposed speaker. If you’re a thought leader, write the pitch yourself… and make certain that it is 100% focused on the session topic.

“Throw your best pitch:” We’re limiting the number of pitches to three per person, so please pitch for the session(s) where you really feel you’ll offer SMX attendees your best.

NEW: SMX Insights Sessions. What are they? 8-10 minute solo sessions that pack a punch and wow attendees with content they can’t and won’t see anywhere else. Tactical. Specific. Actionable. Speakers are challenged to deliver the goods in a limited amount of time: one must-try tactic, one nugget of sage advice, or one takeaway that makes you more productive. Have a gem to share with your colleagues? Pitch your idea and you may make it to the SMX stage!

You’ll be notified: Everyone who pitches to speak will be notified by email whether you are accepted or not.

And don’t delay—the pitch forms for each session will close as sessions are filled, with everything closing Friday, November 29.


About The Author



Continue Reading

SEO

Video: Danny Sullivan, Google Public Liaison of Search, on his transition from Search Engine Land to Google

Published

on


We have a special video interview for you all at Search Engine Land. We interviewed Danny Sullivan, the founder of Search Engine Land and the search community, in a two-part series.

In part one, we asked Danny about his early days in the industry to him ultimately deciding to retire from his role at Search Engine Land / Third Door Media. Then accepting a job a few months later to work with the Google Search team as the Google Public Liaison of Search.

Part two is more about what it is like to work at Google and how he sees things differently as a Googler than when he was working on search from outside of Google.

Here is part one:

I started this vlog series recently, and if you want to sign up to be interviewed, you can fill out this form on Search Engine Roundtable. You can also subscribe to my YouTube channel by clicking here.


About The Author

Barry Schwartz is Search Engine Land’s News Editor and owns RustyBrick, a NY based web consulting firm. He also runs Search Engine Roundtable, a popular search blog on SEM topics.



Continue Reading

SEO

Google Ads Editor update includes support for Discovery campaigns

Published

on


Yes, the editing pane is still awkwardly placed to take up a giant chunk of the right side of the screen, but Google Ads Editor’s latest version does offer some handy updates.

Edit pane. Speaking of that edit pane, now you can at least condense some fields to hide them so there’s a bit less scrolling. (That doesn’t mean irrelevant sections no longer show, however. You’re still going to have to scroll past a grayed-out “Shopping settings” when you’re in a Search campaign, for example.)

Shared negative keyword lists. If you’ve built out broadly applicable negative keyword lists, you can now share those across accounts in the Shared Library in Editor. (Shared Library is located under “Account-level” in the left navigation pane.)

Search for errors. You can search for similar errors across your campaigns or accounts. In the search bar, type “rule” or “violation” and you’ll see a list of options. Similarly, when you find an error or warning, you can click on the “Show violations” link at the bottom of the screen to see them all.

New campaign support. If you are running App campaigns for engagement or have access to Discovery campaigns in beta, you can now create and edit them in Editor.

Why we should care. These changes are relatively minor, but may save you some campaign management time, particularly if you’re using the newly supported campaign types. It’s also a pretty good sign that the Discovery campaigns beta is coming along. At the very least, it’s a good reminder to check how and if you’ve applied your negative keyword lists.


About The Author

Ginny Marvin is Third Door Media’s Editor-in-Chief, running the day to day editorial operations across all publications and overseeing paid media coverage. Ginny Marvin writes about paid digital advertising and analytics news and trends for Search Engine Land, Marketing Land and MarTech Today. With more than 15 years of marketing experience, Ginny has held both in-house and agency management positions. She can be found on Twitter as @ginnymarvin.



Continue Reading

Trending

Copyright © 2019 Plolu.