I recently completed the Google AI Essentials course from Google on Coursera and I am happy with what I got to learn. It covers the foundational concepts of AI, prompt engineering and responsible AI usage. This course helps you improve your productivity using Generative AI tools like Gemini. This is a non-technical course and not meant for those aspiring to be AI/ML developers. Key Insights...
seo report from search console: looker studio template
This Search Console report helps you understand your website’s SEO performance. The ‘Search Console’ data connector in Looker Studio gives you two options to connect: 1. URL Impressions and 2. Site Impressions. You will need to create two data sources, one for ‘URL Impressions’ and the other for ‘Site Impressions’. Important: Some calculated fields need to be customized...
looker Studio: Relative to Base Data vs Corresponding Data
Comparison metrics in Looker Studio have two options: ‘Relative to base data’ and ‘Relative to corresponding data’. Let’s see what these terms mean. Take a look at the below table and its configuration that follows. The dimension is ‘source’. The metric ‘Sessions’ is added twice. You will generally not need to add it twice. But I am doing so in this post to make it easy to explain the difference...
COVID19: Employee Self Declaration using Google Forms and looker Studio
Employees can report any COVID19 symptoms that they have using the Self-Declaration form. The data entered in this Google Form will be displayed in a Looker Studio report. Demo Form: Demo Report: You can copy the form and the report and use it in your organization. Follow the below instructions to copy. How to copy the form and store the responses in a Google Sheet? Click the link below...
Looker Studio Tips for Agencies with Multiple Clients
In this post, I will share a few ideas and Looker Studio features to help Digital Agencies with multiple clients. The idea is to start a discussion around this topic and share notes among ourselves. 1. Create a master report 2. Chart specific vs Data Source calculated fields: Which ones to use? 3. Give descriptive names to data sources 4. Copy existing data source instead of creating new ones 5...
looker Studio Template: Goals Report From Google Analytics
This 5 page Looker Studio template helps you visualize your Google Analytics Goals. The template also provides tips to help you get the most out of Looker Studio features. Some charts include calculated fields, analytical functions, optional metrics, conditional formatting and sort features. If you want a custom Looker studio report built by a professional, you can hire me here. Open in a new...
How to track button clicks in Google Analytics using Tag Manager?
This post shows you how to track button clicks on a website using Google Tag Manager. I assume that you not only know how to install Google Analytics using Tag Manager but have already done that on your website. So here is a page with the ‘Shop now’ button. Let’s see how to track this button clicks using GTM. Step 1: Enable Click Variables Login to GTM, go to...
How to visualize a goal flow segment in looker Studio?
This post shows how to visualize a goal flow segment in Looker Studio. I assume that you have basic knowledge of Looker studio’s calculated fields. You can see the visualization in action here. Assume that the page paths for the goal flow are: /step1.html /step2.html /step3.html /step4.html Step I: Create custom field Now create a custom field with the below formula (replace the page paths...
looker Studio Dashboard for Web Analytics – Free
This Free 16 page Looker Studio Template for Web Analytics consists of 16 pages. The data sources are: Google Analytics (with Adwords linked to Google Analytics) Google Search Console CLICK HERE TO GET THE TEMPLATE If you would rather have a customized Looker studio report, I can create one with Analytical functions (% of total etc.), Calculated fields (simple Math, Aggregation, CASE statements...
How to Give Consultants access to Google Data Studio and Data Sources?
Let us first look at two of the common methods of getting a Looker studio report built and why they are wrong. Wrong Method 1: Consultant creates a ready-to-use template that you copy to your Looker studio account and become the owner. Though sufficient in some cases, it is a generic template that is not tailored to your business. A report that is tailored to your requirements increases the...