Ask and discuss

I swear I had this working, and now all of a sudden now I can’t get it to work.I have google ads for video, display, and search. How do I pull a query for only Search etc? I did the network type (with and without search partners) and tried “contains” or “matches regex” etc and can’t get the query to pull. It will just keep giving me an error  

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

Hi fellow data crunchers,I believe we are not the only team that misses Universal Analytics, with its filter options and views that made reporting easier. A very common issue we are facing is that we work with a team that manages only a certain vertical of their organisation (certain countries, sub-domains etc.) and we want to pull data for only this vertical from GA4. The option we have right now is to add an extra dimension to the data transfers in Supermetrics then filter the relevant vertical in Big Query to show performance on only that.This makes the data crazy fragmented and in some cases cardinality issues could arise. Any of you have similar issues that a filter for transfers could solve? 

Hi,I’m wanting to query for asset_group_asset in Google Sheets. Is there a way to do this today, or any plan to add this capability? More info here: https://developers.google.com/google-ads/api/performance-max/reporting#asset_performancety

Same themes this year, different order It’s easy to get distracted by the extravagance of the Cannes Lions Festival of Creativity: rooftop terraces, yacht parties, chilled rosé and private dinners add to the sensationalism that has made it a legendary event in the industry. However, those who have been up and down the Croisette a few times realize that these are simply distractions from what’s really happening.Evan Kaeding and Lauri Putkinen at the Google BeachAt Cannes Lions this year, three themes dominated the conversations: AI, CTV, and the evolution of Retail Media into Commerce Media. From Meta's bold claims about AI-powered creative workflows to the shifting landscape of TV consumption and the expansion of commerce-driven advertising beyond traditional retail, it was clear that these areas are rapidly transforming the industry. This recap dives into the key takeaways from each of these pivotal discussions, highlighting how brands are navigating and innovating within this dynamic

We hope you had a chance to join us for the APAC SuperSummit 2025 😍We would like to invite you to take part in our Community Challenge for a chance to win a fabulous gift box.How to take part in the Challenge?In the replies to this post, share your biggest takeaway from any of the APAC SuperSummit 2025 sessions. Mention which session it was. Give likes for the takeaways shared by other Community members that you find insightful.The person who shares the most upvoted takeaway will be awarded a gift card worth $200.

 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! ❤️

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.