$299 CMS $99 PPC $99 SEO $49 SMO

Data Analysis

Reporting:

Project Objective

A major SEM agency was seeking operational efficiency in standard & adhoc reporting tasks.

Client

A major Search Engine Marketing agency from Chicago USA

Approach

  • Worked with client to understand the data retrieval process
  • Evaluated the process to generate reports & created specific process documents

Solution and Benefits

  • Recommended 2-3 hours of daily overlap between onsite & offshore team to bridge the communication gap
  • Offered peer-to-peer quality check process to adhere to onsite quality standards
  • Achieved 99% accuracy within one month & later on, consistently provided 100% accuracy for standard reporting tasks
  • Client achieved at least 50% efficiency in daily operational tasks – thereby onsite team was able to focus on generating millions of dollars in new reven

Data Analysis: Case Study 1

Project Objective

Produce marketing strategies based on segmentation analysis.

Client

A fortune-500 affiliate – reseller of cable services i.e. Cable TV, High Speed Internet, & Phone services.

Approach

Gathered multi millions rows of customer address data who is performing a service availability check on affiliate website. Initial data analysis was aimed at data completeness and cleanliness. The 3rd party data to add demographic information was further appended. Segmentation was done using CART (Classification And Regression Trees).

Solution and Benefits

  • Eight segments were created with specific age group, income range, & Education level
  • The segments then further mapped to zip codes
  • The creative team was advised to produce segment specific landing pages e.g. students & recent college graduates were presented with creative which were appealing to them
  • Marketing team further produced promotions as per the segments & worked with the creative team to design the graphicsn
  • With the segmentation marketing – client was able to increase the conversion rate by 200%

Data Analysis: Case Study 2

Project Objective

A major Marketer was seeking to optimize the resource cost by augmenting offshore resources with the onsite team to gain efficiencies in data analysis projects

Client

A fortune-500 affiliate – reseller of cable services i.e. Cable TV, High Speed Internet, & Phone services.

Approach

  • Worked with client to understand the data intricacies; conducted interactive onsite-offshore training sessions
  • Provided best in class SAS/SPSS programmers
  • Evaluated the process & created specific process documents

Solution and Benefits

  • Recommended 2-3 hours of daily overlap between onsite & offshore team to bridge the communication gap
  • Offered peer-to-peer quality check process to adhere to onsite quality standards
  • Further recommended automation for SPSS programs to improve run-time & to reduce the human error
  • Client was able to save at least $75,000 in resource cost
  • Client was able to achieve at least 50% efficiency in data analysis tasks – thereby, onsite team was able to focus on generating millions of dollars in new revenue
  • Offshore team provided 95% & more, accuracy in data analysis projects