Skip to main content

Tips and tricks

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

  • 26 Topics
  • 55 Replies
26 Topics
dataviz
datavizCommunity Moderator
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! 

452
dataviz
15 days ago
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 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

340
Sahra
22 days ago
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

632
L
29 days ago
Milja
MiljaCommunity Moderator
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)

260
Milja
1 month ago
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:  

928
Milja
1 month ago
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

120524
Filipe
1 month ago
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 

1568
dataviz
1 month ago
Senni
SenniCommunity Moderator
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!

653
Senni
2 months ago
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

862
danaditomaso
2 months ago
tea.korpi
tea.korpiCommunity Moderator
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.  

260
tea.korpi
3 months ago
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

180
nitinsnow
3 months ago
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

230
bartschneider
3 months ago
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

660
EpicLarrySE
3 months ago
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! 😊

693
joy.huynh
3 months ago
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! 👇

731
Aurora
4 months ago
Isha
IshaCommunity Moderator
published in Tips and tricks
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.  

150
Isha
4 months ago
Isha
IshaCommunity Moderator
published in Tips and tricks
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

251
nitinvarghese
4 months ago
dataviz
datavizCommunity Moderator
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,

550
dataviz
5 months ago
Isha
IshaCommunity Moderator
published in Tips and tricks
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

190
Isha
5 months ago
tea.korpi
tea.korpiCommunity Moderator
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. 

200
tea.korpi
6 months ago
Isha
IshaCommunity Moderator
published in Tips and tricks
ChatterBlast uncovers the shift to brand awareness & building client trust

ChatterBlast uncovers the shift to brand awareness & building client trust In this episode of The Marketing Intelligence Show, Jessica Gondolfo, Head of US Regional Marketing at Supermetrics, is joined by Joe Mineo, the Associate Director of Ads and Analytics at ChatterBlast – a creative powerhouse of any agency backed up by deep data. Together, they’ll reveal how to leverage data to navigate the evolving marketing landscape.Here's what you'll learn:How to shift gears and build brand awareness with the power of short-form content. How A/B testing unlocks the data to create visuals and messaging that resonate with your target audience. How Supermetrics and BigQuery can help you secure all your historic data. How to empower your clients with data access and avoid vendor lock-in with Supermetrics.Tune in on Spotify below or you can also listen to the episode on Apple Music and Amazon Music. 

220
Isha
6 months ago
Aleks
AleksCommunity Moderator
posted in Tips and tricks
Using custom fields templates in Supermetrics

At Supermetrics, we're on a mission to make marketing data work more accessible to everyone – even more complex tasks like data transformation.Custom fields templates make the transformation features in Supermetrics even easier to use. Check out the short video below to see how 👇 P.S. The first three are based on the most popular transformations in Supermetrics, but let us know if you have a really impactful transformation that you'd like to see templatized!

440
Aleks
6 months ago
Sahra
SahraCommunity Moderator
published in Tips and tricks
How Imajery uses data to prove value across the entire customer journeyPodcast

 How Imajery uses data to prove value across the entire customer journey In this data-packed episode of The Marketing Intelligence Show, Jessica Gondolfo, Head of US Regional Marketing at Supermetrics, is joined by Jay Sala, Founder and CEO, and Sanjay Mayar, VP of Growth, at Imajery. Together, they'll reveal how Imajery uses data to acquire clients and build trust across the entire customer journey.Here's what you'll learn:How to leverage data to make smarter marketing decisions Why client alignment is key to successful campaigns The importance of clear & concise reporting How to use Supermetrics to streamline your marketing dataTune in now!Improve advertising ROI with impact-based attribution (Data Speaks) | TMIS 

180
Sahra
6 months ago
Mariia
MariiaCommunity Moderator
posted in Tips and tricks
Looker Studio tricks that make a difference 💡

Check out 3 easy tricks that’ll make a big difference for your reporting in Looker Studio 👇 Trick # 1. Use conditional formatting. You can use conditional formatting in tables or scorecards. It lets you quickly spot outliers in your data by highlighting them with a specific color. Example use case:  highlight when you’re over or under-pacing your monthly budget. You’ll find conditional formatting under the style panel: Trick #  2. Master report-level components. When you divide your dashboard  into multiple pages by the marketing channel or campaign, it’s important to keep it consistent and aligned with your brand. You should use similar elements on different pages—headlines, colors, or your logo.  The easiest way to manage these branding elements is to set them as report-level components. For example, if you edit the component on one page, it automatically copies the changes to each page. Trick # 3. Connect all your marketing platforms asap.  Connect all your data sources right from

780
Mariia
6 months ago
Mariia
MariiaCommunity Moderator
posted in Tips and tricks
Translate field names in Google Sheets to your local language 💬

Did you know that you can change the language of the fields in your Google Sheets report to the local language?  The report language setting in Supermetrics for Google Sheets translates the field names in your report to any language, making it easy to create a report in the local language.  The report language setting offers translations to 94 languages listed in the ISO 639-1 standard. Learn more about which languages are available. How to change the report language in Google Sheets? Go to the Supermetrics sidebar.  Select Options → select a target language from the Report language drop-down menu.  Note: This setting won't affect the language of the user interface of Google Sheets or the Supermetrics sidebar. Only the field names in the query results are translated into the target language.

220
Mariia
6 months ago
Terms & ConditionsCookie settings