Skip to main content

Spreadsheets

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

  • 18 Topics
  • 27 Replies
18 Topics
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!

2
Sonja Kukkula
22 hours 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

1
michaelkloet
1 day 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

1
jessiebrock
5 days 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

3
jessiebrock
29 days 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?

1
Sonja Kukkula
1 month 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?   

5
haynesy
1 month 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

1
Senni
1 month 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!  

2
phdigital
1 month 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? 

3
gorch
2 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:👉

2
nitinvarghese
2 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.

4
CraigIsAlwaysLearning
2 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?

0
Kathy
3 months 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?

0
Senni
3 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.   

1
Jonathan Lane
3 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! 📈🙌

0
Edward
3 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 👀  

0
Aleks
3 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.

1
bartschneider
3 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

0
AnssiRusi
4 months ago
Terms & ConditionsCookie settings