Skip to main content

Spreadsheets

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

  • 20 Topics
  • 30 Replies
20 Topics
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!

190
ExequielDucart
1 month ago
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.

612
foxco
1 month ago
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?

371
I
1 month ago
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!

532
Sonja Kukkula
2 months ago
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

141
michaelkloet
2 months ago
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

241
jessiebrock
2 months ago
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

1923
jessiebrock
3 months ago
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?

391
Sonja Kukkula
3 months ago
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?   

1255
haynesy
4 months ago
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

331
Senni
4 months ago
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!  

772
phdigital
4 months ago
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? 

993
gorch
4 months ago
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:👉

542
nitinvarghese
4 months ago
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.

864
CraigIsAlwaysLearning
5 months ago
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?

140
Kathy
5 months ago
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.   

801
Jonathan Lane
6 months ago
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! 📈🙌

270
Edward
6 months ago
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 👀  

100
Aleks
6 months ago
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.

1471
bartschneider
6 months ago
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

400
AnssiRusi
6 months ago
Terms & ConditionsCookie settings