Ask and discuss

Ask questions from other community members and share knowledge

39 Topics

Kathy
KathySupermetrics Team
posted in Trends and hot topics

As you transitioned to GA4, have you kept using Universal Analytics metrics such as bounce rate?

Now, with just a few days left before the Universal Analytics API deprecation, I am wondering how everyone dealt with the GA4 transition in their reporting. Did you keep using bounce rate, or did you switch to looking at engagement rate and engaged sessions?This has been a tricky line to navigate while re-creating our old Universal Analytics templates with GA4. Do we keep the metrics just as they were in Universal Analytics? Do we use a mix of both the old and the new metrics? Or do we embrace the change and use the new GA4 metrics exclusively?I'm curious to hear your thoughts.

0
Kathy
2 days ago
superuser
superuserNewbie
asked in Ask the Community

Moz 403 Error

Anybody else getting a 403 error when trying to create a new Moz query in Google Sheets? I’m wondering if it’s related to their recent API updates.

1
auroraho
2 days ago
Senni
SenniCommunity Moderator
posted in Ask the Community

How do you use the Shopify connector, and what brings you the most value (vs. Shopify native reporting)?

Hey,I'm calling out for help here 👋🏼We’re seeing that the Shopify connector is trending amongst our Supermetrics customers, but I have a feeling that we’re not doing a great job in enabling our customers on use-cases and best practises with this connector. Could you help me understand the value of this connector a bit better?What are the most important use-cases with the Shopify connector? What are things that you can do with the connector vs. in the native platform? How do you use this connector together with other connectors, such as Google Ads, Meta and Klaviyo? Is there anything else that we should take into account when planning for enabling materials?We’re planning to build an e-commerce specific onboarding path for our customers, and your insights will help us to do a better job! 

2
Senni
3 days ago
Edward
EdwardSupermetrics Team
posted in Ask the Community

What kind of marketing decisions do you make?

Marketers typically make 4 types of decisions…1. Tactical decisionsFrequently made decisions using low volumes of data. Things like campaign budget allocation, keyword targeting, or reach and frequency monitoring to optimize ROI.2. Optimization decisionsLess-frequently made decisions using low volumes of data. Things like A/B testing, CRO experimentation, or on-page SEO performance.3. Operational decisionsFrequently made decisions using high volumes of data. Things like outlier detection, inventory based advertising, or internal historical benchmarking.4. Strategic decisionsLess-frequently made decisions using high volumes of data. Things like audience segmentation, demand forecasting, and annual budget allocation.For the first two types of decisions, you need on-demand data that is accessible in raw format. This is typically low data volumes in a spreadsheet or dashboard.For the second two types of decisions, you need centralized data for longer-term historical and seasonal analysis.

0
Edward
3 days ago
evankaeding
evankaedingSupermetrics Team
posted in Trends and hot topics

Supermetrics 2024 Cannes Recap 🌴

Last week, I had the privilege of attending one of the most revered events in the advertising industry: the Cannes Lions International Festival of Creativity. Generally known as just “Cannes”, this tentpole event brings over 20,000 industry professionals to the sunny south of France every June to celebrate great works of advertising.  What is Cannes? This trip was a personal milestone for me for several reasons. I first became aware of Cannes when I started at Wieden + Kennedy just six years ago. Walking the hallowed halls of W+K filled with portraits of iconic creative leaders, I quickly picked up on the prestige emanating from the discussions surrounding Cannes. To me as a data analyst, it was an exclusive event reserved for our executives, the business development team and any of the creative teams fortunate enough to have their hard work earn a coveted nomination for a Cannes Lion award.  As I’ve grown in my career, I’ve learned that, for many in the industry, Cannes is a polarizin

0
evankaeding
4 days ago
Edward
EdwardSupermetrics Team
posted in Trends and hot topics

Does "the marketing funnel" exist anymore?

Is it still a useful measurement framework or is this the end of the marketing funnel?We’ve been discussing this a lot lately.Marketers have used the funnel to simplify the buying journey and measure marketing effectiveness at each step as prospects got closer to a purchase.But the buying journey is messy. It’s not linear. And they vary wildly from one customer to another.I’d love to know, what do you think? Is it still a useful measurement framework/metaphor or is time to use something else?

5
bartschneider
4 days ago
bartschneider
bartschneiderSupermetrics Team
posted in Trends and hot topics

Any dbt users here?

This is meant as an open question to maybe get some knowledge exchange going on the topic of dbt and Supermetrics working together.In my team, we have been using dbt for around 3 years now to write data models and schedule update job runs on data warehouses which we are building for our services clients. It quickly became one of my favourite data tools that I genuinely enjoy using 90% of the time (10% not, when I’m frustrated about the UI freaking out).The other week I’ve used Google’s Dataform for the first time and got some ‘we have dbt at home’ vibes from it, although it has pretty good feature parity with dbt.Is anyone here also using one of these? If so, what’s your approach in case you’re using it on top of Supermetrics data? Should we look into publishing dbt model templates and recipes that leverage either custom queries or our standard table groups?

4
gcfmineo
5 days ago
Senni
SenniCommunity Moderator
posted in Spreadsheets

Using Google Sheets for budget pacing

Google Sheets is one of the most versatile tools for quick and easy analysis for any marketer. Do you use it for budget pacing? 👀Our team recently ran a Masterclass on budget pacing. This session combines some of the best Sheets built-in functionalities with automating data refreshes using the Supermetrics connectors.📹 Watch the Budget Pacing MasterclassHow do you do budget pacing?

0
Senni
5 days ago
Asif
AsifNewbie
asked in Spreadsheets

Shopify Conversion summary

Hi Data Friends, Does anyone know if we can pull Shopify conversion summary data into google sheets? I want to see how many sessions in took some one to convert. Please see screenshot.   

1
Jonathan Lane
9 days ago
Mariia
MariiaCommunity Moderator
posted in Tips and tricks

Share your best marketing analytics trick and get a chance to win! 🏆 🎉

 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

17
metricsmark
10 days ago
Mariia
MariiaCommunity Moderator
posted in Data visualization

Data visualization resources 💡

Sure, marketing data is important — but how you present your data is what makes it shine! ✨Whether you’re presenting data to internal stakeholders, analyzing it to aid decision-making, or even communicating data to your customers — what’s important is presenting it in a manner that’s easy to digest and understand.Here’s a roundup of our best data visualization resources to help you really tell the story of your data! 📖 Read: ‘How to build an ecommerce dashboard in Google Data Studio’.  📖 Read: ‘Data visualization for marketers: 6 steps to present data visually’.   📹 Watch: ‘Data visualization in Looker Studio: Better dashboards with Supermetrics Charts’:  

4
dataviz
10 days ago
Edward
EdwardSupermetrics Team
posted in Spreadsheets

"The b@stard with the spreadsheet always wins!" - Rory Sutherland, Ogilvy UK

If that’s the case, what’s your #1 must know spreadsheet tip for marketers?To get the ball rolling, here are 10 (yes 10) Google Sheets tips for marketers from a webinar we did last year...  Can’t wait to hear all your spreadsheet tips! 📈🙌

0
Edward
11 days ago
Aleks
AleksSupermetrics Team
posted in Spreadsheets

Suggested queries in the Google Sheets sidebar

Have you noticed all the cool stuff the Google Sheets team at Supermetrics has been adding to the sidebar?From suggested queries to quick access to reporting templates, the Supermetrics for Google Sheets sidebar has experienced a massive facelift.Check out the video below to see a quick before and after and take it for a spin! Also, let us know kind of suggested queries or other functionality you'd like to have added 👀  

0
Aleks
11 days ago
EpicLarrySE
EpicLarrySESupermetrics Team
posted in Data visualization

Navigating the End of Tableau’s Web Data Connector 2.0: A New Era of Data Integration

 To all my Tableau enthusiasts out there, with the depreciation and eventual end of life for Tableau’s Web Data Connector 2.0 (WDC 2.0), a significant question arises: how will you get data directly into Tableau for analysis now? Let’s take a moment to explore this and consider some future-proof solutions.A Brief HistorySupermetrics effectively leveraged Tableau’s Web Data Connector to facilitate seamless data integration into Tableau Desktop. By generating an endpoint in JSON through the Supermetrics API product, users could simply copy and paste this into Tableau’s WDC, enabling quick data access. However, this method had its limitations, including the lack of cloud deployment capabilities and the need for Tableau Server administrators to perform command line routines.With WDC 2.0 being phased out by 2025, it's crucial to rethink and reconfigure our data workflows.Moving ForwardSo, how will Tableau users adapt to this change? Fortunately, there are robust alternatives that not only m

0
EpicLarrySE
12 days ago
Nicholas
NicholasSupermetrics Team
asked in Ask the Community

Email becoming gtempaccount?

Hi team, why would a log in of name@domain.com become namedomaincom@gtempaccount.com? What would be causing this? How do we go about resolving/reconciling this second account login to our actual name@domain.com team?Many thanks!

1
xinfu
12 days ago
dataviz
datavizCommunity Moderator
published in Data visualization

New Looker Studio feature: Easily create bins

Now and then, Looker Studio sneaks in a new feature before updating the official release notes. The same happened yesterday when a new feature suddenly popped up when one tried to create a new calculated field: "Add bin."If you click this new option in the drop-down menu, you'll see a new interface for easily creating bins.What are bins?Bins in data visualization are like containers that group similar data points, helping to show how data is distributed in a chart, such as a histogram.To create a real-life example, I asked ChatGPT to create a small dataset containing 150 shopping carts with the number of items each cart includes.To visualize such a dataset, you would use a histogram. But before, you would need to "categorize" these numbers. We'd have used CASE statements within a calculated field for this task. Now, we can use a graphical interface.There are two options to create the bins: Equal-sized or custom-sized. Thew new “bin” interface.Once you have created your bins, drop the n

1621
Ilkka Sarkio
13 days ago
dataviz
datavizCommunity Moderator
published in Data visualization

Looker Studio: new options for native tables

Another new feature appeared in Looker Studio. It's now possible to limit the number of items in a table. In addition, it's possible to aggregate the values of all remaining rows into one row called "Others". With these new options, you can create nicer tables. 🤩New options in the data panel for Looker Studio tables 

361
dataviz
17 days 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. 

0
tea.korpi
17 days ago
Isha
IshaSupermetrics Team
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. 

160
Isha
17 days ago
dataviz
datavizCommunity Moderator
published in Data visualization

Learn to choose the right chart with "Practical Charts"

One of the most frequently asked questions about data visualization is, "What chart should I use for...?" Simple answers often fall short, but there's an excellent book that goes much deeper and teaches you to ask the right questions.This book, written by Nick Desbarats, has garnered much attention since its release last year. What sets it apart is its approach to data visualization and charts. Instead of offering simple rules, the book teaches you to carefully consider the message you must convey.Filled with helpful decision charts and packed with great illustrations, this book is full of valuable insights. Rarely have I agreed so much with a book about data visualization. If your day-to-day work involves dashboarding, you should definitely get a copy. A decision guide from the book “Practical Charts” 

110
dataviz
17 days ago
delainamac
delainamacNewbie
asked in Spreadsheets

Facebook organic reach changes?

I recently noticed my organic Facebook page reach dropping for last month, in comparison to previous months. It didn’t make sense, so I re-ran the last 2 years worth of monthly organic reach and all the numbers completely changed from what Supermetrics pulled previously each month.Anyone else notice this? I know there were deprecated metrics on March 14, but this wasn’t one of them.

1
bartschneider
18 days ago
Mariia
MariiaCommunity Moderator
posted in Trends and hot topics

Having a hard time figuring out how to prove the impact of your marketing?

Here are useful resources that help you connect the dots: understand marketing measurement, KPI's, metrics, methods, tools, and how to measure incrementality.  📖 Read: 'Marketing measurement: A guide to KPIs, methods, and tools'. 🎧 Listen: ‘Decoding Incrementality testing: A deep dive into marketing measurement techniques with Olivia Kory’. 📹 Watch: ‘What is marketing data integration?’:   

0
Mariia
18 days ago
Outi
OutiSupermetrics Team
posted in Trends and hot topics

Highlights of WARC Guide to Performance Marketing 2024

WARC released their Guide to Performance Marketing for members in April 2024, and I wanted to share a few relevant highlights from the report on strategic considerations for the future. Have any of you noticed the same trends or struggled with measuring performance marketing effectiveness going forward?💰 Performance accounts for 51% of ad spend Search is diversifying to social platforms like TikTok, which are now used as search tools. Retail media is growing, and its higher ROI is driving this growth. Performance marketing is moving “offline” with programmatic DOOH and Connected TV, for example. 👀 Brands need to start looking beyond short term for efficiency and effectiveness: Adding brand building can improve effectiveness since long-term ROI is 2.5x higher than short-term ROI. For example, campaigns with both reach and performance had 18% greater incremental sales than performance alone. Branding is a way to escape the performance plateau** 📊 Brand’s need multiple approaches

1
Senni
19 days ago
Aleks
AleksSupermetrics Team
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!

0
Aleks
19 days ago
AnssiRusi
AnssiRusiSupermetrics Team
posted in Spreadsheets

What are your top three use cases with Google Sheets?

Hi, I’m curious to learn what are your top three use cases where you use Google Sheets with Supermetrics? How easy do you find it to build these use cases? Any ideas how we could make it better? Thanks, Anssi

0
AnssiRusi
24 days ago
Terms & ConditionsCookie settings