Skip to main content

Spreadsheets

Share your best Google Sheets and Excel tips, and discuss with other members.

  • 28 Topics
  • 45 Replies
28 Topics
J
julianadefreitasdiasNewbie
asked in Spreadsheets
Filter queries for GA4 - terms and regex

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,

101
Sahra
agustonet
agustonetNewbie
asked in Spreadsheets
Issues with Instagram Insights Reels View

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!

121
Sahra
Matthias
MatthiasNewbie
asked in Spreadsheets
Supermetrics for Excel with PowerQuery

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

30
Matthias
shin_apex
shin_apexNewbie
asked in Spreadsheets
Google Ads: Auction Insights

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!

1954
Sahra
tharlim
tharlimNewbie
asked in Spreadsheets
Profile Visit metrics missing

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

613
jessiebrock
MarkieC
MarkieCNewbie
asked in Spreadsheets
Why connect 8 account when I can only use 2

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.

511
Jamilah
6clickz
6clickzNewbie
asked in Spreadsheets
Facebook ads connection error in all recurring reports

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!

1485
Jeroen
shanshan
shanshanNewbie
asked in Spreadsheets
Will it cause the FB account to be banned?

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

211
Sahra
marketing
marketingNewbie
asked in Spreadsheets
Metrics from query can't generate data from ads manager

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? 

291
Senni
raymond
raymondNewbie
asked in Spreadsheets
Google Sheet - How to check performance by asset group in Performance Max campaigns from Google Ads data sources

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?  

1501
jerocellegingo
ExequielDucart
ExequielDucartNewbie
asked in Spreadsheets
Appsflyer/GoogleSheets - timeout error | Solutions

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!

460
ExequielDucart
datamgt
datamgtNewbie
asked in Spreadsheets
Supermetrics Query Is Not Pulling All the Data From the GA4 platform.

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.

1132
foxco
Senni
SenniSupermetrics Team
posted in Spreadsheets
Using Google Sheets for budget pacing

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?

491
I
ppcbuilders
ppcbuildersNewbie
asked in Spreadsheets
"Insert to"

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

181
michaelkloet
bfhost
bfhostNewbie
asked in Spreadsheets
Facebook reels in FB insights

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

4263
jessiebrock
Gagan
GaganNewbie
asked in Spreadsheets
Issues with Facebook connection

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

581
Sonja Kukkula
haynesy
haynesyNewbie
asked in Spreadsheets
Dynamically pulling in values into the "Value" field in google sheet query

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?   

1685
haynesy
hadar
hadarNewbie
asked in Spreadsheets
license issue

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

451
Senni
phdigital
phdigitalNewbie
asked in Spreadsheets
Query to pull month to date compared to same dates a month ago

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!  

902
phdigital
gorch
gorchNewbie
asked in Spreadsheets
Trigger refresh from a script in google sheets

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? 

1303
gorch
Maryanne Damarzo
Maryanne DamarzoNewbie
posted in Spreadsheets
Spend more time analysing your data, not pulling it from the platforms!

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

622
nitinvarghese
CraigIsAlwaysLearning
CraigIsAlwaysLearningNewbie
asked in Spreadsheets
Show Facebook Post Name by date and engagement metrics

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.

974
CraigIsAlwaysLearning
Kathy
KathySupermetrics Team
posted in Spreadsheets
New GA4 template for Google Sheets - try it out, and let us know what you think!

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?

300
Kathy
Asif
AsifNewbie
asked in Spreadsheets
Shopify Conversion summary

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.   

1241
Jonathan Lane
Edward
EdwardSupermetrics Team
posted in Spreadsheets
"The b@stard with the spreadsheet always wins!" - Rory Sutherland, Ogilvy UK

If that’s the case, what’s your #1 must know spreadsheet tip for marketers?To get the ball rolling, here are 10 (yes 10) Google Sheets tips for marketers from a webinar we did last year...  Can’t wait to hear all your spreadsheet tips! 📈🙌

330
Edward
Terms & ConditionsCookie settings