How to create powerful dashboards using Google Spreadsheet and Google Analytics Integration?
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.
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.