Ask the Community

I’m pulling data into Google Sheets from TikTok using Supermetrics to see data for a brand awareness campaign we’re running. I’ve pulled in every metric in the “Video” section here, except for engaged views: https://docs.supermetrics.com/docs/tiktok-ads-fields#videoSome really high numbers are jumping out at me. For example, for a 6 second video that has only 26,000 impressions so far with a reach of 12,000, the Supermetrics column “Avg watch time per person” is 3759, suggesting the average person has watched this video over 625 times. When I pulled in the column “Average play time per user” into Ads Manager, it gave me a figure of 1.89, which is equal to 11.34 seconds, not 3759.I realise this is listed as an estimated metric, but how can it be so completely different? There are a few instances of this in my report and I’m hesitating to show it to stakeholders at all because it looks so absurd.

We need a Supermetrics pro to architect automated, accurate dashboards for retention marketing. Current setup is manual; goal is fast, trustworthy insight for email and SMS across multiple client stacks.ScopeConnectors: Shopify, Klaviyo, Attentive, Postscript, Emotive (varies by client) Warehouse/BI: your recommendation; we care about reliability and clear modeling Metrics: revenue attribution, list growth, deliverability, AOV, LTV by cohort, opt-in/opt-out, send cadence, SMS compliance indicators Quality: data contracts, backfills, freshness SLAs, anomaly detection, reconciliationDeliverablesBlueprint of pipelines and refresh cadence Metric catalog with definitions and guardrails (no double counting) Exec dashboard (5–7 KPIs) and operator views with drilldowns QA playbook and alertingIdeal fitYou’ve shipped production-grade Supermetrics pipelines for ecommerce, can explain your attribution logic, and prioritize accuracy.

Hello all,Does anybody know (or is there documentation) about the APIs used for the connectors: Facebook Insights and Instagram Insights?I found that Meta offers different APIs to fetch data like Marketing API, Graph API and Insights API.Best regards,Manuel

I’m wondering if there is no Umami connector in Supermetrics. Is there any workaround?

We're looking to optimize our existing or implement new Supermetrics setup and need expert guidance on marketing data best practices. Seeking a consultant with 1-2 weeks availability to help us:Develop comprehensive marketing data integration and pipeline strategies Set up advanced data transformation, blending, and automated reporting frameworks Optimize dashboard creation and cross-platform analytics in preferred visualization tools Implement scalable data management solutions and standardized reporting workflows Train our team on platform best practices and marketing intelligence optimizationExperience with similar Supermetrics implementations and proven marketing analytics expertise preferred.

Hey, Supermetrics Community! 👋 Happy Friday! We're back with a quick reminder about our community survey. Your feedback is incredibly valuable and helps us make this a better, more helpful space for everyone. We've got some exciting things planned, and your input is key to making them a success.If you haven't had a chance to fill out the survey yet, please take a moment to do so. It's a great way to tell us what you love, what you'd like to see more of, and what features you'd like to have.As always, feel free to reach out to me or any of the team members with your thoughts. We're here to help and we're so grateful for each and every one of you.Community Survey Cheers to a great weekend! 🚀  

Things that seem out of place or problematic, sometimes only the user can find the clues or cause of the problem, so reporting what happened can help to resolve the issue faster and more accurately depending on the user's report.

Hey all! I’m having issues with the Reddit Ads Supermetrics Looker Studio connector - I am tracking custom events but can’t seem to find any guides on how to make sure these are getting pulled in my reports. Can someone please help? Thank you!!

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  

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

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

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,

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?  

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! 

I want to pull data from Instagram which is older than 28days. But somehow in google looker studio, the data does not work past the 28 days, when i for example choose a custom range. What might be the issue here?

Hi SM community - happy to submit my first thread here! I’ve created a dashboard on Looker Studio to display :Dimensions: Date, Market (based on page ID) Metrics: Reach, Engagement, ERHowever, it would be interesting to differentiate what goes on regular media campaigns and what is post boosting. Is there a dimension that I’m unaware of that could do this trick? Or any other work-around you may be using? Best,Tomás

Hi everyone,I wanted to share an issue I encountered with duplicate impressions in BigQuery when using Supermetrics to pull data from Google Campaign Manager 360 (CM360) and DV360. After verifying the Supermetrics logs, everything seemed correct, but duplicates still appeared in the final dataset.Has anyone else encountered similar issues? Would love to hear your experiences and solutions!Thanks!

Hi!Do any other agencies have internal Looker Studio reports that show analytics for all dashboards? We’re trying to determine what kind of information we can be measuring to show our progress and the benefits of reporting but I’m not sure what’s available or possible, ideally without much additional manual tracking.An initial idea example was to track load times to see how those improve with different fixes but that doesn’t seem to be possible. We’re brainstorming some other options but any other thoughts, suggestions or ideas are welcome!

Hi,I want to create a dashboard in Google Sheets using Shopify as the data source.I'd like to show the sales evolution of SKU groups in terms of quantities sold, not number of orders. Which metric should I select? I used "item" but I'm not getting the same data as in Shopify.Thank you in advance for your help

I am trying to pull Meta revenue (ie Website Purchase Conversion Value), within a certain time period YoY, but it looks like only the revenue from active/enabled campaigns is been pulled into Google Sheets. There must be a way to get all the revenue from all campaigns within a certain time period. Thank you!

Hello, I am working with one client and he has meta ads connector and it is paid version, successfully fetched the data in Google sheets, no problem at all But do I need to buy another connector if I am connecting Google My Business supermetrics connector to looker studio Because it is showing the message that free version is expired...  The Admin in the supermetrics is SAME person for Meta ads and Google my business connector, no difference in this...  So my question isDo supermetrics charge for each connector? Do they have any packages that includes Meta ads + Google My Business Please help me out

Who's joining us today from the APAC SuperSummit? 👋Share your favorite thing from the summit or a key takeaway with the community!Raise your hand if you joined the session today to earn the SuperSummit badge! 🏆Why join SuperSummit APAC?Learn from industry leaders like Google, LinkedIn, and more Get actionable insights to boost your marketing strategy Connect with a global community of data-driven marketersDon't miss out! tune in on here!  

 At the end of the SuperSummit, we randomly selected 5 lucky attendees who are also members of our Community 😍 Here’s our 5 winners who’ll be awarded with €/$50 gift cards 🎉Matias Priani @MatiasPriani  Camilo Arroyave @Camilo  Ikram Bechari @IkkaPikka  Marnie Powell @Marnie Powell  Beth Chenette @BethC  Thank you for your participation! ❤️We’ll contact you all via email about the gift cards within the next few days. Ps. Make sure to share your main SuperSummit takeaway in this post for another chance to win! 🎉

What is the equivalent dimension for “ad” in google ads platform to supermetrics dimension for google ads connector. I am trying to get the ad or creative name for GDN/Youtube ads in google ads using supermetrics. Please let me know. Thanks.