Data visualization

I have 4 US Meta accounts, and I want to combine them into a single data source to call up the total data from these four accounts at the same time. After selecting the 4 Meta accounts via Supermetrics, I found that the spreadsheet cannot read the data, and it shows the prompt: "This query is trying to pull data from 4 views that are not listed as prioritised accounts. To manage your prioritised accounts, follow the link below: https://hub.supermetrics.com/subscriptions/1567269#datasource-FA". I feel confused even when I go to Supermetrics. What should I do?

Hi there, I am having trouble  How do we get the arrow on the actual view, it’s only showing up the edit. See images. Thanks, Nicki

We’re having constant issues with lookerstudio and tiktok connector in supermetrics.  I attached the screenshot from the error.  

How do you pull Organic YouTube impressions vs Paid YouTube impressions at the individual video level? I’m looking to use Supermetrics to accomplish this in Looker

When I enter a 11 months period (example: July 1, 2024 to May 31, 2025), the data for LinkedIn is empty. I know that LinkedIn company pages can only fetch data from within the last 12 months. But this is less. Can someone guide me? Thanks in advance! 

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

Hi! Looking to see if anyone has any examples of exceptional slides for higher edSpecifically examples for funnel slides for higher ed

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?

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

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?

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

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.

 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?  

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

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

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!

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

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

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.  

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

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

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

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

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