How to create powerful dashboards using Google Spreadsheet and Google Analytics Integration?
With 3.5+ years of experience in Start-Up culture, Aditya is a conversion rate optimizer, marketer with cross-functional expertise in business development, digital marketing.
He is currently working in FabHotels.com as Project Manager, taking care of Product and Growth. Working on research, analysis & generation of actionable insights to define the product strategy & roadmap for building best-in-class mobile experiences for all the users.
Prior to this, he was working as Digital Marketing Manager in UrbanClap, Responsible for demand generation across all the 8 major cities in India, funnel improvement, campaign management, budgeting, and optimization.
He is also doing his masters from Management Development Institute, Gurgaon ( Executive-PGPM, It is a course for working professionals ). In free time, he prefers singing, playing drums and painting.
Who should attend this webinar: Marketers, Marketing Analysts, Product Analysts, Product Managers, All the hustlers who use Google Analytics frequently for tracking their website performance, marketing campaigns
What can you expect from this webinar: Every company operates around objectives and uses key performance indicators (KPIs) to track progress towards those objectives. For each goal, there are two main questions teams should easily be able to answer at any time:
- How much progress have we made so far?
- Are we on track to hit the goal?
Data dashboards are a great medium to provide on-demand answers to these questions. There are multiple enterprise-grade data visualization products out there, but sometimes a simple spreadsheet, if used right, can do the job just as well.
Also, in google analytics, there are some constraints like having only 4 segments at a time to analyze the metric, multiple dimension analysis at a time. These constraints would be solved using Google spreadsheet and google analytics integration.
We will be discussing
- What is the Google Analytics add-on?
- How to install and set up the Google Analytics add-on
- How to create a custom report with the Google Analytics add-on
- A step-by-step worked example of setting up an automated report
- Further considerations and pitfalls to avoid