Skip to main content

Ask and discuss

Ask questions from other community members and share knowledge

177 Topics
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.

903
KristinaRauch
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

200
nitinsnow
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

160
nitinsnow
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

640
dataviz
bartschneider
bartschneiderSupermetrics Team
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

240
bartschneider
bfhost
bfhostNewbie
asked in Spreadsheets
Facebook reels in FB insights

Hi, I am struggling with getting data to Facebook insights, especially, I am missing reels data. I got all other post types, like photos, etc, no problem there, but the query simply does not provide me with reels data.Could anyone give me a hint how to get it there, please?My dimensions: Post ID, date, post image url, post message, video image url, post typeMy metrics: Total reach, Paid reach, Organic reach, Viral reach, Total impressions, Paid impressions, Organic impressions, Viral impressions, Total video views, Likes on post, Shares on post, Comments on post, Likes on post shares, Shares on post shares, Comments on post shares, Reels reach, Reels plays, Reels avg. time watched, Reels comments, Reels total reactions

2623
jessiebrock
nitinsnow
nitinsnowSupermetrics Team
posted in Trends and hot topics
Let's start our "Marketing Mix Modelling (MMM)" journey!

Let's start our "Marketing Mix Modelling (MMM)" journey! My name is Nitin Patkar, and I have around 10 years of work experience around data and analytics.As a Senior Solutions Engineer with #Supermetrics, my role often revolves around bridging the gap between data, technology, and business outcomes. One of the most powerful applications I've seen in recent years is the use of predictive analytics in Marketing Mix Modeling (MMM). The goal is to help companies optimize their marketing investments by giving them the tools and guidance needed to implement data-driven solutions. However, not every organization has the internal expertise or data science resources to build such solutions in-house. Fortunately, specialized vendors like Seeda.io and Mutinex—both of whom have strong relationships with Supermetrics—can provide a more accessible path to MMM for businesses without dedicated analytics teams.In this guide, I’ll outline how companies can implement MMM by either leveraging Supermetrics

2200
nitinsnow
dcaraker
dcarakerSupermetrics Team
published in Storage solutions
Marketing Data Warehouse Mastery: A Guide in Slides

We recently hosted a webinar on Marketing Data Warehouse Mastery with our own Solutions Engineers, Zach Bricker and Jack Bitcon. Check out the slides to learn more!Drowning in data but struggling to turn it into actionable insights? Go through these slides to learn how a marketing data warehouse can revolutionize your data management and optimization.Learn the signs of data struggles and their impact on marketing performance, supported by a real-life case study and visuals. Discover key steps in choosing the right data warehouse and how to simplify data management. Explore how to transform and data blending capabilities enhance data functionality, illustrated by another case study and visuals.Whether you're a seasoned marketer or just starting out, these webinar slides provides actionable steps to elevate your agency's performance and deliver measurable results. Don't miss this chance to master analytics consolidation and propel your business to success.Additional Resources:Data Blendi

950
dcaraker
kristina.knut
kristina.knutSupermetrics Team
posted in Ask the Community
Poll 🚀 Tell us more about you and how you see Supermetrics (2/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... 

180
kristina.knut
Outi
OutiSupermetrics Team
posted in Trends and hot topics
🍂 Fall is coming and with it Black Friday - is it panic time? 🔥

I shared some tips on how to prepare for Black Friday and reduce the panic in our Supermetrics blog. Go check out the full content, but shortly  my highlights from the list are:decide if you want / need to participate start planning now Measure, measure, measure Automate reporting, alerts and everything you can But what are your tips for surviving peak season? Read the full blog here: https://supermetrics.com/blog/black-friday-ecommerce

150
Outi
dataviz
datavizCommunity Moderator
published in Data visualization
Choosing the right colors for your Looker Studio dashboard

Choosing the right colors for your reports might be the most challenging part of setting up your Looker Studio dashboard. This article gives a basic guide through the color jungle of data visualization.In data visualization, we differentiate between three categories of colors:UI colors Categorical colors Diverging colors UI colorsThe user interface colors define all elements that don't have a direct relationship with the data. They include your corporate colors for logos or headlines, boxes or layout elements, and colors for labels, annotations, and axes. We suggest keeping these colors as subtle as possible, giving more room for your report's visualizations.UI colors define the colors used in all dashboard elements. Categorical colorsThese are the colors you want to use for your charts. The first color is the most important because it will be used in almost all charts. Often, you'll use bar charts with a single color or line charts with a single color. All other colors will be used wh

2980
dataviz
Gagan
GaganNewbie
asked in Spreadsheets
Issues with Facebook connection

How to connect to Facebook public from google sheets? what to enter in Facebook page aliases/IDs?

441
Sonja Kukkula
Aurora
AuroraCommunity Moderator
posted in Trends and hot topics
Do we have any ecommerce marketers here?

Hey! 👋 Just wanted to check in and see if we have any ecommerce marketers here among us? 👀 We are currently planning a webinar for you, and I wanted to see if there are some really specific pain points that you are struggling with when it comes to peak season.Comment below your biggest challenges before, during and after peak season👇 And I promise to invite you to our upcoming webinar where we will go through some do’s and don’ts for peak season…😉

210
Aurora
kristina.knut
kristina.knutSupermetrics Team
posted in Ask the Community
Poll 🚀 Tell us more about you and how you see Supermetrics (1/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. So, I’ll be popping in over the next weeks to ask you a few questions in the form of polls (also, feel free to tell us why in the thread below!)So, let’s get this started…Your feedback is incredibly valuable to us as it helps us refine our messaging and ensure we’re meeting your needs 🤗

240
kristina.knut
EpicLarrySE
EpicLarrySESupermetrics Team
posted in Data visualization
Adding Image URLs to Your Analysis

Integrating Facebook Ads Image URLs into Looker Studio with SupermetricsIntegrating your Facebook Ads image URLs into Looker Studio (formerly Google Data Studio) can provide valuable insights into your ad performance through a visual dashboard. Incorporating ad creatives into your reporting is extremely useful for:Ad Creative Performance Analysis Campaign Reporting A/B Testing Visualization Creative Strategy DevelopmentWhile some BI tools can import these relatively easily and pull the images with them, others require a bit more effort. In this post, we will focus on one of the more popular BI tools, Looker Studio, and use Facebook Ads as the data source. However, this technique can be applied to any digital media data source that has Image URLs as a dimension.Step 1: Connect Facebook Ads to Looker Studio with SupermetricsSince Looker Studio does not have a native Facebook Ads connector, you'll need a third-party service like Supermetrics. You can either use the Supermetrics connector

1602
EpicLarrySE
EpicLarrySE
EpicLarrySESupermetrics Team
posted in Tips and tricks
Supercharging your Power BI Dashboards using Published Semantic Models on Supermetrics

Ever encountered sluggish performance or timeouts with your Power BI dashboards? If you haven't, you're among the rare few—such issues are all too common. But here's some good news: if you're using the Power BI Service, there's a streamlined way to publish your models and schedule data refreshes while keeping your connection to Supermetrics intact. Curious about how this can transform your Power BI experience? Read on to discover how you can optimize performance and ensure your dashboards are always up-to-date.  What Are Semantic Models?Semantic models in Power BI provide a structured and user-friendly representation of your data. They serve as a bridge between raw data and end-user reports, allowing users to interact with data through familiar business terms rather than complex database schemas. Typically, these models are created using Power BI Desktop with a data modeling tool like Power BI Dataflows or the Power BI Desktop's data model capabilities.How to Publish Semantic Models to

680
EpicLarrySE
dataviz
datavizCommunity Moderator
published in Data visualization
Using the right typography in Looker Studio

Choosing the right typeface for reports in Looker Studio isn't very difficult. Only a few fonts available can be used to display numbers in tables: Lato, Roboto, and Open Sans.All three typefaces have a few things in common: they're highly readable sans-serif fonts, even in small sizes. Most importantly, their numbers are monospaced, meaning all numbers will vertically align perfectly in a table.We chose Lato over Roboto and Open Sans because "Lato" is the Polish word for "summer". We all love summer at Supermetrics.Tip: Make sure your numbers are well-aligned when used in a table. Not all typefaces use monospaced numbers. To ensure consistent usage of font faces and sizes, we recommend creating a page that lists the different headlines, sub-headlines, and labels or axes in your reports. In Looker Studio, you can also determine the line height. You may use a custom value for bigger text blocks to create a more airy look.It is always a good idea to document the choices of type face, siz

2412
dataviz
Mariia
MariiaCommunity Moderator
posted in Trends and hot topics
🤩 Share a marketing campaign that stood out for you and win a gift card 🎁 (ended)

 Inspiration is the fuel that drives innovation 🚀  That’s why we’re excited to announce the next Supermetrics Community Challenge, where we invite you to share a recent marketing campaign that stood out for you and tell us what you liked about it.  Here’s how to take part in this challenge:In the replies to this post, share the marketing campaign that impressed you. Visuals and links are welcome!  Explain what made it stand out for you.  Engage with other Community members’ posts by liking and commenting. We'll award 2 participants with a $/€ 100 Amazon gift card: One for the most upvoted response and one for the response chosen by the Supermetrics Team 🎁✨ ⏳ This challenge ends on August 26, 2024. Let’s inspire and be inspired!  

69810
Mariia
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! 😊

703
joy.huynh
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?   

1455
haynesy
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

3780
dataviz
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

341
Senni
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!  

842
phdigital
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

836
Sahra
Ilkka Sarkio
Ilkka SarkioSupermetrics Team
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:  

981
Mariia
Terms & ConditionsCookie settings