Our client runs a successful brand activation business and BAM, being one of the most affected platforms, has successfully activated more than $200 million sponsorships featuring around 80 clients, 300 events and 100+ retail partners. The application helps event organizers to acquire sponsorships easily, and at the same time, provides promotional opportunities to the brands via a hassle-free registration process. OnGraph is proud of having been selected as a partner by BAM to develop a B2B application that brings together events and sponsors. Our team organized the website in a way that it was easier for event organizers to find sponsors, for attendees to search events and related information including event details, venue, time, location on the website itself. We used different technologies such as Postgres to handle the workload and Solr Search to make users’ search filter criteria faster, easier and efficient.GO TO WEBSITE
We had to go through several challenges such as slow search filter, inaccurate event locator finder, and inconsistent records and information related to branded stores. It was not only daunting to resolve such issues but also required a lot of research and analysis in order to meet tight deadlines.
Users were finding difficulty in searching the specific events due to the humongous information available on the website. The search filter was extremely slow and less responsive while rendering the required event details.
Finding an event locator that is not only cost-effective but also accurate when it comes to searching and locating events was extremely difficult.
Fetching event information from other websites and maintaining their accuracy in terms of venue, location and so on was difficult as we had to filter the event-related information, (fetched through the database), using an entirely different application every time.
Maintaining the stores’ data on a regular basis was difficult due to frequent data invalidation due to reasons such as stores getting closed or moved to a different location.
With the help of our dedicated professionals, we used a tech-stack that helped us resolve the challenges we faced. We used the latest and cost-effective technologies such as Solr Search, Tomtom, geolocation to make sure that we fulfill every requirement from our client.
Instead of SQL query, we used Solr search that enables hit highlighting, full-text search, dynamic clustering, database integration, and real-time indexing. We added filters based on location (city/country) and the name of the event/sponsor to simplify the search and make it more efficient.
Tomtom API integration was used instead of Google place API to locate the events as well as the brand stores. The integration was cost-effective and provided us with accurate results.
To filter out data related to events and nearby stores, we used crawler (a script), an automated program to scan through the web pages and create an index, which in turn was used to maintain accurate events data. Moreover, it was leveraged to determine customer and market trends in a given geography.
We used geolocation to track the exact location of the stores. Geolocation simply tracks which IP range is used by which area, using an IP-to-location database. This way, we were able to easily manage the bulk data related to store locations.