Spreadsheets

Hello,is it possible to run a supermetrics query directly with PowerQuery inside of Excel? It seems I can only return the query results to an Excel sheet but not into PowerQuery. But maybe there is a workaround?Thanks!Matthias

The number of sessions is just a fraction of what it should be.  I go to the GA4 and see a higher session count for the Paid Search, Organic Search, Unassigned, Direct, Referral and Organic Social category sessions.  The amount in these categories from the SuperMetrics Query into our Google Sheet is underreporting what is in the platform.  I tried 2 different accounts and several refreshes.  We have no filters that are obvious to me.

Hi everyone,I’m facing an issue with an AppsFlyer query in Google Sheets that triggers a timeout error (Error: AppsFlyer failure - Data Source Error: Gateway Timeout). This problem has been ongoing for over a month and is specifically affecting certain accounts, while other AppsFlyer accounts work fine without any issues.Despite following the recommendations provided by the support team and trying shorter date ranges, the error persists. Additionally, I was informed about a 90-day limit for event data, but this doesn't seem to apply in my case, as I’m using the segment for other accounts this year up until the current date.The Supermetrics support team is investigating the issue, but I wanted to ask if anyone in the community has experienced this type of error and if they have any additional suggestions or possible solutions to resolve it, as this is a critical function for our work.Any help or recommendations would be greatly appreciated.Thanks in advance!

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 there,I am looking to create a Spreadsheet Pacing document that can track spend for the entire month but get email and SMS notification if there is no spend recorded for previous day - is this possible?I have seen that there is an email notification available, which I am yet to test, however over the weekend I am not checking the pacing document and if there is an urgent issue, can an SMS be received through Supermetrics?Thanks so much!

Hi! Im filtering my data and would like to know how to you use here: Filter________________________IS there a boolean for this?example: “SOURCE OR SELL OR LIKE”________________________ And if I use this regex “contains” or “doenst contains”: do we have some kind of character limits or prohibited? Thanks,

Hello all, Any of you have been experiencing issues when you try to run a query in Instagram Insights for Views and filter by product type REELS? It gives me zero results even if I have thousands of reel interactions and you can see the video has million of video views. Thanks!

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

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.

“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】的数据，但是我担心我的账号会被封禁，请问会这样吗？” 

I don’t know what’s the problem. But, the metrics usually automatically updateas you can see. The data stop continuously generate since 2nd February 2024. any body have the same problem and can solving this? 

When importing metrics for Performance Max campaigns into Google Sheets using dimensions, it works fine with campaign names. However, an error occurs when setting it to asset group names. Is there a way to resolve this issue?  

Google Sheets is one of the most versatile tools for quick and easy analysis for any marketer. Do you use it for budget pacing? 👀Our team recently ran a Masterclass on budget pacing. This session combines some of the best Sheets built-in functionalities with automating data refreshes using the Supermetrics connectors.📹 Watch the Budget Pacing MasterclassHow do you do budget pacing?

I’d like to insert multiple query results in the same tab.  But I cannot find what “google Gemini” indicates is the option that does that - INSERT TO - as in INSERT the query results into THIS data range

Hi, I am struggling with getting data to Facebook insights, especially, I am missing reels data. I got all other post types, like photos, etc, no problem there, but the query simply does not provide me with reels data.Could anyone give me a hint how to get it there, please?My dimensions: Post ID, date, post image url, post message, video image url, post typeMy metrics: Total reach, Paid reach, Organic reach, Viral reach, Total impressions, Paid impressions, Organic impressions, Viral impressions, Total video views, Likes on post, Shares on post, Comments on post, Likes on post shares, Shares on post shares, Comments on post shares, Reels reach, Reels plays, Reels avg. time watched, Reels comments, Reels total reactions

How to connect to Facebook public from google sheets? what to enter in Facebook page aliases/IDs?

I want the value in the ‘Value’ field to be pulled in from a cell in my sheet (e.g. E2) that would contain the Product Title i want to filter from.Is this possible?   

hi i saw in my google sheets which conact to supermatrics a messege said my lisence of goggle ads is not valid,but as you can see in the screenshot the lisence is validplease help me understand how to fix it

Hi team, I was wondering if there was a way to modify the query dates to compare the same dates a month ago. There is only an option for same dates a year ago. ie Compare 1-14th Aug 2024 to 1-14 Jul 2024.Thank you!  

It would be very helpful if I could trigger a refresh all of a google sheets query set via a google sheets script. Has anyone found a way to do this? 

Spend more time analysing your data, not pulling it from the platforms!I’ve created a video here to show you exactly how I collate daily data automatically. If you’re like me, managing multiple social media platforms,you know how insightful but time-consuming manual reporting can be.Let me show you how you can use Supermetrics to do this for you..it’s a game-changer!Easily see:video views,profile views,engagement,likes,comments,shares,new followers,and current followers.👉 Use the data to analyse which content performs best and why so you can adjust your future content strategy.👉 Adjust the settings so you have new updated data daily.👉 Enable email notifications for any query failures to ensure your data is always up-to-date.I believe that social media managers shouldn’t spend hours pulling data,—they should spend their time analysing it to gain actionable insights.With automatic updates,you always have the latest data at your fingertips,allowing you to focus on what matters most:👉

Hey Supermetrics community,I’m trying to import a daily breakdown of Facebook & InstagramAccount name Post date Organic reach Organic impressionsThe aim is to blend this data with GA4 to understand what posts did and did not drive traffic to our website. Unfortunately, this query loads no data. If I remove post date and account name, then the query shows the daily breakdown for organic reach/impressions.Any ideas as to what I am doing wrong? Thanks in advance.

This week, we launched a new Supermetrics for GA4 template that includes tips and tricks on how to use Supermetrics. It is perfect for anyone who wants to see clear examples of how Supermetrics for Google Sheets is used in practice and learn about useful features. On the template, you’ll find:Hints about the Supermetrics features used Clear color coding to differentiate queries from formulas The AI Summary feature, which provides practical strategies from your data to drive growth and success An instructions page with lots of relevant contentThe template should work well for anyone who is just getting started with GA4 and Supermetrics, but we're are also keen in hearing feedback from more advanced Supermetrics users. Is this something you could imagine using for your organisation?

Hi Data Friends, Does anyone know if we can pull Shopify conversion summary data into google sheets? I want to see how many sessions in took some one to convert. Please see screenshot.