oops.

The chart I did in the last presentation was based on a 16.97 profit (mine) here it is for a 15.00 profit.

Also the chart doesn't show as nicely when I post it.

$0.10 86 1.17%
$0.15 57 1.75%
$0.20 43 2.33%
$0.25 34 2.92%
$0.30 29 3.50%
$0.35 24 4.08%
$0.40 21 4.67%
$0.45 19 5.25%
$0.50 17 5.83%
$0.55 16 6.42%
...

That last post was too complicated.

Let me simplify it.

Definitions
-----------
ROI = 50% - The return I need to be profitable across the entire campaign
CTR = Conversion from a click into a Sale
CPC = Cost per click
Profit = How much I make on each sale
SALES = total sales
COST = Total Cost
TRAFFIC = Total Number of Clicks

TARGETCLICKS = My target clicks for sales for a keyword at a CPC price....

Newest approach to adjusting my costs for each keyword.

I am now getting into it!!

I have set a ROI return that I want to get me started.

I have started with 50%. This means that I need to get a 50% return on a keyword. Therefore for every $100 I spend, I need a $50 profit. I have just chosen the amount randomly since its in keeping with the typical Retail standard of 50% margins.

Anyways - that means I can now start looking at the number...

yacobir wrote: Good luck with your next sale! Don't try to figure out too much information...

I think I am an idiot.

I think I keep screwing up with T202, Excel and AdWords Editor.

I keep all my keywords in one page in the Excel,
I have a control page where I put all my ads.

I then use Excel to generate all the content for the rest of my campaign -
Keyword groups - one keyword Broad and Exact per adgroup.
Text ads - every ad is available for every keyword.

But I somehow keep screwing up the connection between...