Lynchpin’s Post

Just updated the latest version of my regex used to monitor referral traffic from Chatbots / LLM in Looker Studio (based on default GA4 setups). Link is now in the comments since I will be offline for a few days :) Please repost if you found it useful.

Write #LookML with #Gemini assistance (Public Preview) 🤩 Gemini in #Looker provides generative AI-powered assistance to help you work with your data. In the Looker IDE (in Looker Core, not Studio), the Help me code panel uses Gemini in Looker to generate LookML code suggestions in response to written prompts. You can use Gemini to create dimensions, dimension groups, and measures in your LookML project. ➡https://lnkd.in/dwP-FifJ

Enabling BigQuery linking for GA4 offers key benefits: Advanced Analysis: Run complex queries for deeper insights. Raw Data Export: Access and store raw event data for long-term use. Custom Reporting: Create tailored reports to meet specific business needs. Data Integration: Combine GA4 data with other sources for comprehensive analysis. Machine Learning: Leverage ML models to predict user behavior. Scalability: Efficiently handle large datasets. Event Flexibility: Easily query based on specific user interactions. Overall, it enhances data-driven decision-making. ♻ Like or Repost to get others to play as well 💌 Hire Me: https:https://lnkd.in/ghUxhEpU 💌 Portfolio Link: https://lnkd.in/g-7yEqNm #googleanalytics4 #ga4 #digitalmarketsact #digitalmarketing #analytics #dataanalysis #marketer #dataanalyst #data #datadriven #exceltips #marketinganalyst #bigquery #lookerstudio #googledatastudio #googlesheets #python #datavisualization  #BigQuery #LookerStudio #WebsiteAnalytics #DataVisualization #BusinessIntelligence #DigitalMarketing #GoogleCloud

I am shifting my focus from what we're doing in #dbt to what we're doing in #looker. I am determined to figure out a sustainable way of using Looker in a company that has multiple domains and thousands of data tables. I'm sure there's a better way than creating 10K datasets and 50K charts in the Looker repo, ensuring most of these will never get maintained or used again. 😇 How do you make sure the model exposes all of your data in a way that users can find what they're looking for? I don't mean documentation, I mean how do you combine views into explores and explores into models. Who are you favourite thought leaders on this topic? Any "aha" moments you've had? Any articles that you keep going back to for guidance?

🚀 Understanding Query Length Categorization in Looker Studio 🔻 Categorize: ✅ Short-tail: Queries with ≤ 2 words. ✅ Mid-tail: Queries with 3-4 words. ✅ Long-tail: Queries with more than 4 words. 🔻 How to use: 1️⃣Creating a Calculated Field 2️⃣Add RegEx code as shown in the image 🔰 Tip: Excluding “null” or hidden queries can yield better results.

Normally, I would hold the excitement to prepare a video, but I need to spread the news: REGEX functions are coming to Microsoft Excel!!! 🎉 Those who are devs or professionals in tech & data will understand what the functions do just by their names: REGEXEXTRACT, REGEXREPLACE, and REGEXTEST. If you have never heard about REGEX before, it stands for "Regular Expressions," which is a notation to help match patterns in data. The new REGEX functions in Excel can help you with the following tasks: • REGEXTEST: To test if there is a specific pattern in some text. • REGEXEXTRACT: To extract specific part(s) matching the given pattern. • REGEXREPLACE: To replace a matching pattern with specific text. Well, a picture is worth a thousand words, so here we go with a quick demonstration of emails being extracted from unstructured text! 🔥 More tips to come! 🚀 Follow: Cristiano Galvao #REGEX #Excel #MicrosoftExcel #RegularExpressions #Data

🎯 How to Separate Traffic by Different Directories in Looker Studio Segmenting traffic based on different directories can provide valuable insights into how users interact with key sections of your site. 🧐 1️⃣ Creating a Calculated Field 2️⃣ Add RegEx code as shown in the image ⚠️ Note: This formula is just a starting point! You’ll need to customize the directory structure based on your own site’s URLs. For example, change /cat/, /product/, or /mag/ to match your actual directory names.

🔓Unlock the power of custom channels in Looker Studio! Tired of default channel groups not fitting your needs? Modify the code with Regex functions to create tailored channels that meet your specific requirements. Elevate your data analysis with personalized channel groups in Looker Studio. Want to know more contact us now ! 📩 sales@analyticsliv.com 🌐 www.analyticsliv.com #dataanalytics #lookerstudio #customchannels #googleanalytics #analysis

Heard of REGEX or Regular expressions but have no idea what they are or why you would even need them? If so I invite you to spend a couple minutes in this quick video as I demystify REGEX and show you WHY its a great tool to have in your toolbox. So check the comments for the link and give it a whirl!! Tommy #Data #Excel #ExcelTips #PersonalDevelopment

Sharing some incredibly useful cheat sheets that have significantly enhanced my data manipulation and visualization skills using R's tidyverse package by DataCamp. These resources are perfect for beginners and experienced users alike, providing quick references for essential functions and techniques. Take your data skills to the next level with these handy guides. Download them and keep them by your side for your next data project! #DataScience #RStats #Tidyverse #DataAnalysis #DataVisualization #LearningResources #ProfessionalDevelopment