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

Categorising Keywords with MS-Excel

Remove ads while supporting the Unscripted philosophy...become an INSIDER.

Andy Black

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,803
47,249
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
 

Don't like ads? Remove them while supporting the forum. Subscribe.

Last edited:

Ubermensch

Bronze Contributor
Speedway Pass
Jul 7, 2008
1,034
108
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
652
2,507
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

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,803
47,249
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
652
2,507
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

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,803
47,249
4,306
Ireland

Hassan

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

eTox

Stupid naive kid
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 21, 2016
449
587
262
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

Making a nuisance of himself on Twitter
Staff member
EPIC CONTRIBUTOR
FASTLANE INSIDER
Read Millionaire Fastlane
Speedway Pass
May 20, 2014
11,803
47,249
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 Fox Web School "Legend" Group Coaching Program 2021
I thought I would post up the first video from the newest 2021 program content... Just a...
  • Sticky
MARKETPLACE Kill Bigger Incubator
I have not offered one of these in a while, but it looks like I have time to take on an...
  • Sticky
MARKETPLACE You Are One Call Away From Living Your Dream Life - LightHouse’s Accountability Program ⚡
Hi Andreas, It is per month, with the first month being half. This is a great question, I...
  • Sticky
MARKETPLACE Lex DeVille's - Advanced Freelance Udemy Courses!
Hi Lex, I looked at several options including Kajabi and settled on the Divi theme on Wordpress...
  • Sticky
MARKETPLACE Grow Your Business With a Book (An Unorthodox Marketing Strategy That Built One of the Largest...
Are you looking for a new, lesser-known but potentially very lucrative source of leads to your...
  • Sticky
FEATURED! Introducing... WEALTH EXPO$ED, A Short Story By MJ DeMarco
The story is BASED UPON a true story. The details aren't entirely accurate or from a distinct...



Forum Sponsor

Grow an online business:
- Start immediately!
- Master business skills!
- 100+ Fastlane students enrolled!
Review & Details >

New Topics

Fastlane Insiders

View the forum AD FREE.
Private, unindexed content
Detailed process/execution threads
Monthly conference calls with doers
Ideas needing execution, more!

Join Fastlane Insiders.

Top Bottom