Skip to main content

Tips and tricks

Do you want to know how others are using Supermetrics or other best practises? Join the discussion!

  • 31 Topics
  • 61 Replies
31 Topics
Outi
OutiCommunity Moderator
posted in Tips and tricks
My favourite marketing data solution - Data Quality Monitoring 🔎

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

50
Outi
Mariia
MariiaCommunity Moderator
posted in Tips and tricks
Share your best marketing analytics trick and get a chance to win! 🏆 🎉 (Ended)

 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

126327
Filipe
Isha
IshaCommunity Moderator
published in Tips and tricks
What does it take to turn scattered campaign data into a streamlined, insight-driven engine in just 6 months?
What does it take to turn scattered campaign data into a streamlined, insight-driven engine in just 6 months?Podcast

In this episode of The Marketing Intelligence Show, Martina Karakoleva, Campaign Insights Manager at Philips Healthcare, walks us through:How Philips automated reporting and improved data trust The role naming conventions played in scaling fast Why centralizing data ownership in marketing is a game-changer How the analyst role is evolving with AI and automation What’s next for Philips’ marketing data journeyIf you're working on improving data workflows, reporting automation, or simply want to hear how a global team transformed its analytics stack—this one’s for you.Tune in now: https://supermetrics.com/podcasts/philips-healthcare-data-transformation   Related read: Campaign naming conventions: The key to cleaner and reliable reportingLet us know your favourite takeaway or how you're solving similar challenges in your org! 

20
Isha
Isha
IshaCommunity Moderator
published in Tips and tricks
Turning MMM data into insights
Turning MMM data into insightsPodcast

Marketing Mix Modeling (MMM) used to be slow, complex, and only for the biggest brands. Not anymore.In this episode of the Marketing Intelligence Show, Juha Nuutinen, CEO of Sellforte, chats with Outi Karppanen about how MMM has changed—and why it’s becoming a go-to method for marketers who want to make better, data-informed decisions.Here are a few takeaways:Short-term results aren’t the full story. Focusing only on quick wins can slowly weaken your brand. MMM helps you see both short- and long-term impact. Testing makes MMM better. Running experiments (like geo tests or lift studies) helps validate your MMM results and gives you more confidence in your next move. More dashboards ≠ more clarity. Data is only helpful if it leads to action. MMM brings your results together and shows you what’s actually working—and where to shift your budget. Start small. Learn fast. You don’t need a perfect setup or months of work. Even with just a few key channels, you can start seeing valuable insight

90
Isha
Isha
IshaCommunity Moderator
published in Tips and tricks
How Google measures marketing success: brand, performance & AI
How Google measures marketing success: brand, performance & AIPodcast

Every marketer faces the same challenge: balancing long-term brand building with short-term performance goals. At Google, Siim Säinas, Social Measurement & Insights Manager, is tackling this challenge head-on—using AI, experimentation, and new measurement frameworks to refine marketing effectiveness.Key insights from the episode:Brand vs. performance marketing isn’t a tradeoff—Google aligns them to maximize both short- and long-term growth. Creative testing is evolving—real-time AI analysis can pinpoint the exact moment an ad drives engagement. You don’t need a big budget to measure brand impact—Siim shares how direct traffic and share of search act as reliable proxies. Attention is the new currency in media measurement—why traditional reach metrics are becoming obsolete. AI is changing marketing strategy—from streamlining data analysis to optimizing creative and campaign execution.Siim also highlights why controlled experiments, like exposed vs. control tests, are critical to prov

180
Isha
sarahm
sarahmNewbie
posted in Tips and tricks
Looking for Inspiration

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!

721
camila.tejeiro
dataviz
datavizSupermetrics Team
published in Tips and tricks
New learning material available for Looker Studio Pro

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! 

813
KingMedia
Sahra
SahraCommunity Moderator
published in Tips and tricks
Recap of the "From Garbage In, Garbage Out: Ensuring Data Integrity" Webinar
Recap of the "From Garbage In, Garbage Out: Ensuring Data Integrity" Webinar

 Recap of the "From Garbage In, Garbage Out: Ensuring Data Integrity" Webinar We were delighted to host our exclusive community event "From Garbage In, Garbage Out: Ensuring Data Integrity" on November 14th at 5pm EET.  Key Takeaways:Understanding Data Quality: We delved into what data quality is and the key dimensions that define it. Importance of Data Quality: We explored why maintaining high data quality is crucial for accurate reporting and analysis. Ensuring Data Integrity: Practical examples and methodologies on how to ensure robust data integrity were shared with the attendees.If you missed the live session, don't worry! You can access the recording and the slide deck from the webinar below:See the webinar recording hereYou can find the webinar slides attached below. We appreciate everyone who joined us for the webinar and engaged in the insightful discussions. Stay tuned for our next event on December 5th Product Updates Session and December 10th, when we'll explore how to leve

540
Sahra
L
LukasNewbie
asked in Tips and tricks
Custom Conversion: Display of conversion value and number of conversions for a specific product in Looker Studio

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

2032
L
Milja
MiljaSupermetrics Team
posted in Tips and tricks
Let’s talk campaign naming conventions!

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)

430
Milja
Mariia
MariiaCommunity Moderator
posted in Tips and tricks
Must-know Google Sheets tip for marketers: Add image creatives to your reports 🖼️

💡 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:  

1588
Guandor
Paul Turzynski
Paul TurzynskiNewbie
asked in Tips and tricks
Data comparaison with same day last year on lookerstudio

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 

4558
dataviz
Senni
SenniSupermetrics Team
asked in Tips and tricks
Best resources to get started with Supermetrics?

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!

883
Senni
marouscha_dorenbos
marouscha_dorenbosNewbie
posted in Tips and tricks
Automatic Alerts when a 404 response happens - thanks to SuperMetrics

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

1002
danaditomaso
tea.korpi
tea.korpiSupermetrics Team
posted in Tips and tricks
Skip query refresh

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.  

520
tea.korpi
nitinsnow
nitinsnowSupermetrics Team
posted in Tips and tricks
SEO and PPC - The dynamic duo

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

310
nitinsnow
bartschneider
bartschneiderSupermetrics Team
posted in Tips and tricks
User stories: Unexpected benefits from a DWH project

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

290
bartschneider
EpicLarrySE
EpicLarrySESupermetrics Team
posted in Tips and tricks
Supercharging your Power BI Dashboards using Published Semantic Models on Supermetrics

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

760
EpicLarrySE
heini.lindfors
heini.lindforsSupermetrics Team
asked in Tips and tricks
Help us shape our article: Black Friday eCommerce 🙋

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! 😊

733
joy.huynh
Aurora
AuroraCommunity Moderator
posted in Tips and tricks
7 ways agencies are using Supermetrics to win and retain clients

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! 👇

801
Aurora
Isha
IshaCommunity Moderator
published in Tips and tricks
How do you leverage data to supercharge your video marketing strategy?
How do you leverage data to supercharge your video marketing strategy?Podcast

How do you leverage data to supercharge your video marketing strategy? We just chatted with one of our customers, Sean Whitmore, Director of Digital at SnapShot Interactive, about the latest trends in video marketing. And he shared insights into blending data with creativity and maximizing audience engagement through short-form content strategies. Sean also highlighted the crucial metrics that drive their video campaigns and how they balance creativity with brand safety.This was a fun chat on The Marketing Intelligence Show, and we'd love for you to check it out and share your thoughts. Listen to the full episode here. Or tune in on Spotify below alternatively you can also listen to the episode on Apple Music and Amazon Music.Deep dive to discover how SnapShot Interactive reduced reporting hours by 35% and sees a 3X ROI with Supermetrics in the our case study.  

170
Isha
Isha
IshaCommunity Moderator
published in Tips and tricks
How does PlanetArt use marketing mix modeling (MMM) to optimize their marketing?
How does PlanetArt use marketing mix modeling (MMM) to optimize their marketing?Podcast

 Ever wondered how some companies nail their marketing strategies across multiple channels? In the latest episode of The Marketing Intelligence Show, Ryan Hubbard, Senior Business Intelligence Analyst at PlanetArt, shares some great insights on how their team leverages MMM to refine their marketing strategies.PlanetArt, a diverse e-commerce company, uses MMM to analyze their ad performance across various platforms, including Google Ads, social media, and offline channels like direct mail and podcasts. This approach helps them understand the true impact of their marketing spend, optimize their budget allocation, and enhance customer acquisition.If you’re curious about how to make your marketing efforts more effective through data-driven strategies, you might find this episode incredibly useful. Tune into the full episode here. Or tune in on Spotify below alternatively you can also listen to the episode on Apple Music and Amazon Music.For a deep dive into how PlanetArt reduced reporting

341
nitinvarghese
dataviz
datavizSupermetrics Team
published in Tips and tricks
Using Tell Me to compare dimension values to the average

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,

850
dataviz
Isha
IshaCommunity Moderator
published in Tips and tricks
How important is competitive intelligence in B2B marketing?
How important is competitive intelligence in B2B marketing?Podcast

In the ever-evolving world of B2B marketing, staying ahead of the curve can feel like a constant sprint. We’re all busy crafting killer content, optimizing campaigns, and chasing those leads. But how often do we take a step back and analyze what our competitors are up to?To answer this question, we recently spoke with Trevor Irish, a digital marketing analyst at Vollrath, a leading commercial cookware manufacturer. Where we uncovered how Trevor used the competitive intelligence to:Identify ideal posting frequency Craft high-performing content themes Make informed budget decisionsWe’d love to hear your thoughts on competitive intelligence in B2B marketing! Have you ever used data from competitor analysis to inform your own marketing strategy? Share your experiences in the comments below!P.S. Dive deeper with Trevor and learn how Vollrath uses Supermetrics to win the B2B game in the Marketing Intelligence show podcast episode here!Or tune in on Spotify below alternatively you can also li

230
Isha
tea.korpi
tea.korpiSupermetrics Team
posted in Tips and tricks
Repurpose your Google Sheet reports

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. 

240
tea.korpi
Terms & ConditionsCookie settings