Will GA spreadsheet add on support G4?

[Donna Johnson]

Does anyone have the latest info on whether or not, the GA spreadsheet add on will support move to G4? Saw this fairly recent post that it will not support G4 metrics and am hoping it is not accurate:
https://stackoverflow.com/questions/73085235/google-sheets-is-not-compatible-with-ga4-only-with-universal-analytics

[Matt Landers]

Currently, it does not support GA4, but we are working on a new version of the add-on. I don't have a timeline for that just yet, but if you sign up for the Google Analytics Developer Newsletter, you'll get notified when it is ready.

On Wed, Sep 28, 2022 at 8:15 AM Donna Johnson <johnso...@gmail.com> wrote:

Does anyone have the latest info on whether or not, the GA spreadsheet add on will support move to G4? Saw this fairly recent post that it will not support G4 metrics and am hoping it is not accurate:
https://stackoverflow.com/questions/73085235/google-sheets-is-not-compatible-with-ga4-only-with-universal-analytics

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/3e0d548b-1d4b-4d0c-bd47-9a6f3f606e6cn%40googlegroups.com.

--

Matt Landers Developer Relations Manager, Google Analytics mattl...@google.com

[Thu Tran]

Will the GA4 add on be available before Jul 2023 (UA's sunset date)?

[Matt Landers]

Yes. It's one of our top priorities right now. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/8e480af5-9a6e-46ba-ae44-9c34a9fcb573n%40googlegroups.com.

[Michele Pisani]

Hi guys,

for GA4 solution, I create this add-on that helps you view and edit Google Analytics 4 data more easily in Google Sheets.

It works similar to the good old add-on for Universal Analytics, as it is *FREE*: https://workspace.google.com/marketplace/app/ga4_magic_reports/6532356327

[Eric Bradley]

Hi Michele,

This tool is awesome! Thanks for putting it together. I am running into one hiccup. With the Dimension filters I am trying to use the add OR function, and it appears to be working as an add AND function (or something else). I would be glad to share an example with you if that would be helpful.

Eric

--
Eric Bradley

Librarian - Head of Research & Instruction
Harold and Wilma Good Library
Goshen College
1700 S. Main Street
Goshen, IN 46526

(p) 574-535-7424
www.goshen.edu/library

Schedule a meeting with me!

To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/caa96dea-45e3-49d7-88d9-8e8527f390c2n%40googlegroups.com.

[Michele Pisani]

Hi Eric,

thanks for the feedback!

Can you post a screenshot of the configuration so I can try to replicate it on my Property, please?

Thank you!

Michele

[Eric Bradley]

Hi Michele,

It is column D I am referring to.

Thanks! Eric

--
Eric Bradley

Librarian - Head of Research & Instruction
Harold and Wilma Good Library
Goshen College
1700 S. Main Street
Goshen, IN 46526

(p) 574-535-7424
www.goshen.edu/library

Schedule a meeting with me!

[Michele Pisani]

Hi Eric,

I was able to replicate the error and I confirm that there was indeed a bug in the code.

Your report was really helpful! Now the problem should be fixed, please let me know if you can confirm that it now works correctly on your side too.

Thank you!

Michele

[Eric Bradley]

This works! thank you for your promptness to correct this.

Take care,

Eric

--
Eric Bradley

Librarian - Head of Research & Instruction
Harold and Wilma Good Library
Goshen College
1700 S. Main Street
Goshen, IN 46526

(p) 574-535-7424
www.goshen.edu/library

Schedule a meeting with me!

[Michele Pisani]

Thanks to you Eric for your feedback! :)

M

[Dorian Medina]

Hi Michele, What is the name or link of that Add-On? 
Thanks

[Thu Tran]

Hi Matt  Landers  ,  UA is about to sunset soon, does your team has a solution for the new version of the add-on?

[Sinead Cunningham]

Hello, wondering if this add on is ready?

[Erik Olsen]

No word yet? 

[Alexandra Lumare]

Tic Toc tic toc tic toc tic toc tic toc...    10 days left   

[Ppcandanalytics Consultant]

For anyone still looking for a GA4 sheets add-on solution, here's a free Google Apps Script alternative. The blog post describes how to set it up and use it and the code is all open source. 

There are also some general notes about some issues I've come across whilst using the GA4 API vs the UA API which may be of interest even if you're using other solutions.

[Giel Hoogstraten]

Hi all, We have built a Google Analytics 4 add-on for Google Sheets, which has been available since September 2022.
Since its launch, we have consistently collected user feedback, leveraging these insights to continuously refine and enhance the add-on's features.
We confident that our add-on is a great solution to easily get your Google Analytics 4 data into Google Sheets. While it's not free, we believe it's very affordable.
If you need a solution, give it a try. The add-on offers a 14-day free trial period.

To install the add-on, go to: https://workspace.google.com/marketplace/app/ga4_reporting_for_google_analytics_4/126881055683

For more information, visit: https://adformatic.com/en/reporting-for-google-analytics-4/

[Alexandra Lumare]

Hi,

I have this issue with your script: TypeError: Cannot read properties of undefined (reading 'map')
Any suggest?

Thanks

[Caroline Buridant]

Hi Matt, any news about the add-on?

[Brandon Kramer]

FYI - Google released their GA4 Sheets add-on recently. https://workspace.google.com/u/0/marketplace/app/ga4_reports_builder_for_google_analytics/589269949355

 

 

BRANDON KRAMER, MBA

Senior Digital Marketing Strategist

 

433 Park Avenue, Falls Church, VA 22046

(571) 348-4864 | bkr...@waepa.org | waepa.org

 

 

--
You received this message because you are subscribed to a topic in the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-analytics-spreadsheet-add-on/LLj6e76H2Zw/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/e51ddc5e-c079-4673-9f26-4172d8bcbea0n%40googlegroups.com.

Notice: To protect your privacy, please do not send identifiable/sensitive information via email to include certificate, account, Social Security or credit card numbers, passwords or any other personal information. Instead, contact WAEPA directly at (800) 368-3484. This email may contain privileged information and, in all cases, provided for the sole use of the intended recipient. If you are not the intended recipient, please contact the sender and delete all copies. (4ZVD0R8G)