| |
|
| Market Research Outsourcing (MRO) |
|
» |
|
|
» |
|
|
» |
|
|
» |
|
|
|
|
|
|
|
|
| Data Processing & Analysis |
|
|
|
| |
 Abacus data processing & analytics team is well equipped to professionally manage your data processing, data management, statistical analysis, data mining and other related areas needs. We contribute to our clients’ success worldwide by providing high quality services in data management and analytics services at competitive prices.
We are committed to provide timely delivery of error free processed data on an on going basis. We continuously innovate in processes, quality control, value additions and demonstrate leadership in our field of work through customer focus and total employee involvement.
|
| |
|
| |
We specialize processing the data collected through various methodologies like F2F, CLT’s, web surveys, CATI & PAPI, etc. We deliver value and exceed the expectations of our clients and have worked on multi-country long tracking studies, omni-bus, and in-depth interviews.
We can design automated E-Tabs for your tracking studies which will help you draw standard charts including additional campaign sections and client specific / standard/non standard charts along with template bank with different colors schemes offering more options for cosmetic look of the deck.
We provide continued support through long holidays to cater urgent requests.
Our experience:
- We have successfully handed Track/Dips for Honomichl Top 50 research & consulting firms
- Handed Print Links, CAPI Tracks and automated monthly toplines
- Standard tables with significance testing, moving averages
- Standard times series charts and time series charts on moving averages
- Multi category continuous or ad-hoc study – Online, PAPI, CAPI and CATI
- Capabilities to develop customized programs based on algorithm provided
- We also provide macros on charts to automate tracking studies
- Our analyst goes through rigorous classroom trainings on research insights for sound industry and product knowledge
- Dedicated office specific teams to develop in depth knowledge of projects
- Close interaction and monthly meetings with PM and CS teams to iron out any operational concerns
- We also provide data manipulation combining data from various survey sources
- Working with data in multiple formats like Quanvert, SPSS, ASCII, and CSV
- Conversion of data-single card to multi card (and vice versa)
- Simple time series charts and time series charts on moving averages
Click on the icons to know more:
|
Data coding – Abacus compiles and generates cleaned data files after validating, cataloguing, editing, open ended coding and merging multiple survey instrument outputs into one single data set or table. |
Data cleansing – Abacus research analysts follow a methodical process for preparing the data for high end statistical analysis. Typically we study the survey instrument and the data set and based on the data collected we check for errors, incorrect and missing values. |
Data tabulation – We work with primary research outputs in SPSS, ASCII, Excel, Custom Tables, mrTables, Quantum and Wincross for banners and cross tabs. |
Data reduction - Using factor analysis, we minimize the number of variables by merging those which highly correlate among themselves. After which the merged variables are used for further analysis. |
Statistical analysis – We specialize in delivering statistical analysis to cater to client’s needs such as,
- Testing Statistical Significance between different phenomenons.
(t test anova)
- Modeling Consumer Behavior – (Multiple Regression Analysis)
- Segmenting customers - Different customers have different needs and it is rarely possible to satisfy all customers by treating them alike. So we do segmentation which helps our client’s in more effective allocation of sales and marketing resources. Also this helps them to identify different marketing strategies for each segment based on the characteristics and needs of each segments.
- Predicting Customer Behavior with the help of their survey responses and demographic details and here we can do Logistic regression and Discriminant analysis
- Canonical Correlation - With the help of canonical correlation we can take two sets of variables and show what is common amongst the two sets. We can also use canonical correlation analysis to produce a model equation which relates two sets of variables and also you can gain insight into what dimensions are common between the variables and how much variance is shared
|
|
| |
|
|
|
| |
|
|
|
| Client description |
The client is one of the world’s leading research companies in marketing research and brand consulting. Their expertise spans from communications assessment and media evaluation to brand performance monitoring and marketing accountability. |
| Project description |
It was a dipstick study in 25 countries with a total sample size of 12000 respondents involving around 4000+ brands. Abacus Market Analytics was asked to start the data validation program within 7 days after field work started. Each country had separate data tables in XLS and MS-word format with a set of 25 Quanvert database - 1 for each country and one combine Quanvert file. Abacus was also responsible for generating country wise Jaccard Scores on different cuts and Brand Image profile (BIP) charts. |
| Abacus deliverables |
Abacus Market Analytics did the following things:
- Abacus analytics team prepared a common card design for all the countries
- A master brand list was generated to streamline the process
- Data validation program was designed for each country
- Constant interactions happened with the fieldwork agencies for any discrepancy in the data
- Last year data was merged with the current year data for drawing comparisons & trends
- We also merged CAPI data with PAPI as two countries data were captured in CAPI in different layouts
- The final deliverable was sent to the client using Quantum / SPSS
|
| Benefits |
This was the first project with the client and Abacus completed the entire project in a very systematic way with resource strength of 2 data processing analyst and a manager. The timelines of finishing the project was tough and Abacus team was able to give client ready output well within the tough timelines. |
|
| Client description |
The end client is a diversified pharmaceutical and health care giant. |
| Project description |
The objective of the study was to track the usage of 5 different product categories of the company. The survey data was captured in grid format for all 5 categories for each respondent. |
| Abacus deliverables |
Key requirements of the projects met by Abacus Market Analytics team were:
- Abacus team sent the data cleaning script to the client
- Generated complex tables as per client requirement
- Final output was delivered in different tables based on various factors like household income, number of family members, demographics, etc.
- The total number of respondents were displayed as baseline and calculations were done on total volume used by these respondents for various brands
- Volumetric Share Calculation was done along with volume share of each category on different cuts
Multi level process used to simplify the analysis task:
In Level 1 process
o We stacked the data category wise, i.e. 5 categories 2 brands per category (5*2=10); and generated a counter within the process to identify the categories.
In Level 2 process
o We stacked the data member wise, i.e. 8 members per category for each brand.
|
|
| Client description |
The client is of the well known brands in the soft-drink industry. |
| Project description |
This was a Brand Pack Price study on Carbonated Soft Drink in Morocco
The object was to evaluate price sensitivities of various SKU’s in Carbonated Soft Drink category in Morocco thus enabling the client to align product portfolio to maximize revenue and/ or market share. The main object was to explore the possibility of introduction of new packs and enable the client to analyze various ‘What-if’ scenarios.
|
| Abacus deliverables |
We used techniques like Extended Gabor Granger, Price sensitivity meter along with regular data analysis to meet the research objectives. |
| Benefits |
Benefits Abacus Market Analytics provided analysis outputs like EGG which went as a direct feed into the model (CBC) calibration. Analysis from various other sections went into better understanding of the market. Rigorous analysis was done on Brands section and Imagery section and we provided the final deliverable in normal CSVs at various cuts and also in SPSS format.
The various techniques used were as below:
PSM - is an economical technique that can be a stand-alone measure or readily incorporated into some other piece of research. PSM may reveal a discrepancy between manufacturer and consumer price or value perceptions. It may on the other hand, be that the manufacturer is unwilling (or even unable) to set a price until he knows the optimum range within which potential consumers would be prepared to pay.
Garbor Granger™ (Buyer response)- “demand curve”
A relatively simple approach to the estimation of demand elasticity involves the testing of a series of different prices for a product or service, and measuring change in interest or purchase intention at each price
By aggregating the responses across the total sample, a `demand curve` can be plotted to show the relationship between price and purchase intent (or volume share if the appropriate questions have been asked).
|
|
| Client description |
The client is recognized leader in confections with a wide range of product offerings including gum, mints, hard and chewy candies, lollipops, and chocolate. |
| Project description |
A usage & attitude study for confectionery with special focus on gums:
AT CATEGORY LEVEL
For Gums, Candies, Mints & Chocolates, we will look at
- Awareness of different categories
- Defining their role & understanding the determiners behind the groupings
- Elucidate the usage and consumption patterns
- Switching behavior within each & across various confectionary categories
- Imagery associated with each confectionary category
AT BRAND LEVEL
For Gum Brands - Boomer, Orbit, Double mint, we will look at
- 5 Ws: When, who, where, what & why
- Feedback on the product
- General purchase behavior
- Imagery in terms of personality & functional imagery associated with each brand
|
| Abacus deliverables |
Abacus Market Analytics provided frequency tables with significant testing as well as factor weighting at all India level along with Jaccard Tables (YY,YN & NY).
|
| Benefits |
Client was delighted to get the information on awareness and the usage pattern of their Confectionery Products in different states.
|
|
|
|
|
