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

New site Hotspot Law like ZocDoc for lawyers

Published

on


Local search is probably more visible than it has ever been since the advent of Google Maps. Yet, paradoxically, there’s almost no consumer-facing innovation taking place. There’s Google, Yelp, Facebook (somewhat) and a range of specialized vertical apps and sites, some of which have simply survived but aren’t thriving.

Little or no ‘horizontal’ innovation. Part of the lack of “horizontal” innovation in local is likely the result of venture capital not wanting to fund anything that goes up directly against Google. The company may appear to many investors now like an insurmountable juggernaut in local/mobile search.

Any new local-consumer startups, therefore, are likely to appear in specific industries or otherwise offer specialized use cases. Such is the case with Hotspot Law, a new legal search site that hopes to bring ZocDoc-style appointment scheduling to the legal profession. It also seeks to provide a more reliable and cost-effective flow of leads to consumer attorneys.

The legal vertical has a quite a few competitors, including Avvo (Internet Brands), LegalZoom, FindLaw and several others. Despite this, Hotspot Law founder Felix Shipkevich believes he’s solving two unsolved problems in the legal vertical.

“The legal market is in dire need of an upgrade,” argues Shipkevich.

Making direct connections with lawyers. “Once you’ve finished searching online, you have to start calling,” he said. “You don’t get to speak directly to attorneys, you typically talk to a gatekeeper.” He points out that this process of getting to a lawyer is time consuming for people who need legal help. “None of these [completing] platforms directly connect the consumer with an attorney.”

Shipkevich, who is an attorney and faculty member at Hofstra Law School, said he was inspired by ZocDoc and the way it enables direct connections between doctors and patients. Similarly, he wanted to remove the friction in lawyer-consumer matchmaking. Shipkevich explained that also sees Hotspot Law as a way to make “justice” more accessible to consumers.

Why you should care. Legal lead-gen is costly. Shipkevich believes that existing legal sites and ad solutions don’t serve lawyers particularly well either. “PPC advertising can be extremely expensive; in New York it can be $60 to $80 per click.” He adds that “Yelp is expensive. Sometimes it takes $2,000 to $4,000 to bring in a case.”

He wants to solve that problem with simplified reasonable pricing for lawyers who may be struggling to find clients. But he also sees Hotspot Law evolving into a platform to help attorneys manage existing clients. Currently the site only operates in New York, with plans to expand geographic coverage in the coming months.

For the time being Shipkevich will need to rely on SEO for discovery but over time he hopes to build a branded consumer destination. It will be very challenging given the current structure of local SERPs. One has to admire the ambition and chutzpah.


About The Author

Greg Sterling is a Contributing Editor at Search Engine Land. He researches and writes about the connections between digital and offline commerce. He is also VP of Strategy and Insights for the Local Search Association. Follow him on Twitter or find him at Google+.

Continue Reading

SEO

Remembering the Tragedy That Made Our Community Start Talking

Published

on


About one year ago, everything changed for me and for our community.

A tragedy that struck home so hard it shook us to our core.

A suicide.

A dear friend, brilliant mind, adored father, respected colleague … the list goes on, left us in a way that hits straight to the heart and wakes you up like very few other events can.

I certainly woke up that day. That alarm screamed as loud as it could and I still hear it to this day.

I know I wasn’t alone. So many of my peers experienced similar emotions, sensations, and reactions.

We Could No Longer Ignore the Problem

Sadly, this wasn’t the first tragedy we’d encountered that year – we lost other friends and colleagues as well.

But we knew we couldn’t stand to lose any more amazing people.

We couldn’t look away. We couldn’t just carry on anymore.

So we started talking.

I have been blown away by our internet marketing community. Many of us have never even met face to face and yet the comradery, the friendship, the support among us run rampant!

Never before have I seen a group of people come together so quickly and so openly as when we were forced to face this tragedy.

Groups were formed. Calls were made. Texts were sent. Face-to-face get-togethers were had. Columns like this one were created.

And the best part of it all? It didn’t stop!

We saw the need to stay connected. We recognized that we are a family that needs to support each other. And, perhaps most of all, we saw that we were not alone in our struggles.

It has been amazing to see the openness and honesty that has become so commonplace over the past year. I have seen people that once felt they couldn’t risk being seen without their mask on break down and lay themselves out in the most vulnerable ways.

I include myself in that list. I have become more able to reveal myself to the world around me. That has only been made possible by others sharing in that journey with me.

In leading up to this piece, I knew that I wanted to really find a way to focus on the positive changes that our community has seen because of Jordan Kasteler.

I wanted to honor him in a way that really brought some form of good to this incredible loss that we all experienced due to his passing.

Where Are We Now? Thoughts from Our Community

I reached out and asked a few people in our community if they would share some words of how they have been changed for the better as well as how they have seen our community as whole making changes to support each other over the past year.

Here is what they had to say:

Alexandra Tachalova:

“Working days, nights, and weekends was normal for me a few years ago. However, at that time I couldn’t say that I was really happy. I didn’t understand at the time that my work-life balance was completely off, and I now know that that could have developed into something truly horrifying.

I eventually reached such an emotionally unstable point that I hit a time where one week I was super productive, but the following week I felt hugely demotivated and absolutely miserable. (I know this is a familiar story with many others as well, I hear people telling similar stories and sharing similar experiences regularly.)

Over the past while, I have been working diligently to save myself from this emotional trap. This new focus has led me to investing more time into things that are not related to work and putting more time into the things that help to create a happier life for myself.

I can see that more people in our community are becoming more aware of the need to make this sort of a switch to their schedules and priorities as well, which is brilliant to see!”

Melissa Fach:

“In the past year, I have noticed a massive shift in our community not being ashamed to reach out and ask for help, advice, or just a kind word. I feel like masks have been dropped, and people are not embarrassed to discuss what make them “real”; I love it!

I think many people used to feel they had to have public persona that was acceptable, and now they know we all have issues and it is OK to talk about.

I have a picture of Jordan out that I see every day. I moved past the guilt and the pain when I looked at it, and he is now a daily reminder to stay present with my friends as much as I can.

And, it is a reminder to me to stay focused on my well-being as well. I tend to overwork and do too much for everyone and end up exhausted. I take steps now to take care of me more than ever before.”

Steve Wiideman:

“Though I’ve been in the industry for years, I’m still a somewhat newer member of the SEO community. Call it fear of rejection, social anxiety, whatever, I’ve always been nervous to put myself in a position to be judged by my peers.

It really wasn’t until I was invited to an amazing Facebook group made up of a small close-knit group of industry peers focusing on supporting each other through the day-to-day struggles that I realized that nearly everyone shared the same fears, anxieties and experiences that I have.

What a relief it is to know there is a place where we share what we are feeling and have so much empathy! Finally I have a place I can turn to where people understand me.

Even if I don’t share as much as others, I have peace of mind knowing there are people there ready and willing to listen and help, where there’s no judgement, just open arms.”

Danny Goodwin:

“We’ve definitely made a lot of progress over the past year as a community. However, if I’m being completely honest, we still have a long way to go. I’m still hearing about issues of bullying. I’m seeing people piling on people they disagree with on Twitter.

While, thankfully, these are in the minority, the polarization and black-and-white thinking needs to stop. The judging and assuming needs to stop. The trolling and “mob mentality” needs to stop.

We need to stop fighting each other and start lifting each other up – treating everyone like human beings. Nobody is perfect, but I hope we will continue to see more people be able to let go of their hate and negativity to accept love and positivity into their lives. I know that will continue to be our aim with Friday Focus – to remind everyone that they are not alone in their struggles.

Ultimately, though, I am so happy to be a part of something so positive in our community – and it’s great to see so many others jumping onboard, too.”

Kim Krause Berg:

“It’s easy to assume that your peers are generally doing better than you, making more money than you, and are super successful in every way. It is only in the past few years that I realized this is baloney.

I respect people who remove their masks and show who they really are. We are people with lives and struggles, heartache, depression, and pain.

In the past year I have opened up more and made new friendships as a result. We have more in common with each other than we might think.”

Dave Davies:

“Over the past year I’ve seen an incredible shift in our community.

Social media itself breeds an environment where we see only the best of our peers and post the best of ourselves and being in marketing, needing to be on social media, needing to market ourselves on social media and seeing only the best version of those trained in presenting the best version of themselves – one can feel very alone in difficult times. Compounding that we face an often isolated profession where even sitting beside someone, we are focused on a screen and all they contain.

Sadly, we all know too well what that leads to, and over the past year we collectively recognized that we are human. That those around us are human. That others need support and perhaps most importantly, that we do too.

We finally heard the words spoken all too often after those tragic events, “If only they had asked for help.” And we took it upon ourselves to do so.

We finally knew to listen, to watch and to find out how those around us were doing, lest we face the loss of another friend who we would have dropped everything for, ‘If only they had asked for help.’

The community has grown it’s heart and soul over the past year.

There is still a lot to do. There are still many who don’t know where to turn. Many who don’t know who to talk to. But each time we reach out and each time we talk about challenges openly, share our own and listen to theirs … each time we do that, the community grows it’s heart a little more.

It has been a incredible year of change. While we will forever mourn the spark, the now burning fire keeps us all warmer.”

Jeremy Knauff:

“One thing that has changed dramatically in our industry over the last year, is that as individuals, we’ve become a lot more vocal about asking for help when we need it.

I think most people are more than willing to help each other. They just have to know that someone needs help. Now that people are starting to open up more about their personal struggles, the community is able to better support them.”

Thank You!

I want to take this opportunity to thank all of you – whether I know you in person, whether I know you online, even if I don’t know you at all –- thank you for being here.

Thank you for caring and sharing and being a part of the positive change that we are all working so hard at creating.

Keep being a force for good in our community.

Together we will make a difference.

Remembering the Tragedy That Made Our Community Start Talking  

 

This piece is written in memory, honor, recognition, and gratitude of Jordan Kasteler. For all that he gave us, shared with us, taught us and left us with. We are eternally grateful.

 


***PLEASE DO NOT STRUGGLE ALONE! Reach out, ask for help and know that you are valued.
CLICK HERE for a list of phone numbers for Suicide Hotlines around the world.***



Continue Reading

SEO

20190718 SEL Brief

Published

on

Please visit Search Engine Land for the full article.



Continue Reading

Trending

Copyright © 2019 Plolu.