Skip to main content

Ask and discuss

Ask questions from other community members and share knowledge

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

593
joy.huynh
3 months ago
haynesy
haynesyNewbie
asked in Spreadsheets
Dynamically pulling in values into the "Value" field in google sheet query

I want the value in the ‘Value’ field to be pulled in from a cell in my sheet (e.g. E2) that would contain the Product Title i want to filter from.Is this possible?   

1065
haynesy
3 months ago
dataviz
datavizCommunity Moderator
published in Data visualization
Layout and grid options in Looker Studio

When starting a new Looker Studio dashboard, one of the first things you need to decide on are the foundational elements: layout, grid, and headers. Here's a quick roundup of what to watch out for.Canvas size & navigationFor the navigation, there are two crucial decisions to make:Where do you want to place your navigation? How wide should your report be?It's always easier to create reports on a larger canvas. But will it fit into your users' screens? If you prefer your navigation on the side because you expect your reports to have many pages, the navigation will further reduce the horizontal space available.If you place your navigation on top, your reports can be wider, but you'll fit fewer pages unless you store pages within sections. Sections in Looker Studio are like folders and are a great way to organize dashboards with many reporting pages.We are using the top navigation with a canvas width of 1420px. However, we also considered the side navigation with a canvas of 1180px. Bo

1890
dataviz
3 months ago
hadar
hadarNewbie
asked in Spreadsheets
license issue

hi i saw in my google sheets which conact to supermatrics a messege said my lisence of goggle ads is not valid,but as you can see in the screenshot the lisence is validplease help me understand how to fix it

291
Senni
3 months ago
phdigital
phdigitalNewbie
asked in Spreadsheets
Query to pull month to date compared to same dates a month ago

Hi team, I was wondering if there was a way to modify the query dates to compare the same dates a month ago. There is only an option for same dates a year ago. ie Compare 1-14th Aug 2024 to 1-14 Jul 2024.Thank you!  

682
phdigital
3 months ago
nitinvarghese
nitinvargheseCurious Mind
asked in Ask the Community
Looking for Power Point Slides from the NYC SuperSummit Conference

good morning! I was wondering if anyone knew where I can access the presentation slides from the SuperSummit Conference in NYC back on 6/27? Thank you so much in advance

656
Sahra
3 months ago
Ilkka Sarkio
Ilkka SarkioCommunity Moderator
posted in Trends and hot topics
Community event recording: Looker Studio for marketers panel discussion (14.8.2024)

Thank you all for joining the panel discussion about Looker Studio for marketers!🙌I want to give special shoutouts to our awesome panelists, @arturbensch and @qudeeskiani, both members of Supermetrics affiliate program. I recommend to reach out to them both here in the community, if you want to dive deeper into the topics discussed in the event. In case you missed the event, you can watch the recording here:  Our next community exclusive event continues on the topic of Looker Studio. Our Head of Visualisation and a true Looker Studio guru @Ralph presents you the Looker Studio Toolkit, a UI-style guide for building coherent reports with ease. Sign up here:  

841
Mariia
3 months ago
nitinvarghese
nitinvargheseCurious Mind
asked in Ask the Community
What challenges have SuperMetrics helped you overcome?

What has everyone had a problem with and how was SuperMetrics able to help you? Curious and would love to hear everyone's experiences

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

691
Aurora
3 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.  

120
Isha
3 months ago
Robin_Shukla
Robin_ShuklaNewbie
asked in Data visualization
Issue with Stacking Multiple Columns in Looker Studio Using Supermetrics Connector for Google Ads

Hi everyone,Objective: Stack multiple headline columns (Headline 1 to Headline 15) into a single column in Looker Studio. Challenge: Looker Studio doesn’t natively support this transformation. Data Source: Using the Supermetrics connector for Google Ads, which lacks a built-in feature for stacking columns vertically. Need: A workaround or best practices to achieve this within Looker Studio.Has anyone faced a similar issue or found a solution? Any advice would be greatly appreciated!Thanks in advance!

823
Kathy
3 months ago
Natashafathani
NatashafathaniNewbie
asked in Data visualization
Creating groups in Looker Studio

i want to create a group field in looker studio, but i can’t select ‘the field to group by’ because the list is not showing, can you help me to solve this? 

514
dataviz
3 months ago
phdigital
phdigitalNewbie
asked in Ask the Community
Query to pull all Shopify accounts under Partner account

Hi teamHow do I pull a query for all Shopify accounts under our Shopify Partner account?  When I create a query, it only gives me the option to select an individual account (71 accounts total), but I can’t choose the partner account that all the Shopify accounts sit under.  Like with Google ads, I can choose our MCC email account where all the ad accounts sits under. I want to do the same thing for Shopify. Thank you!

441
xinfu
3 months ago
Mariia
MariiaCommunity Moderator
posted in Trends and hot topics
You’re invited 💌 Sign up for an exclusive panel discussion!

 We’re happy to invite you to a panel discussion: Looker Studio for Marketers.  What? Panel discussion: Looker Studio for MarketersWhen? August 14, 2024, at 10 a.m. EDT | 3 p.m. BSTHow to register? 🔗 Click ATTEND hereWill I get a recording? Yes, by registering in advance. In this session, our panelists @Ilkka Sarkio, @arturbensch and Qudees Tariq Kiani will talk about:The best practices to tailor your Looker Studio dashboard. The tips on how to build actionable dashboards. The Looker Studio hacks we all wish we knew sooner. See you there! 

231
Aurora
3 months ago
gorch
gorchNewbie
asked in Spreadsheets
Trigger refresh from a script in google sheets

It would be very helpful if I could trigger a refresh all of a google sheets query set via a google sheets script. Has anyone found a way to do this? 

853
gorch
3 months ago
Mariia
MariiaCommunity Moderator
posted in Ask the Community
Results of the Supermetrics Community MVPs Competition 🏆

Two weeks ago, we invited you to participate in the Supermetrics Community MVPs Competition by being active and earning points.  During these weeks, we were closely following the leaderboard and now are ready to announce the top 3 Supermetircs Community MVPs. 🥇 The first place goes to @nitinvarghese! You've been an absolute champion, and we're happy to reward you with a $150 gift card. 🥈 The silver medal goes to @gcfmineo! You've been active since the day you joined our Community. We greatly appreciate you, and reward you with a $100 gift card.  🥉 Our third leader is @RickM! Thank you for your active participation in the Community — it means a lot to us. We’ll reward you with a $50 gift card.  We'll contact you all by email soon about the details of rewards. Everyone who climbed the MVPs leaderboard, don’t worry — your points accumulate. So keep earning them and get an advantage in the next MVP competition 😉 

362
Mariia
3 months ago
Mariia
MariiaCommunity Moderator
posted in Ask the Community
Earn points and win big 🏆 Supermetrics Community MVPs Competition is on 🔥 (ended)

 As a young Community, we value your active participation. Your knowledge, questions, and feedback help us create a supportive and insightful environment.  Thus, we're excited to launch the Supermetrics Community MVPs Competition 🏆 Every action you take in the Community earns you points! Whether that’s from creating new discussion topics or providing helpful answers to questions, you’ll climb our MVPs leaderboard for the chance to win gift cards. The leaderboard is always visible, either on the right-hand side of the Community's main page or here, so you can follow the results in real-time 🍿 But let's get to the point. How do you earn the points?Create a new topic / Ask the Community = 20 points  Reply to a question post = 15 points  Reply to any kind of post = 10 points  Receive a like = 5 points  Give a like = 1 point  Overall, the more active you are in the Community, the more points you'll rack up and the higher you’ll climb on the leaderboard! The top 3 winners on the leaderboar

1945
nitinvarghese
3 months ago
dataviz
datavizCommunity Moderator
published in Data visualization
Creating groups and histograms with Looker Studio

Looker Studio has added two new calculated field types in the past month: groups and bins. These features make it easy to group dimension values into larger categories or bin values to create histograms. In a recent article, I covered how to use the graphical UI to create bins. Let's also take a quick look at how to create groups.Creating GroupsWhen creating a new field of type "group," you must choose a dimension field and define each group. The options are similar to filters. You can create groups by inclusion or exclusion and use different selection types, such as regular expressions or a new option called "In," which lets you manually select the dimension values.Tip: Country groups can be created using the "In" option A workaround for previously aggregated dataThe article could end here, but there are cases where it isn’t possible to use the graphical interface to create bins. Common use cases involve data from GA4 connectors, where many metrics are pre-aggregated. For example, the

7080
dataviz
3 months ago
tomek_chwaja
tomek_chwajaNewbie
asked in Ask the Community
Facebook and instagram insights data

Hi!I am struggling with adding the following metrics from Facebook Insights page to my Power BI report based on SuperMetrics data: Content Interactions (Facebook); 3 second video plays (Facebook); Content Interactions (Instagram).Are you able to help me? I am eaither not able to find these metrics or the metrics are not in line with Facebook Insights page.

812
Milja
3 months ago
Marvin
MarvinNewbie
asked in Ask the Community
Help Needed. Creatives won't show ( Google Ad Manager)

Does anyone know how to have creative images show in Looker Studio? -I’v tried these two method and I can’t get it to work. The images don’t show on the tablehttps://help.funnel.io/en/articles/5102984-how-to-show-ad-images-creatives-in-looker-studio

583
Aurora
3 months ago
Aurora
AuroraCommunity Moderator
posted in Trends and hot topics
Connector of the Month: HubSpot

We’re back again with another “Connector of the Month” and this time it’s……. HubSpot!🤖 HubSpot has revolutionized marketing by offering a unified platform for CRM, marketing automation, sales, and customer service. Unlock the full potential of your HubSpot data with our powerful data source connector. With this connector, you can:Centralize all key metrics: pull and analyze different data, such as contacts, leads, amount won, and email engagement from multiple HubSpot accounts in one single view Visualize your full funnel: combine HubSpot data with those from other marketing channels to understand which campaigns are bringing the most leads and the ROI of your overall marketing activities Uncover insights seamlessly: create complex and interactive client-facing dashboards that drill down data on a granular levelYou can try our HubSpot connector free for 14 days, start today. Just click here to get started.Let me know how it goes!😊

331
Aurora
3 months ago
Mariia
MariiaCommunity Moderator
posted in Trends and hot topics
📚 Helpful resources: GA4

With Universal Analytics now officially retired as of July 1st, many marketers are finding themselves in uncharted territory with GA4.  If you're still getting to know GA4, you're not alone. This new version brings many changes and improvements, but it can initially be overwhelming.  Here are our resources to help you navigate the transition smoothly and make the most out of GA4's powerful features! 📖 Read: ‘Google Analytics 4 guide for marketers: How to set up your properties and make the most of your GA4 data’. 📹 Watch: ‘How to visualize your GA4 data in Looker Studio using user journey visualizations’:  📹 Watch: ‘How to check that your GA4 setup is correct with Online Metrics audit tool’   

140
Mariia
3 months ago
dataviz
datavizCommunity Moderator
published in Data visualization
Workshop recording: The Future of Community Visualizations

I was honored to be invited to hold a workshop in Siavash Kanani's Masterclass series. In this workshop, I'll start with a quick run-through on how to use Supermetrics Charts in your Looker Studio reports. The highlight, however, is the new visualizations now available within a closed beta test group.The recording of this workshop is now available on Zoom.As a member of the Supermetrics Community, you can now get access to these visualizations. Please join the Supermetrics Charts group and read the pinned message, "Welcome to the Supermetrics Charts Beta Group!" which contains another video explaining all the details about the beta phase and how to access the new charts.As I mentioned in the workshop, getting early access is a bit of a treasure hunt, but I think it's worthwhile. 

554
dataviz
4 months ago
evankaeding
evankaedingSupermetrics Team
posted in Trends and hot topics
The Future of the Cookie 🍪

Google announced last week that it will not proceed with deprecating third party cookies, a stark reversal from its messaging around the topic for the past four years. In a blog post authored by Anthony Chavez, a VP at Google in charge of Privacy Sandbox, the following quote summarizes their position:“[W]e are proposing an updated approach that elevates user choice. Instead of deprecating third-party cookies, we would introduce a new experience in Chrome that lets people make an informed choice that applies across their web browsing, and they’d be able to adjust that choice at any time. We're discussing this new path with regulators, and will engage with the industry as we roll this out.”There’s a lot to unpack. Let’s rewind and take a look back at how we got here. What are third-party cookies used for? Cookies are small pieces of information stored in your browser to personalize your web browsing experience. First-party cookies are set by the domain of the site you’re visiting, while

1430
evankaeding
4 months ago
Aurora
AuroraCommunity Moderator
posted in Trends and hot topics
Connector of the Month: GA4

 Say hello to our connector of the month for June: GA4! To no surprise to anyone, Google Analytics 4 is the most popular web analytics tool out there. The tool allows its users to track website events and analyze how the website is converting visitors. The Supermetrics GA4 connector allows you to export data for further analysis and report multiple properties simultaneously in one report and in a reporting tool of your choice. We’ve put together some useful resources around the topic in our Google Analytics 4 knowledge center: Find everything you need about GA4 migration, including blog posts, video tutorials, and support articles.And don’t forget to try our GA4 connector!

391
nitinvarghese
4 months ago
Terms & ConditionsCookie settings