{"id":284,"date":"2016-10-15T16:24:24","date_gmt":"2016-10-15T12:24:24","guid":{"rendered":"https:\/\/optimizationup.com\/?p=284"},"modified":"2016-10-15T16:24:24","modified_gmt":"2016-10-15T12:24:24","slug":"advanced-performance-forecasting-techniques","status":"publish","type":"post","link":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/","title":{"rendered":"Advanced Performance Forecasting Techniques"},"content":{"rendered":"

Forecasting is a key element in conducting your performance media plans and campaigns’ success, before we explain how to forecast, we have to understand what regression analysis<\/strong> is. Regression analysis according to Wikipedia is a statistical process for estimating the relationships among variables. It allows us to make predictions about future outcomes by estimating the relationship between two variables, where we can utilize what happened in the past to predict what can happen in the future.<\/p>\n

To run a regression analysis, we need two things:-<\/p>\n

1- Dependent variable\u00a0<\/strong><\/p>\n

2- Independent Variable<\/strong><\/p>\n

In this article, we will be using the traffic<\/strong> (Independent Variable) to forecast the revenue<\/strong> (Dependent variable). In general,\u00a0the independent variable is the cause<\/strong> and the dependent variable is the effect<\/strong>.<\/p>\n

\"performance-forecast\"<\/p>\n

The first thing we have to do is to determine if there is a correlation between our variables.\u00a0Correlation<\/strong> is a statistical measure that indicates the extent to which two or more variables fluctuate together.\u00a0In other words, it measures how two variables change in relation to each other.\u00a0In our example, we want to determine the nature of the relationship between traffic and revenue. On of the easiest way is to use is excel<\/span>:-<\/p>\n

CORREL Excel<\/span> Formula<\/h5>\n

Through excel you can calculate the correlation between two variables using the CORREL function. The syntax of the formula is \u00a0CORREL(ARRAY1, ARRAY2)<\/code><\/p>\n

\"traffic-forecast\"<\/p>\n

So, the correlation between the traffic and the revenue in our case is:- 0.96<\/p>\n

If the number is closer to 1, it means there is a strong relationship between the two data<\/span> sets. If the number is close to 0, it means there is no or weak relationship between the two variables or in other words the relation between the two variables is Zero. So, in our case, the number is so close to 1 which means that there is a strong positive correlation between the traffic and revenue.<\/p>\n

Create a Scatter Chart<\/h5>\n

Plot the independent variable on the x-axis (traffic) and the dependent variable on the y-axis (revenue).<\/p>\n

\"scatter-graph-excel\"<\/p>\n

Find the best trend line<\/h5>\n

This step is really important, because if you pick the wrong trend line, your forecast won\u2019t be accurate. After you made the scatter chart you need now a line to connect these dots. Right click on your data<\/span> point and select \u201c Add Trendline\u201d<\/p>\n

\"trendline-graph-excel\"<\/p>\n

There are many types of trend line as you can see:-<\/p>\n

\"trendlines-excel\"<\/p>\n

To figure out which one fits your data<\/span>, we have to calculate R2<\/sup><\/strong>\u00a0or the coefficient of determination<\/strong> which is a number from 0 to 1 that describes how well a regression line fits a data set. In our case, it tells\u00a0us how well traffic can predict revenue. If the number is closer to 0, traffic is not a good predictor of revenue. If the number is closer to 1, traffic is a good predictor of revenue. To display R2<\/sup>, please see below:-<\/p>\n

\"r2-forecast-trendline\"<\/p>\n

Now you have to repeat the step for each line type till you know which line has the highest R2<\/sup> value. In our example, the linear trend line has the highest R2\u00a0<\/sup>value which means it’s the best fit for our forecast.<\/p>\n

\"trend-lines-forecast\"<\/p>\n

Now to begin forecasting, select the type of trendline that has the highest R2\u00a0<\/sup>value and then you need to insert in the forward section (of your trendline option) the number of periods into the future for which you want to forecast values.<\/p>\n

\"budget-forecast\"<\/p>\n

Summary<\/h5>\n

Forecasting is not just guessing. It involves use of certain data which becomes useful information through statistical process. \u00a0Effective planning, budgeting and forecasting \u00a0are important \u00a0skills that help organizations maximize revenues, manage costs and projects.\u00a0And one of the best forecasting techniques available is regression that you need to get the hang of it.<\/p>\n","protected":false},"excerpt":{"rendered":"

Forecasting is a key element in conducting your performance media plans and campaigns’ success, before we explain how to forecast, we have to understand what regression analysis is. Regression analysis according to Wikipedia is a statistical process for estimating the relationships among variables. It allows us to make predictions about future outcomes by estimating the…<\/p>\n

Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":300,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[41,35],"class_list":["post-284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-optimize","tag-analytics","tag-search"],"yoast_head":"\nAdvanced Performance Forecasting Techniques | Optimization Up<\/title>\n<meta name=\"description\" content=\"Forecasting is a key element in conducting your performance media plan and campaigns' success, but before we explain how to forecast, we have to understand\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced Performance Forecasting Techniques | Optimization Up\" \/>\n<meta property=\"og:description\" content=\"Forecasting is a key element in conducting your performance media plan and campaigns' success, but before we explain how to forecast, we have to understand\" \/>\n<meta property=\"og:url\" content=\"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/\" \/>\n<meta property=\"og:site_name\" content=\"Optimization Up\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/A7med.3lii\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-15T12:24:24+00:00\" \/>\n<meta name=\"author\" content=\"Ahmed Ali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@A7med_3ly\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ahmed Ali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/\"},\"author\":{\"name\":\"Ahmed Ali\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"headline\":\"Advanced Performance Forecasting Techniques\",\"datePublished\":\"2016-10-15T12:24:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/\"},\"wordCount\":616,\"commentCount\":4,\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#primaryimage\"},\"thumbnailUrl\":\"\",\"keywords\":[\"Analytics\",\"Search Engine Marketing\"],\"articleSection\":[\"Optimize\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/\",\"name\":\"Advanced Performance Forecasting Techniques | Optimization Up\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#primaryimage\"},\"thumbnailUrl\":\"\",\"datePublished\":\"2016-10-15T12:24:24+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"description\":\"Forecasting is a key element in conducting your performance media plan and campaigns' success, but before we explain how to forecast, we have to understand\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#primaryimage\",\"url\":\"\",\"contentUrl\":\"\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/advanced-performance-forecasting-techniques\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/optimizationup.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Advanced Performance Forecasting Techniques\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/\",\"name\":\"Optimization Up\",\"description\":\"Advanced Optimization & Analytics Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/optimizationup.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\",\"name\":\"Ahmed Ali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"caption\":\"Ahmed Ali\"},\"description\":\"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor & GA4 Auditor - discover all my products here.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/A7med.3lii\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/a7med-ali\\\/\",\"https:\\\/\\\/x.com\\\/A7med_3ly\"],\"url\":\"https:\\\/\\\/optimizationup.com\\\/author\\\/a7med\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced Performance Forecasting Techniques | Optimization Up","description":"Forecasting is a key element in conducting your performance media plan and campaigns' success, but before we explain how to forecast, we have to understand","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/","og_locale":"en_US","og_type":"article","og_title":"Advanced Performance Forecasting Techniques | Optimization Up","og_description":"Forecasting is a key element in conducting your performance media plan and campaigns' success, but before we explain how to forecast, we have to understand","og_url":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/","og_site_name":"Optimization Up","article_author":"https:\/\/www.facebook.com\/A7med.3lii","article_published_time":"2016-10-15T12:24:24+00:00","author":"Ahmed Ali","twitter_card":"summary_large_image","twitter_creator":"@A7med_3ly","twitter_misc":{"Written by":"Ahmed Ali","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#article","isPartOf":{"@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/"},"author":{"name":"Ahmed Ali","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"headline":"Advanced Performance Forecasting Techniques","datePublished":"2016-10-15T12:24:24+00:00","mainEntityOfPage":{"@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/"},"wordCount":616,"commentCount":4,"image":{"@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#primaryimage"},"thumbnailUrl":"","keywords":["Analytics","Search Engine Marketing"],"articleSection":["Optimize"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/","url":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/","name":"Advanced Performance Forecasting Techniques | Optimization Up","isPartOf":{"@id":"https:\/\/optimizationup.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#primaryimage"},"image":{"@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#primaryimage"},"thumbnailUrl":"","datePublished":"2016-10-15T12:24:24+00:00","author":{"@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"description":"Forecasting is a key element in conducting your performance media plan and campaigns' success, but before we explain how to forecast, we have to understand","breadcrumb":{"@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#primaryimage","url":"","contentUrl":""},{"@type":"BreadcrumbList","@id":"https:\/\/optimizationup.com\/advanced-performance-forecasting-techniques\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/optimizationup.com\/"},{"@type":"ListItem","position":2,"name":"Advanced Performance Forecasting Techniques"}]},{"@type":"WebSite","@id":"https:\/\/optimizationup.com\/#website","url":"https:\/\/optimizationup.com\/","name":"Optimization Up","description":"Advanced Optimization & Analytics Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/optimizationup.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768","name":"Ahmed Ali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","caption":"Ahmed Ali"},"description":"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor & GA4 Auditor - discover all my products here.","sameAs":["https:\/\/www.facebook.com\/A7med.3lii","https:\/\/www.linkedin.com\/in\/a7med-ali\/","https:\/\/x.com\/A7med_3ly"],"url":"https:\/\/optimizationup.com\/author\/a7med\/"}]}},"_links":{"self":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/comments?post=284"}],"version-history":[{"count":0,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/284\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/media?parent=284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/categories?post=284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/tags?post=284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}