{"id":3016,"date":"2020-06-17T15:32:50","date_gmt":"2020-06-17T13:32:50","guid":{"rendered":"https:\/\/help.marketingminer.com\/?post_type=kb&#038;p=3016"},"modified":"2020-10-13T10:29:25","modified_gmt":"2020-10-13T08:29:25","slug":"data-analysis-of-exported-data","status":"publish","type":"kb","link":"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/","title":{"rendered":"Data analysis of exported data"},"content":{"rendered":"\n<h2>Excel<\/h2>\n\n\n\n<p><strong>Excel table is the basic output of Marketing Miner<\/strong> that is available to a user after completing a report. It always contains an initial list (Report) that summarizes info about collected data, then a general list Data that contains data that were accessible at output for individual lines, and then other lists according to miners that cannot be paired straight into a line.<\/p>\n\n\n\n<p><strong>Design adjustment<\/strong><\/p>\n\n\n\n<p>After downloading and opening the file, a user gets to the initial list (Report). Some Excel versions ask for <strong>permission<\/strong> before manipulating, because it is a file that is downloaded from the internet, comparably to the image below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"39\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-1024x39.png\" alt=\"Excel permission\" class=\"wp-image-3017\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-1024x39.png 1024w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-300x12.png 300w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission-768x30.png 768w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/excel-permission.png 1275w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>To be able to manipulate the file, a user first has to give permission to do so. Excel also often displays output file without <strong>wrapping the text<\/strong>, which could look chaotic to a user. To make it more clear for a user, the wrap text function should be removed:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"193\" height=\"101\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/wrapping-in-Excel.png\" alt=\"Wrapping in Excel\" class=\"wp-image-3020\"\/><\/figure><\/div>\n\n\n\n<p><strong>Filter creation<\/strong><\/p>\n\n\n\n<p>Filter function is used to adjust data display. This function will create a filter range from the top columns, which will allow user to search for rows in columns or to otherwise filter dataset content:<\/p>\n\n\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/YNB4a2pzq4E\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p><strong>Examples of content filtering<\/strong><\/p>\n\n\n\n<p>Basic filtering is text filtering. A user types in a part of the text that corresponds with the cells of selected column and after clicking OK, a user gets to the dataset only corresponding with the assignment.<\/p>\n\n\n\n<p>Excel has two basic and most commonly used types of filters:<\/p>\n\n\n\n<p><strong>Text filters<\/strong><\/p>\n\n\n\n<p>In case there is a text content in the column cells, Excel uses text filters to filter it. These filters work similarly to searching and their functionality is intuitive to its name.:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"539\" height=\"359\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-filters.png\" alt=\"Text filters\" class=\"wp-image-3023\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-filters.png 539w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-filters-300x200.png 300w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/><\/figure><\/div>\n\n\n\n<p><strong>Number filters<\/strong><\/p>\n\n\n\n<p>In case there is a numeral content in the column cells, Excel uses number filters to filter it. Those allow user to select a part of the dataset that corresponds with more complex conditions of the range or with the minimum or maximum value of the column cells.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"451\" height=\"276\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/number-filters.png\" alt=\"Number filters\" class=\"wp-image-3026\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/number-filters.png 451w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/number-filters-300x184.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/figure><\/div>\n\n\n\n<p><strong>Conditional formatting<\/strong><\/p>\n\n\n\n<p>Conditional formatting is used to change a color of the cell, based on its value compared to the whole column. An example of the application and the output can be found in the video below:<\/p>\n\n\n\n<p><strong>Making charts<\/strong><\/p>\n\n\n\n<p>Using output data, a user can then make charts:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"371\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-1024x371.png\" alt=\"Charts in Excel\" class=\"wp-image-3029\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-1024x371.png 1024w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-300x109.png 300w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel-768x278.png 768w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/charts-in-Excel.png 1270w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Other tutorials for Microsoft Excel:<\/strong><\/p>\n\n\n\n<p>Instructions on how to make charts in Excel can be found at:<br><a href=\"http:\/\/blog.hubspot.com\/marketing\/how-to-build-excel-graph#sm.0001r0d1h49fkev4ss01cfocetczs\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/blog.hubspot.com\/marketing\/how-to-build-excel-graph#sm.0001r0d1h49fkev4ss01cfocetczs<\/a><\/p>\n\n\n\n<h2>OpenRefine<\/h2>\n\n\n\n<p>For the below mentioned operations, it is necessary to have one of the versions of OpenRefine installed. You can find them at:<br><a href=\"http:\/\/openrefine.org\/\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/openrefine.org\/<\/a><\/p>\n\n\n\n<p><strong>Creating a project from imported data<\/strong><\/p>\n\n\n\n<p>To import a project into OpenRefine, an XLSX file of downloaded output from Marketing Miner should be imported at input for this tool. In the second step, it is necessary to select the list of sheet that is going to be processed. OpenRefine should automatically detect coding of the file and display a project preview in the output example.<\/p>\n\n\n\n<p>After naming the project and clicking on <strong>Create project<\/strong>, a new project will be created in OpenRefine, and you can work with it further, with the help of instructions below.<\/p>\n\n\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/YnkL1A_4Kqw\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p><strong>Facet application and output filtration<\/strong><\/p>\n\n\n\n<p>One of the strengths of OpenRefine is working with <strong>Facets<\/strong> and <strong>Filters<\/strong>. They allow user to work quickly with identification of potential problems and opportunities. Facets can be simultaneously combined among themselves. Basic tools for content filtration and segmentation are:<\/p>\n\n\n\n<p><strong>Text Filter<\/strong><\/p>\n\n\n\n<p>Simple search through the match of part of the text with the cell content. In the text filter, a user can work with regular phrases or they can specify if their assignment is case sensitive (depends on letter case).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"299\" height=\"93\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/open-refine-text-filter.png\" alt=\"Open Refine text filter\" class=\"wp-image-3032\"\/><\/figure><\/div>\n\n\n\n<p><strong>Text Facet<\/strong><\/p>\n\n\n\n<p>Text Facet clusters cells based on their match. It looks into the whole column of a project, which a user clicked on, and combines all the cells with the same content, so a user can filter the content of the same cells in the column.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"298\" height=\"296\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-facet-1.png\" alt=\"Open Refine text facet\" class=\"wp-image-3035\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-facet-1.png 298w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-facet-1-150x150.png 150w\" sizes=\"(max-width: 298px) 100vw, 298px\" \/><\/figure><\/div>\n\n\n\n<p>This Facet works similarly to clustering according to the cell content, when filtering in Excel.<\/p>\n\n\n\n<p><strong>Numeric Facet<\/strong><\/p>\n\n\n\n<p>Numeric Facet takes into account cells of used columns that have numbers in them, and then carries them out to an X axis, where a user can, using shifting the range of the axis, define data that he wants to work with (or data he wants to see).<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"299\" height=\"126\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/numeric-facet-open-refine.png\" alt=\"Numberic Facet open refine\" class=\"wp-image-3038\"\/><\/figure><\/div>\n\n\n\n<p>After carrying out Numeric Facet above more columns, their restrictions are combined.<\/p>\n\n\n\n<p><strong>Scatterplot Facet<\/strong><\/p>\n\n\n\n<p>Scatterplot Facet works similarly to Numeric Facet, with the difference that it carries out the data to two axis at the same time. A user then gets one metric on X axis and another one on Y axis. After selecting the Scatterplot Facet segment, a user gets to the filtered content that falls into their selection.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"296\" height=\"198\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/Scatterplot-Facet-2.png\" alt=\"Scatterplot Facet\" class=\"wp-image-3041\"\/><\/figure><\/div>\n\n\n\n<p>For example, Scatterplot Facet is perfect for Boston matrix.<\/p>\n\n\n\n<p><strong>Word Facet<\/strong><\/p>\n\n\n\n<p>Word Facet is located in the section Customized Facets and simply takes the cells of selected column and it divides them into words. After that, it calculates the frequency of their occurrence and shows it at output.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"297\" height=\"295\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/word-facet-open-refine.png\" alt=\"Word Facet - Open Refine\" class=\"wp-image-3044\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/word-facet-open-refine.png 297w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/word-facet-open-refine-150x150.png 150w\" sizes=\"(max-width: 297px) 100vw, 297px\" \/><\/figure><\/div>\n\n\n\n<p>With Word Facet , it is easy to find out the frequency of occurrence of specific phrases or when checking your content or copying from competition, determine the number of query occurrence.<\/p>\n\n\n\n<p><strong>Text-length Facet<\/strong><\/p>\n\n\n\n<p>Facet, which scan the cells of selected column and carries out their length on to the filtered X axis.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"297\" height=\"295\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-length-facet-open-refine-1.png\" alt=\"Text-length Open Refine facet\" class=\"wp-image-3047\" srcset=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-length-facet-open-refine-1.png 297w, https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/text-length-facet-open-refine-1-150x150.png 150w\" sizes=\"(max-width: 297px) 100vw, 297px\" \/><\/figure><\/div>\n\n\n\n<p>It can be very useful for a user, when checking the title length or analyzing competition ads.<\/p>\n\n\n\n<p><strong>Facet by blank<\/strong><\/p>\n\n\n\n<p>Simple facet, which only scans the cells and calls the ones that are empty, true and the rest false.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"297\" height=\"152\" src=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/facet-by-blank-open-refine.png\" alt=\"Facet by blank Open Refine\" class=\"wp-image-3050\"\/><\/figure><\/div>\n\n\n\n<h2>Tableau<\/h2>\n\n\n\n<p>Tableau is a great tool in the field of Business Intelligence. It provides a fast and efficient option for data visualization for the users of Marketing Miner.<br>More info on the tool and its download at:<br><a href=\"http:\/\/www.tableau.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/www.tableau.com\/<\/a><\/p>\n\n\n\n<p><strong>Import of the output into Tableau<\/strong><\/p>\n\n\n\n<p>After launching Tableau, a user creates a new project, where he imports Excel output from Marketing Miner. From there a user then drags the Excel list that he wants to, using Tableau, process.:<\/p>\n\n\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/oLAh9RWwfmQ\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p><strong>Data visualization<\/strong><\/p>\n\n\n\n<p>After getting to the worksheet, you can simply, by dragging the dimensions and metrics, create the data visualization.:<\/p>\n\n\n\n<iframe loading=\"lazy\" width=\"718\" height=\"429\" src=\"https:\/\/www.youtube.com\/embed\/YGhAr4xjtMk\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p>More info on data visualization options in Tableau can be found at:<br><a href=\"http:\/\/www.tableau.com\/learn\/training\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/www.tableau.com\/learn\/training<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list (Report) that summarizes info about collected data, then a general list Data that contains data that were accessible at output for individual lines, and then other lists according to &#8230; <a title=\"Data analysis of exported data\" class=\"read-more\" href=\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/\" aria-label=\"More on Data analysis of exported data\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"kbtopic":[30],"kbtag":[88,87,86,85,84],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Data analysis of exported data - Marketing Miner Knowledge Base<\/title>\n<meta name=\"description\" content=\"Excel Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data analysis of exported data - Marketing Miner Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"Excel Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list\" \/>\n<meta property=\"og:url\" content=\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Marketing Miner Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/marketingminer\/\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-13T08:29:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1354\" \/>\n\t<meta property=\"og:image:height\" content=\"759\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png\" \/>\n<meta name=\"twitter:site\" content=\"@marketingminer\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/\",\"url\":\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/\",\"name\":\"Data analysis of exported data - Marketing Miner Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/help.marketingminer.com\/en\/#website\"},\"datePublished\":\"2020-06-17T13:32:50+00:00\",\"dateModified\":\"2020-10-13T08:29:25+00:00\",\"description\":\"Excel Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list\",\"breadcrumb\":{\"@id\":\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/help.marketingminer.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data analysis of exported data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/help.marketingminer.com\/en\/#website\",\"url\":\"https:\/\/help.marketingminer.com\/en\/\",\"name\":\"Marketing Miner Knowledge Base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/help.marketingminer.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/help.marketingminer.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/help.marketingminer.com\/en\/#organization\",\"name\":\"Marketing Miner\",\"url\":\"https:\/\/help.marketingminer.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/help.marketingminer.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png\",\"contentUrl\":\"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png\",\"width\":4098,\"height\":819,\"caption\":\"Marketing Miner\"},\"image\":{\"@id\":\"https:\/\/help.marketingminer.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/marketingminer\/\",\"https:\/\/twitter.com\/marketingminer\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data analysis of exported data - Marketing Miner Knowledge Base","description":"Excel Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list","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:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/","og_locale":"en_US","og_type":"article","og_title":"Data analysis of exported data - Marketing Miner Knowledge Base","og_description":"Excel Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list","og_url":"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/","og_site_name":"Marketing Miner Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/marketingminer\/","article_modified_time":"2020-10-13T08:29:25+00:00","og_image":[{"width":1354,"height":759,"url":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/10\/data-analysis-of-exported-data.png","twitter_site":"@marketingminer","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/","url":"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/","name":"Data analysis of exported data - Marketing Miner Knowledge Base","isPartOf":{"@id":"https:\/\/help.marketingminer.com\/en\/#website"},"datePublished":"2020-06-17T13:32:50+00:00","dateModified":"2020-10-13T08:29:25+00:00","description":"Excel Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list","breadcrumb":{"@id":"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/help.marketingminer.com\/en\/article\/data-analysis-of-exported-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/help.marketingminer.com\/en\/"},{"@type":"ListItem","position":2,"name":"Data analysis of exported data"}]},{"@type":"WebSite","@id":"https:\/\/help.marketingminer.com\/en\/#website","url":"https:\/\/help.marketingminer.com\/en\/","name":"Marketing Miner Knowledge Base","description":"","publisher":{"@id":"https:\/\/help.marketingminer.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/help.marketingminer.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/help.marketingminer.com\/en\/#organization","name":"Marketing Miner","url":"https:\/\/help.marketingminer.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/help.marketingminer.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png","contentUrl":"https:\/\/help.marketingminer.com\/wp-content\/uploads\/2020\/06\/cropped-Logo-01@3x.png","width":4098,"height":819,"caption":"Marketing Miner"},"image":{"@id":"https:\/\/help.marketingminer.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/marketingminer\/","https:\/\/twitter.com\/marketingminer"]}]}},"_links":{"self":[{"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/kb\/3016"}],"collection":[{"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/comments?post=3016"}],"version-history":[{"count":2,"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/kb\/3016\/revisions"}],"predecessor-version":[{"id":4148,"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/kb\/3016\/revisions\/4148"}],"wp:attachment":[{"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/media?parent=3016"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/kbtopic?post=3016"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/help.marketingminer.com\/en\/wp-json\/wp\/v2\/kbtag?post=3016"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}