Skip to main content

Spreadsheets

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

  • 25 Topics
  • 40 Replies
25 Topics
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!

323
Sonja Kukkula
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.

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

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

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

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

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

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

892
foxco
Senni
SenniCommunity Moderator
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?

461
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

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

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

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

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

1515
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

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

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

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

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

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

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

1091
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! 📈🙌

320
Edward
Aleks
AleksCommunity Moderator
posted in Spreadsheets
Suggested queries in the Google Sheets sidebar

Have you noticed all the cool stuff the Google Sheets team at Supermetrics has been adding to the sidebar?From suggested queries to quick access to reporting templates, the Supermetrics for Google Sheets sidebar has experienced a massive facelift.Check out the video below to see a quick before and after and take it for a spin! Also, let us know kind of suggested queries or other functionality you'd like to have added 👀  

110
Aleks
delainamac
delainamacNewbie
asked in Spreadsheets
Facebook organic reach changes?

I recently noticed my organic Facebook page reach dropping for last month, in comparison to previous months. It didn’t make sense, so I re-ran the last 2 years worth of monthly organic reach and all the numbers completely changed from what Supermetrics pulled previously each month.Anyone else notice this? I know there were deprecated metrics on March 14, but this wasn’t one of them.

1631
bartschneider
AnssiRusi
AnssiRusiSupermetrics Team
posted in Spreadsheets
What are your top three use cases with Google Sheets?

Hi, I’m curious to learn what are your top three use cases where you use Google Sheets with Supermetrics? How easy do you find it to build these use cases? Any ideas how we could make it better? Thanks, Anssi

430
AnssiRusi
Terms & ConditionsCookie settings