The Entrepreneur Forum | Startups | Entrepreneurship | Starting a Business | Motivation | Success

Categorising Keywords with MS-Excel

Accelerate wealth. Build a business that pays freedom. Join more than 70,000 entrepreneurs and register for the Fastlane Entrepreneur forum. Remove ads? Join the INSIDERS.

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,950
4,306
Ireland
I've just been training a paid search and content marketing team on exactly how to do what I cover in this video.

I originally dropped the video into the inside on Aug-2014 here.

I thought it might people on the outside ...

View: https://youtu.be/GMZdjtu5jig
 
Last edited:

Ubermensch

Bronze Contributor
Speedway Pass
Jul 7, 2008
1,034
111
893
Chicago
I've just been training a paid search and content marketing team on exactly how to do what I cover in this video.

I originally dropped the video into the inside on Aug-2014 here.

I thought it might people on the outside ...


This calls to mind the word "concatenation," favorite of a former digital agency/search pro I used to know.

verb (used with object), concatenated, concatenating.
1.
to link together; unite in a series or chain.
 

GoodluckChuck

Platinum Contributor
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Summit Attendee
Speedway Pass
Feb 2, 2017
657
2,545
660
my house
Fantastic video! Now if you'll excuse me I'm going to watch this about 16 more times...
 
  • Thread starter
  • Moderator
  • #4

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,950
4,306
Ireland
Fantastic video! Now if you'll excuse me I'm going to watch this about 16 more times...
Ha. I completely forgot about this video. I should probably drop a version into my course, or do an "Excel With AdWords" course (I actually had the .com for that... but didn't want a domain with AdWords in it).

Annoyingly, the Vimeo full-screen controls don't seem to show when the video is embedded in the forum. Makes it a bit small to view.
 

GoodluckChuck

Platinum Contributor
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Summit Attendee
Speedway Pass
Feb 2, 2017
657
2,545
660
my house
I think a short guide of how to use excel in regards to Adwords would be a great addition to your course!
 
  • Thread starter
  • Moderator
  • #7

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,950
4,306
Ireland

Hassan

Bronze Contributor
FASTLANE INSIDER
Read Millionaire Fastlane
I've Read UNSCRIPTED
Summit Attendee
Speedway Pass
Oct 14, 2012
196
240
168
This is great content with juicy takeaways, will definitely be re-listening multiple times. Thank you Andy!
 

eTox

Expect success, but prepare to fail.
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 21, 2016
461
620
282
Toronto
@Andy Black you mention that it's best to split up the long tail keywords into heads and geomodified tails.

Do you have any method of doing that? I mean something more efficient than going and manually removing the location keywords from the tails.

What's your method of doing this?
 
  • Thread starter
  • Moderator
  • #10

Andy Black

About to go on a video creation spree...
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
12,425
48,950
4,306
Ireland
@Andy Black you mention that it's best to split up the long tail keywords into heads and geomodified tails.
Yes, I often try to split out the short-head from the long-tail, and I often start with the long-tail buyer search terms.

So I might have a campaign targeting the whole of Ireland where I’m bidding on:
  • blacksmiths dublin
  • blacksmiths cork
  • blacksmiths galway
(Where Dublin, Cork, and Galway are counties in Ireland.)

I may then create a campaign per county that targets people searching when they’re physically IN that county and keywords will be:
  • +blacksmiths +near-me
  • [blacksmiths]
I may even bid on:
  • +blacksmiths
but I’d be careful of it canabalising other keywords, and bringing in junk.
 

Sponsored Offers

  • Sticky
MARKETPLACE NEW: The Best School for Going Fastlane (Now open for summer enrollment)
Hey everyone, I have a big announcement to make about how we are going to be working with...
MARKETPLACE Fox Web School "Legend" Group Coaching Program 2021
Any update? Hey bud! When I can squeeze out the time to work, it's been going pretty well...
MARKETPLACE Not sure how to start? This free book will teach you how to build a successful web design business
Hi Fox. Starting the book and got through the introduction. Had a conversation with Andy Black...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
Chris is super sharp and is aware of many facets of entrepreneurship and can help get your...
Introducing MJ's Personal Unscripted Network, Join Now for FREE!
Any chance to make it available outside of US? It has been available outside of the US on...

Forum Sponsor

Learn Fastlane Business Skills & Get Profitable Within 30 Days...

Get Started Now

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom