Skip to main content

Recently active topics

35 Topics
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

2
danaditomaso
1 day ago
michaelmelen
michaelmelenNewbie
asked in Ask the Community
Are community members allowed to post events?

Hey,I noticed an Events section here but I don’t have the ability to post there. Is it open for community members to post their events?We (SmartSites) are hosting an event with Mailchimp (a Supermetrics data source) in NYC on October 16. It’s free to attend: https://www.smartsites.com/loyalty-lab/If allowed, I’d appreciate if an Admin can add this to Events. If not, I apologize; feel free to delete this post. 

2
michaelmelen
1 day ago
kristina.knut
kristina.knutSupermetrics Team
posted in Ask the Community
Poll 🚀 Tell us more about you and how you see Supermetrics (3/5)

Hey everyone! 👋We’re curious to hear your thoughts on how you perceive Supermetrics, what you use it for and what resonates with you the most. This is our next question in a series of polls we have planned… and you’re, of course, welcome to share more of your thoughts in the thread below! So, this week we want to know... 

0
kristina.knut
1 day ago
dataviz
datavizCommunity Moderator
published in Data visualization
The Looker Studio Toolkit Webinar Recording

Too many cooks spoil the broth — this applies when too many authors work on dashboards. However, proven methods exist for creating consistent data reports across an organization.Many organizations use Looker Studio to create data reports because the dashboard tool is easily accessible and simple to use. But, when a large team of editors works on different reports without established design standards, the result can be inconsistent reports with varying color palettes, drastically different layouts, and other discrepancies.To solve this, Supermetrics has developed the Looker Studio Toolkit, a basic style-guide helping you to create consistent reports. It sets basic standards that cover everything from typography, color schemes, and layouts to pre-made visualizations.Our toolkit is freely available and primarily intended as a source of inspiration. It’s been tailored to the default templates of our Looker Studio connectors and is also used in several workshops and webinars.While every org

160
dataviz
2 days ago
hatran
hatranCommunity Moderator
New Data Fields for Your Favorite Data Sources Are Live! 🎉News

Hey Supermetrics Community! 👋 We’re excited to share some awesome updates to our data connectors, bringing you even more granular insights for your reports. These new fields are now available in Google Sheets, Looker Studio, and Excel. Plus, they'll be available in DWH/API next week!Here’s what’s new:📱TikTok Ads (TIK):Total page view content Total page view content value Cost per page view content🎥Google Display & Video 360 (DBM):Client cost (Advertiser)📌Pinterest Ads (PIA):Three second video views✨X Ads (TA):15s video views🛍️Shopify (SHP):Fixed: Total sales metric calculation now includes duties. New fields:Duties Fulfillment date Line item fulfillment dateWe’re constantly working to improve our connectors and give you more flexibility with your data. Let us know how these new fields impact your reporting, and don’t hesitate to reach out if you have any questions!Happy reporting! 📈🙌

10
hatran
2 days 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!

1
Kathy
2 days ago
Jaspreet
JaspreetNewbie
asked in Ask the Community
Can we get the data from Facebook Marketplace using Supermetrics?

We are in process of doing the Rental market analysis and we see that a lot of house rental ads are there on FB marketplace only.While we do have the connector to the Facebook from Supermetrics but we are not able to get a handle to the FB Marketplace data.Any insights or suggestions would be helpful. Thanks.

1
Merenparras
3 days ago
KarenR
KarenRNewbie
asked in Ask the Community
Basis DSP >< SM Connector

Hey there! Does anyone else use Basis DSP and is having issues with the connector? Our primary issue is that SM isn’t pulling in all the data that Basis DSP API is providing; only the very high-level ‘Line’ item level data is available, with Group and Tactic level data completely missing (even though it’s available in the Basis DSP API). Support told me to submit an “Idea” which I’ve done now twice with no update. This is a HUGE missing for us, and wondering if anyone else is experiencing the same thing?

2
Kenneth
3 days ago
Kathy
KathySupermetrics Team
posted in Trends and hot topics
Is Last-Click Attribution Really That Bad? Thoughts on Multi-Channel ROAS + Template

Last-click attribution has a bad reputation, yet many of our customers rely on it for multi-channel reporting. So, I had to ask: if it’s so flawed, why is it still so popular?Marketing is messy. Looking at just the last touchpoint and attributing revenue or conversions solely to that moment doesn’t give us the full picture. But let’s be real—more advanced methods like Marketing Mix Modeling (MMM) aren’t accessible for everyone. And even multi-touch attribution isn’t perfect, especially when privacy limitations make it difficult to track a user’s journey across every interaction.So why last-click? It’s relatively simple to implement. UTM tags, the technology behind it, are reliable. Plus, some data is always better than none. For businesses with short sales cycles, understanding the last touchpoint can be quite insightful for decision-making—as long as you keep in mind that it’s just the final stop, not the whole journey.As your business’s data maturity grows, you can blend insights fro

0
Kathy
3 days ago
Aleks
AleksCommunity Moderator
published in Trends and hot topics
Product Updates: September 2024 recording

Thank you to everyone who joined our second Product Updates session! 🙌Me and JB had a great time discussing the exciting new features and updates we’ve been working on for Supermetrics. We were thrilled to hear all your feedback and ideas during the session.A special shout-out to everyone who expressed interest in joining our beta programs for the newly introduced features. Just like last time, we’ll be reaching out to those who answered the polls in the near future to invite you to join the beta tests 👀In case you missed it, the recording of the session can be found below.We're planning to continue these sessions quarterly, so expect the next update to come around December. We can’t wait to show you what’s next! Thanks for your support, and we’ll see you at the next session!

590
Aleks
9 days ago
dataviz
datavizCommunity Moderator
published in Data visualization
Creating a centralized Looker Studio dashboard for chart styles

One of the most useful functions in Looker Studio is called "Paste styles only." This function is a real-time saver, allowing you to copy any chart and paste all styling information into a chart of the same type.Pasting styles into a chart saves time and ensures coherent styling.Style coherence across an organizationLooker Studio doesn't provide a centralized tool to achieve coherent styling across multiple reports. Each report has its theme settings, and each chart has its styling information. At Supermetrics, we created a Looker Studio styling repository for each report series we maintain. This repository—called the Toolkit—contains sample configurations of each chart type used in these reports.Keeping a repository of styled charts is the basis for organization-wide coherent report styling.Whenever someone inserts a new chart into a report, they can simply copy a chart from the repository and paste the styling information into the newly created chart.  

190
dataviz
9 days ago
Kenneth
KennethCommunity Moderator
CJ Affiliate is now available in Early Access!

 Connector alert – CJ Affiliate is now in Early Access!Unlock the full potential of your CJ Affiliate data and gain actionable insights to optimize your affiliate marketing strategies.💰 Measure the return on investment (ROI) of your affiliate programs: Gain a clear understanding of the financial impact of your CJ Affiliate programs on your business and ensure a healthy return on investment. 🚀 Identify and leverage top-performing publishers: Discover the publishers that drive the highest impact for your business and allocate your resources strategically to maximize results. 📊 Track sales trends to optimize your marketing strategies: Monitor your overall sales trends to optimize your marketing strategies, identify new opportunities, and adapt to changing market dynamics.Get started now – authenticate in the Supermetrics Hub and begin reporting! 

70
Kenneth
9 days ago
tea.korpi
tea.korpiCommunity Moderator
posted in Data transformations
Join Data Management Community Group! 👋🏼

Want to level up your reporting and get more out of our data management features? We’ve got a place just for you! We now have a Data Management Group in the Supermetrics Community where you can learn more and share best practices about:Custom fields Data blending Account taggingAnd here’s the best part—as a group member, you’ll get a chance to test early access features as soon as they are released! Upcoming early access releases include Joins in Data Blending, which allows you to report ROAS easier than before, Data Blending templates, and so much more! 👀Connect with others, swap tips, and get inspired! Join us and be part of the conversation!  

0
tea.korpi
9 days ago
ryanmio
ryanmioNewbie
asked in Ask the Community
New Trade Desk failure: Trade Desk refresh failed because "background import in progress"

“Background report import is in progress. Please try again later. If the problem remains after 24 hours, please contact our support.”

4
jmar
9 days ago
dataviz
datavizCommunity Moderator
published in Data visualization
Sharing resources across many Looker Studio reports

Data reports sometimes require a page containing contextual information, such as resource links or background details on how the data was collected. Often, you may want to include the same information in multiple reports.The issue arises when the information is contained in multiple reports and an update is required. You would need to track down all reports containing the information and update each individually. In this scenario, embedding a report page from another Looker Studio report can be a suitable solution.Our new series of connector templates includes a page called "Getting Started," which links to many resources that apply to all our connectors. Almost all the information on this page is managed in a separate Looker Studio report and then embedded using the technique described in this help article.It's possible to place additional elements on top of the embedded information. We do this with some links that change for each report. You may notice that these elements load faster

251
majorkooms
10 days ago
Aurora
AuroraCommunity Moderator
What's new at Supermetrics in September 2024News

What’s new at Supermetrics in September 2024Welcome back to another Supermetrics roundup. In this September edition, besides product updates, we’re bringing you many exciting new events.Customer case study of the month: PlanetArtPlanetArt is a house of ecommerce brands using a mix of online and offline marketing channels. They wanted to understand their marketing’s true impacts, as relying heavily on last-click attribution gave a false impression that paid search campaigns drove most of their sales. Ryan Hubbard, Senior Business Intelligence Analyst at PlanetArt, built an MMM model, which Supermetrics fuels with advertising data. This has helped them save 20 hours a week and improved ROI and profitability.Want to know how PlanetArt did it? Read the full story! Learn more here.Read the full story.Product updatesHourly alerts in Supermetrics for data warehouseWe've upgraded from daily to hourly alerts, allowing you to address issues faster and minimize their impact on your dashboards. Ad

2485
Aurora
10 days ago
rachaelmarsland
rachaelmarslandSupermetrics Team
posted in Ask the Community
How do YOU manage paid vs. organic data in sheets?

Hey Supermetrics Community! Rachael Marsland - your friendly neighbourhood CSM here coming to ya from Ontario, Canada.  I was chatting with one of my customers today and they asked me if I had any tips for organizing paid vs. organic data in sheets using Supermetrics. I answered to the best of my ability as a non-marketer, but it lead to me to thinking.. if only we had a forum where customers could connect with each other and ask for tips, tricks, and best practices... which finally motivated me to make my first post in hopes this helps my customer &amp; other new Supermetrics users.  So I ask: How do YOU manage &amp; organize paid vs. organic data in sheets?

0
rachaelmarsland
11 days 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.  

0
tea.korpi
11 days ago
Mick
MickSupermetrics Team
posted in Data Management
Welcome to the Data Management community group

Hey everyone! 👋I’m Mick, the Product Manager for Data Management at Supermetrics. Our team is all about looking for ways to make our data management features smoother and more powerful.That means improving the data blending feature, enriching your data in different ways, fixing any pesky anomalies, and finding ways to help you group campaigns and accounts in ways that make sense for your reporting workflows.What can you expect from this group?You’ll be the first one to learn about updates regarding data management First in line to get access to new beta features Share your best practices with others Ask questions from me and the groupI’m glad you joined and helping us build the best data management tools possible!

0
Mick
11 days ago
T
Tom SchooneNewbie
asked in Ask the Community
Creating a relationship between Facebook Ads and Instagram Insights data

Does anyone know if it is possible to create a relation between Instagram posts (likes comments etc. - Instagram Insights) and the ad spend on those posts (promoting for example- Facebook Ad manager). I am looking to create a dashboard where we show engagement (Instagram Insights) and spend (Facebook Ads). However, as far as I know this would require an overlapping dimension in Instagram Insights and Facebook ads in order to create a relationship in PowerBi, preferably done through a unique values post ID. Unfortunately post ID or media ID's are not the same numbers in the two data sources.Would love to hear if others experience the same issue.

3
KristinaRauch
12 days 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

0
nitinsnow
12 days ago
Valter Andersson
Valter AnderssonCommunity Moderator
Simplify your account management with account tagging

Introducing Account Tagging We know that managing numerous accounts across platforms can be challenging. Our latest feature, Account Tagging, has been created to solve this problem. The new feature is available for all Supermerics users. This simple yet powerful feature allows you to choose different data source accounts and group those accounts using different tags to best serve your needs.   What's New? Create dynamic groups using account tagsManage your accounts with ease using our new account tagging feature. This allows you to search, select, and tag accounts to create dynamic groups for easy access and management across Supermetrics products.Use account tags to fetch data from multiple accountsApply your account tags in any Supermetrics product when creating a query or transfer. This streamlines the process, saving you time and effort. Dynamically updating tagsMake changes to account tags centrally in Supermetrics Hub with changes reflecting dynamically across both triggers and t

1655
AnnaV
17 days ago
nitinsnow
nitinsnowSupermetrics Team
posted in Trends and hot topics
Why marketing mix modelling is important

Marketing Mix Modelling (MMM) is incredibly important because it helps marketers understand the true value of their marketing efforts across the entire customer journey. Here's why:1. Beyond Last-Click Attribution:Traditional last-click attribution: This method only gives credit to the final touchpoint before a conversion, ignoring all the other interactions that may have influenced the customer's decision. MMM's holistic view: It considers all touchpoints, from initial awareness to final purchase, providing a more accurate picture of how each channel contributes to conversions.2. Optimizing Marketing Spend:Informed budget allocation: MMM helps you understand which channels are driving the most value, allowing you to allocate your budget more effectively. Identifying underperforming channels: It can reveal channels that may be underperforming or not contributing significantly to conversions, allowing you to adjust your strategy.3. Improved Campaign Performance:Targeted messaging: By un

0
nitinsnow
17 days ago
dataviz
datavizCommunity Moderator
published in Data visualization
Looker Studio's most important theme and report settings

Before adjusting the first charts you add to your Looker Studio dashboard, ensure the theme settings are aligned with your report design. Before publishing the report, go through a checklist of the report settings.Theme SettingsWith the theme settings, you can adjust all default values of charts and other dashboard components, such as text boxes and native navigation elements, including typefaces, colors, and border styles.At first, it might not be obvious what theme setting affects a specific component. For this reason, it's a good exercise to create a basic reporting page that includes text boxes, tables, and a date picker. Then, change the theme settings until you achieve the desired result. Once you have your theme set up correctly, you usually won't need to adjust it again. There isn't a centralized place for settings in Looker Studio. Try to familiarize yourself with all the settings and adjust the theme as soon as possible. Report SettingsValidate all report settings before rele

150
dataviz
18 days ago
bartschneider
bartschneiderCommunity Moderator
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

0
bartschneider
19 days ago
Terms & ConditionsCookie settings