Saturday 26 Sep, 2026

Starting at 8.30am doors open

Etc Venues Fenchurch Street

etc.venues Fenchurch Street, 8 Fenchurch Pl, London EC3M 4PB
Menu

Merging GA data with other data sources

This session is being run by Petr Havlik who will attending from Prague! Petr’s session is about incorporating company data sources to get the best value using some simple methods. He will be using some real data from one of his clients to show you.

Petr says this ;

I would like to give a short demo on the importance of merging web analytics data with data that companies have available in internal systems (CRM/ERP etc.).Luckily, this doesn’t have to include any horrendously expensive Business Intelligence solutions. No tracking code changes required either. Merging data is actually quite simple and effective, all you need is Excel (with PowerPivot enabled to avoid slow and dummy LOOKUPs).In 15 minutes, I would like to demonstrate how to:

  1. Download raw and unsampled data from GA
  2. Merge GA data with other data sources
  3. Calculate 2 simple and quick things:
  • “True” ROI for traffic channels based on Net Profit (evaluate campaigns by net profit — not sales revenue).
  • Detailed conversion rates for products / categories / any other dimensions.

Real e-commerce numbers from one of my clients included :-).

Thanks,

Petr

 

Leave a Reply

Your email address will not be published. Required fields are marked *