For the longest time I loathed Google Adwords Editor for one main reason...

I would want to download a campaign to a CSV and edit it within excel (because that is soooo much easier than editing it in the actual editor). When I would go to upload the campaign, I would realize that the only way you can upload the campaign via the Adwords Editor is through the encrypted .AEA files.

For a long time I searched on how to make this work and saw that some people use macros and external programs to get this to work and well... I didn't want to do that.

After thinking about how the adwords Editor works... I figured a way to do it fairly efficiently and with very little extra work.

Basically, because the adwords editor checks for incorrect values and such, you can utilize this for your advantage!!!

So, let's go through the whole process...

Download a CSV campaign using the Adwords Editor

• First, you'll need Adwords Editor.
• Next, right click on a campaign and click export to CSV.
• Edit campaign in excel.

Upload A CSV Campaign to Adwords using the Adwords Editor

• First Select ALL (Ctrl+A) and Copy (Ctrl+C)
• Go into Adwords Editor and click on the keywords tab. Click Make multiple changes -> Add / Update Multiple Keywords.
• Click my campaign information below includes column information...
• Paste the entire campaign into the box and hit ok.
• You'll notice that Adwords Editor filters out the ads as incorrect formats. Sweet.
• Now, click the ad tab, add multiple ads and again paste the entire campaign.
• Now you'll need to go through and if this is a new campaign (or renamed), you will need to set adgroup bids and enter the remaining campaign information on the tabs.

Editing campaigns in this format really saves me a lot of time and I hope that it can save you a lot of time too...

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(3 votes, average: 4.67 out of 5)

 Loading ...

Adwords Editor is the affiliate marketers playground.

Really, if you're doing any type of PPC marketing, you should be using the Adwords Editor to build your campaigns because it does speed things up a lot. This post really isn't on how to use adwords editor though. It's simple enough that it won't take long before you're a pro at making campaigns...

Rather, this post is about how NOT to use adwords editor.

The other night, Tyler Cruz and I were talking and he reminded me of a good point about the adwords Editor.

With Adwords Editor, if you're trying to upload a huge campaign, you're going to run into some huge problems.

When you try to upload a large campaign with say 10,000+ keywords, you might run into a problem posting the campaign changes. When you start getting into the 100,000+ keyword arena you face even more problems such as your computer slowing down to a crawl (even with 2-4 GB of ram).

Essentially the trick with uploading large campaigns is to break the campaigns into smaller chunks.

I try not to upload more than a few thousand keywords at a time if that.

See, with google, the important part is not so much having 100,000 keywords, it's finding the profitable keywords and expanding those.

Hope that helps!

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(1 votes, average: 5 out of 5)

 Loading ...

Here are some good tips to get you started with your Google Adwords campaigns.

• 1. Don't start a campaign with broad matching. Use phrase and exact. This really helps to narrow down profitable keywords which you can then use as a model for expansion. Turn broad match keywords on once you are making a profit and ready to start expanding your volume.
• 2. Turn off content network and search network. Get comfortable with the conversions from straight search results before turning on the methods that can really hurt or help your campaign. The content network is really for advanced users only in my opinion. (Of course this is all my opinion haha)
• 3. Geotarget. Make sure you're targeting your Ads directly to the audience you are wanting. If your campaign allows for Canadian traffic, make sure you target it! Many people seem to forget that there is traffic outside of the United States and let publishers like me make extra money with a lot less work.
• 4. Group Your Keywords. Group your keywords into tight groups that are all related to both your ad and landing page. The better the quality score, the happier you'll be, trust me, it's worth the time it takes
• 5. Look at what others are doing. Yahoo has a tool that you can view other people's ads while writing your own by clicking a keyword. Google doesn't have a tool like this but a simple Google search is fine. See what ads are good performing ads and which seem to suck. The higher they are, the better that ads probably are.
• 6. Be smart! Track your results. I've tried setting up Prosper202 and had some trouble getting it to work but maybe you won't have the same issues as me. It looks like a good app either way.
• 7. Buy an Adwords Voucher if your account is under 14 days old. Buy the biggest one you can get! I find Digitalpoint forums are a great place to buy these vouchers.

So those are probably the MAIN things I would tell any person looking to start advertising in Adwords. These things can really mean the difference between making a lot of money and flopping so do it right the first time so you won't have to lose money!

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(2 votes, average: 3 out of 5)

 Loading ...

Many people don't know that you can generate keywords in many ways for your pay per click affiliate campaigns.

In fact, there are a ton of ways that you can find huge keyword lists but not all are effective or worth it. So I will be going over a list of the commonly accepted ways to get large keyword lists, why you need large keyword lists, and where to go.

First, the way MOST people generate their keywords (80%+ I'd estimate) is via the normal google and yahoo tools. You create a campaign and boom a keyword generator pops up for you to use. Easy and works well, best of all free.

The way that most people don't know about is generating keywords via other tools and programs. Some of these tools are free, some cost, some suck, some are amazing. I have tested pretty much every program on the market today.

First, the bad keyword generating tools. Stay away from these:

• Keyword Elite. - Like sorting through 50,000 keywords to find a few good keywords? Not me. No thanks.
• Keyword Companion. - Expensive tool that is similar to keyword elite but sorts through keywords a bit easier. Overall, TERRIBLE customer support (I had to spam the owners blog to get a response to my support ticket, no joke.)

Now, the following tools are ones I have used and found to be great and actually useful.

• My personal favorite: Wordze. This is the tool I like the best for generating larger keyword lists. You can read my Wordze Review. here.
• WordTracker. This program is one of the top in the industry and the best part... a full 7 day free trial. No reason why you shouldn't try it.
• PPC Coach. While reviewing the PPC Coach program, I noticed a reallllllllly amazing keyword tool. I actually utilized the tool multiple times already and well, I'm not really going to get into the tool because it's a secret I don't really like to share. It's worth the $50 bucks just for that tool and you'll notice in the comments of the PPC Coach review that people seem to find it worth it too.

Why do you need large keyword lists?

In search engines, the more areas of coverage you have, the more traffic you get. Plain and simple.

Many times in google, you can just use a broad keyword such as "credit cards" and it will cover all the credit cards keywords. Here is the problem: With broad match like that, you're going to get a percent of untargeted traffic unless you're using a large negative keyword list.

What do you do? Use these generators and use exact and phrase. Then you know exactly what you're getting as far as traffic goes.

Test broad search at a latter time.

With yahoo search marketing, I find the more keywords the better as long as you group your keywords well.

So now you know how to get good quality keywords and where to put them and how to implement them.

EDIT: Wordtracker link was broken. It's now fixed.

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(2 votes, average: 5 out of 5)

 Loading ...

I am about to share with you one of the single biggest factors that allowed me to expand my business as rapidly as I have.

As you guys know, I am 21 years old. Before I was an affiliate marketer, I was doing some arbitrage (in 2004) and some other website ventures. Needless to say, I wasn't rich. My credit was great but my credit limits were fairly constricting when you're talking about spending tens of thousands each month.

For a while, I made due by charging up cards and paying them off, charging them up, paying them off, etc but eventually this caught up to me and my credit score started to decline. Ouch. That's one number you just don't want to mess with!

As I sought for a solution that would allow me to grow, I turned to family and friends for help. For a while this worked and to this day, I still have people willing to invest $40,000 or more at any time which is nice!

Well as of lately, I've been paying for all my ads via Google Invoicing.

What is Google Invoicing?

Google Invoicing allows you to charge up 1 month's worth of advertising and then pay off the bill at the end of the money via checks or wire. Sweet!

With google's invoicing system, you have 30 days after the end of the month to pay off your bill before your account... well... you don't want to know what would happen if you didn't pay after 30 days.

So does this mean that you can spend $1,000,000 and pay it next month? No, not really... With the google invoicing system, you actually are given a "credit line." Once you hit this credit limit (laid out in your approval letter), your traffic will slow down or stop completely.

Applying for google invoicing is pretty simple, but to be accepted, you have to meet some requirements. They don't accept just any advertisers and you shouldn't expect to get in as a brand new advertiser. For example some of the requirements are you must spend a minimum amount each month for three months in a row. I'm not quite sure what this amount is and they don't really say. I know that when I applied for invoicing, I had spent over 5 figures each month for 4 or 5 months with adwords.

To apply for invoicing, you create a support ticket and request an application. Fill out the app, return it and hope for the best.

Now, there are a couple down sides to google adwords invoicing. First, you cannot pay via credit card. It is check or wire only!

Thankfully with affiliate marketing, if you're doing more volume you'll be paid weekly so as long as you're making a profit, it wont be a problem. Save up a pool of money for paying invoicing and you'll be A-OK.

The second major downside is that with invoicing you cannot get an increase in your credit line for 3 months and even after that it's not a promised thing.

If you've built a good relationship with Google, they'll generally work with you. After going through the invoicing application, I expressed my need for mid $xxx,xxx range per month in credit to allow for growth. After a bit of email exchanges, I was granted enough to make sure I didn't hit any limits for a couple months ;).

The third and final major downside to google invoicing is that you REALLY want to be sure that you want invoicing because they wont switch accounts back once they have been changed over. Be sure that you talk to your support person about your needs and such before applying.

If you're really looking to grow your business like I was, this is one method that will enable you to explode quite fast if you were in a similar situation to me.

As a word for the wise, I would highly recommend waiting to apply for invoicing until you spend at least 5 figures per month and are fairly consistent in spending a lot.

Finally, the information above is my experience from a USA account and I'm not sure the process for non-USA adwords accounts or if they even offer invoicing to non-US accounts.

Good luck for those who apply!

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(5 votes, average: 4.2 out of 5)

 Loading ...

Not too many people know about my beginnings as an affiliate marketer.

I, like many, had innumerable questions about being a successful affiliate. And to be honest, I wasn't able to find all my answers right away. There was however a couple who I looked up to who gave me many of the tools I needed to get going in the right direction.

Today, I want to talk about one of my mentors. His name is Derek and he run's a blog over at ClickConsultants.com.

Derek is a super affiliate (through azoogleads, neverblueads, incentaclick, and more) who certainly knows his stuff. He's had the opportunity to work with some other top affiliates such as Paul from UberAffiliate.com and more!

All that to say, his blog is one jam packed with very helpful affiliate information... and you know what? You can never know too much about affiliate marketing and/or internet marketing.

I have been following his blog and a couple of highlight posts you might want to check out are:

• Direct linking vs Landing pages...
• Easy PPC Tips Part 1. Part 2. And Part 3.
• Increase ROI with Day Parting.

Etc, etc, etc. The list really goes on and on.

Anyways, all of that is basically to say: Check out his blog. It's worth your time.

Besides the blog, Derek also runs a paid private forum which can really help starting affiliates get their feet on the ground, so be sure to check that out as well.

Most of the things I learned about starting a campaign were originated in that paid forum.

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(No Ratings Yet)

 Loading ...

I'm sure that everyone has seen a typical sales page on some site.

The truth is these sites do sell but this post is not about making a typical sales page (or your money back! hahaha). This post is about the most important factor on those sales pages that you can use on all your pages.

This single most important factor that every single sales page will have is a headline.

Surprisingly headlines are very important. They reaffirm to your visitor that they're going to get what they wanted when they clicked onto your page.

If your headline is not clear / visible or does not reaffirm the purpose of coming to your site, you need to change it.

When split testing your landing page, start with your headline on the landing page.

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(No Ratings Yet)

 Loading ...

Are you ready to hear one of the best tips for increasing your affiliate landing page conversions?

I've decided to write a short series on increasing landing page conversions.

Let's start! So how DO you increase landing page conversions?

Well it's quite simple actually. In order to know how to make conversions better, you need to understand the mind of your visitors.

This in years past was very difficult to track but thankfully there are a few good resources that will help you to essentially put on your visitors mind and see what they're thinking.

The first site is CrazyEgg.

What crazyegg does is allows you to see a heatmap of where your visitors are clicking.

Therefore the areas that are more heavily clicked are the areas you want to put your affiliate link. Simple right?

Areas that are less viewed you can fill with stuff that attempts to direct the attention to the links.

Another good example of how this can be used. On your typical ringtone landing page, you can use this to see what people click on most of your carriers page. Use this data to arrange your buttons in such a way that your most popular carrier is in the place that is clicked most often making it that much easier for your to convert that person.

Doing small changes like this take very little time and over the period of a month, you can be very, very far ahead of the competition.

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(1 votes, average: 5 out of 5)

 Loading ...

I had to post this because it's bugging me.

I've had a couple people comment (in reference to the original post) about how there is this great guide here or there about how to encrypt their keywords before sending them to the affiliate network SUB-ID.

Can I share a big huge secret with all of you?
Every guide I've seen doesn't do a bit of good at hiding your keywords.

Do you want to know why?

Think about how headers work in PHP and you'll realize that affiliate networks can still see your keywords used! Think about it for a second... Unless you add 1 vital step, your efforts are a waste.

This post isn't for most affiliates, just those encrypt their keywords and think they're safe.

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(3 votes, average: 3.67 out of 5)

 Loading ...

Please note that the below post is a very SIMPLIFIED version of how to track keyword level conversions.

GOOGLE Adwords Required Changes:
In your adwords ad URL destination you add to the end:

?OVKEY={Keyword}

Yahoo Search Marketing Changes:
In your Yahoo Search Marketing Administration Tab, you can turn "tracking URL's" on. That's all you need to do.

Step 2.
On your landing page at the VERY start of the file (About < html >) add the following:

< ? (remove the space between the < and the ?) $keyword=$_GET['OVKEY']; ?>

Step 3.
Now on your affiliate link add a sub id like so:
http://jumplink.com/jump.php?sub=< ?=$keyword;?> (Again remove the space between the < and the ?)

Obviously you replace the jumplink.com with the jumplink of your affiliate network.

Now you can see in the reports of your affiliate network which keyword converted for you.

The benefit of tracking keywords is you're able to find more profitable keywords and ditch the ones you're losing money on.

Just a word of caution. If you're running a campaign doing more than $100 bucks per day, I HIGHLY Recommend you work on some method of encryption for your keyword data.

• If you enjoyed this post, consider subscribing to my posts via email

Related Posts:

No related posts.

Rate This Post:

(5 votes, average: 4.6 out of 5)

 Loading ...