Ask and discuss

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?

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.   

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’:  

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! 📈🙌

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 👀  

 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

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 

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. 

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” 

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.

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?’:   

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

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!

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

Hi! Just wondering about when google will turn off access to the old UA/GA API? 

What's one thing you wish somebody told you when you started your career in marketing analytics?

Hi! Crafting your own Looker Studio dashboards is super fun, but sometimes it is easier to rely on a good report template to start reporting on your data fast. Supermetrics offers a wide variety of free report templates for Looker Studio in our template gallery. Which report template is your favourite? What kind of template would you like us to publish next? Comment down below!

Hi everyone, reaching out with the looming knowledge of the deprecation of third party cookies happening soon. What is Supermetrics doing in relation to conversion APIs to combat that?

You can use more than 30 charts in Looker Studio. But which type of chart will tell your story the best? 🤔 Choosing the wrong chart can confuse or even lead viewers to the wrong interpretation of the data. We’ll help you nail the art of data visualization.Instead of thinking about the type of chart, we recommend asking yourself what you need to see. For example, do you want to compare values, show an evolution, or show targets?Here’s a selection process that we recommend to follow:Define your precise question → What columns could answer the question? Select relevant metrics and dimensions → Inspect your data and check our documentation, if needed. Create a story → What is the date range? What is the data granularity? Decide if you need multiple angles for a complete answer → Do you need a subset of columns for a chart? Pick the one that fits best.Keep this process in mind, and you’ll nail the art of data visualization! 🎨 

After Geraldin’s visit to CDMX, we’d love to see more events catering to Spanish speaking customers. Even a webinar would be very welcome!  

Given the growing accessibility of marketing data, it’s easy to get overwhelmed by all the available metrics. We recommend choosing the KPIs you want to track based on the decisions you want to make:  Strategic KPIsThese set the long-term direction of your marketing strategy, deciding on aspects like the marketing mix, budget allocation, positioning, and messaging. 🤔 For example, how should we allocate the budget this year? Customer lifetime value (CLV), Customer acquisition cost (CAC), Brand mentions/brand sentiment, Customer retention rate. Operational KPIsThese ensure marketing activities run smoothly and efficiently. 🤔 For example, what affects the sudden drop in trials? Marketing qualified leads (MQLs), Sales qualified leads (SQLs), Brand visibility. Optimization KPIsThese are the small, ongoing decisions your marketing team needs to make about the best way to get the most out of each of your marketing tactics. 🤔 For example, should we change the color of the CTA button on our

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

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.