Ask the Community

I have a Hubspot account connection that is reporting significantly different numbers in Power BI (through SM connector) from what I’m seeing in the Hubspot UI. Sends and delivers are the same for these emails, but unique opens and clicks are not. According to HS, they process bot traffic before the API, so it shouldn’t be reflecting bot opens (I’m assuming this includes iOS mail apps, but HS hasn’t outright confirmed that). The other idea I have is that the metrics are being aggregated daily and unique clicks by day might include a returning user - but altering the query to just return a single row per campaign (rather than events for each date) shows the same wrong numbers. When performing this same adjustment in the Hubspot API explorer, it works fine. For reference, one of these emails shows 1,138 unique opens and 311 unique clicks in Hubspot itself. By contrast, Supermetrics is reading 2,591 opens and 388 clicks (when date is an added dimension) or 2,075

In Meta's interface, when I add multiple Custom Conversions to a campaign, I can see the total conversions, but I'm unable to find a way to break down the performance by each individual Custom Conversion event in the reporting view (similar to how Google Ads handles it with the conversion type dimension). Does any know how this can be achieved? 

Hi alli have some problem with Youtube Data that i need the pull out the published date and time. when i used “ Published Time” ,it seems like a schedule date and time when i click to published the content so i need the exact date and time that post was posted already not schedule time.Please help meThanks

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 i

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 e

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? 

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