The Entrepreneur Forum | Financial Freedom | Starting a Business | Motivation | Money | Success

Categorising Keywords with MS-Excel

Learn how to build wealth and win financial freedom the Fastlane way!

Say "NO" to mediocre living rife with jobs, ascetic frugality, and suffocating savings rituals— learn how to build a Fastlane business that pays both freedom and lifestyle affluence. Join more than 70,000 entrepreneurs who are making it happen.
Join for FREE Today
Get the books
Remove ads? Join Fastlane INSIDERS
(Registration removes this block)
Marketing, social media, advertising

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,945
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 to Fastlane Insiders.
Last edited:

Ubermensch

Bronze Contributor
Speedway Pass
Jul 7, 2008
1,034
117
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 Fastlane!
Read Unscripted!
Summit Attendee
Speedway Pass
Feb 2, 2017
660
2,596
my house
Fantastic video! Now if you'll excuse me I'm going to watch this about 16 more times...
 

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,945
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.
 
Don't like ads? Remove them while supporting the forum: Subscribe to Fastlane Insiders.

GoodluckChuck

Platinum Contributor
FASTLANE INSIDER
Read Fastlane!
Read Unscripted!
Summit Attendee
Speedway Pass
Feb 2, 2017
660
2,596
my house
I think a short guide of how to use excel in regards to Adwords would be a great addition to your course!
 

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,945
Ireland

Hassan

Bronze Contributor
Read Fastlane!
Read Unscripted!
Summit Attendee
Speedway Pass
Oct 14, 2012
197
244
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 Fastlane!
Speedway Pass
May 21, 2016
467
636
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?
 

Andy Black

Help people. Get paid. Help more people.
Staff member
FASTLANE INSIDER
EPIC CONTRIBUTOR
Read Fastlane!
Speedway Pass
May 20, 2014
14,267
53,945
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.
 
Don't like ads? Remove them while supporting the forum: Subscribe to Fastlane Insiders.

Post New Topic

Please SEARCH before posting.
Please select the BEST category.

Post new topic

New Topics

Fastlane Insiders

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

Join Fastlane Insiders.

Must Read Books...

Explore books recommended by MJ DeMarco and other members of the Fastlane entrepreneurial community.
Fastlane Bookstore
Top