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...

Ok - Now I have made my first sale - I have looked and seen everything that T202 can help me to make my next sale.

Interesting thing happened - the sale came from one of the ads that had the least number of clicks.

The sale came from a computer in a public library.
(Using an IP search and whosis thing) I am not sure if it was an employer of the library or somebody using a public computer.

The sale came from a keyword that you would think the user...