SOLUTION
When we took over our client's accounts, we first conducted a tracking audit, examining UTMs across channels and their integration with the Data Warehouse. Subsequently, we developed a UTM standard sheet to ensure consistent parameters across all channels.
To dynamically pull campaign names, ad groups, and keyword parameters, we implemented dynamic URL parameters for social media and ValueTrack parameters for Google campaigns. Collaborating with the BI team and Data Warehouse ensured accurate data retrieval in the DWH and its proper display on the data visualization platform.
Working closely with the BI team, we created dashboards that provided visibility into conversions (Sign-Ups, FTDs) and player values, even at the keyword level. This enabled our client to reallocate budgets to the most profitable channels more effectively, significantly save on budget, and helped to double the GGR from new users year over year.