Using Excel To Forecast Paid-Search Performance
Kayla Kurtz tells us how to estimate account performance before making a paid-search account active. She shows us the process by using Excel and a few simple formulas, but she tells us that the process should only provide marketers with a baseline to analyze data. It's not a sure thing. Pulling keyword tool data into and out of an Excel spreadsheet to analyze, totaling searches and averages of the cost per clicks, and checking terms in the traffic estimator produces an educated guess to predict account performance before it goes live.