Comprehensive Data Collection & Analysis
Challenge: Ushahidi faced three major issues that needed to be addressed to enhance their data visibility and operational efficiency. Firstly, the manual resolution of support tickets: Ushahidi records deployment and creator information in Google Sheets, which requires the team to address support requests by hand, leading to delays and a tedious workload. Secondly, there was a lack of conversion and churn data: Without a system to track successful onboardings and drop-offs, it became difficult to understand why users were leaving and how improvements could be made. Lastly, the data was cluttered: The team struggled to differentiate between genuine and spam (test) deployments, resulting in disordered data.
Solution: The objective was to develop a detailed tracking plan to capture all events for proper analysis of user behavior. We aimed to create a system that gathered data automatically on user interactions and stored it centrally. Here's how the MarketLytics team achieved this: - Data collection: We utilized a combination of Google Tag Manager (web) and the new Google Tag Manager (server side) for data gathering. - Data translation: The data was then sent to Google Analytics to help identify users, assess interactions with our sites, and understand how these users arrived at our sites. - Data storage: We utilized Google BigQuery to store and transform this information, loading raw data into specific datasets for querying via SQL. - Data visualization: Finally, we created reports in Google Data Studio to provide an up-to-date view of potential customers and their activities.
Result: As a result, Ushahidi gained a complete overview of deployment activities and user journeys in both Google Analytics 4 and Google BigQuery. They could visualize all events included in their master sheet alongside deployment performance, which is automatically updated. This streamlined the manual processes of data collection, user response, and identifying potential users.