{"id":11503,"date":"2018-01-10T10:41:54","date_gmt":"2018-01-10T10:41:54","guid":{"rendered":"https:\/\/www.mobidea.com\/academy\/?p=11503"},"modified":"2018-05-09T10:44:31","modified_gmt":"2018-05-09T10:44:31","slug":"analyze-affiliate-data","status":"publish","type":"post","link":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/","title":{"rendered":"How to Analyze Affiliate Data Like a Pro (and Why It&#8217;s Important)"},"content":{"rendered":"<div class=\"mobid-before-content\" style=\"margin-top: 5px;margin-bottom: 5px;margin-left: auto;margin-right: auto;text-align: center;\" id=\"mobid-1472469743\"><div class=\"mobid-adlabel\">Advertisement<\/div><a data-no-instant=\"1\" href=\"https:\/\/www.mobidea.com\/academy\/recommends\/banner-placement-1\/\" rel=\"noopener nofollow\" class=\"a2t-link\" target=\"_blank\" aria-label=\"da\"><img src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2022\/09\/da.gif\" alt=\"\"  class=\"no-lazyload\" width=\"730\" height=\"90\"   \/><\/a><\/div><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title ez-toc-toggle\" style=\"cursor:pointer\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#introduction\" >Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#the-importance-of-affiliate-data\" >The Importance of Affiliate Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#affiliate-metrics-data-becomes-real\" >Affiliate Metrics: Data Becomes Real<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#clicks\" >Clicks<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#visits\" >Visits<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#costs\" >Costs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#conversions\" >Conversions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#revenues\" >Revenues<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#margin\" >Margin<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#the-difficulty-of-analyzing-data-in-affiliate-marketing\" >The Difficulty of Analyzing Data in Affiliate Marketing<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#how-to-analyze-data-in-media-buying-campaigns\" >How to Analyze Data in Media Buying Campaigns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#how-to-use-excel-to-analyze-data-in-media-buying-campaigns\" >How to use Excel to Analyze Data in Media Buying Campaigns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#excel-features-you-can-use-to-analyze-data\" >Excel Features You Can Use to Analyze Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#analytical-tool-overview\" >Analytical Tool Overview<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#best-excel-shortcuts-for-data-analysis\" >Best Excel Shortcuts for Data Analysis<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#the-most-important-excel-formulas-you-need-to-know-to-analyze-data\" >The Most Important Excel Formulas You Need to Know to Analyze Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#examples-of-how-to-analyze-data-using-excel\" >Examples of How to Analyze Data Using Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"introduction\"><\/span>Introduction<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Wanna know a life-changing, jaw-dropping truth:<\/p>\n<p>Excel is the best thing you\u2019ll ever be able to explore in this god forsaken, barren land we call earth!<\/p>\n<p>Don\u2019t forget that info is power.<\/p>\n<p>This power is the result of a super thorough analytical mindset.<\/p>\n<p>You must know everything.<\/p>\n<p>Every detail is a giant step for you to know more and become better.<\/p>\n<p>The ability to know everything comes through Excel and its many awesome tools for data analysis.<\/p>\n<p>In this article, us Excel experts are gonna explore some of the most crucial data parameters you must bear in mind to succeed.<\/p>\n<p>We\u2019re gonna go through all the relevant details, with a special focus on what\u2019s gonna help you be the king of media buying analysis.<\/p>\n<p>We will refer to the most important Excel tools and show you how to use them for max efficiency.<\/p><div class=\"mobid-in-content-15-p\" style=\"margin-top: 26px;margin-bottom: 26px;\" id=\"mobid-1629861333\"><div class=\"mobid-adlabel\">Advertisement<\/div><a data-no-instant=\"1\" href=\"https:\/\/www.mobidea.com\/academy\/recommends\/semrush-v2\/\" rel=\"noopener nofollow\" class=\"a2t-link\" target=\"_blank\" aria-label=\"semrushtrialseo\"><img src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2022\/09\/semrushtrialseo.gif\" alt=\"\"  class=\"no-lazyload\" width=\"728\" height=\"90\"  style=\"display: inline-block;\" \/><\/a><\/div>\n<p>Ready for a post about the best Excel tips and tricks for affiliates?<\/p>\n<p>Prepared for some awesomely advanced Excel tricks that will optimize your media buying experience?<\/p>\n<p>Let\u2019s begin our journey through affiliate marketing databases and learn some super cool Excel tricks!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"the-importance-of-affiliate-data\"><\/span>The Importance of Affiliate Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In your life, you\u2019ll be tasked with making a bunch of relevant decisions.<\/p>\n<p>Where should you buy groceries if you want the cheapest supermarket prices?<\/p>\n<p>Which restaurant to pick for a lovely night out with your boo?<\/p>\n<p>How do you deal with all these decisions and their ramifications?<\/p>\n<p>Info.<\/p>\n<p>You always need information to decide.<\/p>\n<p>How do you get this info?<\/p>\n<p>By analyzing data.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1.jpg\"><img decoding=\"async\" width=\"700\" height=\"394\" class=\"aligncenter size-large wp-image-9763\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-700x394.jpg\" alt=\"man analyzing data\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-700x394.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-250x141.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-768x432.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-1024x576.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-760x428.jpg 760w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-623x351.jpg 623w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-316x177.jpg 316w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-150x84.jpg 150w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1-120x68.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/man-analyzing-data-1.jpg 1500w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>This is why a complete dataset makes all the difference.<\/p>\n<p>Quality data usually means quality decisions.<\/p>\n<p>Why not always?<\/p>\n<p>Because it depends on the way that data is actually analyzed.<\/p>\n<p>Later on, we\u2019ll go through the data-analysis best practices.<\/p>\n<p>For now, though, we\u2019re gonna focus on datasets.<\/p>\n<p>Which question should we ask ourselves?<\/p>\n<p>\u201cWhich is the most relevant data to know in the media buying game?\u201d<\/p>\n<p>Ready for a rundown of important affiliate metrics?<\/p>\n<p>Let\u2019s go check them so that you can be ready for the best tips and tricks for Microsoft Excel!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"affiliate-metrics-data-becomes-real\"><\/span>Affiliate Metrics: Data Becomes Real<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You know as well as any other affiliate marketer out there that affiliate metrics are remarkably important.<\/p>\n<p>They allow you to measure results and get the data you need to optimize faster like a master!<\/p>\n<p>Ready to understand which are the metrics for affiliate marketing that you need to check to analyze that sweet data?<\/p>\n<p>Check these <a href=\"https:\/\/www.mobidea.com\/academy\/affiliate-marketing-metrics\/\">affiliate metrics<\/a>!<\/p>\n<h3><span class=\"ez-toc-section\" id=\"clicks\"><\/span><span style=\"font-size: 14pt;\"><strong>Clicks<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The quantity of clicks you received in a <a href=\"https:\/\/www.mobidea.com\/academy\/banner-design-ads\/\">banner<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"visits\"><\/span><span style=\"font-size: 14pt;\"><strong>Visits<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The quantity of visits on the <a href=\"https:\/\/www.mobidea.com\/academy\/mobile-pre-landers\/\">prelander<\/a> or <a href=\"https:\/\/www.mobidea.com\/academy\/affiliate-landing-pages\/\">landing page<\/a>.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"costs\"><\/span><span style=\"font-size: 14pt;\"><strong>Costs<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The costs you must pay to generate the number of clicks\/visits you have.<\/p>\n<p>It\u2019ll always be a relation between volumes and the costs per click\/impressions\/visits you have.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"conversions\"><\/span><span style=\"font-size: 14pt;\"><strong>Conversions<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The number of conversions\/subscriptions you get from your traffic.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"revenues\"><\/span><span style=\"font-size: 14pt;\"><strong>Revenues<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The revenues you\u2019ve gotten from the conversions\/subscriptions your traffic has generated.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills.jpg\"><img decoding=\"async\" width=\"700\" height=\"394\" class=\"aligncenter size-large wp-image-9281\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-700x394.jpg\" alt=\"person with money bills\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-700x394.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-250x141.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-768x432.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-1024x576.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-760x428.jpg 760w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-623x351.jpg 623w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-316x177.jpg 316w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-150x84.jpg 150w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills-120x68.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/person-with-money-bills.jpg 1500w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>It\u2019s always a relation between the <a href=\"https:\/\/www.mobidea.com\/academy\/mobile-cpa\/\">CPA<\/a>\/payout and the number of conversions.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"margin\"><\/span><strong><span style=\"font-size: 14pt;\">Margin<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>What you\u2019ve really earned.<\/p>\n<p>This is your profit.<\/p>\n<p>The revenues minus the costs.<\/p>\n<p>This is the info you need if you want to start.<\/p>\n<p>What?<\/p>\n<p>You wanna dive deeper?<\/p>\n<p>Then we\u2019ll have to start exploring a real special little something:<\/p>\n<p>Affiliate data details.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"the-difficulty-of-analyzing-data-in-affiliate-marketing\"><\/span>The Difficulty of Analyzing Data in Affiliate Marketing<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You\u2019re analyzing data.<\/p>\n<p>The vibe is right, you seem up for it, it\u2019s all going your way.<\/p>\n<p>But wait!<\/p>\n<p>What\u2019s the main difficulty you experience when analyzing data in affiliate marketing?<\/p>\n<p>There are three main issues that come about.<\/p><div class=\"mobid-in-content-15-p_2-2\" style=\"margin-top: 26px;margin-bottom: 26px;\" id=\"mobid-524725216\"><div class=\"mobid-adlabel\">Advertisement<\/div><a data-no-instant=\"1\" href=\"https:\/\/www.mobidea.com\/academy\/recommends\/semrush-v1\/\" rel=\"noopener nofollow\" class=\"a2t-link\" target=\"_blank\" aria-label=\"backlinks\"><img src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2021\/03\/PD-970x250-Discover-backlinks-faster-than-ever-1.png\" alt=\"\"  srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2021\/03\/PD-970x250-Discover-backlinks-faster-than-ever-1.png 970w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2021\/03\/PD-970x250-Discover-backlinks-faster-than-ever-1-250x52.png 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2021\/03\/PD-970x250-Discover-backlinks-faster-than-ever-1-700x144.png 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2021\/03\/PD-970x250-Discover-backlinks-faster-than-ever-1-768x158.png 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2021\/03\/PD-970x250-Discover-backlinks-faster-than-ever-1-120x25.png 120w\" sizes=\"(max-width: 970px) 100vw, 970px\" class=\"no-lazyload\" width=\"970\" height=\"200\"  style=\"display: inline-block;\" \/><\/a><\/div>\n<p>Let\u2019s check each one in detail, shall we?<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Three Data-Related Difficulties<\/strong><\/span><\/p>\n<p><strong><span style=\"font-size: 14pt;\">Volumes<\/span><\/strong><\/p>\n<p>Now here\u2019s something that can be super hard.<\/p>\n<p>The quantity of data can make sure that tracking volumes is a complicated endeavor.<\/p>\n<p>If you start by working on a couple of campaigns, then maybe you can follow their evolution.<\/p>\n<p>What if you begin adding campaigns willy-nilly?<\/p>\n<p>Tracking all the volumes is gonna get mighty complex.<\/p>\n<p>The difficulties will start troubling you.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man.jpg\"><img decoding=\"async\" width=\"700\" height=\"393\" class=\"aligncenter size-large wp-image-8718\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-700x393.jpg\" alt=\"worried man\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-700x393.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-250x141.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-768x432.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-1024x575.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-760x428.jpg 760w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-623x351.jpg 623w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-316x177.jpg 316w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-150x84.jpg 150w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man-120x67.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/12\/worried-man.jpg 1500w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>You\u2019ll have a hard time understanding which campaigns are losing money and where.<\/p>\n<p>What to do?<\/p>\n<p>Follow our advice and check a couple of tools.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Tracking Platform<\/strong><\/span><\/p>\n<p>This is where you can configure the campaigns and receive all the information you need to calibrate optimizations like a master.<\/p>\n<p>You can track conversions made by country, carrier, operating system, device, browser and much more.<\/p>\n<p><strong><em>Learn More: <a href=\"https:\/\/www.mobidea.com\/academy\/affiliate-tracking-platforms\/\">The Best Affiliate Tracking Platforms to Know in 2018<\/a><\/em><\/strong><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Excel<\/strong><\/span><\/p>\n<p>You\u2019ll need to analyze huge databases.<\/p>\n<p>This means you\u2019ll need a tool like Excel to help you.<\/p>\n<p>In this article, we\u2019ll show you how to use it properly for you to really take max advantage.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Details<\/strong><\/span><\/p>\n<p>If you want to succeed in this industry, you need to go into detail.<\/p>\n<p>You must thoroughly analyze each parameter and its many <a href=\"https:\/\/www.mobidea.com\/academy\/correlation-volume-bid-ctr\/\">correlations<\/a>.<\/p>\n<p>You\u2019ll need to know your most profitable campaigns and where you should focus your attention.<\/p>\n<p>Look at the websites and understand which ones are golden.<\/p>\n<p>Check operating systems with a high performance and others which aren\u2019t as well known.<\/p>\n<p>Look for the specific <a href=\"https:\/\/www.mobidea.com\/academy\/profitable-niches\/\">niches<\/a> in which you can increase your profits.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1.jpg\"><img decoding=\"async\" width=\"700\" height=\"394\" class=\"aligncenter size-large wp-image-10715\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-700x394.jpg\" alt=\"bills of money falling\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-700x394.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-250x141.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-768x432.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-760x428.jpg 760w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-623x351.jpg 623w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-316x177.jpg 316w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-150x84.jpg 150w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2017\/07\/bills-of-money-falling-1-120x68.jpg 120w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><strong><span style=\"font-size: 14pt;\">Correlations<\/span><\/strong><\/p>\n<p>With so many parameters, it\u2019s only natural that there are many correlations.<\/p>\n<p>One of the most obvious correlations is the one which occurs between the iOS operating system and iPhone\/iPad devices.<\/p>\n<p>iOS not showcasing the best results?<\/p>\n<p>It may be due to one of those devices.<\/p>\n<p>There are lots of unexpected correlations.<\/p>\n<p>For example, don\u2019t expect that certain sets of banners will only work for a particular website.<\/p>\n<p>What to do?<\/p>\n<p>Go into detail.<\/p>\n<p>Check different correlations that may appear.<\/p>\n<p>For that, you need a tool that allows for an easy and super fast analysis.<\/p>\n<p>Is it Excel, you ask?<\/p>\n<p>You know it, bro!<\/p>\n<h2><span class=\"ez-toc-section\" id=\"how-to-analyze-data-in-media-buying-campaigns\"><\/span>How to Analyze Data in Media Buying Campaigns<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Do you wanna analyze media buying campaigns like a master?<\/p>\n<p>Then it\u2019s super important to have a great tracking solution or at least to <a href=\"https:\/\/www.mobidea.com\/academy\/dynamic-tracking\/\">configure the postback<\/a> correctly.<\/p>\n<p>It\u2019s the only way for you to get relevant and highly-valuable data to analyze.<\/p>\n<p>Let\u2019s say that you have one of these tools implemented.<\/p>\n<p>Then it\u2019s gonna be easier for you to effectively optimize your data using Excel.<\/p>\n<p>Excel allows you to match, configure, relate and organize data.<\/p>\n<p>This will allow you to come up with conclusions.<\/p>\n<p>But how can you analyze a <a href=\"https:\/\/www.mobidea.com\/academy\/media-buying-budget-strategy\/\">media buying campaign<\/a>?<\/p>\n<p>Check some clues!<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Analyzing Campaigns<\/strong><\/span><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Overview<\/strong><\/span><\/p>\n<p>First thing to do?<\/p>\n<p>Get an overall view of your campaigns.<\/p>\n<p>Which ones are losing, which ones are mighty profitable and which ones need your immediate attention.<\/p>\n<p>How to do it?<\/p>\n<p>Just match the campaign\u2019s revenues and the campaign\u2019s costs per day.<\/p>\n<p>You\u2019ll have an idea about how your investment is actually going and what\u2019s the effective impact of your actions.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters.jpg\"><img decoding=\"async\" width=\"700\" height=\"193\" class=\"aligncenter size-large wp-image-11510\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters-700x193.jpg\" alt=\"excel parameters\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters-700x193.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters-250x69.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters-768x211.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters-1024x282.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters-120x33.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-parameters.jpg 1323w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Look for margin rates.<\/p>\n<p>It\u2019ll help you control your investment and to know when to stop or invest more.<\/p>\n<p>First, go and check the campaign which appears to be losing a whole lotta money.<\/p>\n<p>Then, take quick and swift action.<\/p>\n<p>This will have a major impact on the total margin.<\/p>\n<p>Now\u2019s the moment to go into detail.<\/p>\n<p>Choose a campaign and analyze all the parameters thoroughly.<\/p>\n<p>Check for heavy losses, websites, devices, operating systems, etc.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Banners<\/strong><\/span><\/p>\n<p>We may begin the optimization by looking at banners.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters.jpg\"><img decoding=\"async\" width=\"700\" height=\"120\" class=\"aligncenter size-large wp-image-11511\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters-700x120.jpg\" alt=\"banner parameters\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters-700x120.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters-250x43.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters-768x131.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters-1024x175.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters-120x21.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/banner-parameters.jpg 1636w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Always have 3 banners.<\/p>\n<p>Why?<\/p>\n<p>Because you should be following the <a href=\"https:\/\/www.mobidea.com\/academy\/banners-tips-improve-performance\/\">optimal rule of banners<\/a>.<\/p>\n<p>Two good banners and one that you wanna test.<\/p>\n<p>See the image above?<\/p>\n<p>We believe it\u2019s easy to see that the banner which has the highest CTR is also the one with the lowest eCPA.<\/p>\n<p>It isn\u2019t always the case.<\/p>\n<p>Even so, it\u2019s frequent that there actually is a correlation between both.<\/p>\n<p>What to do?<\/p>\n<p>Stop banner 3 and add a new one to be tested.<\/p>\n<p>Pro tip:<\/p>\n<p>Always remember that banners have no correlation with other parameters!<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Websites<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters.jpg\"><img decoding=\"async\" width=\"700\" height=\"182\" class=\"aligncenter size-large wp-image-11512\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters-700x182.jpg\" alt=\"websites parameters\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters-700x182.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters-250x65.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters-768x199.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters-1024x266.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters-120x31.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/websites-parameters.jpg 1491w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Let\u2019s imagine your campaign has a payout of 0.85\u20ac.<\/p>\n<p>Looking at the eCPA values, it\u2019s easy to see that SITE 5 is the one you should stop.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Devices VS Operating Systems<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters.jpg\"><img decoding=\"async\" width=\"700\" height=\"213\" class=\"aligncenter size-large wp-image-11513\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters-700x213.jpg\" alt=\"devices parameters\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters-700x213.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters-250x76.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters-768x233.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters-1024x311.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters-120x36.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/devices-parameters.jpg 1590w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters.jpg\"><img decoding=\"async\" width=\"700\" height=\"153\" class=\"aligncenter size-large wp-image-11514\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters-700x153.jpg\" alt=\"operating systems parameters\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters-700x153.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters-250x55.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters-768x168.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters-1024x224.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters-120x26.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/operating-systems-parameters.jpg 1640w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>In these two images, you can see that Android is correlated with several devices.<\/p>\n<p>Let\u2019s suppose that the payout is 0.50\u20ac.<\/p>\n<p>It means that &#8211; with an eCPA of 0.53\u20ac for Android &#8211; you\u2019re losing money.<\/p>\n<p>Should you stop Android?<\/p>\n<p>No.<\/p>\n<p>Why not?<\/p>\n<p>Because of correlations.<\/p>\n<p>Samsung, Samsung tablets and Lenovo are the sources of the bad performance.<\/p>\n<p>Stopping these will make Android profitable and the campaign positive.<\/p>\n<p>By analyzing the correlations, you\u2019ve made your campaign profitable.<\/p>\n<p>There are also positive correlations.<\/p>\n<p>Check your best targets, the correlation between them, and then target those specific ones by creating a new campaign.<\/p>\n<p>Finally, take a look at the prices of your campaign.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices.jpg\"><img decoding=\"async\" width=\"700\" height=\"117\" class=\"aligncenter size-large wp-image-11516\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices-700x117.jpg\" alt=\"campaign prices\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices-700x117.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices-250x42.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices-768x128.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices-1024x171.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices-120x20.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/campaign-prices.jpg 1799w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>On day 6, there\u2019s a decrease of impressions and a CPM increase due to competition.<\/p>\n<p>In this case, it\u2019s clear that someone has gotten your position, therefore decreasing both your volumes and traffic quality.<\/p>\n<p>Since your CPM increased, someone has been able to get a position below you.<\/p>\n<p>The result is an increase of the eCPA, which may turn a profitable campaign into a black hole.<\/p>\n<p>These analyses are fundamental if you want to turn your campaigns into <a href=\"https:\/\/www.mobidea.com\/academy\/trail-unexplored-path\/\">gold mines<\/a>.<\/p>\n<p>With Excel, you can improve your efficiency and reach the next level.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"how-to-use-excel-to-analyze-data-in-media-buying-campaigns\"><\/span>How to use Excel to Analyze Data in Media Buying Campaigns<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel is an extremely useful tool for data analysis.<\/p>\n<p>If you don\u2019t want to get involved with programming, then Excel really is both the fastest and easiest tool for you to use.<\/p>\n<p>Anyone can learn how to explore Excel.<\/p>\n<p>It\u2019s just a matter of getting used to the functions and their specific goals.<\/p>\n<p>Why is Excel the belle of the ball?<\/p>\n<p>Here are three good reasons why!<\/p>\n<ul style=\"list-style-type: disc;\">\n<li>Easier to analyze data<\/li>\n<li>Great at summarizing in different ways<\/li>\n<li>Useful for you to compare building a pivot table report instead of having to go through the process of building the same report manually<\/li>\n<\/ul>\n<p>Boring, indeed!<\/p>\n<p><a href=\"https:\/\/www.mobidea.com\/academy\/focus-mobile\/\">Mobile marketing<\/a> gets bigger, more popular, and more interesting by the minute.<\/p>\n<p>As you get into it, you\u2019ll understand that there are a lot more parameters and variables to be tracked and analyzed.<\/p>\n<p>Through the use of pivot tables, you can perform a successful A\/B testing and also split test offers.<\/p>\n<p>There are even some Excel Pivot table tricks you can use to maximize success.<\/p>\n<p>Excel will basically help you create cross tabulations of keywords.<\/p>\n<p>Pivot Tables provide you with a versatile way to handle all those extra columns that you have to deal with in your reports.<\/p>\n<p>Then, all this precious info will be processed through pivot tables in order to optimize your campaigns.<\/p>\n<p>Pivot tables are terrific to analyze data on the fly without building a full program.<\/p>\n<p>This really is one of the best tricks in Microsoft Excel, brother!<\/p>\n<p>You don\u2019t even have to know any Excel formulas.<\/p>\n<p>The name &#8220;Pivot Table&#8221; somehow makes it sound like it&#8217;s some advanced gizmo only reserved for Excel wizards.<\/p>\n<p>It&#8217;s actually quite the opposite.<\/p>\n<p>It&#8217;s an easy, fast, yet powerful way for marketers who aren\u2019t familiar with Excel to quickly analyze large amounts of data.<\/p>\n<p>Are you someone who believes Excel gives you a general headache?<\/p>\n<p>We both promise this experience is gonna be free of agonizing pain!<\/p>\n<p>Compare building a pivot table report to the process of building the same report manually.<\/p>\n<p>How?<\/p>\n<p>Check the video below!<\/p>\n<p><iframe loading=\"lazy\" title=\"Why pivot tables?\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/3kO_YqUpBCE?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<h2><span class=\"ez-toc-section\" id=\"excel-features-you-can-use-to-analyze-data\"><\/span>Excel Features You Can Use to Analyze Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Analyzing your data used to be quite the boring process.<\/p>\n<p>It was a ton of work.<\/p>\n<p>With Excel, though, everything changes for the better.<\/p>\n<p>Indeed, with this amazing tool, it\u2019ll only take a few steps for you to analyze like a pro.<\/p>\n<p>You can instantly create different types of charts, including line and column charts, or add miniature graphs.<\/p>\n<p>You can also apply a table style, create Pivot Tables, quickly insert totals, and apply conditional formatting.<\/p>\n<p>Amazing!<\/p>\n<p>So many cool tricks in Excel, so little time!<\/p>\n<p>Here\u2019s a neat trick we\u2019ll teach you.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Trick &#8211; First Part<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/support.office.com\/en-us\/article\/Select-cells-ranges-rows-or-columns-on-a-worksheet-23f64223-2b6b-453a-8688-248355f10fa9?ui=en-US&amp;rs=en-US&amp;ad=US\" target=\"_blank\" rel=\"noopener\">Select the cells<\/a> that contain the data you want to analyze.<\/p>\n<p><strong><span style=\"font-size: 14pt;\">Trick &#8211; Second Part<\/span><\/strong><\/p>\n<p>Click the Quick Analysis button that appears at the bottom right of your selected data (or press CRTL + Q).<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel.jpg\"><img decoding=\"async\" width=\"576\" height=\"585\" class=\"aligncenter size-full wp-image-11519\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel.jpg\" alt=\"quick analysis excel\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel.jpg 576w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel-250x254.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel-120x122.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel-32x32.jpg 32w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel-50x50.jpg 50w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/quick-analysis-excel-64x64.jpg 64w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/a><\/p>\n<p>Which analytical feature should you use?<\/p>\n<p>If you\u2019re not sure which analytical option to pick, here\u2019s a quick overview.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"analytical-tool-overview\"><\/span>Analytical Tool Overview<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-size: 14pt;\"><strong>Quick Analysis<\/strong><\/span><\/p>\n<p>In the \u201cQuick Analysis\u201d gallery, select the tab you want.<\/p>\n<p>For example, formatting lets you highlight parts of your data by adding things like data bars and colors.<\/p>\n<p>This lets you see high and low values, among other things.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel.jpg\"><img decoding=\"async\" width=\"700\" height=\"271\" class=\"aligncenter size-large wp-image-11520\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel-700x271.jpg\" alt=\"formatting excel\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel-700x271.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel-250x97.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel-768x298.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel-1024x397.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel-120x47.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/formatting-excel.jpg 1295w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Charts<\/strong><\/span><\/p>\n<p>Excel recommends different charts, based on the type of data you\u2019ve selected.<\/p>\n<p>If you don\u2019t see the chart you want, click on \u201cMore Charts\u201d.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel.jpg\"><img decoding=\"async\" width=\"700\" height=\"273\" class=\"aligncenter size-large wp-image-11521\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel-700x273.jpg\" alt=\"charts excel\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel-700x273.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel-250x97.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel-768x299.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel-1024x399.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel-120x47.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/charts-excel.jpg 1296w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>You might notice that the options you can choose from aren\u2019t always the same.<\/p>\n<p>That\u2019s because the options change based on the type of data you\u2019ve selected in your workbook.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Totals<\/strong><\/span><\/p>\n<p>Totals allow you calculate the numbers in columns and rows.<\/p>\n<p>For example, the \u201cRunning Total\u201d inserts a total that grows as you add items to your data.<\/p>\n<p>Click the little arrows on the right and left to see additional options.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel.jpg\"><img decoding=\"async\" width=\"700\" height=\"272\" class=\"aligncenter size-large wp-image-11522\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel-700x272.jpg\" alt=\"totals excel\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel-700x272.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel-250x97.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel-768x299.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel-1024x398.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel-120x47.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/totals-excel.jpg 1293w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Tables make it easy for you to filter and sort your data.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel.jpg\"><img decoding=\"async\" width=\"700\" height=\"273\" class=\"aligncenter size-large wp-image-11523\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel-700x273.jpg\" alt=\"tables excel\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel-700x273.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel-250x97.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel-768x299.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel-1024x399.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel-120x47.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/tables-excel.jpg 1294w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Sparklines are like tiny graphs that you can show along your data.<\/p>\n<p>They provide you with a quick way to see trends.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel.jpg\"><img decoding=\"async\" width=\"700\" height=\"255\" class=\"aligncenter size-large wp-image-11524\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel-700x255.jpg\" alt=\"sparklines excel\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel-700x255.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel-250x91.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel-768x280.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel-1024x373.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel-120x44.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/sparklines-excel.jpg 1185w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"best-excel-shortcuts-for-data-analysis\"><\/span>Best Excel Shortcuts for Data Analysis<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are hundreds of Excel shortcuts and tricks for you to explore.<\/p>\n<p>The problem with this is that it can become overwhelming for you to have to know them all by heart.<\/p>\n<p>You can\u2019t possibly absorb 233 new shortcut keys and start using them.<\/p>\n<p>That\u2019s why we\u2019ve got you covered, bro!<\/p>\n<p>The following sections cover some of the best shortcut keys.<\/p>\n<p>Try to incorporate a new shortcut key into your Excel routine every week.<\/p>\n<p>Prepared for a lesson about the best tricks in Excel?<\/p>\n<p>Dive into it!<\/p>\n<p><strong><span style=\"font-size: 14pt;\">Excel Shortcuts List<\/span><\/strong><\/p>\n<p><strong><span style=\"font-size: 14pt;\">Move Quickly<\/span><\/strong><\/p>\n<p>This is one of the best Excel shortcuts tips and tricks.<\/p>\n<p>Let\u2019s understand how to move quickly among worksheets.<\/p>\n<p>Ctrl + Page Down jumps to the next worksheet.<\/p>\n<p>Ctrl + Page Up jumps to the previous worksheet.<\/p>\n<p>Let\u2019s pretend that your workbook has 12 worksheets named Jan, Feb, Mar, . . . Dec.<\/p>\n<p>If you\u2019re currently on the Jan worksheet, hold down Ctrl and press Page Down five times to move to Jun.<\/p>\n<p>Great, isn\u2019t it?<\/p>\n<p>It really is one of those awesome Excel tricks for you to explore.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Jump to the Bottom<\/strong><\/span><\/p>\n<p>Jump to the bottom of data with Ctrl+Arrow<\/p>\n<p>As long as there are no blank cells in your data, just press Ctrl+Down Arrow to move to the last row in the data set.<\/p>\n<p>Use Ctrl+Up Arrow to move to the first row in the data set.<\/p>\n<p>Quick and easy!<\/p>\n<p>Keep reading for some more useful tricks in Excel.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Current Region<\/strong><\/span><\/p>\n<p>This is one of the most important and useful Excel tips and tricks for beginners.<\/p>\n<p>Select the current region with Ctrl+*<\/p>\n<p>Press Ctrl * to select the current range.<\/p>\n<p>The current range is the whole dataset, in all directions from the current cell until Excel hits the edge of the worksheet or a completely blank row and column.<\/p>\n<p>Let\u2019s say you&#8217;ve just selected A2:J987654 but you\u2019re staring at the bottom-right corner of your data.<\/p>\n<p>Press Ctrl + Period to move to the next corner of your data.<\/p>\n<p>Since you\u2019re at the bottom-right corner, it will take two presses of Ctrl + Period to move to the top-left corner.<\/p>\n<p>Even though this moves the active cell, it doesn\u2019t undo your selection.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Popping Open the Right-Click Menu<\/strong><\/span><\/p>\n<p>More useful Excel tricks?<\/p>\n<p>Go for it!<\/p>\n<p>Pop open the right-click menu using Shift + F10<\/p>\n<p>Pressing Shift + F10 opens the right-click menu.<\/p>\n<p>Use the up\/down arrow keys to move to various menu choices and the right arrow key to open a fly-out menu.<\/p>\n<p>When you get to the item you want, press Enter to select it.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Time-Stamp<\/strong><\/span><\/p>\n<p>Date-stamp or time-stamp using Ctrl shift ; or Ctrl shift :<\/p>\n<p>Here\u2019s an easy way to remember this shortcut.<\/p>\n<p>What time is it right now?<\/p>\n<p>It\u2019s 11:21 here.<\/p>\n<p>There\u2019s a colon in the time.<\/p>\n<p>Press Ctrl+Colon to enter the current time in the active cell.<\/p>\n<p>Note that this is not the same as using =NOW() or =TODAY().<\/p>\n<p>Those functions change over time.<\/p>\n<p>These shortcuts mark the time or date in which you pressed the key and the value does not change.<\/p>\n<p>Neat, right?<\/p>\n<p>Another one of those splendid tricks for Excel you have to explore.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Last Task Repeat<\/strong><\/span><\/p>\n<p>Repeat the last task with F4.<\/p>\n<p>Let\u2019s say you\u2019ve just selected a cell.<\/p>\n<p>Here\u2019s what happened next:<\/p>\n<p>Home, Delete, Delete Cells, Delete Entire Row, OK.<\/p>\n<p>You need to delete 24 more rows in various spots throughout your data set.<\/p>\n<p>Select a cell in the next row to delete and press F4, which repeats the last command but on the currently selected cell.<\/p>\n<p>Select a cell in the next row to delete and press F4.<\/p>\n<p>Before you know it, all 24 rows will be deleted.<\/p>\n<p>That\u2019s right!<\/p>\n<p>You didn\u2019t have to click on Home, Delete, Delete Cells, Delete Entire Row, OK 24 times.<\/p>\n<p>The F4 key works with 92% of the commands you\u2019ll use.<\/p>\n<p>Try it.<\/p>\n<p>You&#8217;ll love it.<\/p>\n<p>It&#8217;ll be obvious when you try to use one of the unusual commands that can\u2019t be redone with F4.<\/p>\n<p>Simple, right?<\/p>\n<p>Now that\u2019s one of the most useful Excel spreadsheet tricks for you to dive into!<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Dollar Sign<\/strong><\/span><\/p>\n<p>Add dollar signs to a reference with F4.<\/p>\n<p>When you\u2019re entering a formula and you need to change A1 to $A$1, click F4 while the insertion point is touching A1.<\/p>\n<p>You can press F4 again in order to freeze only the row with A$1.<\/p>\n<p>Press F4 again to freeze the column with $A1.<\/p>\n<p>Press again to toggle back to A1.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"the-most-important-excel-formulas-you-need-to-know-to-analyze-data\"><\/span>The Most Important Excel Formulas You Need to Know to Analyze Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ready to use the most famous formulas like a pro?<\/p>\n<p>Need some Excel formula tricks from these two masters?<\/p>\n<p>Pay attention, then!<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>VLOOKUP<\/strong><\/span><\/p>\n<p>This is a blessing for any mobile marketer.<\/p>\n<p>It\u2019s one of the best tricks on Excel!<\/p>\n<p>This incredible function is great for comparing and connecting different sets of data.<\/p>\n<p>Basically, this formula will ascertain whether a given value from one table exists in the first column of another table, and then return a value from the second table.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup.jpg\"><img decoding=\"async\" width=\"700\" height=\"145\" class=\"aligncenter size-large wp-image-11526\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup-700x145.jpg\" alt=\"vlookup\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup-700x145.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup-250x52.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup-768x159.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup-1024x212.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup-120x25.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/vlookup.jpg 1091w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Tip:<\/p>\n<p>Don\u2019t forget to lock the range of the second table.<\/p>\n<p>This is a common error when copying this formula.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>CONCATENATE or &amp;.<\/strong><\/span><\/p>\n<p>This is pretty useful.<\/p>\n<p>It\u2019s one of those Excel sheet tricks everyone should know.<\/p>\n<p>It comes in handy when you\u2019re creating different keyword lists or adding tracking parameters to URLs:<\/p>\n<p>Tip:<\/p>\n<p>We personally prefer using the \u201c&amp;\u201d symbol.<\/p>\n<p>Why?<\/p>\n<p>Because it\u2019s shorter than typing a full \u201cconcatenate\u201d formula, but does the same exact thing.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate.jpg\"><img decoding=\"async\" width=\"700\" height=\"78\" class=\"aligncenter size-large wp-image-11527\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate-700x78.jpg\" alt=\"concatenate\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate-700x78.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate-250x28.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate-768x85.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate-1024x114.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate-120x13.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/concatenate.jpg 1653w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>LEN<\/strong><\/span><\/p>\n<p>This is great when you\u2019re writing for a banner.<\/p>\n<p>That\u2019s why it\u2019s one of the most popular Excel tricks and shortcuts for affiliates.<\/p>\n<p>Simply put this formula next to your description cells.<\/p>\n<p>What will happen?<\/p>\n<p>It will tell you when there is more room available, or when it\u2019s over the character limit.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len.jpg\"><img decoding=\"async\" width=\"700\" height=\"227\" class=\"aligncenter size-large wp-image-11528\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len-700x227.jpg\" alt=\"len\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len-700x227.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len-250x81.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len-768x249.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len-1024x333.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len-120x39.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/len.jpg 1139w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Text to Columns<\/strong><\/span><\/p>\n<p>We find this Excel magic trick to be super useful, especially when we work with destination URL lists.<\/p>\n<p>It\u2019s one of those Excel spreadsheet tips and tricks that you need to grasp!<\/p>\n<p>Let\u2019s say you\u2019ve got a URL report and that you\u2019d like to analyze the performance per unique URL.<\/p>\n<p>However, every destination URL has a unique parameter attached.<\/p>\n<p>Check the image below to see magic happen.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns.jpg\"><img decoding=\"async\" width=\"700\" height=\"340\" class=\"aligncenter size-large wp-image-11529\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns-700x340.jpg\" alt=\"text to columns\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns-700x340.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns-250x121.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns-768x373.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns-1024x497.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns-120x58.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/text-to-columns.jpg 1343w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Were we right or not?<\/p>\n<p>See?<\/p>\n<p>This is one of those cool Microsoft Excel tricks everyone should know.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"examples-of-how-to-analyze-data-using-excel\"><\/span>Examples of How to Analyze Data Using Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You\u2019ve checked all these amazing Excel tricks and awesome examples.<\/p>\n<p>Now, what?<\/p>\n<p>It\u2019s time to put these new Excel tricks into practice.<\/p>\n<p>Doing <a href=\"https:\/\/www.mobidea.com\/academy\/what-is-mobile-affiliate-marketing\/\">mobile affiliate marketing<\/a>?<\/p>\n<p>Then you know as well as we do that there are a lot of variables which can be tracked.<\/p>\n<p>You can track brands, models, carriers, websites and so on.<\/p>\n<p>Imagine you had amazing data about affiliate marketing.<\/p>\n<p>It represented the traffic an affiliate had sent to an offer.<\/p>\n<p>They want to find what they could do with the data to find the campaign\u2019s best-converting segments.<\/p>\n<p>As previously mentioned, Pivot tables will allow you to easily analyze this data.<\/p>\n<p>There are a bunch of Excel pivot table tips and tricks for you to know.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Step One<\/strong><\/span><\/p>\n<p>Select all, table.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table.jpg\"><img decoding=\"async\" width=\"700\" height=\"353\" class=\"aligncenter size-large wp-image-11530\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table-700x353.jpg\" alt=\"excel pivot table\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table-700x353.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table-250x126.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table-768x387.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table-1024x516.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table-120x60.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-pivot-table.jpg 1300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Step Two<\/strong><\/span><\/p>\n<p>Insert\/Pivot Table\/OK<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-tables-insert.jpg\"><img decoding=\"async\" width=\"605\" height=\"511\" class=\"aligncenter size-full wp-image-11531\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-tables-insert.jpg\" alt=\"pivot tables insert\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-tables-insert.jpg 605w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-tables-insert-250x211.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-tables-insert-120x101.jpg 120w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Step Three<\/strong><\/span><\/p>\n<p>In any pivot table, you need to fill the box with the corresponding variable.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/variable-box.jpg\"><img decoding=\"async\" width=\"577\" height=\"484\" class=\"aligncenter size-full wp-image-11532\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/variable-box.jpg\" alt=\"variable box\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/variable-box.jpg 577w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/variable-box-250x210.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/variable-box-120x101.jpg 120w\" sizes=\"(max-width: 577px) 100vw, 577px\" \/><\/a><\/p>\n<p>a) Filter \u2013 pre-selection of what you want<br \/>\nb) Rows \u2013 for your x-axis<br \/>\nc) Columns \u2013 for your y-axis<br \/>\nd) Values<br \/>\n\u00a7 Count<br \/>\n\u00a7 Sum<br \/>\n\u00a7 Max<br \/>\n\u00a7 Min<br \/>\n\u00a7 Average<\/p>\n<p>Select the field you want to see in the row fields area.<\/p>\n<p>In this case, you\u2019ll select Campaign.<\/p>\n<p>This is what you want to analyze.<\/p>\n<p>For the columns, press clicks, conversions, and revenue.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Step Four<\/strong><\/span><\/p>\n<p>After this, you need to change the format of the cells accordingly.<\/p>\n<p>Since the revenue isn\u2019t in euros, you need to select the column\/format and insert the currency.<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>Step Five<\/strong><\/span><\/p>\n<p>Wanna check one of the best Excel tricks and tips?<\/p>\n<p>Keep reading!<\/p>\n<p>Imagine you want to analyze CellFlirt &#8211; mobile T-Mobile campaign in more detail.<\/p>\n<p>You also wanna analyze its top-converting brands.<\/p>\n<p>It has 27 conversions and 162\u20ac in revenue.<\/p>\n<p>You want to select the field that it\u2019ll open into.<\/p>\n<p>Click \u201cbrand\u201d.<\/p>\n<p>It adds all the brands for the campaigns in the row section.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2.jpg\"><img decoding=\"async\" width=\"700\" height=\"371\" class=\"aligncenter size-large wp-image-11533\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2-700x371.jpg\" alt=\"pivot table 2\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2-700x371.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2-250x132.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2-768x407.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2-1024x542.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2-120x64.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-2.jpg 1284w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3.jpg\"><img decoding=\"async\" width=\"700\" height=\"366\" class=\"aligncenter size-large wp-image-11534\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3-700x366.jpg\" alt=\"pivot table 3\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3-700x366.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3-250x131.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3-768x401.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3-1024x535.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3-120x63.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-3.jpg 1277w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>The brands will appear for all the campaigns.<\/p>\n<p>Even so, we only want to analyze that specific one.<\/p>\n<p>How to go about it?<\/p>\n<p>Simple!<\/p>\n<p>Select all\/options under pivot table\/tools, and collapse the entire field.<\/p>\n<p>After that, just hit the plus button of the campaign you want.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4.jpg\"><img decoding=\"async\" width=\"700\" height=\"362\" class=\"aligncenter size-large wp-image-11535\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4-700x362.jpg\" alt=\"pivot table 4\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4-700x362.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4-250x129.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4-768x397.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4-1024x530.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4-120x62.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-4.jpg 1266w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>Since you\u2019re optimizing conversion rates, you want to add a calculated field because the conversion rate isn&#8217;t available in the data as it wasn&#8217;t calculated.<\/p>\n<p>To do so, insert calculated field &amp; format accordingly, after selecting the pivot table.<\/p>\n<p>Formula = conversions (insert field) \/clicks (insert field)<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5.jpg\"><img decoding=\"async\" width=\"700\" height=\"370\" class=\"aligncenter size-large wp-image-11536\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5-700x370.jpg\" alt=\"pivot table 5\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5-700x370.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5-250x132.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5-768x406.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5-1024x542.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5-120x64.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-5.jpg 1281w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6.jpg\"><img decoding=\"async\" width=\"700\" height=\"369\" class=\"aligncenter size-large wp-image-11537\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6-700x369.jpg\" alt=\"pivot table 6\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6-700x369.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6-250x132.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6-768x405.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6-1024x539.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6-120x63.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-6.jpg 1287w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>The brands Sharp &amp; Softbank have high conversion rates.<\/p>\n<p>The next step would be to insert that field on the report filter and only select those two to pinpoint them.<\/p>\n<p>In order to conclude the analysis, press SubID.<\/p>\n<p>It shows you the ads which have performed best for those two specific brands.<\/p>\n<p><a href=\"https:\/\/cdnwp.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7.jpg\"><img decoding=\"async\" width=\"700\" height=\"365\" class=\"aligncenter size-large wp-image-11538\" src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7-700x365.jpg\" alt=\"pivot table 7\" srcset=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7-700x365.jpg 700w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7-250x130.jpg 250w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7-768x401.jpg 768w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7-1024x534.jpg 1024w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7-120x63.jpg 120w, https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/pivot-table-7.jpg 1280w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>If you go deeper, you can see that ads 23, 19, 13, 22 are performing better.<\/p>\n<p>Ad 10 is performing poorly.<\/p>\n<p>What to do?<\/p>\n<p>You should pause that ad in those two brands.<\/p>\n<p>Now is this one of the coolest Microsoft Excel tricks or what?<\/p>\n<h2><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Enjoyed these Microsoft Excel tips and tricks?<\/p>\n<p>Think you know so many great Excel tricks that your affiliate marketing colleagues are gonna feel sad?<\/p>\n<p>Spread the word on these neat Excel tricks, bro!<\/p>\n<p>You know everything you need.<\/p>\n<p>Working on Excel involves a lot of copy-pasting, cleaning, formatting, and calculating.<\/p>\n<p>You can do it all manually, of course.<\/p>\n<p>But you can read up, learn the rules of the game, and use Excel\u2019s mighty powerful functionalities in order to become much more efficient.<\/p>\n<p>The tips that we\u2019ve shown in this article will increase the efficiency of your analysis.<\/p>\n<p>More importantly, they will also make sure you come up with better conclusions.<\/p>\n<p>The actions that you\u2019ll take after coming up with your conclusions will have a huge impact on the performance and profits of your campaigns.<\/p>\n<p>Performance. Metrics. Improvement. Success.<\/p>\n<p>This is what knowing the best Excel tricks is all about.<\/p>\n<p>Use this master article, keep checking the most useful Excel tricks, and become an Excel pro who uses this super cool tool to increase affiliate marketing revenues.<\/p>\n<p>Cheers!<\/p>\n<p><span style=\"font-size: 14pt;\"><strong>See Also:<\/strong><\/span><\/p>\n<ul style=\"list-style-type: disc;\">\n<li><a href=\"https:\/\/www.mobidea.com\/academy\/affiliate-marketing-metrics\/\">Affiliate Marketing Metrics: Which Ones Should I Check?<\/a><\/li>\n<li><a href=\"https:\/\/www.mobidea.com\/academy\/mobile-pre-landers\/\">5 Most Common Mobile Pre-Landers That Convert<\/a><\/li>\n<li><a href=\"https:\/\/www.mobidea.com\/academy\/affiliate-landing-pages\/\">How to Create Killer Affiliate Landing Pages in 2018<\/a><\/li>\n<li><a href=\"https:\/\/www.mobidea.com\/academy\/mobile-cpa\/\">Mobile CPA Ecosystem: Where This Story Begins<\/a><\/li>\n<\/ul>\n<div class=\"mobid-after-content\" style=\"margin-top: 5px;margin-bottom: 5px;margin-left: auto;margin-right: auto;text-align: center;\" id=\"mobid-960366478\"><div class=\"mobid-adlabel\">Advertisement<\/div><a data-no-instant=\"1\" href=\"https:\/\/www.mobidea.com\/academy\/recommends\/banner-placement-2\/\" rel=\"noopener nofollow\" class=\"a2t-link\" target=\"_blank\" aria-label=\"da\"><img src=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2022\/09\/da.gif\" alt=\"\"  class=\"no-lazyload\" width=\"730\" height=\"90\"   \/><\/a><\/div>","protected":false},"excerpt":{"rendered":"Introduction Wanna know a life-changing, jaw-dropping truth: Excel is the best thing you\u2019ll ever be able to explore in this god forsaken, barren land we call earth! Don\u2019t forget that info is power. This power is the result of a super thorough analytical mindset. You must know everything. Every detail is a giant step for&#8230; <a class=\"view-article\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/\">View Article<\/a>","protected":false},"author":6,"featured_media":11614,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8954],"tags":[214,225,171,172,199],"learning_paths":[],"class_list":["post-11503","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-affiliate-marketing","tag-optimization","tag-tools","tag-affiliate-industry","tag-affiliate-marketing","tag-getting-started"],"translation":{"provider":"WPGlobus","version":"3.0.0","language":"en","enabled_languages":["en","ru"],"languages":{"en":{"title":true,"content":true,"excerpt":false},"ru":{"title":false,"content":false,"excerpt":false}}},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Amazing Excel Tricks to Analyze Affiliate Data (Like a Pro)<\/title>\n<meta name=\"description\" content=\"Learn these amazing Excel tricks, tips, and techniques to get to know how you can effectively analyze affiliate data like a master pro!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Amazing Excel Tricks to Analyze Affiliate Data (Like a Pro)\" \/>\n<meta property=\"og:description\" content=\"Learn these amazing Excel tricks, tips, and techniques to get to know how you can effectively analyze affiliate data like a master pro!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Mobidea Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Mobidea\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-10T10:41:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-05-09T10:44:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"844\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Andr\u00e9 Martins\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mobacademy\" \/>\n<meta name=\"twitter:site\" content=\"@Mobideanews\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/\",\"url\":\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/\",\"name\":\"Amazing Excel Tricks to Analyze Affiliate Data (Like a Pro)\",\"isPartOf\":{\"@id\":\"https:\/\/www.mobidea.com\/academy\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg\",\"datePublished\":\"2018-01-10T10:41:54+00:00\",\"dateModified\":\"2018-05-09T10:44:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.mobidea.com\/academy\/#\/schema\/person\/c1bc25df354604621b194ee14dbe4d13\"},\"description\":\"Learn these amazing Excel tricks, tips, and techniques to get to know how you can effectively analyze affiliate data like a master pro!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#primaryimage\",\"url\":\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg\",\"contentUrl\":\"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg\",\"width\":1500,\"height\":844,\"caption\":\"excel tricks\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.mobidea.com\/academy\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Analyze Affiliate Data Like a Pro (and Why It&#8217;s Important)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.mobidea.com\/academy\/#website\",\"url\":\"https:\/\/www.mobidea.com\/academy\/\",\"name\":\"Mobidea Academy\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.mobidea.com\/academy\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.mobidea.com\/academy\/#\/schema\/person\/c1bc25df354604621b194ee14dbe4d13\",\"name\":\"Andr\u00e9 Martins\",\"description\":\"Andr\u00e9 Martins joined Mobidea in 2015. He comes from a scientific area so numbers and analytical power are two of his stronger skills. He began as a Media Buyer and Account Manager for Spanish-speaking VIP affiliates. He came about when social traffic was only at its early stages, and he honed the role like a pro. Andr\u00e9 became a true expert on social traffic. In the second half of 2016, a new independent team was created on Mobidea: the Social Marketing team. The strong analytical skills and the media buying\/business experience make Andr\u00e9 a great expert on the subject. Apart from working, Andr\u00e9 has many different passions. He really loves Astrophysics (where he managed to get a PhD) and he is a History buff. He loves travelling. He also enjoys watching movies with his loved one and sports are a great source of fun in his life! Playing football, hiking and cycling are three things that make Andr\u00e9 really happy!\",\"sameAs\":[\"https:\/\/x.com\/mobacademy\"],\"url\":\"https:\/\/www.mobidea.com\/academy\/author\/andre-martins\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Amazing Excel Tricks to Analyze Affiliate Data (Like a Pro)","description":"Learn these amazing Excel tricks, tips, and techniques to get to know how you can effectively analyze affiliate data like a master pro!","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:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/","og_locale":"en_US","og_type":"article","og_title":"Amazing Excel Tricks to Analyze Affiliate Data (Like a Pro)","og_description":"Learn these amazing Excel tricks, tips, and techniques to get to know how you can effectively analyze affiliate data like a master pro!","og_url":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/","og_site_name":"Mobidea Academy","article_publisher":"https:\/\/www.facebook.com\/Mobidea\/","article_published_time":"2018-01-10T10:41:54+00:00","article_modified_time":"2018-05-09T10:44:31+00:00","og_image":[{"width":1500,"height":844,"url":"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg","type":"image\/jpeg"}],"author":"Andr\u00e9 Martins","twitter_card":"summary_large_image","twitter_creator":"@mobacademy","twitter_site":"@Mobideanews","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/","url":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/","name":"Amazing Excel Tricks to Analyze Affiliate Data (Like a Pro)","isPartOf":{"@id":"https:\/\/www.mobidea.com\/academy\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#primaryimage"},"image":{"@id":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg","datePublished":"2018-01-10T10:41:54+00:00","dateModified":"2018-05-09T10:44:31+00:00","author":{"@id":"https:\/\/www.mobidea.com\/academy\/#\/schema\/person\/c1bc25df354604621b194ee14dbe4d13"},"description":"Learn these amazing Excel tricks, tips, and techniques to get to know how you can effectively analyze affiliate data like a master pro!","breadcrumb":{"@id":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#primaryimage","url":"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg","contentUrl":"https:\/\/www.mobidea.com\/academy\/wp-content\/uploads\/2018\/12\/excel-tricks.jpg","width":1500,"height":844,"caption":"excel tricks"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mobidea.com\/academy\/analyze-affiliate-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mobidea.com\/academy\/"},{"@type":"ListItem","position":2,"name":"How to Analyze Affiliate Data Like a Pro (and Why It&#8217;s Important)"}]},{"@type":"WebSite","@id":"https:\/\/www.mobidea.com\/academy\/#website","url":"https:\/\/www.mobidea.com\/academy\/","name":"Mobidea Academy","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mobidea.com\/academy\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.mobidea.com\/academy\/#\/schema\/person\/c1bc25df354604621b194ee14dbe4d13","name":"Andr\u00e9 Martins","description":"Andr\u00e9 Martins joined Mobidea in 2015. He comes from a scientific area so numbers and analytical power are two of his stronger skills. He began as a Media Buyer and Account Manager for Spanish-speaking VIP affiliates. He came about when social traffic was only at its early stages, and he honed the role like a pro. Andr\u00e9 became a true expert on social traffic. In the second half of 2016, a new independent team was created on Mobidea: the Social Marketing team. The strong analytical skills and the media buying\/business experience make Andr\u00e9 a great expert on the subject. Apart from working, Andr\u00e9 has many different passions. He really loves Astrophysics (where he managed to get a PhD) and he is a History buff. He loves travelling. He also enjoys watching movies with his loved one and sports are a great source of fun in his life! Playing football, hiking and cycling are three things that make Andr\u00e9 really happy!","sameAs":["https:\/\/x.com\/mobacademy"],"url":"https:\/\/www.mobidea.com\/academy\/author\/andre-martins\/"}]}},"_links":{"self":[{"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/posts\/11503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/comments?post=11503"}],"version-history":[{"count":31,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/posts\/11503\/revisions"}],"predecessor-version":[{"id":11670,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/posts\/11503\/revisions\/11670"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/media\/11614"}],"wp:attachment":[{"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/media?parent=11503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/categories?post=11503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/tags?post=11503"},{"taxonomy":"learning_paths","embeddable":true,"href":"https:\/\/www.mobidea.com\/academy\/wp-json\/wp\/v2\/learning_paths?post=11503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}