Initial situation
Tirana Dental Clinic needed a reliable reporting structure that would integrate not only marketing data but also CRM information from HubSpot. Previous tracking solutions with Google Analytics and Tag Manager provided data, but lacked a clear link to leads, channels and actual results. The biggest challenge was to clean up disparate and inaccurate tracking data and structure it so that it could be merged into reliable reports in HubSpot and Looker Studio.
Measures
- HubSpot integration: Setting up CRM data streams in HubSpot including leads, deals and marketing activities.
- Google Ads & Meta Ads: Connection of advertising data to HubSpot to map complete customer journeys.
- Workflows for channel mapping: Automated assignment of imprecise tracking data to defined marketing channels.
- Looker Studio Reporting: Creation of a comprehensive dashboard with marketing and CRM KPIs for management and marketing.
Results
- Centralized reporting in HubSpot & Looker Studio
- Clean database through workflows & channel mapping
- 360° overview of leads, marketing channels & performance
- Future-proof setup thanks to complete integration of CRM and marketing data
