Tips and tricks

Hi everyone! I wanted to share one of my favourite marketing data solutions: Data Quality Monitoring!And it’s because I'm always the person in the room asking what's the processes, what's everyones role, whose documenting these and so on. I love structure and processes. So I love this solution for two reasons:📊 First being that most often people only think to use their data to report how campaigns are performing and forget that the data can be used to monitor the data.🔎 Second is that it can minimize the human errors significantly. No matter how much we automate or utilize AI there will always be some element of the process that remains susceptible for errors. In the example dashboard you can see tracking of misnamed campaigns and URL’s. But it could be UTM’s or something else which role is to make sure your data remains quality 💎! Since we all know garbage data leads to garbage insights!So I wrote a whole blog post about how to monitor and improve your marketing data quality to our

 Welcome aboard, marketing analytics gurus! 🎉 We're thrilled to launch our very first Supermetrics Community Challenge. Our Community Challenges are a chance for us all to dive into the exciting world of marketing analytics in a fun way.  The rules of the first Challenge are simple: In the replies to this post, share your favorite marketing analytics trick you wish you knew sooner. “Like” the replies of other Community members that resonate with you the most. We'll award 2 participants with a special gift box worth $200: one for the most upvoted response and one for the response chosen by the Supermetrics Team 🎁✨ ⏳ The challenge ends on June 30, 2024.  Our example of the trick: when analyzing the performance of different ad creatives in Google Sheets, use the formula =IMAGE("URL"), where the URL is the public web address of that image. It'll add an image of the ad to your report and make it more descriptive 🤩 Here’s our short demo video.  Can't wait to see your answers!  P.S. Commen

I’m looking for some inspiration, would anyone like to share an example of their favorite dashboard slide(s) or graphs? Something that really helps tell a story, or a cool solve to a problem you had? A creative layout or information you found to be useful to share? Thanks!

Have you ever wondered about the additional features Looker Studio Pro offers compared to the standard version? The differences between the two products have been a poorly explored grey area for a long time.This week, Looker Studio released new training material that dives deep into features exclusive to the Pro version, including workspaces, report scheduling, and security topics.You can access the training materials hereGoogle Cloud Skills Boost: Looker Studio Pro 5 hours of video material on workspaces, report scheduling and security As Looker Studio shifts more focus to the Pro version in the coming months, more resources will likely become available.Happy learning! 

Hey guys, first question in the community, so I hope I'm putting it in the right place. 👀 We are trying to display a product-specific conversion value and the corresponding conversion number from a META ad campaign in Looker Studio. We are able to do this for the overall conversion value and the total number of conversions for the campaign. However, we are advertising product A, for example, and only want to receive the conversion value and the number of conversions from the sales of product A. The values are displayed in the META ad manager with the help of the corresponding custom conversion. Which parameter/filter can we use to display these values in Looker Studio? The product we use is Supermetrics for Looker Studio, so we don’t use Google Sheets in between. Many thanks in advance for any tips, tricks or anything else that could help us. 😀 Cheers,Lukas

Hi Supermetrics Community! 👋Ever struggled with campaign names that make your reporting a nightmare? I know the feeling, which is why I recently wrote an article about smart campaign naming conventions to help marketers like us streamline our data analysis.In the article, I cover:✨ Structuring campaign names hierarchically for clarity✨ Key-value pair vs. delimiter-based naming methods✨ How to integrate naming conventions with UTM parametersI also included:✔️ A free campaign naming template✔️ A quick tutorial to help you implement itOne challenge I faced while writing this was striking the right balance between granularity and simplicity—especially at the ad group level. Ultimately, I chose a method that worked for me, but naming conventions are never one-size-fits-all.💡 Now, I want to hear from YOU!How do you approach naming campaigns and ad groups? Do you prefer key-value pair methods for flexibility or delimiter-based ones for simplicity? What’s your biggest challenge (or success)

💡 Insert image creatives into Google Sheets reports to make your reports more descriptive.  Use cases:Ad creative analysis and reports Social media content analysis and reports Website image analysisHow to insert an image creative into Google Sheets? 👉 Use the formula =IMAGE("URL"), where the URL is the public web address of that image.See how we used the example of image creatives from Nike’s Instagram account pulling data with Supermetrics Instagram Public Data connector:  

Hello , I was wondering if someone knows how can we compare data with last year same day comparaison instead of just last year ? (really needed for the retail sector)  (e.g Monday 19 August 2024 vs Monday 21 August 2023 instead of the 19/08/24 vs 19/08/23 dafault comparaison window) If seen some stuff online but honestly it wasn’t work on my side ! Thanks for your help :D  Paul T 

Hey Community! 👋I've noticed a lot of great resources online for learning how to get the most out of Supermetrics. To help us all level up our skills, I'm creating a thread to collect the best tutorials, tips, and case studies.Let's start with this helpful YouTube video: This video provides practical advice on structuring reports for paid advertising analysis in Facebook & YouTube Ads.What are your favorite Supermetrics resources? Share your tips, tricks, or favorite tutorials below!

Hey all,  I think I created a funky little function with the help of Supermetrics, to get alerts whenever a 404 response happens on the site (more or less).  How this works is: GA4/GTM: You need to have an event that tracks whenever a user visits a 404 page - you can set this up through GTM or GA4 itself Supermetrics: You pull your 404 data into a sheet thanks to supermetrics Apps Script: Thanks to a script you install an alert whenever a 404 happens (e.g. every day, every 7 days, every month). You receive an automated email in your inbox whenever a 404 has happened in your chosen timeframe.The email looks something like this:   You can find the details on how to set this up, plus the needed code for apps script, here: https://docs.google.com/document/d/1FyaHdzBq2_CMTCU53DT2XBovYoCuyrI8Id5o2YlXB9A/edit#heading=h.kkz9ddaki0go It’s seriously very simple and will help your to stay on top of 404 issues.Be aware of course that if a user doesn’t accept consent, you won’t know when they have

Here’s a quick tip for you. Setting report triggers in Google Sheets is a lifesaver, but you may have queries in your reports that you don’t want to update every time the refresh happens. This is why we have a handy advanced setting called ​​’SKIP_QUERY_REFRESH’. This setting skips the query you don’t want to update but runs the refresh to all other queries.  

It's time to talk about the dynamic duo of digital marketing: SEO (Search Engine Optimization) and PPC (Pay-Per-Click) . While they might seem different, they're actually two sides of the same Google coin, working together to drive traffic and conversions.Here's the thing:Both are triggered by keywords: Whether you're crafting SEO-optimized content or setting up a PPC campaign, keywords are the foundation. Both share a similar look: You'll see clickable headlines, body copy, and site links in both organic and paid search results. Both drive ROI: When done right, both SEO and PPC can deliver significant returns on investment. Both aim to match user intent: The goal is to connect users with relevant results, leading to conversions for your business.But what are the key differences?Paid vs. Organic: PPC is about paying to appear in search results, while SEO focuses on earning a spot through optimized content and technical factors. Speed: PPC delivers faster results, while SEO takes time t

My job at Supermetrics is to help our users build the solutions they want to get when they buy our product. I’ve met hundreds of people with data analytics problems and I regret that I never started a count of how many projects I’ve built either myself or with my team. Those projects often have an interesting story in them. Here’s one that stuck in my memory: A few years ago, a popular international brand got Supermetrics in order to build a centralised data platform for their marketing reporting. As a big international business, they had siloed regional marketing departments that operated under guidance from the HQ but otherwise were making their own decisions when it came to the details of running their marketing. They were setting their campaigns up themselves and were also running their own marketing reporting, sending results back to HQ in dashboards or spreadsheets.You can imagine that this situation was causing friction as HQ had difficulties comparing the performance marketing

Ever encountered sluggish performance or timeouts with your Power BI dashboards? If you haven't, you're among the rare few—such issues are all too common. But here's some good news: if you're using the Power BI Service, there's a streamlined way to publish your models and schedule data refreshes while keeping your connection to Supermetrics intact. Curious about how this can transform your Power BI experience? Read on to discover how you can optimize performance and ensure your dashboards are always up-to-date.  What Are Semantic Models?Semantic models in Power BI provide a structured and user-friendly representation of your data. They serve as a bridge between raw data and end-user reports, allowing users to interact with data through familiar business terms rather than complex database schemas. Typically, these models are created using Power BI Desktop with a data modeling tool like Power BI Dataflows or the Power BI Desktop's data model capabilities.How to Publish Semantic Models to

Hey everyone! 👋We’re planning a new article about Black Friday and eCommerce for the Supermetrics blog, and we need your help!We want to focus on how to use marketing data to boost Black Friday activities. What questions or topics do you think we should cover? Whether it’s data-driven strategies, analytics tips, or anything else related to marketing data for Black Friday, we’d love to hear your thoughts! Your input will help us create valuable content for you. Drop your questions and ideas in the comments.Thanks a ton! 😊

Data is your agency's secret weapon. ⚔️Want to land more clients? Prove your worth? Drive growth? Data is the key.Have a look at our latest blog article 7 ways agencies are using Supermetrics to win and retain clients.How are you using Supermetrics to supercharge your agency? Share your favorite use cases in the comments below! 👇

I was recently asked if it's possible to use Tell Me to gain insight into how certain dimension values compare to the dataset's average.Getting the data right is less a chart problem, but a typical "Level of Detail" or "LOD" case. From my designer perspective, it's one of the hardest things to understand. It took me many hours to learn how to do this in Tableau, and I wondered if it could also be achieved natively in Looker Studio without using BigQuery.The short answer is yes, it's possible. Let's look at the following result:  A very simple insight that compares row-level information with an aggregated value of the complete dataset.How can row-level data be compared with aggregated values of the dataset?The solution isn't trivial, and we need to use a Looker Studio technique called "self-join."A self-join is a data blend where both datasets have the same source. To achieve the desired outcome, we need to create a cross-join, which doesn't require any join conditions.On the left side,

So you’ve created an awesome Google Sheet report for one client. Here’s how to repurpose that for another account easily. 🙌🏻 In the Google Sheets file you want to duplicate, go to Extensions → Supermetrics → Duplicate this file for another account. Select the accounts, pages, and views you want to use in the new duplicated file and its queries. Note: If you used several data sources in the original file, you will be asked to choose the accounts for all those data sources Once you have selected your accounts, click Duplicate the file. Your queries will now be duplicated and refreshed in the newly copied file. Depending on the volume of queries in the original file, this may take a few moments to complete. ...And that’s it.