There is a is powerful tool to detect equations and hidden relationships among the data sets. What makes it irresistible tool is its cost - FREE!. It is Eureqa. In this blog I will explain how to find relationship between cost and long term revenue for a keyword campaign in Google Adwords. This is a simplied version of identifying a relationship at macro level and then drilling down further to identify more details.
The sample I have taken is over two months summarized data at daily level for a campaign. Since cost and revenue are affected by other factors including the keywords or ad words that comprised a campaign, competitors' bidding, landing page or page optimizations, etc., it is important to note that the following is to get a quick insight into how cost is related to revenue for a particular campaign. This is one of important arsenal out of few to get better positive ROI.
The data set is shown below in the application's tab 1(Enter Data). This very much looks like Excel spreadsheet!. First column is cost and second is long term revenue.
Related Posts: Generating quick positive SEM ROI
Data Engineering and Science, DW, BI & more - Posts by Shiva Maganahalli. Also, see http://www.hiregion.org
Showing posts with label Predictive Analysis. Show all posts
Showing posts with label Predictive Analysis. Show all posts
Subscribe to:
Posts (Atom)