Kapital - AI Adoption Masterclass - Automate Your Reports with Google Looker Studio and BigQuery - Yasen Lilov

Overview of how you can leverage AI to automate reporting with Google Looker Studio and BigQuery

1. Automate Your Reports with Google Looker Studio and BigQuery Masterclass: AI Adoption Yasen Lilov Partner, Head of Data & Analytics

2. Agenda increase Efficiency enhance Performance improve Productivity

3. Yasen Lilov Partner, Head of Data & Analytics VertoDigital

4. Yasen Lilov Partner, Head of Data & Analytics VertoDigital

5. Yasen Lilov Partner, Head of Data & Analytics VertoDigital

6. Yasen Lilov Partner, Head of Data & Analytics VertoDigital

7. Meet Jim.

8. > Digital Marketing Specialist Marketing Agency

9. Which ad creatives are driving the most conversions on Meta Ads? Pain Point : The manual extraction and cleaning process is tedious and can delay the timely delivery of insights to the team. CTR, Conv. Rate, CPA

10. How are my Google campaigns performing this month compared to the previous month? Pain Point : This process is time-consuming and prone to errors, especially when dealing with large datasets or multiple campaigns. Clicks, Impressions, Conv. Rate, Conversions

11. What is the ROI of our latest marketing campaign across all platforms? Pain Point : Combining data from multiple sources involves complex data manipulation, and any misalignment in data formatting or time periods can lead to inaccurate results. Clicks, Impressions, Conv. Rate, Cost Conversions - Leads, ROI, Revenue

12. Pain points Complex data integrations Time-consuming data extraction Tedious data cleaning and visualization

13. Stage One : Increase Efficiency Connect To all your data Visualise R eports Share Across organization Enter Google Looker Studio

14. Stage One : Increase Efficiency Enter Google Looker Studio - Data Extraction [Solved]

15. Stage One : Increase Efficiency Enter Google Looker Studio - Data Cleaning, Visualisation [Solved] 3.1M 20.3M 73,800 528,038 $8,403 107,444

16. Stage One : Increase Efficiency Enter Google Looker Studio - Data Cleaning, Visualisation [Solved] 3.1M 20.3M 73,800 528,038 $8,403 107,444

17. Stage One : Increase Efficiency Enter Google Looker Studio - Data Cleaning, Visualisation and Sharing [Solved] 3.1M 20.3M 73,800 528,038 $8,403 107,444

18. Stage Two : Improve Productivity Enter Google BigQuery F ully managed, serverless data warehouse designed for scalable and efficient data analytics. It is part of the Google Cloud Platform (GCP) Extensive Data Connectors Built-in ML Capabilities Continued Innovation

19. Stage Two : Improve Productivity Enter Google BigQuery Complex data integrations [Solved] CRM Data Product Data … Native You own the data Build first-party data pool Data modelling, blending and transformations can be customized

20. Stage Two : Improve Productivity Enter Google BigQuery Complex data integrations [Solved] CRM Data Product Data … Native Fivetran Native Native Segment SnapLogic Zapier

21. Stage Three : Enhance Performance Enter Google BigQuery and AI

22. Stage Three : Enhance Performance Enter Google BigQuery and AI Can you help us rewrite our Ad Copy? We have just around 120 Headlines across 8 Ad Groups. It would be great if we can have two variations per Ad Group.

23. Stage Three : Enhance Performance Enter Google BigQuery and AI Custom GPTs Leverage first party data to write contextual prompts for Generative AI. Ad Copy Structure Custom GPT INPUT OUTPUT Persona attributes Historical performance Keywords and Landing Pages Scraped Landing Page content </ >

24. Stage Three : Enhance Performance Enter Google BigQuery and AI Applied-AI enabled. User Segmentation and Clustering Group similar customers for personalized marketing and product development. Custom GPTs Leverage first party data to write contextual prompts for Generative AI.

25. Stage Three : Enhance Performance User Segmentation and Clustering Group similar customers for personalized marketing and product development. Propensity modeling Identify customers most likely to convert or churn, enabling targeted marketing campaigns and resource optimization. Custom GPTs Leverage first party data to write contextual prompts for Generative AI. Enter Google BigQuery and AI Applied-AI enabled.

26. Stage Three : Enhance Performance Forecasting Leverage historical data to decide on actions to take in the future. The decisioning model relies heavily on accurate and timestamped data. User Segmentation and Clustering Group similar customers for personalized marketing and product development. Propensity modeling Identify customers most likely to convert or churn, enabling targeted marketing campaigns and resource optimization. Custom GPTs Leverage first party data to write contextual prompts for Generative AI. Enter Google BigQuery and AI Applied-AI enabled.

27. Thank you!

28. Yasen Lilov Partner, Head of Data & Analytics VertoDigital /in/yasenlilov/ [email protected] Scan to connect!