App Icon
Retrieve data and create automatic backups from Google Search Console™ into Google Sheets™.
Eintrag aktualisiert:13. Dezember 2021
Kompatibel mit:
150.188
Überblick
Search Analytics for Sheets allows you to:

1. Retrieve query, page, clicks and other data on-demand for any of your verified websites from Google Search Console's Search Analytics directly into Google Sheets.

- supports grouping and filtering data by "Query", "Page", "Country" and "Device"
- offers data on "Clicks", "Impressions", "CTR" and "Position"
- no limit on how much data can be pulled (only limited by the available data and the Google Sheets limit of 5 million cells per spreadsheet)

2. Create automatic data backups in Google Sheets

- backup daily or monthly Search Analytics data for any site or property set in its own spreadsheet
- create unlimited number of backups
- create both aggregated-data backups as well as grouped/filtered backups

Visit https://searchanalyticsforsheets.com for full documentation of what the add-on can do.


CHANGELOG

2021-11-26: Version 67

- Added News Tab, Google News and Discover search types, as well as the ability to fetch fresh data and use regex within filters

2021-11-23: Version 66

- Added ability to request custom amount of rows

2020-03-13: Version 56

- Added search bar for site dropdown

2019-10-30: Version 55

- Fixed backups not getting deleted automatically

2019-10-27: Version 54

- Disable backup on most errors

2019-04-04: Version 49

- Added handling multiple signed in accounts issue and domain properties

2018-07-26: Version 48

- Added the new 25,000 row limit per query

2018-06-22: Version 44

- Now includes the full 16 months range of data available to request

2017-10-22: Version 37

- Now works with property sets as well!

2017-09-08: Version 36

- Upgraded to the latest OAuth library

2017-06-01: Version 35

- Added daily backups!

2016-11-13: Version 29

- Added Google Analytics tracking code

2016-31-10: Version 25

- Fixed newsletter subscription from notification.

2016-31-10: Version 24

- Added notification for new version.

2016-31-10: Version 23

- Added option to retrieve more than 5000 rows. 'Cleanified' code to make it easier to add new features later.

2016-08-13: Version 11-16

- Tested and fixed authorization bug when property sets are present.

2016-06-09: Version 10

- Fixed small issue during authorization.

2016-06-08: Version 9

- Fixed small issue causing backup cycles to execute every day.

2016-06-06: Version 8

- Fix to backups not running due to trigger not being executed.
- Added the ability to run a backup cycle right away when activating the backup.

2016-05-17: Version 7

- Small fix for a notification that showed up if the user wasn't authorized.

2016-05-16: Version 6

- Small fix to issue that caused backups to run every day, despite completing successfully.

2016-05-15: Version 5

- Fixed MAJOR issue with fetching available date ranges from Google Search Console. If you had issues authorizing the add-on until now, this should fix it.
- Added the ability to view all active backups (the spreadsheets where backups have been created with your current user account) in the 'About' tab. This will only work with backups created started with this version.
- The backup option that allows you to save aggregated data as well no longer applies filters. You'll notice that the sheet name containing this data will change as well (starting with the next backup cycle).
- You can now subscribe to be notified by future updates via e-mail using the Subscribe button in the 'About' tab.
Weitere Informationen
PreiseKostenlos
Entwickler
Händlerstatus nicht angegeben
Die App Search Analytics for Sheets fragt nach den unten angegebenen Berechtigungen. Weitere Informationen
Die App „Search Analytics for Sheets“ benötigt Zugriff auf Ihr Google-Konto
Dadurch erhält Search Analytics for Sheets die folgenden Berechtigungen:
Alle Ihre Google-Tabellen aufrufen, bearbeiten, erstellen oder löschen
Externe Webinhalte in Aufforderungen und Seitenleisten in Google-Anwendungen anzeigen und ausführen
Verbindung mit externem Dienst herstellen
Ausführung dieser App während Ihrer Abwesenheit zulassen
E-Mails unter Ihrem Namen senden
Primäre E-Mail-Adresse Ihres Google-Kontos abrufen
Personenbezogene Daten aufrufen, einschließlich aller Daten, die Sie öffentlich zugänglich gemacht haben
Search Console-Daten für bestätigte Websites abrufen
Rezensionen
Sprache:
Sortieren nach:
Google prüft keine Rezensionen oder Bewertungen. Weitere Informationen zu Rezensionen
Profile Picture
Ein Nutzer von Search Analytics for Sheets
20. Juni 2016
Could you please add crawling error and hreflang error support? That'd be awesome! Thank you very much.
War dieses Rezension hilfreich?
Ja
Nein
Profile Picture
Ein Nutzer von Search Analytics for Sheets
19. Oktober 2016
Unique and very good tool for GSC, + developers answer your questions when you send some to them!
War dieses Rezension hilfreich?
Ja
Nein
Profile Picture
Roland
22. Juli 2020
Hello, thanks for that great add-on!! This one is one of my favorite tools and I use it every day! But one thing: SC now shows "News" for Search Type. Could you please add this new feature to the add-on. Thanks!
War dieses Rezension hilfreich?
Ja
Nein
1-3 von 3
Suche
Suche löschen
Suche schließen
Google-Apps
Hauptmenü