I'm looking for a server side piece of software that daily takes every product on the Clickbank database and then accesses Google keyword tools to find out the keywords associated with the product website and the CPC and CTR for each keyword to work out the profitability of promoting the product on Google Adwords.
## Deliverables
Here's a rough spec for what I'm looking for.
Commission Blueprint Process
For every product on Clickbank
Use Google keyword tool to retrieve keywords for the Clickbank product site
Sort keyword list by number of searches per month - high to low
For each keyword in the keyword list
Use Google traffic estimator to retrieve data for exact phrase keyword based on no daily budget and CPC of $1
If the Ad Position < 4
Do Until Ad Position > 3
Store CPC
Store Estimated Clicks
Decrease CPC by $0.10
Use Google traffic estimator to retrieve data for exact phrase keyword based on no daily budget and new CPC
End Do
Keyword CPC = Stored CPC
Else
Do Until Ad Position > 3
Store CPC
Store Estimate Clicks
Increase CPC by $0.10
Use Google traffic estimator to retrieve data for exact phrase keyword based on no daily budget and new CPC
End Do
Keyword CPC = Stored CPC
End If
End For
Sort keyword list by estimated clicks per day high to low
For each keyword
Keyword cost per day = Keyword Estimated Clicks * Keyword CPC
End For
For the top ten keywords by clicks per day
Calculate Campaign cost per day = Campaign cost per day + Keyword cost per day
Click Inventory = Click Inventory + Keyword clicks
End For
If Product Gravity < 200
Conv Rate = 1%
End If
If Product Gravity >=200 and < 300
Conv Rate = 1.5%
End If
If Product Gravity >=300 and <400
Conv Rate = 1.75%
End If
If Product Gravity >=400
Conv Rate = 2%
End If
Refund Rate = 3%
Conversions per Day = Click Inventory * Conv Rate
Refunds = Conversions per Day * Refund Rate
Net conversions = Conversions per Day - Refunds
Commisisons per day = Net conversions * Product Total $ Per Sale
Profit / Loss = Commissions per day - Campaign Cost per day
End For
Export all data in Excel or CSV format for download every day. Each day's file to be timestamped and held on server.