1.) The picture is from the flowers my Mom sent to congratulate Mike, Istvan, and me on the Los Angeles "Make More with your Online Store" seminar. My mom ROCKS!
2.) Just got back from a hot date! We went to the opening game at the new Busch stadium and had killer seats just behind home plate on the third base side! Go Cards! Nothing like a hot dog at the ballpark with your best girl on about the best Spring day I've ever seen.
Back to work, though. Steve says if I want to afford any more hot dogs or trips to California, I've got to sell some more Yahoo! Store books and seminar seats. Hint, hint!
3.) PowerPosting for Fun & Profit: Seminar Nugget #14
Ok. Want an additional 30,000 relevant visitors a month to your Yahoo Store for less than a dime each? I sure do!
{Hey! Buy the book, because I explain it better in there than I do here. This post is really for seminar folks LA + SF, but anyone can feel free to use this stuff. Your mileage may vary. Blah, blah, blah...}
First: Download robsnell-powerpost-yahoo-store-search.xls
In this example I take it for granted that you have the following:
- a Yahoo Store needing more traffic
- a Google Adwords account ($5 to set one up)
- $100-2000 a month to spend on traffic
- a big honking list of relevant keywords
In the LA seminar, we took the Store Manager's Statistics: References : Details and downloaded the CSV for the highest volume search engine (which was usually Google).
For the folks playing along at home: You must reduce your references:details.csv (keyword list) to a unique list of words and phrases. Use NOTEMAID to strip off the HTML. Use Excel's SUBTOTAL feature to pound that ole list down into a list of uniques, and remember that there are as many ways to do that as there are ticks on an old hound dog...
THEN...
1.) Download the powerpost.xls worksheet and open it in Excel. Input your store account and your maximum bid (up to 11 cents is good). Test the fake URLs created to see if they really work on your store.
2.) Open your internet browser and log into your Google AdWords account:
A. Create a new campaign/adgroup called something like bulk + the date.
B. Write a generic ad. Something like this:
{Keyword:DomainName here}
100% satisfaction guaranteed.
Free shipping on $99+ orders.
YourDomain.com
4.) Paste your KEYWORDS into this Excel sheet to generate the blue POWERPOST code. Have more than 100 keywords? Good! Just copy the formula and paste it into additional cells. Up to 2000 lines or so should get you.
5.) COPY & PASTE blue stuff to POWERPOST directly into the keywords field. Now update. You'll probably have to delete some weird characters or long, long keyword strings. Don't sweat the small stuff...
The FORMAT of power posting is:
keyword phrase ** max bid ** URL like this:
big red widgets ** 0.06 ** http://search.store.yahoo.com/cgi-bin/nsearch?catalog=webstore-design&query=big+red+widgets+gaw
Good luck! I get 1,000+ people a day to my stores at less than a dime each.
Remember to test those URLs to make sure that you're sending traffic to YOUR store and not MINE!
-- Rob Snell
P.S. Oh, yeah! Make sure you're using the conversion code Google provides on your Confirmation page. It takes maybe 2 minutes to get it from Google, paste it in your store, and publish. This code will let you see the difference between a successful PPC campaign and throwing good money after bad in paid search.
Email me if you need help (or read my Yahoo Store book!)
Comments