Unified fragmented data sources into a single, automated ecosystem that improved collaboration between marketing, CRM, and analytics teams.

Approach

• Connected multiple data environments — including Google BigQuery, Sheets, and CRM tools — through custom App Script and automation workflows.
• Mapped each team’s data needs and access habits, ensuring outputs were intuitive for both technical and non-technical users.
• Built lightweight processes for data refreshes and permissions, aligning information flow with campaign and reporting cycles.

Impact

• Enabled real-time access to performance and incentive data across departments, reducing delays in reporting and approvals.
• Increased analytical maturity by making reliable data accessible without external support or manual exports.
• Established a framework still used to connect new systems into the organisation’s analytics stack.