For the below mentioned operations, it is necessary to have one of the versions of OpenRefine installed. You can find them at:
Instructions for installation and potential changes in this tool can be found at:
Creating a project from imported data
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.
After naming the project and clicking on Create project, a new project will be created in OpenRefine, and you can work with it further, with the help of instructions below.
Facet application and output filtration
One of the strengths of OpenRefine is working with Facets and Filters. 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:
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).
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.
This Facet works similarly to clustering according to the cell content, when filtering in Excel.
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).
After carrying out Numeric Facet above more columns, their restrictions are combined.
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.
For example, Scatterplot Facet is perfect for Boston matrix.
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.
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.
Facet, which scan the cells of selected column and carries out their length on to the filtered X axis.
It can be very useful for a user, when checking the title length or analyzing competition ads.
Facet by blank
Simple facet, which only scans the cells and calls the ones that are empty, true and the rest false.