Skip to main content

Data visualization

Share your best tips and tricks about data visualization, and ask the community for help. Discuss Looker Studio and PowerBI related topics.

  • 35 Topics
  • 48 Replies
35 Topics
nikeul
nikeulNewbie
asked in Data visualization
Shopify connector - get sold products by product tag

Hi,i want to get the total sum of sold products having a certain product tag. I am realy struggling wwiwth getting this to work. In shopify itselfe it is a super easy thing, but somehow the google looker studio ↔ supermetrics connector is struggling wiwth this request since i am not getting it to work. would there be any help?

281
Sahra
Mariia
MariiaCommunity Moderator
posted in Data visualization
Channel mix dashboard template

While pulling data from single channels into your dashboard helps you to stay on top of one channel performance, the real power of your Supermetrics license comes with reporting data from multiple channels.Here's a paid channel mix dashboard template that will help you evaluate your allocation of marketing resources across different channels and understand the best possible mix of channels to maximize your return on investment (ROI).   Get the paid channel mix reporting template » With this template, you’ll have:A side-by-side comparison of the overall performance of each channel during a specific period.  Traffic volume, conversion rates, cost per acquisition, and/or return on ad spend for each channel.  Campaign performance per channel.Happy reporting! 😊

1585
Kathy
geeky_analyst
geeky_analystNewbie
asked in Data visualization
How to Add Facebook Ads Image in PowerBI using Supermetrics Storage or Supermetrics to PowerBI?

How to show Ad Creative in PowerBI?I know that this is a no brainer if we are talking about Supermetrics to Looker Studio but Supermetrics Storage or SM to PowerBI it’s kinda annoying.URL signature expiredwill be send if you input the Creative/Thumbnail URL to your browser.Anyone resolve this issue?

1555
Milja
EdY
EdYNewbie
asked in Data visualization
question Campaign delivery

How can I access or calculate the 'Campaign Delivery' metric for Facebook Ads in Supermetrics?

222
Sahra
duncan_teeps
duncan_teepsNewbie
asked in Data visualization
Gather Facebook Comments and its informations

Hello,I was wondering if it is possible to gather the comments of an ad through the Supermetrics API. Specifically, I would like to retrieve the content, its ID, and perhaps its parent ID. Currently, we are only able to get the number of comments.Is there any way to achieve this? If not, is it planned to be added in the future?I couldn’t find the relevant field in the documentation here: https://supermetrics.com/docs/integration-facebook-ads-fields/#fieldThank you very much.

801
gcfmineo
N
NassratNewbie
asked in Data visualization
Facebook insights Video views, 15s and 60s views

 Hi everyone,I am trying to have the same metrics and chart as it is on Facebook insights using Facebook connector. When trying to bring same metrics to the chart, it returns the error “Can't fetch the post_video_views_60s_excludes_shorter metric, when splitting by video-level dimensions” When asked the support team, they said the 15 and 60s are post level metrics but the total video view is something called “dynamic” metric that can work as page and post level. I can not understand the responses. Anyone found similar issue? Any help?  

751
jessiebrock
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

951
Milja
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

261
Kathy
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!

802
maryan
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

401
michaelkloet
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

2170
Lee
dataviz
datavizSupermetrics Team
published in Data visualization
The Looker Studio Toolkit Webinar Recording

Too many cooks spoil the broth — this applies when too many authors work on dashboards. However, proven methods exist for creating consistent data reports across an organization.Many organizations use Looker Studio to create data reports because the dashboard tool is easily accessible and simple to use. But, when a large team of editors works on different reports without established design standards, the result can be inconsistent reports with varying color palettes, drastically different layouts, and other discrepancies.To solve this, Supermetrics has developed the Looker Studio Toolkit, a basic style-guide helping you to create consistent reports. It sets basic standards that cover everything from typography, color schemes, and layouts to pre-made visualizations.Our toolkit is freely available and primarily intended as a source of inspiration. It’s been tailored to the default templates of our Looker Studio connectors and is also used in several workshops and webinars.While every org

610
dataviz
dataviz
datavizSupermetrics Team
published in Data visualization
Creating a centralized Looker Studio dashboard for chart styles

One of the most useful functions in Looker Studio is called "Paste styles only." This function is a real-time saver, allowing you to copy any chart and paste all styling information into a chart of the same type.Pasting styles into a chart saves time and ensures coherent styling.Style coherence across an organizationLooker Studio doesn't provide a centralized tool to achieve coherent styling across multiple reports. Each report has its theme settings, and each chart has its styling information. At Supermetrics, we created a Looker Studio styling repository for each report series we maintain. This repository—called the Toolkit—contains sample configurations of each chart type used in these reports.Keeping a repository of styled charts is the basis for organization-wide coherent report styling.Whenever someone inserts a new chart into a report, they can simply copy a chart from the repository and paste the styling information into the newly created chart.  

490
dataviz
dataviz
datavizSupermetrics Team
published in Data visualization
Sharing resources across many Looker Studio reports

Data reports sometimes require a page containing contextual information, such as resource links or background details on how the data was collected. Often, you may want to include the same information in multiple reports.The issue arises when the information is contained in multiple reports and an update is required. You would need to track down all reports containing the information and update each individually. In this scenario, embedding a report page from another Looker Studio report can be a suitable solution.Our new series of connector templates includes a page called "Getting Started," which links to many resources that apply to all our connectors. Almost all the information on this page is managed in a separate Looker Studio report and then embedded using the technique described in this help article.It's possible to place additional elements on top of the embedded information. We do this with some links that change for each report. You may notice that these elements load faster

401
majorkooms
dataviz
datavizSupermetrics Team
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

670
dataviz
dataviz
datavizSupermetrics Team
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

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

2072
EpicLarrySE
dataviz
datavizSupermetrics Team
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

3402
dataviz
dataviz
datavizSupermetrics Team
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

5880
dataviz
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!

1133
Kathy
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? 

734
dataviz
dataviz
datavizSupermetrics Team
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

15550
dataviz
dataviz
datavizSupermetrics Team
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. 

754
dataviz
dataviz
datavizSupermetrics Team
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

6022
nitinvarghese
CraigIsAlwaysLearning
CraigIsAlwaysLearningNewbie
asked in Data visualization
Transforming/Blending data for Looker Studio - visualisation speed load times

Supermetrics community,A couple of years ago using Supermetrics and Looker Studio, I have always preferred transforming/blending data in Google Sheets before importing to Looker Studio to improve the load times of Looker Studio visualisations.As it’s been a couple of years since I’ve used Supermetrics, and just jumping back in, does anyone have best practice guidelines, or their own processes, to have fast load times in Looker Studio? I used to find the native connectors slow to load, especially if blending was involved.Thanks in advance,Craig

512
CraigIsAlwaysLearning
Terms & ConditionsCookie settings