Follow Kurt Melvin on Twitter

Subject: "Clickbank Merchant Data Feed for Spreadsheets"   Previous Topic | Next Topic
Printer-friendly copy    
Conferences The New MadBomber Marketing and SEO Forum Topic #420
Reading page 1 of 1 pages
Kurtadmin click here to view user rating
Member since Dec-5-02
8892 posts, 5 feedbacks, 8 points
Aug-04-10, 05:07 PM (PST)
Click to EMail Kurt Click to send private message to Kurt Click to view user profileClick to add this user to your buddy list  
"Clickbank Merchant Data Feed for Spreadsheets"
 
I took the CB merchant datafeed and converted it to a pipe-delimited text file that can be opened by Excel or Open Office.

This will let you sort by different factors or create your own formulas.

This is fresh as of Aug. 4, 2010 and this took more work than I thought, so I suggest you use it right away for best effect.

www.dombom.com/iframes/cb_marketplace_feed_v1-2-2.zip



-Boom boom boom boom.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
kelvin brownmoderator click here to view user rating
Member since Dec-11-02
638 posts, 2 feedbacks, 4 points
Aug-05-10, 09:14 PM (PST)
Click to EMail kelvin brown Click to send private message to kelvin brown Click to view user profileClick to add this user to your buddy list  
1. "RE: Clickbank Merchant Data Feed for Spreadsheets"
 
   Hi Kurt,

As a giveback, I took this file and converted it to fatbomb format.

This will let anyone use it as a fatbomb search, use with blogbomb, or any RSS feed.

I especially like blogbomb or zztuelz, because you can then pull only items matching keywords you wish to use, at that time.

The file is ready to go, you just have to do a find and replace on one word> AFFILIATE

each product is one line, Example:

Link|title|Description

http://AFFILIATE.ETVCORP.hop.clickbank.net|"SatelliteDirect - Highest Converting Tv to PC Product Earn 75% Bonuse"|By Promoting the Leading Tv to PC patent-pending software. For more information please visit our affiliate page: http://www.satellitedirect.com/affiliates.php


I am going to email the file to you, Kurt, because the system will not let me attache it.


kelvin

Join the MadBomber VIP club here http://www.dombom.com/vip/clk/54sr37


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
Kurtadmin click here to view user rating
Member since Dec-5-02
8892 posts, 5 feedbacks, 8 points
Aug-06-10, 11:34 AM (PST)
Click to EMail Kurt Click to send private message to Kurt Click to view user profileClick to add this user to your buddy list  
2. "RE: Clickbank Merchant Data Feed for Spreadsheets"
 
>As a giveback, I took this file and converted it to fatbomb
>format.

...

>I am going to email the file to you, Kurt, because the
>system will not let me attache it.


Thanks Kelvin...The forum has a limit of something like 200k for uploads.

BTW, how did you convert it?

I was thinking about doing a video on how to use a spread sheet to do it, do you have a better way?


-Boom boom boom boom.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
kelvin brownmoderator click here to view user rating
Member since Dec-11-02
638 posts, 2 feedbacks, 4 points
Aug-06-10, 01:55 PM (PST)
Click to EMail kelvin brown Click to send private message to kelvin brown Click to view user profileClick to add this user to your buddy list  
3. "RE: Clickbank Merchant Data Feed for Spreadsheets"
 
   Not better, just different.

I started by saving it as cvs tab delimited, imported into linez, find and replace. Only problem is with that many lines, I could not complete the job as a single file. The limit was probably memory and browser timeout.


So, I ended up using the same cvs file, and doing find and replace in NoteTad pro.


NOTE: the file is based on the old standard affiliate links Clickbank used. Not the new url you get with supposed security features to prevent hyjacking.

kelvin

Join the MadBomber VIP club here http://www.dombom.com/vip/clk/54sr37


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
kelvin brownmoderator click here to view user rating
Member since Dec-11-02
638 posts, 2 feedbacks, 4 points
Aug-22-10, 06:44 PM (PST)
Click to EMail kelvin brown Click to send private message to kelvin brown Click to view user profileClick to add this user to your buddy list  
4. "RE: Clickbank Merchant Data Feed for Spreadsheets"
 
   Hi Kurt,

Do you know how accurate this was?

I am asking, because when I checked my own product was not in the list.

One reason maybe be because of the low threshold of sales.

Kelvin

Join the MadBomber VIP club here http://www.dombom.com/vip/clk/54sr37


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
Kurtadmin click here to view user rating
Member since Dec-5-02
8892 posts, 5 feedbacks, 8 points
Aug-23-10, 12:03 PM (PST)
Click to EMail Kurt Click to send private message to Kurt Click to view user profileClick to add this user to your buddy list  
5. "RE: Clickbank Merchant Data Feed for Spreadsheets"
 
LAST EDITED ON Feb-26-11 AT 02:18 PM (PST)
 
>Hi Kurt,
>
>Do you know how accurate this was?
>
>I am asking, because when I checked my own product was not
>in the list.
>
>One reason maybe be because of the low threshold of sales.
>
>Kelvin


Hey Kelvin,

I really don't know...But I think that you do need a certain number of sales to be listed in the market place and I think this data is taken from the CB market place.


-Boom boom boom boom.


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote
kelvin brownmoderator click here to view user rating
Member since Dec-11-02
638 posts, 2 feedbacks, 4 points
Aug-23-10, 01:57 PM (PST)
Click to EMail kelvin brown Click to send private message to kelvin brown Click to view user profileClick to add this user to your buddy list  
6. "RE: Clickbank Merchant Data Feed for Spreadsheets"
 
   Hi Kurt,

You gave me a couple of ideas. Just by my toying with this.

I went, got the feed, massaged it a bit.

And then ran the whole thing through RZZ tuelz, to create a feed.

But, that is one big file.

So, I also broke it down into 20 chunks via category.

I put up a gig at zeerk.com to see if anyone would buy the set for $25 customized with your clickbank ID.

you can of course then add the feeds based on category to your blog, or submit to aggregators, mashups, etc.

kelvin

Join the MadBomber VIP club here http://www.dombom.com/vip/clk/54sr37


  Alert | IP Printer-friendly page | Edit | Reply | Reply With Quote


Conferences | Topics | Previous Topic | Next Topic