Skip to main content

Recently active topics

30 Topics
datamgt
datamgtNewbie
asked in Spreadsheets
Supermetrics Query Is Not Pulling All the Data From the GA4 platform.

The number of sessions is just a fraction of what it should be.  I go to the GA4 and see a higher session count for the Paid Search, Organic Search, Unassigned, Direct, Referral and Organic Social category sessions.  The amount in these categories from the SuperMetrics Query into our Google Sheet is underreporting what is in the platform.  I tried 2 different accounts and several refreshes.  We have no filters that are obvious to me.

10
datamgt
2 hours ago
brittany_LH
brittany_LHNewbie
asked in Data visualization
Error extracting email address data from Klaviyo

I’m trying to extract email address data from the Klaviyo connector in Looker Studio, but it keeps failing no matter how few or how many other dimensions/metrics I try. I want to use email address data to blend with other data sources, but without this data from Klaviyo, I can’t do that. I also can’t build a table with the raw data from Klaviyo using the connector either. I initially thought I was just trying too bring in too much data, but now I’m not sure? TIA

151
Kathy
9 hours ago
AnssiRusi
AnssiRusiSupermetrics Team
posted in Trends and hot topics
Invite from the CEO: Welcome to SuperSummit October 24th

Welcome to join our biggest event of the year, SuperSummit on Oct 24th. Our team has been working super hard to provide three hours of marketing insights for you. We've got an incredible lineup of speakers from TikTok, Google, BBC, McCann, and more, ready to share how they're tackling the biggest challenges in marketing and data.This is your chance to level up your marketing strategy for 2025. Why join?Learn from the best in the industry Get actionable insights for your data-driven marketing Connect with a community of like-minded professionalsI’m also having a keynote “Driving growth by embracing messy marketing” with our Chief Product Officer Matt.  Looking forward seeing you all at SuperSummit.  Welcome,Anssi RusiCEO @ Supermetrics Save your spot and join us live by clicking here  

180
AnssiRusi
5 days ago
Aurora
AuroraCommunity Moderator
What's new at Supermetrics in October 2024

What’s new at Supermetrics in October 2024We’re back with another roundup of updates and news.Join SuperSummit and learn what it takes to master your marketing in 2025 and beyondThe SuperSummit is our flagship event, where we gather experts from global brands and agencies to discuss trends, challenges, and innovations in marketing.This year, we're partnering with Google Cloud, TikTok, Meta, BBC, Venture Beyond, McCann, and SnapShot to provide 3-hours of insights into their marketing strategies and playbooks.👉Sign up for free. Introducing Query insights in Google Sheets – A new AI feature to generate insightsWith the query insights feature, you can quickly get AI-generated insights about your data and its performance. You can identify trends and changes and take action based on the insights. 👉Read support article here.Onboarding your new team members using Looker Studio step-by-step modulesIf you have new team members eager to unlock the power of Supermetrics for Looker Studio, we've

2330
Aurora
5 days ago
mnatanasabapathy
mnatanasabapathyNewbie
asked in Ask the Community
AD or creative name for google ads

What is the equivalent dimension for “ad” in google ads platform to supermetrics dimension for google ads connector. I am trying to get the ad or creative name for GDN/Youtube ads in google ads using supermetrics. Please let me know. Thanks.

593
Milja
6 days ago
KarenR
KarenRNewbie
asked in Data visualization
Google Ads - Ad Creative Reporting

Hey there! Has anyone figured out a good way to pull into a Looker Studio chart Google Ads ad creative so the correct ad group with the various images, headline text, etc., pull in under that ad group? Did you break out each Google Ads channel separately (search, YouTube, RDA, etc.)? We run a lot of responsive ads, and would love to build a client-friendly dashboard to show which creative image and text copy performs best by Ad Group on responsive ads. Thanks in advance for your help! Best, Karen

170
KarenR
6 days ago
Aleks
AleksCommunity Moderator
published in Trends and hot topics
Join us at SuperSummit on October 24th, 2024

Hey Supermetrics Community 👋@Jess Gondolfo and I are so excited to be hosting SuperSummit 2024 on October 24th! 🎉 We've got an incredible lineup of speakers from TikTok, Google, BBC, McCann, and more, ready to share how they're tackling the biggest challenges in marketing and data. Click here to sign up and join us live Whether you're a seasoned marketer or just starting your marketing data journey, this is THE event to:Level up your marketing data skills: Learn cutting-edge strategies from industry leaders. Gain valuable insights: Hear how top companies are navigating data fragmentation and maximizing their marketing ROI. Connect with the best: Network with experts, peers, and the Supermetrics team!Check out the agenda below 👇  Save your spot and join us live by clicking here We can't wait to see you there!

432
Mariia
6 days ago
nitinsnow
nitinsnowSupermetrics Team
posted in Trends and hot topics
My Journey of Learning PPC

My Journey of Learning PPCTwenty months ago, I embarked on a journey to master the intricacies of Paid Search (PPC). As a Senior Solutions Engineer, understanding digital marketing use cases, particularly around PPC, became critical to providing relevant solutions to my customers. At first, the world of PPC felt unfamiliar, but as I dove deeper into it, I began to see how search engine behaviour, marketing strategies, and paid advertising connect to help businesses compete for visibility.The First Steps: Understanding Paid SearchPaid search is a digital marketing strategy designed to position your business at the top of search engine results when potential customers are actively searching for relevant products or services. My journey started with Google Ads, the dominant advertising tool globally. It opened my eyes to how paid search campaigns work and the impact they can have on business growth.Search engines, like Google, act as a bridge between questions and answers. Paid search all

190
nitinsnow
7 days ago
maryan
maryanNewbie
asked in Data visualization
Looker Studio | Instagram Insights Not Working

Hey community!Does anyone know why Instagram Insights are showcasing incorrect data in my Looker Studio doc?Ie. For two different time periods (one last year, one this year) data is staying the exact same. In simple terms I am trying to showcase the increase in account followers across two different time periods. Any help would be greatly appreciated thank you!

392
maryan
12 days ago
Aurora
AuroraCommunity Moderator
posted in Trends and hot topics
Connector of the Month: YouTube

Hey y’all! 👋 We’re back to highlight one special connector for October: YouTube. Reach a massive global audience and connect with potential customers on YouTube, the world's most popular video-sharing platform.With our YouTube connector, you can:Create an easy inventory list of your video assets on YouTube and quickly see which content has generated the most engagement. See how your videos’ likes, comments, and account follows have changed over time and if there are any seasonal differences. Combine data with your other social and paid media channels to see the performance of your campaigns.And if you only tried the previous version of the connector, we’ve made some new updates. 💡 Here's what's new with the connector:The new connector is faster in loading and fetching data The UI has been improved, and the new connector makes it easier for account selection The new connector reduces errors in creating invalid field combinationsYou can try the YouTube connector here. Let me know what

160
Aurora
13 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!

433
Senni
13 days ago
6clickz
6clickzNewbie
asked in Spreadsheets
Facebook ads connection error in all recurring reports

I have an issue in all of my reports where I use Facebook ads. I've been using them for months and 2 days ago they all went broke with the same error. Facebook error: User may not have permissions to access account act_336487693. But I can't loose access to all ad acounts at once. I checked that and re-authorized all but nothing works.When I try to edit query and choose ad account I see this message: Invalid appsecret_proof provided in the API argument. What should I do? I can't switch connection in every report.Thanks for the help!

302
Sonja Kukkula
14 days ago
ppcbuilders
ppcbuildersNewbie
asked in Spreadsheets
"Insert to"

I’d like to insert multiple query results in the same tab.  But I cannot find what “google Gemini” indicates is the option that does that - INSERT TO - as in INSERT the query results into THIS data range

101
michaelkloet
14 days ago
irina.pozniakova
irina.pozniakovaCommunity Moderator
Platform update: user permissions and role managementNews

We’re excited to share an update to our platform’s user access management! This will give you more control over who has edit access to features like transfers and transformations, making it easier to avoid accidental changes.Key changesTwo new default roles on the platform:A view-only role: Users can access and view shared resources but cannot modify them. When assigning this role, you can ensure that only authorized team members can make changes to transfers, blends, and custom fields.Finance role: Users can manage financial data, billing, and licenses. This role allows users to handle these tasks securely without using an additional license seat. Users with finance roles do not get access to other platform features.Revamped Team pageWe’ve refreshed the team management interface to make it easier for administrators to view, understand, and manage user roles.A new permissions table has been added, clearly outlining the access levels associated with each role.Why it mattersThese updates

110
irina.pozniakova
15 days ago
msacco
msaccoNewbie
asked in Data visualization
Calculate Days Difference in Date Range

In a Looker Studio Dashbaord I want to just count the number of days in a selected Date Range.  I’ve seen threads to use DATE_DIFF(MAX(Day),MIN(Day)) Not working. any suggestions appreciated

131
michaelkloet
15 days ago
Mick
MickSupermetrics Team
posted in Data transformations
Early access to data blending features and more in the Data Management group!

Are you reporting cross-channel attribution? If so, our latest update to data blending will make your life easier.Today, Supermetrics supports blending similar sources like paid media channels using union operations. But we know how tricky it can be to include conversion data from platforms like Google Analytics or Shopify. That’s why we’re introducing join operations—so you can get conversion data from platforms such as Google Analytics 4, Shopify, and Salesforce.Join the data management group to learn more and get early access to the feature.

100
Mick
19 days ago
Mick
MickSupermetrics Team
posted in Data Management
Join operations in data blending Beta access

Today, Supermetrics’ data blending works great for bringing together similar sources, like paid media channels, using union operations. But things get trickier when you want to include conversion data from platforms like Google Analytics or Shopify. That’s why we’re working on a major update to data blending!With the new join operations, you’ll be able to seamlessly combine data from Google Analytics 4, Shopify, Salesforce, and your marketing campaigns. This means richer insights, like tracking conversion attribution across all your platforms.Reporting use case example: Last-click-attribution report with blended Facebook, Google Ads, and TikTok Ads data joined with Google Analytics conversions on Campaign name.We’re now looking for beta testers to test Join operations while in early access. If you’re interested in getting early access to the feature and helping us improve it, let us know in the comments section below.

190
Mick
19 days ago
tharlim
tharlimNewbie
asked in Spreadsheets
Profile Visit metrics missing

hi everyone,i’m struggling to find a metrics from Facebook called “Profile Visit”, it’s not available when i tried to pull report from Supermetrics’ extension. Can anyone let me know how to pull this specific metric?Many thanks,Tommy

181
jessiebrock
19 days ago
Trevor
TrevorNewbie
asked in Ask the Community
Facebook Insights Organic Reach and Impressions showing 0

I know there are a lot of Facebook changes. I’m no where near caught up on them. The big one I noticed for my reports is that Organic Reach and Organic Impressions have been showing as 0’s for me. I reconnected the Facebook Insights connector and saw a lot of the changes.Organic Reach Organic Reach of Posts Organic Impressions Organic Impressions of PostsThese are all 0s for me. Is this true for everyone? All I find via Google Search is that Facebook’s organic reach is trending down across the board - but nothing that says we should have 0. 

421
jessiebrock
19 days 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... 

251
phil_data_2024
21 days ago
Outi
OutiSupermetrics Team
posted in Trends and hot topics
Supermetrics DMEXCO 2024 recap 🇩🇪

DMEXCO 2024 in Cologne showcased the evolving digital marketing landscape, with a strong emphasis on artificial intelligence (AI), the rise of retail media, and the ongoing shift towards a privacy-focused environment. What is DMEXCO?DMEXCO (Digital Marketing Exposition & Conference) is a premier global event uniting marketing, media, and tech professionals, including advertisers, agencies, publishers, and technology providers. The event is divided into key areas: the World of Agencies, World of E-Commerce, World of Media, World of Tech, and a dedicated Start-up area. Each area features exhibition booths, keynote stages, and masterclass sessions, offering diverse learning and networking opportunities. Navigating the DMEXCO Maze:With approximately 180 events across two days, spanning seven main stages and numerous masterclasses and specialized sessions, navigating DMEXCO presented a challenge. The reality is that you need to choose to either:Focus on networking and check out what all

220
Outi
21 days ago
Lee
LeeSupermetrics Team
posted in Data visualization
Looker Studio loading slowly? Here are two options for huge performance gains

You've built the perfect Looker Studio dashboard. It's beautiful, insightful, and … painfully slow. We've all been there. That wait for the data to load is frustrating enough when it’s for yourself, but can be excruciating when you’re presenting to stakeholders.Don’t lose hope, here are two great ways to get your dashboards loading in a flash.  How much faster?  Here’s a quick comparison video: Option 1: The Built-in Looker Studio Extract Data FeatureLooker Studio's built-in "Extract data" option is a quick and easy way to speed things up. It creates a copy of your data source, storing it directly within Looker Studio. This means your dashboard queries a smaller, locally stored dataset instead of hitting the original source platforms every time - and that’s generally where the lag time comes from.Pros:Simple Setup: Easy to use and requires minimal technical knowledge. Free: It's a built-in feature, so no extra cost.Cons:Storage Limitations: You're limited by Extract Data connector’s st

500
Lee
21 days ago
Kenneth
KennethCommunity Moderator
Pipedrive is now available in Early Access!

 Connector alert – Pipedrive is now in Early Access!Fetch CRM data from Pipedrive to optimize marketing campaigns, improve ROI, and accelerate sales.🔍 Analyze sales performance trends to improve your marketing and business strategies.  📊 Optimize marketing budgets by identifying the most effective lead and deal generation channels. 💰 Demonstrate marketing ROI by tracking the full sales funnel and linking marketing investments to leads and closed deals. 🎯 Improve sales pipeline efficiency by identifying and resolving bottlenecks in deal progression.Get started now – authenticate in the Supermetrics Hub and begin reporting! 

190
Kenneth
22 days 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

632
danaditomaso
25 days 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. 

322
michaelmelen
25 days ago
Terms & ConditionsCookie settings