Saturday, August 21, 2004
Google Auto Bidder
Click Here to see an example
I have developed a small application (php) to manage adwords bids for me. Here is how it works :
1) You need file_db.class.php : Google provides files in csv format - this class gives you access to these files, and allows you to manipulate the data.
2) You need to generate a specific report from Google :
Keyword Maximum CPC Impressions CTR Cost Avg Position Conversions Total Value Avg Value
(Just go in custom reports, and select the fieldsabove - set it up to be sent everyday to you (You just have to save it then on your server, in the specific directory).
Note : Google told me that we should soon have direct ftp access for reports available to anyone (not only agencies).
3) You need to ask google to send you a report ** on all the campaigns setup in your account (service avaialble only for premium accounts).
All you need to do then is to create a class which will suggest bids for you, and then replace the existing bids with the suggested one in the report ** sent by google.
An example of algorithm (roi = [Net commission + Net Adsense / Cost], cpc=bid for the specific keyword, cost = cost of the specific keyword, rank = rank of the specific keyword):
Note: : I run the report daily over the last 30 days. Some refinement could be done at this level to run different advisers (one over 1 month, one over 1 week, one over the last 2 days) to add some weight on the changes...
function Adviser($roi, $cpc, $cost, $rank)
{
if ($cost == 0)
{
if ($rank>8 && $cpc<$this->maxBid)
$cpc = $cpc+0.01;
} elseif ($roi<0.5){ cpc =" $this-">minBid;
} elseif ($roi<0.9){>$this->minBid)
$cpc = $cpc - 0.01;
} elseif ($rank > 3){
if ($rank < cpc =" $cpc+0.01;" cpc =" $cpc+0.02;" cpc =" $cpc+0.03;">
to be even more accurate in your ROI calculation, I would advise you to export your adsense stats too (keywords clicks). You can easlily get these figures with scripts such as this one.
If you have got any question, please click here
I think that it is important to let the bid automators open source since a bid automator needs to be tuned according marketing segment, and products types.
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment