Web Scraper Shortcode WordPress Plugin Review

This short post is on the WP-plugin called Web Scraper Shortcode, that enables one to retrieve a portion of a web page or a whole page and insert it directly into a post. This plugin might be used for getting fresh data or images from web pages for your WordPress driven page without even visiting it. More scraping plugins and sowtware you can find in here.

To install it in WordPress go to Plugins -> Add New.
Usage

The plugin scrapes the page content and applies parameters to this scraped page if specified. To use the plugin just insert the

[web-scraper ]

shortcode into the HTML view of the WordPress page where you want to display the excerpts of a page or the whole page. The parameters are as follows:

    url (self explanatory)
    element – the dom navigation element notation, similar to XPath.
    limit – the maximum number of elements to be scraped and inserted if the element notation points to several of them (like elements of the same class).

The use of the plugin is of the dom (Data Object Model) notation, where consecutive dom nodes are stated like node1.node2; for example: element = ‘div.img’. The specific element scrape goes thru ‘#notation’. Example: if you want to scrape several ‘div’ elements of the class ‘red’ (<div class=’red’>…<div>), you need to specify the element attribute this way: element = ‘div#red’.
How to find DOM notation?

But for inexperienced users, how is it possible to find the dom notation of the desired element(s) from the web page? Web Developer Tools are a handy means for this. I would refer you to this paragraph on how to invoke Web Developer Tools in the browser (Google Chrome) and select a single page element to inspect it. As you select it with the ‘loupe’ tool, on the bottom line you’ll see the blue box with the element’s dom notation:


The plugin content

As one who works with web scraping, I was curious about  the means that the plugin uses for scraping. As I looked at the plugin code, it turned out that the plugin acquires a web page through ‘simple_html_dom‘ class:

    require_once(‘simple_html_dom.php’);
    $html = file_get_html($url);
    then the code performs iterations over the designated elements with the set limit

Pitfalls

    Be careful if you put two or more [web-scraper] shortcodes on your website, since downloading other pages will drastically slow the page load speed. Even if you want only a small element, the PHP engine first loads the whole page and then iterates over its elements.
    You need to remember that many pictures on the web are indicated by shortened URLs. So when such an image gets extracted it might be visible to you in this way: , since the URL is shortened and the plugin does not take note of  its base URL.
    The error “Fatal error: Call to a member function find() on a non-object …” will occur if you put this shortcode in a text-overloaded post.

Summary

I’d recommend using this plugin for short posts to be added with other posts’ elements. The use of this plugin is limited though.



Source: http://extract-web-data.com/web-scraper-shortcode-wordpress-plugin-review/

Visual Web Ripper: Using External Input Data Sources

Sometimes it is necessary to use external data sources to provide parameters for the scraping process. For example, you have a database with a bunch of ASINs and you need to scrape all product information for each one of them. As far as Visual Web Ripper is concerned, an input data source can be used to provide a list of input values to a data extraction project. A data extraction project will be run once for each row of input values.

An input data source is normally used in one of these scenarios:

    To provide a list of input values for a web form
    To provide a list of start URLs
    To provide input values for Fixed Value elements
    To provide input values for scripts

Visual Web Ripper supports the following input data sources:

    SQL Server Database
    MySQL Database
    OleDB Database
    CSV File
    Script (A script can be used to provide data from almost any data source)

To see it in action you can download a sample project that uses an input CSV file with Amazon ASIN codes to generate Amazon start URLs and extract some product data. Place both the project file and the input CSV file in the default Visual Web Ripper project folder (My Documents\Visual Web Ripper\Projects).

For further information please look at the manual topic, explaining how to use an input data source to generate start URLs.


Source: http://extract-web-data.com/visual-web-ripper-using-external-input-data-sources/

Scraping Amazon.com with Screen Scraper

Let’s look how to use Screen Scraper for scraping Amazon products having a list of asins in external database.

Screen Scraper is designed to be interoperable with all sorts of databases and web-languages. There is even a data-manager that allows one to make a connection to a database (MySQL, Amazon RDS, MS SQL, MariaDB, PostgreSQL, etc), and then the scripting in screen-scraper is agnostic to the type of database.

Let’s go through a sample scrape project you can see it at work. I don’t know how well you know Screen Scraper, but I assume you have it installed, and a MySQL database you can use. You need to:

    Make sure screen-scraper is not running as workbench or server
    Put the Amazon (Scraping Session).sss file in the “screen-scraper enterprise edition/import” directory.
    Put the mysql-connector-java-5.1.22-bin.jar file in the “screen-scraper enterprise edition/lib/ext” directory.
    Create a MySQL database for the scrape to use, and import the amazon.sql file.
    Put the amazon.db.config file in the “screen-scraper enterprise edition/input” directory and edit it to contain proper settings to connect to your database.
    Start the screen scraper workbench

Since this is a very simple scrape, you just want to run it in the workbench (most of the time you want to run scrapes in server mode). Start the workbench, and you will see the Amazon scrape in there, and you can just click the “play” button.

Note that a breakpoint comes up for each item. It would be easy to save the scraped details to a database table or file if you want. Also see in the database the “id_status” changes as each item is scraped.

When the scrape is run, it looks in the database for products marked “not scraped”, so when you want to re-run the scrapes, you need to:

UPDATE asin
SET `id_status` = 0

Have a nice scraping! ))

P.S. We thank Jason Bellows from Ekiwi, LLC for such a great tutorial.


Source: http://extract-web-data.com/scraping-amazon-com-with-screen-scraper/

Using External Input Data in Off-the-shelf Web Scrapers

There is a question I’ve wanted to shed some light upon for a long time already: “What if I need to scrape several URL’s based on data in some external database?“.

For example, recently one of our visitors asked a very good question (thanks, Ed):

    “I have a large list of amazon.com asin. I would like to scrape 10 or so fields for each asin. Is there any web scraping software available that can read each asin from a database and form the destination url to be scraped like http://www.amazon.com/gp/product/{asin} and scrape the data?”

This question impelled me to investigate this matter. I contacted several web scraper developers, and they kindly provided me with detailed answers that allowed me to bring the following summary to your attention:
Visual Web Ripper

An input data source can be used to provide a list of input values to a data extraction project. A data extraction project will be run once for each row of input values. You can find the additional information here.
Web Content Extractor

You can use the -at”filename” command line option to add new URLs from TXT or CSV file:

    WCExtractor.exe projectfile -at”filename” -s

projectfile: the file name of the project (*.wcepr) to open.
filename – the file name of the CSV or TXT file that contains URLs separated by newlines.
-s – starts the extraction process

You can find some options and examples here.
Mozenda

Since Mozenda is cloud-based, the external data needs to be loaded up into the user’s Mozenda account. That data can then be easily used as part of the data extracting process. You can construct URLs, search for strings that match your inputs, or carry through several data fields from an input collection and add data to it as part of your output. The easiest way to get input data from an external source is to use the API to populate data into a Mozenda collection (in the user’s account). You can also input data in the Mozenda web console by importing a .csv file or importing one through our agent building tool.

Once the data is loaded into the cloud, you simply initiate building a Mozenda web agent and refer to that Data list. By using the Load page action and the variable from the inputs, you can construct a URL like http://www.amazon.com/gp/product/%asin%.
Helium Scraper

Here is a video showing how to do this with Helium Scraper:


The video shows how to use the input data as URLs and as search terms. There are many other ways you could use this data, way too many to fit in a video. Also, if you know SQL, you could run a query to get the data directly from an external MS Access database like
SELECT * FROM [MyTable] IN "C:\MyDatabase.mdb"

Note that the database needs to be a “.mdb” file.
WebSundew Data Extractor
Basically this allows using input data from external data sources. This may be CSV, Excel file or a Database (MySQL, MSSQL, etc). Here you can see how to do this in the case of an external file, but you can do it with a database in a similar way (you just need to write an SQL script that returns the necessary data).
In addition to passing URLs from the external sources you can pass other input parameters as well (input fields, for example).
Screen Scraper

Screen Scraper is really designed to be interoperable with all sorts of databases. We have composed a separate article where you can find a tutorial and a sample project about scraping Amazon products based on a list of their ASINs.


Source: http://extract-web-data.com/using-external-input-data-in-off-the-shelf-web-scrapers/

Selenium IDE and Web Scraping

Selenium is a browser automation framework that includes IDE, Remote Control server and bindings of various flavors including Java, .Net, Ruby, Python and other. In this post we touch on the basic structure of the framework and its application to  Web Scraping.
What is Selenium IDE


Selenium IDE is an integrated development environment for Selenium scripts. It is implemented as a Firefox plugin, and it allows recording browsers’ interactions in order to edit them. This works well for software tests, composing and debugging. The Selenium Remote Control is a server specific for a particular environment; it causes custom scripts to be implemented for controlled browsers. Selenium deploys on Windows, Linux, and iOS. How various Selenium components are supported with major browsers read here.
What does Selenium do and Web Scraping

Basically Selenium automates browsers. This ability is no doubt to be applied to web scraping. Since browsers (and Selenium) support JavaScript, jQuery and other methods working with dynamic content why not use this mix for benefit in web scraping, rather than to try to catch Ajax events with plain code? The second reason for this kind of scrape automation is browser-fasion data access (though today this is emulated with most libraries).

Yes, Selenium works to automate browsers, but how to control Selenium from a custom script to automate a browser for web scraping? There are Selenium PHP and other language libraries (bindings) providing for scripts to call and use Selenium. It is possible to write Selenium clients (using the libraries) in almost any language we prefer, for example Perl, Python, Java, PHP etc. Those libraries (API), along with a server, the Java written server that invokes browsers for actions, constitute the Selenum RC (Remote Control). Remote Control automatically loads the Selenium Core into the browser to control it. For more details in Selenium components refer to here.


A tough scrape task for programmer

“…cURL is good, but it is very basic.  I need to handle everything manually; I am creating HTTP requests by hand.
This gets difficult – I need to do a lot of work to make sure that the requests that I send are exactly the same as the requests that a browser would
send, both for my sake and for the website’s sake. (For my sake
because I want to get the right data, and for the website’s sake
because I don’t want to cause error messages or other problems on their site because I sent a bad request that messed with their web application).  And if there is any important javascript, I need to imitate it with PHP.
It would be a great benefit to me to be able to control a browser like Firefox with my code. It would solve all my problems regarding the emulation of a real browser…
it seems that Selenium will allow me to do this…” -Ryan S

Yes, that’s what we will consider below.
Scrape with Selenium

In order to create scripts that interact with the Selenium Server (Selenium RC, Selenium Remote Webdriver) or create local Selenium WebDriver script, there is the need to make use of language-specific client drivers (also called Formatters, they are included in the selenium-ide-1.10.0.xpi package). The Selenium servers, drivers and bindings are available at Selenium download page.
The basic recipe for scrape with Selenium:

    Use Chrome or Firefox browsers
    Get Firebug or Chrome Dev Tools (Cntl+Shift+I) in action.
    Install requirements (Remote control or WebDriver, libraries and other)
    Selenium IDE : Record a ‘test’ run thru a site, adding some assertions.
    Export as a Python (other language) script.
    Edit it (loops, data extraction, db input/output)
    Run script for the Remote Control

The short intro Slides for the scraping of tough websites with Python & Selenium are here (as Google Docs slides) and here (Slide Share).
Selenium components for Firefox installation guide

For how to install the Selenium IDE to Firefox see  here starting at slide 21. The Selenium Core and Remote Control installation instructions are there too.
Extracting for dynamic content using jQuery/JavaScript with Selenium

One programmer is doing a similar thing …

1. launch a selenium RC (remote control) server
2. load a page
3. inject the jQuery script
4. select the interested contents using jQuery/JavaScript
5. send back to the PHP client using JSON.

He particularly finds it quite easy and convenient to use jQuery for
screen scraping, rather than using PHP/XPath.
Conclusion

The Selenium IDE is the popular tool for browser automation, mostly for its software testing application, yet also in that Web Scraping techniques for tough dynamic websites may be implemented with IDE along with the Selenium Remote Control server. These are the basic steps for it:

    Record the ‘test‘ browser behavior in IDE and export it as the custom programming language script
    Formatted language script runs on the Remote Control server that forces browser to send HTTP requests and then script catches the Ajax powered responses to extract content.

Selenium based Web Scraping is an easy task for small scale projects, but it consumes a lot of memory resources, since for each request it will launch a new browser instance.



Source: http://extract-web-data.com/selenium-ide-and-web-scraping/

Advantages of Online Data Entry Services

People all over the world are enthusiastic to buy online data entry services as they find it cost effective. Most of them have an impression that they get quality services against the prices they have to pay. Entering data online is of a great help to business units of all sizes as they consider them as their main basis of profession.

Online data entering and typing services providers have skilled resources at their service who deliver quality work timely. These service providers have modernized technology, assuring cent percent security of data. Online data entry services include the following:

    Data entry
    Data Processing
    Product entry
    Data typing
    Data mining, Data capture/collection
    Business Process Outsourcing
    Data Conversion
    Form Filling
    Web and mortgage research
    Extraction services
    Online copying, pasting, editing, sorting, as well as indexing data
    E-books and e-magazines data entry

Get companies world wide quality services to business units of all sizes, some of the common input formats are:

    PDF
    TIFF
    GIF
    XBM
    JPG
    PNG
    BMP
    TGA
    XML
    HTML
    SGML
    Printed documents
    Hard copies, etc

Benefits of outsourcing online data entering services:

Major benefits of data entry for business units is that they get the facts and figures which helps in taking strategic decisions for the organization. The data projected by numbers turns to be a factor of evaluation that accelerates the progress of the business. Online data typing services maintain high level of security by using systems that are highly protected.

The business organization progresses because of right decisions taken with the help of superior quality data available.

    Save operational overhead expense.
    Saves time and space.
    Accurate services can be accessed.
    Eliminating the paper documents.
    Cost effective.
    Data accessible from anywhere in the world.
    100% work satisfaction.
    Access to professional and experienced data typing services.
    Adequate knowledge of wide range industrial needs.
    Use of highly advance technologies for quality results.

Business organizations find themselves blessed because of the benefits they receive out of outsourcing their projects on online data entering and typing services, because it not only saves their time but also saves a huge amount of money.

Upcoming business companies can focus on their key business functions instead of dealing with non-key business activities. They find it sensible to outsource their confidential and crucial projects to trustworthy online data entry services and remain free for their key business activities. These companies have several layers of quality control which assures 99.9% quality on projects on online data entry.




Source: http://ezinearticles.com/?Advantages-of-Online-Data-Entry-Services&id=6526483

Web Data Extraction Services

Web Data Extraction from Dynamic Pages includes some of the services that may be acquired through outsourcing. It is possible to siphon information from proven websites through the use of Data Scrapping software. The information is applicable in many areas in business. It is possible to get such solutions as data collection, screen scrapping, email extractor and Web Data Mining services among others from companies providing websites such as Scrappingexpert.com.

Data mining is common as far as outsourcing business is concerned. Many companies are outsource data mining services and companies dealing with these services can earn a lot of money, especially in the growing business regarding outsourcing and general internet business. With web data extraction, you will pull data in a structured organized format. The source of the information will even be from an unstructured or semi-structured source.

In addition, it is possible to pull data which has originally been presented in a variety of formats including PDF, HTML, and test among others. The web data extraction service therefore, provides a diversity regarding the source of information. Large scale organizations have used data extraction services where they get large amounts of data on a daily basis. It is possible for you to get high accuracy of information in an efficient manner and it is also affordable.

Web data extraction services are important when it comes to collection of data and web-based information on the internet. Data collection services are very important as far as consumer research is concerned. Research is turning out to be a very vital thing among companies today. There is need for companies to adopt various strategies that will lead to fast means of data extraction, efficient extraction of data, as well as use of organized formats and flexibility.

In addition, people will prefer software that provides flexibility as far as application is concerned. In addition, there is software that can be customized according to the needs of customers, and these will play an important role in fulfilling diverse customer needs. Companies selling the particular software therefore, need to provide such features that provide excellent customer experience.

It is possible for companies to extract emails and other communications from certain sources as far as they are valid email messages. This will be done without incurring any duplicates. You will extract emails and messages from a variety of formats for the web pages, including HTML files, text files and other formats. It is possible to carry these services in a fast reliable and in an optimal output and hence, the software providing such capability is in high demand. It can help businesses and companies quickly search contacts for the people to be sent email messages.

It is also possible to use software to sort large amount of data and extract information, in an activity termed as data mining. This way, the company will realize reduced costs and saving of time and increasing return on investment. In this practice, the company will carry out Meta data extraction, scanning data, and others as well.

please visit Data extraction services to take care of your online as well as offline projects and to get your work done in given time frame with exceptional quality.




Source: http://ezinearticles.com/?Web-Data-Extraction-Services&id=4733722

Web Mining

With the bang of the era of information technology, we have entered into an ocean of information. This information blast is strongly based on the internet; which has become one of the universal infrastructures of information. We can not deny the fact that, with every passing day, the web based information contents are increasing by leaps and bounds and as such, it is becoming more and more difficult to get the desired information which we are actually looking for. Web mining is a tool, which can be used in customizing the websites on the basis of its contents and also on the basis of the user interface. Web mining normally comprises of usage mining, content mining and structure mining.

Data mining, text mining and web mining, engages various techniques and procedures to take out appropriate information from the huge database; so that companies can take better business decisions with precision, hence, data mining, text mining and web mining helps a lot in the promotion of the 'customer relationship management' goals; whose primary objective is to kick off, expand, and personalize a customer relationship by profiling and categorizing customers.

However, there are numbers of matters that must be addressed while dealing with the process of web mining. Data privacy can be said to be the trigger-button issue. Recently, privacy violation complaints and concerns have escalated significantly, as traders, companies, and governments continue to gather and warehouse huge amount of private information. There are concerns, not only about the collection and compilation of private information, but also the analysis and use of such data. Fueled by the public's concern about the increasing volume of composed statistics and effective technologies; conflict between data privacy and mining is likely to root higher levels of inspection in the coming years. Legal conflicts are also pretty likely in this regard.

There are also other issues facing data mining. 'Erroneousness of Information' can lead us to vague analysis and incorrect results and recommendations. Customers' submission of incorrect data or false information during the data importation procedure creates a real hazard for the web mining's efficiency and effectiveness. Another risk in data mining is that the mining might get confused with data warehousing. Companies developing information warehouses without employing the proper mining software are less likely to reach to the level of accuracy and efficiency and also they are less likely to receive the full benefit from there. Likewise, cross-selling may pose a difficulty if it breaks the customers' privacy, breach their faith or annoys them with unnecessary solicitations. Web mining can be of great help to improve and line-up the marketing programs, which targets customers' interests and needs.

In spite of potential hurdles and impediments, the market for web mining is predicted to grow by several billion dollars in the coming years. Mining helps to identify and target the potential customers, whose information are "buried" in massive databases and to strengthen the customer relationships. Data mining tools can predict the future market trends and consumer behaviors, which can potentially help businesses to take proactive and knowledge-based resolutions. This is one of the causes why data mining is also termed as 'Knowledge Discovery'. It can be said to be the process of analyzing data from different points of view and sorting and grouping the identified data and finally to set up a useful information database, which can further be analyzed and exploited by companies to increase and generate revenue and cut costs. With the use of data mining, business organizations are finding it easier to answer queries relating to business aptitude and intelligence, which were very much complicated and intricate to analyze and determine earlier.




Source: http://ezinearticles.com/?Web-Mining&id=6565700

Things You Should Know about Data Mining or Data Capturing

The World Wide Web is a portal containing billions of quality information, spanning resources from around the globe. Through the years, the internet has developed into a competitive business environment which offers advertising, promotions, sales and marketing innovations that has rapidly created a following with most websites, and gave birth to online business transactions and unprecedented financial growth.

Data mining comes into the picture in quite an obscure procedure. Most companies utilize data entry level workers to edit or create listings for the items they promote or sell online. Data mining is that early stage prior to the data entry work which utilizes available resources online to gather bits and pieces of information relevant to the business or website they are categorizing.

In a certain point of view, data mining holds a great deal of importance, as the primary keeper of the quality of the items being listed by the data entry personnel as filtered through the stages under data mining and data capturing.

As mentioned earlier, data mining is a very obscure procedure. The reason for my saying this is because of the fact that certain restrictions or policies are enforced by websites or business institutions particularly on the quality of data capturing, which may seem too time-consuming, meticulous and stringent.

These methodologies are but without explanation as well. As only the most qualified resources bearing the most relevant information can be posted online. Many data mining personnel can only produce satisfactory work on the data entry levels, after enhancing the quality of output from the data mining or data capturing stage.

Data mining includes two common strategies. The first one would be a strategy based on manual labor and data checking, with the use of online or local manual tools and scripts to gather the right information. The second would be through the use of web crawlers or robots to perform the task of checking for information on various websites automatically. The second stage offers a faster method for gathering and listing information.

But often-times the procedure spit out very garbled data, often confusing personnel more than helping.

Data mining is a highly exhaustive activity, often expending more effort, time and money than other types of work. Leveling them out, local data mining is a sure fire method to gain rapid listings of information, as collected by the information miners.

Steve Arun is an Internet Marketing, Client Account Specialist for KPOWEB, an Offshore Outsourcing Consulting company provides virtual dedicated staffing to small business. Go now to KPOWEB Offshore Outsourcing Services, the IT outsourcing people, to access their affordable “Virtual IT Staffing Solution” to find efficient dedicated team that fit your business needs.




Source: http://ezinearticles.com/?Things-You-Should-Know-about-Data-Mining-or-Data-Capturing&id=256125

Data Mining's Importance in Today's Corporate Industry

A large amount of information is collected normally in business, government departments and research & development organizations. They are typically stored in large information warehouses or bases. For data mining tasks suitable data has to be extracted, linked, cleaned and integrated with external sources. In other words, it is the retrieval of useful information from large masses of information, which is also presented in an analyzed form for specific decision-making.

Data mining is the automated analysis of large information sets to find patterns and trends that might otherwise go undiscovered. It is largely used in several applications such as understanding consumer research marketing, product analysis, demand and supply analysis, telecommunications and so on. Data Mining is based on mathematical algorithm and analytical skills to drive the desired results from the huge database collection.

It can be technically defined as the automated mining of hidden information from large databases for predictive analysis. Web mining requires the use of mathematical algorithms and statistical techniques integrated with software tools.

Data mining includes a number of different technical approaches, such as:

    Clustering
    Data Summarization
    Learning Classification Rules
    Finding Dependency Networks
    Analyzing Changes
    Detecting Anomalies

The software enables users to analyze large databases to provide solutions to business decision problems. Data mining is a technology and not a business solution like statistics. Thus the data mining software provides an idea about the customers that would be intrigued by the new product.

It is available in various forms like text, web, audio & video data mining, pictorial data mining, relational databases, and social networks. Data mining is thus also known as Knowledge Discovery in Databases since it involves searching for implicit information in large databases. The main kinds of data mining software are: clustering and segmentation software, statistical analysis software, text analysis, mining and information retrieval software and visualization software.

Data Mining therefore has arrived on the scene at the very appropriate time, helping these enterprises to achieve a number of complex tasks that would have taken up ages but for the advent of this marvelous new technology.



Source: http://ezinearticles.com/?Data-Minings-Importance-in-Todays-Corporate-Industry&id=2057401

RFM - A Precursor to Data Mining

RFM in Action

RFM was initially utilized by marketers in the B-2-C space - specifically in industries like Cataloging, Insurance, Retail Banking, Telecommunications and others. There are a number of scoring approaches that can be used with RFM. We'll take a look at three:

RFM - Basic Ranking
RFM - Within Parent Cell Ranking
RFM - Weighted Cell Ranking

Each approach has experienced proponents that argue one over the other. The point is to start somewhere and experiment to find the one that works best for your company and your customer base. Let's look at a few examples.

RFM - Basic Ranking

This approach involves scoring customers based on each RFM factor separately. It begins with sorting your customers based on Recency, i.e., the number of days or months since their last purchase. Once sorted in ascending order (most recent purchasers at the top), the customers are then split into quintiles, or five equal groups. The customers in the top quintile represent the 20% of your customers that most recently purchased from you.

This process is then undertaken for Frequency and Monetary as well. Each customer is in one of the five cells for R, F, and M

Experience tells us that the best prospects for an upcoming campaign are those customers that are in Quintile 5 for each factor - those customers that have purchased most recently, most frequently and have spent the most money. In fact, a common approach to creating an aggregated score is to concatenate the individual RFM scores together resulting in 125 cells (5x5x5).

A customer's score can range from 555 being the highest, to 111 being the lowest.

RFM - Within Parent Cell Ranking

This approach is advocated by Arthur Middleton Hughes - one of the biggest proponents of RFM analysis. It begins like the one above, i.e., all customer are initially grouped into 5 cells based on Recency. The next step takes customers in a given Recency cell - say cell number 5, and then ranks those customers based on Frequency. Then customers in the 55 (RF) cell are ranked by monetary value.

RFM - Weighted Ranking

Weightings used by RFM practitioners vary. For example some advocate adding the RFM score together - thus giving equal weight to each factor. Consequently, scores can range from 15 (5+5+5) to 3 (1+1+1). Another weighting arrangement often used is, 3xR + 2xF + 1xM. In this case, scores can range from 30 to 3.

So which to use? In reality, there are many other permutations of approaches that are being used today. Best-practice marketing analytics requires a fine mix of mathematical and statistical science, creativity and experimentation. Bottom line, test multiple scoring methods to see which works best for your unique customer base.

Establishing a Score Threshold

After a test or production campaign, you will find that some of the cells were profitable while some were not. Let's turn to a case study to see how you can establish a threshold that will help maximize your profitability. This study comes from Professor Charlotte Mason of the Kenan-Flagler Business School and utilizes a real-life marketing study performed by The BookBinders Book Club (Source:Recency, Frequency and Monetary (RFM) Analysis, Professor Charlotte Mason, Kenan-Flagler Business School, University of North Carolina, 2003).

BookBinders is a specialty book seller that utilizes multiple marketing channels. BookBinders traditionally did mass marketing and wanted to test the power of RFM. To do so, they initially did a random mailing to 50,000 customers. The customers were mailed an offer to purchase The Art History of Florence. Response data was captured and a "post-RFM" analysis was completed. This "post analysis" was done by freezing the files of the 50,000 test customers prior to the actual test offer. Thus, the impact of this test campaign did not effect the analysis by coding many (the actual buyers) of the 50,000 test subjects as the most recent purchasers. The results firmly support the use of RFM as a highly effective segmentation approach.

Purchased the book = yes; months since last purchase = 8.61; total # purchases = 5.22; dollars spent = 234.30
Purchased the book = no; Months since last purchase = 12.73; total # purchases = 3.76; dollars spent = 205.74

Customers that purchased the book were more recent purchasers, more frequent purchasers and had spent the most with BookBinders.

The response rate for the top decile (18%) was twice the response rate associated with the 5th decile (9%).

Results from this test were then used by BookBinders to identify which of their remaining customers should receive the same mailing. BookBinders used a breakeven response rate calculation to determine the appropriate RFM cells to mail.

The following cost information was used as input:

Cost per Mail-piece $0.50

Selling Price $18.00

BookBinders Book Cost $9.00

Shipping Costs $3.00

Breakeven is achieved when the cost of the mailing is equal to the net profit from a sale. In this case:

Breakeven = (cost to mail the offer/net profit from a single sale)

= $0.50/($18-9-3)

= ($0.50/6)

= 8.3% = Breakeven Response rate

So, according to the test offer, profit can be obtained by mailing to cells that exhibited a response rate of greater than 8.3%

RFM dramatically improved profitability by capturing 71% of buyers (3,214/4,522) while mailing only 46% of their customers (22,731/50,000). And the return on marketing expenditures using RFM was more than eight times (69.7/8.5) that of a mass mailing.

Number of Cells and Cell Size Considerations

As previously mentioned, RFM was initially utilized by companies that operated in the B-to-C marketplace and generally possessed a very large number of customers. The idea of generating 125 cells using quintiles for R, F and M has been a very good practice as an initial modeling effort. But what if you are a B-to-B marketer with relatively fewer customers? Or, what if you are a B-to-C marketer with an extremely large file with millions of customers? The answer is to use the same approach that is used in data mining -- be flexible and experiment.

Establishing a minimum test cell size is a good place to start. Arthur Hughes recommends the following formula:

Test Cell Size = 4 / Breakeven Response Rate.

The Breakeven Response Rate was addressed above in the BookBinders case study. The number "4" is a number that Hughes has found works successfully based on many studies he has performed. BookBinders Breakeven Response Rate was 8.3%. Using the above formula, you would need a minimum of 48 customers in each cell (4/0.083). BookBinders actually had 400 customers per cell, so they had more than adequate comfort in the significance of their test. In reality, BookBinders could have created as many as 1,041 cells if they were comfortable using the minimum of 48 per cell. As an example, they could have used deciles as opposed to quintiles and established 1,000 cells (10 x 10 x 10). The more cells the finer the analysis, but of course the law of diminishing returns will arise.

Other weighting considerations can be used for small files. If your Breakeven Response Rate is 3%, your minimum cell size would be 133 customers (4/0.03). Therefore, if you have 12,000 customers you could have about 90 cells (12,000/133). As such, a 5 x 5 x 4 (100 cells) or a 5 x 4 x 4 (80 cells) approach may be appropriate.

Conclusions

RFM, BI and data mining are all part of an evolutionary path that is common to many marketing organizations. While RFM has been practiced for over 40 years, it still holds great value for many organizations. Its merits include:

- Simplicity - easy to understand and implement

- Relatively low cost

- Proven ROI

- The demand on data requirements are relatively low in terms of variables required and the number of records

- Once utilized, it sets up a broader foundation (from an infrastructure and business case perspective) to undertake more sophisticated data mining efforts

RFM's challenges include:

- Contact fatigue can be a problem for the higher scoring customers. A high level cross-campaign communication strategy can help prevent this.

- Your lowest scoring customers may never hear from you. Again, a cross-campaign communications plan should ensure that all of your customers are communicated with periodically to ensure low scoring customers are given the opportunity to meet their potential. Also, data mining and the prediction of customer lifetime value can help address this shortcoming.

- RFM includes only three variables. Data mining typically finds RFM-based variables to be quite important in response models. But there are additional variables that data mining typically use (e.g., detailed transaction, demographic and firmographic) that help produce improved results. Moreover, data mining techniques can also increase response rates via the development of richer segment/cell profiles that can be used to vary offer content and incentives.

As stated before, successful marketing efforts require analytics and experimentation. RFM has proven itself as an effective approach to predicting response and improving profitability. It can be an important stage in your company's evolution in marketing analytics.




Source: http://ezinearticles.com/?RFM---A-Precursor-to-Data-Mining&id=1962283

How Data Mining is Useful to Companies?

Every business, organization and government bodies are collecting large amount of data for research and development. Such huge database can make them to have the information on hand when required. But most important is that it takes much time to find important information from the data. "If you want to grow rapidly, you must take quick and accurate decisions to grab timely available opportunities."

By applying the process of data mining, you can easily extract and filter required information from data. It is a processing of refining data and extracting important information. This process is mainly divided into 3 sections; pre-processing, mining and validation. In pre-processing, large amount of relevant data are collected. The mining section includes data classification, clustering, error correction and linking information. The last but important is validate without which you can not make trust on information. In short, data mining is a process of converting data into authentic information.

Let's have look on how data mining is useful to companies.

Fast and Feasible Decisions: To search information from huge bundle of data require more time. It also irritates a person who is doing such. With annoyed mind one can not take accurate decisions that's for sure. By having help of data mining, one can easily get information and make fast decisions. It also helps to compare information with various factors so the decisions become more reliable. Data mining is helpful in every decision to make it quick and feasible.

Powerful Strategies: After data mining, information becomes precise and easy to understand. While making strategies, one can easily analyze information in various dimensions. This analysis helps to get real idea about the strategy implementation. Management bodies can implement powerful strategies effectively to expand business boundaries.

Competitive Advantage: Information is easily available and precise so that one can compare it with competitors' information. It is very much required that you must compare the data otherwise you will have to suffer in business. After doing competitive analysis, one can make corrective decisions to go ahead from competitors. This way company can gain competitive advantage.

Your business can get all the benefits of data mining at cutting rates through outsourcing.

Bea Arthur invites you on Data Entry India, which provides Data Entry Services, Data Conversion Services and Data Processing Services. They are having vast experience in data mining.




Source: http://ezinearticles.com/?How-Data-Mining-is-Useful-to-Companies?&id=2835042

Advantages of Data Mining in Various Businesses

Data mining techniques have advantages for several types of businesses, as well as there are more to be discovered over time. Since the era of the computer, things have been changing pretty quickly and every new step in the technology is equivalent to a revolution. Communication itself has not been enough. As compared to the present times, the data analyzers in the past have not achieved the chance to go further with the data they have in hand. Today, this data isn't used for selling more of a product but to foresee future risks as well as prevent them.

All are benefiting from modern these techniques even from smaller to large enterprises. They can now predict the outcome of a particular marketing campaign by analyzing them. However, in order for these techniques to be successful, the data must be arranged accurately. If your data is disseminated, you need to bring it in a meeting and then feed into the systems for the algorithms to figure it out. To put it shortly, no matter how small or big your business might be you always need to have the right system when collecting data from your customers, transactions and all business activities.

Advantages of Data Mining For Businesses

Businesses can truly benefit from its latest techniques; however, in the future, data mining techniques are expected to be even more concise and effective than they are today. Here are the essential techniques that you need to understand:

· Big companies providing the free web based email services can use data mining techniques to catch spam emails from their customer's inboxes. Their software uses a technique to assess whether an email is a spam or not. These techniques are first tested and validated before they are finally used. This is to ensure they are producing the correct results.

· Large retail stores and even shopping malls could make use of these techniques by registering and recording the transactions made by their customers. When customers are buying particular sets of product, it can give them a good understanding of placing these items in the aisle. If they want to change the order and placement of the item on weekends, it could be found out after analyzing the data on their database.

· Companies manufacturing edible or drinkable products could easily use data mining techniques to increase their sales in a particular area and launch new products based on the information they've obtained. That's why the conventional statistical analysis is rigid in scenarios wherein consumer behavior is in question. However, these techniques still manages to give you good analysis for any situations.

· In call centers, the human interaction is at its peak because people are talking with another people at all times. Customers respond differently when they talk to a female representative as opposed to talking to a male representative. The response of customers to an infomercial is different from their response to an ad in the newspaper. Data could be used for the benefit of the business and is best understood with the use of data mining techniques.

· Data mining techniques are also being used in sports today for analyzing the performances of players in the field. Any game could be analyzed with the help of these techniques; even the behaviors of players could be changed on the field through this.

In short, data mining techniques are giving the organizations, enterprises and smaller businesses the power of focusing on their most productive areas. These techniques also allow stores and companies to innovate their current selling techniques by unveiling the hidden trends of their customer's behavior, background, price of the products, placement, closeness to the related products and many more.



Source: http://ezinearticles.com/?Advantages-of-Data-Mining-in-Various-Businesses&id=7568546

How Web Data Extraction Services Will Save Your Time and Money by Automatic Data Collection

Data scrape is the process of extracting data from web by using software program from proven website only. Extracted data any one can use for any purposes as per the desires in various industries as the web having every important data of the world. We provide best of the web data extracting software. We have the expertise and one of kind knowledge in web data extraction, image scrapping, screen scrapping, email extract services, data mining, web grabbing.

Who can use Data Scraping Services?

Data scraping and extraction services can be used by any organization, company, or any firm who would like to have a data from particular industry, data of targeted customer, particular company, or anything which is available on net like data of email id, website name, search term or anything which is available on web. Most of time a marketing company like to use data scraping and data extraction services to do marketing for a particular product in certain industry and to reach the targeted customer for example if X company like to contact a restaurant of California city, so our software can extract the data of restaurant of California city and a marketing company can use this data to market their restaurant kind of product. MLM and Network marketing company also use data extraction and data scrapping services to to find a new customer by extracting data of certain prospective customer and can contact customer by telephone, sending a postcard, email marketing, and this way they build their huge network and build large group for their own product and company.

We helped many companies to find particular data as per their need for example.

Web Data Extraction

Web pages are built using text-based mark-up languages (HTML and XHTML), and frequently contain a wealth of useful data in text form. However, most web pages are designed for human end-users and not for ease of automated use. Because of this, tool kits that scrape web content were created. A web scraper is an API to extract data from a web site. We help you to create a kind of API which helps you to scrape data as per your need. We provide quality and affordable web Data Extraction application

Data Collection

Normally, data transfer between programs is accomplished using info structures suited for automated processing by computers, not people. Such interchange formats and protocols are typically rigidly structured, well-documented, easily parsed, and keep ambiguity to a minimum. Very often, these transmissions are not human-readable at all. That's why the key element that distinguishes data scraping from regular parsing is that the output being scraped was intended for display to an end-user.

Email Extractor

A tool which helps you to extract the email ids from any reliable sources automatically that is called a email extractor. It basically services the function of collecting business contacts from various web pages, HTML files, text files or any other format without duplicates email ids.

Screen scrapping

Screen scraping referred to the practice of reading text information from a computer display terminal's screen and collecting visual data from a source, instead of parsing data as in web scraping.

Data Mining Services

Data Mining Services is the process of extracting patterns from information. Datamining is becoming an increasingly important tool to transform the data into information. Any format including MS excels, CSV, HTML and many such formats according to your requirements.

Web spider

A Web spider is a computer program that browses the World Wide Web in a methodical, automated manner or in an orderly fashion. Many sites, in particular search engines, use spidering as a means of providing up-to-date data.

Web Grabber

Web grabber is just a other name of the data scraping or data extraction.

Web Bot

Web Bot is software program that is claimed to be able to predict future events by tracking keywords entered on the Internet. Web bot software is the best program to pull out articles, blog, relevant website content and many such website related data We have worked with many clients for data extracting, data scrapping and data mining they are really happy with our services we provide very quality services and make your work data work very easy and automatic.



Source: http://ezinearticles.com/?How-Web-Data-Extraction-Services-Will-Save-Your-Time-and-Money-by-Automatic-Data-Collection&id=5159023

What You Should Know About Data Mining

Often called data or knowledge discovery, data mining is the process of analyzing data from various perspectives and summarizing it into useful information to help beef up revenue or cut costs. Data mining software is among the many analytical tools used to analyze data. It allows categorizing of data and shows a summary of the relationships identified. From a technical perspective, it is finding patterns or correlations among fields in large relational databases. Find out how data mining works and its innovations, what technological infrastructures are needed, and what tools like phone number validation can do.

Data mining may be a relatively new term, but it uses old technology. For instance, companies have made use of computers to sift through supermarket scanner data - volumes of them - and analyze years' worth of market research. These kinds of analyses help define the frequency of customer shopping, how many items are usually bought, and other information that will help the establishment increase revenue. These days, however, what makes this easy and more cost-effective are disk storage, statistical software, and computer processing power.

Data mining is mainly used by companies who want to maintain a strong customer focus, whether they're engaged in retail, finance, marketing, or communications. It enables companies to determine the different relationships among varying factors, including staffing, pricing, product positioning, market competition, and social demographics.

Data mining software, for example, vary in types: statistical, machine learning, and neural networks. It seeks any of the four types of relationships: classes (stored data is used for locating data in predetermined groups), clusters (data are grouped according to logical relationships or consumer preferences), associations (data is mined to identify associations), and sequential patterns (data is mined to estimate behavioral trends and patterns). There are different levels of analysis, including artificial neural networks, genetic algorithms, decision trees, nearest neighbor method, rule induction, and data visualization.

In today's world, data mining applications are available on all size systems from client/server, mainframe, and PC platforms. When it comes to enterprise-wide applications, the size usually ranges from 10 gigabytes to more than 11 terabytes. The two important technological drivers are the size of the database and query complexity. A more powerful system is required with more data being processed and maintained, and with more complex and greater queries.

Programmable XML web services like phone number validation will assist your company in improving the quality of your data needed for data mining. Used to validate phone numbers, a phone number validation service allows you to improve the quality of your contact database by eliminating invalid telephone numbers at the point of entry. Upon verification, phone number and other customer information can work wonders for your business and its constant improvement.



Source: http://ezinearticles.com/?What-You-Should-Know-About-Data-Mining&id=6916646

Cutting Down the Cost of Data Mining

For most industries that maintain databases, from patient history in the healthcare industry to account information for the financial and banking sectors, data entry costs are a significant expense for maintaining good records. After data enters a system, performing operations and data mining extractions on the information is a long process that becomes more time consuming as a database grows.

Data automation is essential for reducing operational expenses on any type of stored data. Having data entrants performing every necessary task becomes cost prohibitive quickly. Utilizing software solutions to automate database operations is the ultimate answer to leveraging information without the associated high cost.

Data Mining Simplified

Data management software will greatly enhance the productivity of any data entrant or end user. In fact, effective programs offer macro recording that can turn any user into a data entry expert. For example, a user can perform an operation on a single piece of data and "record" all the actions, keystrokes, and mouse clicks into a program. Then, the computer software can repeat that task on every database entry automatically and at incredible speeds.

Data mining often requires a decision making process; a recorded macro is only going to perform tasks and not think about what it is doing. Software suites are able to analyze data, decide what action needs to be performed based on user specified criteria, and then iterate that process on an entire database. This function nearly eliminates the need for a human to have to manually look at data to determine its content and the necessary operation.

Case Study: Bank Data Migration

To understand how effective data mining and automation can be, let us take a look at an actual example.

Bank data migration and manipulation is a large undertaking and an integral part of any bank's operations. Account data is constantly being updated and utilized in the decision making process. Even a mid-sized bank can have upwards of a quarter million accounts to maintain. In order to update every account to utilize new waive fee codes, data automation can save approximately 19,000 hours that it would have taken to open every account, decide what codes applies, and update that account's status.

Recurring operations on a database, even if small in scale, that can be automated will reap cost saving benefits over the lifetime of a business. The credit department within a bank would process payment plans for new home, car, and personal loans monthly, saving thousands of operations performed every month. Retirement and 401k accounts that shift investments every year based on expected retirement dates also benefit from automatic account updates, ensuring timely and accurate account changes.

Cost savings for data mining or bank data migration are an excellent profit driver. Cutting down on expenses on a per-client or per-account basis increases margins directly without having to secure more customers, reduce prices, or remove services. Efficient data operations will save time and money, allowing personnel to better direct their energy and efforts towards key business tasks.



Source: http://ezinearticles.com/?Cutting-Down-the-Cost-of-Data-Mining&id=3329403

Usefulness of Web Scraping Services

For any business or organization, surveys and market research play important roles in the strategic decision-making process. Data extraction and web scraping techniques are important tools that find relevant data and information for your personal or business use. Many companies employ people to copy-paste data manually from the web pages. This process is very reliable but very costly as it results to time wastage and effort. This is so because the data collected is less compared to the resources spent and time taken to gather such data.

Nowadays, various data mining companies have developed effective web scraping techniques that can crawl over thousands of websites and their pages to harvest particular information. The information extracted is then stored into a CSV file, database, XML file, or any other source with the required format. After the data has been collected and stored, data mining process can be used to extract the hidden patterns and trends contained in the data. By understanding the correlations and patterns in the data; policies can be formulated and thereby aiding the decision-making process. The information can also be stored for future reference.

The following are some of the common examples of data extraction process:

• Scrap through a government portal in order to extract the names of the citizens who are reliable for a given survey.
• Scraping competitor websites for feature data and product pricing
• Using web scraping to download videos and images for stock photography site or for website design

Automated Data Collection
It is important to note that web scraping process allows a company to monitor the website data changes over a given time frame. It also collects the data on a routine basis regularly. Automated data collection techniques are quite important as they help companies to discover customer trends and market trends. By determining market trends, it is possible to understand the customer behavior and predict the likelihood of how the data will change.

The following are some of the examples of the automated data collection:

• Monitoring price information for the particular stocks on hourly basis
• Collecting mortgage rates from the various financial institutions on the daily basis
• Checking on weather reports on regular basis as required

By using web scraping services it is possible to extract any data that is related to your business. The data can then be downloaded into a spreadsheet or a database for it to be analyzed and compared. Storing the data in a database or in a required format makes it easier for interpretation and understanding of the correlations and for identification of the hidden patterns.

Through web scraping it is possible to get quicker and accurate results and thus saving many resources in terms of money and time. With data extraction services, it is possible to fetch information about pricing, mailing, database, profile data, and competitors data on a consistent basis. With the emergence of professional data mining companies outsourcing your services will greatly reduce your costs and at the same time you are assured of high quality services.




Source: http://ezinearticles.com/?Usefulness-of-Web-Scraping-Services&id=7181014

Understanding Data Mining

Well begun is half done. We can say that the invention of Internet is the greatest invention of the century which allows for quick information retrieval. It also has negative aspects, as it is an open forum therefore differentiating facts from fiction seems tough. It is the objective of every researcher to know how to perform mining of data on the Internet for accuracy of data. There are a number of search engines that provide powerful search results.

Knowing File Extensions in Data Mining

For mining data the first thing is important to know file extensions. Sites ending with dot-com are either commercial or sales sites. Since sales is involved there is a possibility that the collected information is inaccurate. Sites ending with dot-gov are of government departments, and these sites are reviewed by professionals. Sites ending with dot-org are generally for non-profit organizations. There is a possibility that the information is not accurate. Sites ending with dot-edu are of educational institutions, where the information is sourced by professionals. If you do not have an understanding you may take help of professional data mining services.

Knowing Search Engine Limitations for Data Mining

Second step is to understand when performing data mining is that majority search engines have filtering, file extension, or parameter. These are restrictions to be typed after your search term, for example: if you key in "marketing" and click "search," every site will be listed from dot-com sites having the term "marketing" on its website. If you key in "marketing site.gov," (without the quotation marks) only government department sites will be listed. If you key in "marketing site:.org" only non-profit organizations in marketing will be listed. However, if you key in "marketing site:.edu" only educational sites in marketing will be displayed. Depending on the kind of data that you want to mine after your search term you will have to enter "site.xxx", where xxx will being replaced by.com,.gov,.org or.edu.

Advanced Parameters in Data Mining

When performing data mining it is crucial to understand far beyond file extension that it is even possible to search particular terms, for example: if you are data mining for structural engineer's association of California and you key in "association of California" without quotation marks the search engine will display hundreds of sites having "association" and "California" in their search keywords. If you key in "association of California" with quotation marks, the search engine will display only sites having exactly the phrase "association of California" within the text. If you type in "association of California" site:.com, the search engine will display only sites having "association of California" in the text, from only business organizations.



Source: http://ezinearticles.com/?Understanding-Data-Mining&id=5608012

Why Web Scraping Software Won't Help

How to get continuous stream of data from these websites without getting stopped? Scraping logic depends upon the HTML sent out by the web server on page requests, if anything changes in the output, its most likely going to break your scraper setup.

If you are running a website which depends upon getting continuous updated data from some websites, it can be dangerous to reply on just a software.

Some of the challenges you should think:

1. Web masters keep changing their websites to be more user friendly and look better, in turn it breaks the delicate scraper data extraction logic.

2. IP address block: If you continuously keep scraping from a website from your office, your IP is going to get blocked by the "security guards" one day.

3. Websites are increasingly using better ways to send data, Ajax, client side web service calls etc. Making it increasingly harder to scrap data off from these websites. Unless you are an expert in programing, you will not be able to get the data out.

4. Think of a situation, where your newly setup website has started flourishing and suddenly the dream data feed that you used to get stops. In today's society of abundant resources, your users will switch to a service which is still serving them fresh data.

Getting over these challenges

Let experts help you, people who have been in this business for a long time and have been serving clients day in and out. They run their own servers which are there just to do one job, extract data. IP blocking is no issue for them as they can switch servers in minutes and get the scraping exercise back on track. Try this service and you will see what I mean here.



Source: http://ezinearticles.com/?Why-Web-Scraping-Software-Wont-Help&id=4550594

Data Mining's Importance in Today's Corporate Industry

A large amount of information is collected normally in business, government departments and research & development organizations. They are typically stored in large information warehouses or bases. For data mining tasks suitable data has to be extracted, linked, cleaned and integrated with external sources. In other words, it is the retrieval of useful information from large masses of information, which is also presented in an analyzed form for specific decision-making.

Data mining is the automated analysis of large information sets to find patterns and trends that might otherwise go undiscovered. It is largely used in several applications such as understanding consumer research marketing, product analysis, demand and supply analysis, telecommunications and so on. Data Mining is based on mathematical algorithm and analytical skills to drive the desired results from the huge database collection.

It can be technically defined as the automated mining of hidden information from large databases for predictive analysis. Web mining requires the use of mathematical algorithms and statistical techniques integrated with software tools.

Data mining includes a number of different technical approaches, such as:

    Clustering
    Data Summarization
    Learning Classification Rules
    Finding Dependency Networks
    Analyzing Changes
    Detecting Anomalies

The software enables users to analyze large databases to provide solutions to business decision problems. Data mining is a technology and not a business solution like statistics. Thus the data mining software provides an idea about the customers that would be intrigued by the new product.

It is available in various forms like text, web, audio & video data mining, pictorial data mining, relational databases, and social networks. Data mining is thus also known as Knowledge Discovery in Databases since it involves searching for implicit information in large databases. The main kinds of data mining software are: clustering and segmentation software, statistical analysis software, text analysis, mining and information retrieval software and visualization software.

Data Mining therefore has arrived on the scene at the very appropriate time, helping these enterprises to achieve a number of complex tasks that would have taken up ages but for the advent of this marvelous new technology.




Source: http://ezinearticles.com/?Data-Minings-Importance-in-Todays-Corporate-Industry&id=2057401