GIS/Market Research Case Studies
The Green Confidence Index (GCI) is a collaboration between Earthsense, Survey Sampling and GreenBiz. The GCI is an index score that tracks the changes in consumer attitudes and behaviors on the environment, and their perceptions on corporations and other institutions.
FSI automated the monthly process of exporting the survey response data from SPSS to SQL Server, and then generating more than a dozen Excel reports, each with over 50 data points and metrics.
As part of the Earthsense team, FSI is responsible for maintaining the data for a large, syndicated survey. Eco-Insights© is the largest U.S. syndicated database of consumer attitudes and behaviors toward the environment and sustainability.
Scripts are built in SPSS to export into a SQL Server 2008 database. All aspects of database maintenance, including QA/QC, appending and exporting to various platforms are handled by a combination of stored procedures and an Excel VBA application, custom built for the project.
FSI teamed up with TNG Research to develop a customized posting system for The Tennis Channel, combining commercial traffic schedules with local market ratings data and advertiser guarantees to create a “report card” or each client’s audience delivery.
To develop the report card, FSI used a combination of SQL Server stored procedures and Excel VBA. The proprietary algorithm was automated to run against each advertiser in each of 57 markets based on each ratings data.
FSI teamed with its partner Catenate Consulting as Experian’s “spatial analytical” team. During that relationship FSI/Catenate developed a methodology to use customer transaction files to create targeted mailing lists for Experian.
FSI automated the process to run the “hot spot” routine, which analyzed a million-plus record customer list and mapped it for over 250 stores.
The result was to increase return rates for direct mail campaigns for customers such as Williams Sonoma, Borders Books and Pottery Barn.