Ask and discuss

 We’ve got a six-way tie for the best APAC SuperSummit 2025 takeaway, and we need your vote to crown the winner! ⚔️🔹 Haven’t voted yet? Scroll through these epic insights and throw a like (❤️) on your favorite!🔹 Already voted? Tag a teammate to weigh in, every vote counts!The $200 gift card is this close to finding its owner—help us break the tie!👉 Voting closes 8th of July 2025, act fast!(P.S. Still haven’t shared your own takeaway? Jump in, it’s not too late!)

 We want to hear your data transformation stories! In our recent webinar, we shared how to use custom fields and data blending, but now we want to learn from you. Share your favorite use cases for custom fields or data blending in the comments below 👇 Tell us:What problem does it solve? What data sources you blend? Or what custom field you created?  What's the outcome?Not using the data transformations yet? Share your ideas for how you would use them. We'll award the most upvoted response with $/€50 Amazon gift card 🎁✨ ⏳ The challenge ends on June 17, 2025. Let's learn from each other! ❤️

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! 

Hi Supermetrics team,I am in the process of making a payment for the Start Price Package with Supermetrics. With the Starter Price Package, we would like to add 5 ad accounts/media sources.Does Supermetrics limit the number of report refreshes per month?Thank you,

 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

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 everyone!I’m relatively new to SEM—my background has been more focused on social (both organic and paid)—and I’d love some help navigating a current project.I was asked to include auction insights in a recurring report, and while I’ve managed to find metrics like impression share using keyword text as a dimension, I’m stuck on how to include the Display URL domain like we see in the Google Ads UI.From what I understand, this data is only available for selected keywords—and usually through the Google Ads interface—but I’m wondering if anyone here has found a way to pull this info using Supermetrics (whether via Google Sheets, Data Studio, or another connector)? I’d love to either automate or semi-automate this process, rather than manually exporting from the UI every time.If anyone has tackled this or has a creative workaround, I’d really appreciate your advice. Thanks so much!

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?

hi everyone,i’m struggling to find a metrics from Facebook called “Profile Visit”, it’s not available when i tried to pull report from Supermetrics’ extension. Can anyone let me know how to pull this specific metric?Many thanks,Tommy

Hi everyone,Hope you’re well. I’m working with some clients on Amazon Ads. I connected my Amazon Ads account to Supermetrics to retrieve data and send it to Big Query.My issue is the following : I have a duplication of accounts for my clients with 16-digits ID. It seems to be for each marketplace, but there is no way to identify which ID corresponds to which marketplace. Moreover, when I try to make some previews to find the right account, the query dysfunctions.Anyone had a similar issue ? Found a solution ? Thanks ! 

I am running into a problem where Facebook Ads and Google Sheets (via Supermetrics) aren’t matching up. I have created Custom Conversions in Facebook Ads. Once they have been Activated, I was able to use them as a metric in Supermetrics for Google Sheets. I have since created more of them in Facebook Ads (they are active), but I am not seeing them appear in my Supermetrics side panel. I have re-connected the Facebooks Data Source via the Hub, but I am not seeing any changes in what Custom Conversions are available for me to select. Any help/advice would be appreciated. Happy to share more information as needed as well.Thanks!

Hi, We are trying to use Facebook Ads connector to Looker Studiowhen the campaign objective is OUTCOME_SALES then the reach value will always be zero? how to solve this?  

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

Hoping to hear from some others (especially other agencies) about the benefits of switching to data warehousing for reporting. What improvements have you seen? Was the initial lift easier/harder than expected? Please share your experiences! 

Hello everyone,I’m hoping someone will be able to help me. We pay for the Growth account, which allows us to connect 8 accounts to our Google Sheets. However, when I went to use one a few days ago, I received a note saying that I could not get data because it was not one of our prioritized accounts.When I reached out to support, they told me that you can only have 2 prioritized accounts, but I can’t find anywhere to set this. Also, why are we paying for 8 accounts if we can only use 2? It seems a little redundant.Additionally, we have 3 people on our team, and none of us seem to have access to set a priority account. I’m getting a little lost as to what I can do now since support takes a whole day to tell me that we only have 2 prioritized accounts. But if you can only have 2, what’s the point of going above the basic plan?I need help pretty urgently now and can’t really wait another day for support to tell me that I can have 8 accounts but can’t use them.

I have an issue in all of my reports where I use Facebook ads. I've been using them for months and 2 days ago they all went broke with the same error. Facebook error: User may not have permissions to access account act_336487693. But I can't loose access to all ad acounts at once. I checked that and re-authorized all but nothing works.When I try to edit query and choose ad account I see this message: Invalid appsecret_proof provided in the API argument. What should I do? I can't switch connection in every report.Thanks for the help!

Hi everyone,I’m working with large datasets pulled from Supermetrics, and I’m facing challenges when it comes to processing them efficiently. The datasets are growing, and it's starting to strain my current AI computer setup. I’m wondering what the best AI computing setups are for handling such massive datasets.To give some context, I need a system that can:Handle complex data processing and analysis Scale as the dataset grows Integrate well with AI frameworks (like TensorFlow or PyTorch) Be cost-effectiveWhat hardware and cloud-based solutions do you recommend for this kind of workload? Are there specific GPUs, CPUs, or cloud services that work best for large-scale data analysis?Any insights or recommendations would be greatly appreciated!Thanks! 

“The search result is "Hello, I want to use this to update the data of FB advertising background [FB AD] in real time, but I am worried that my account will be banned. Will this happen?" (translation)搜索结果为“你好，我想用这个来实时更新FB广告后台【FB AD】的数据，但是我担心我的账号会被封禁，请问会这样吗？” 

Dear community, As a performance agency, we manage ppc campaigns for lead gen for clients in real estate. Our dashboards (in Looker Studio) use a variety of single data sources (via Supermetrics) and one extensive datablend blending GA4 with all ad platforms (Google Ads, Meta Ads, Microsoft Ads and others).  We use one very important custom dimension ‘Project’. This is a string extracted from the following dimensions with a Regex:GA4: Property name Meta Ads: Campaign name Google Ads: Campaign name Microsoft Ads: Campaign name LinkedIn Ads: Campaign nameUpon blending and visualizing data, all seems to work like a charm. Until… we use a data filter based on this ‘Project’ dimension.The individual scorecards displaying ‘Impressions’ and ‘Clicks’ (as well as derivatives like CPM, CPC) fail to display and result in an error.The weird thing is, in non-scorecard visualizations, there seems to be no issue to report the impressions and clicks metrics grouped by ‘Project’. Upon contacting Superm