Home / Questions / 416638
Accepted
Ariel Montes
Asked: 2021-12-25 03:17:52 +0800 CST 2021-12-25 03:17:52 +0800 CST

How to get Google Analytics statistics in a Google Docs spreadsheet?

  • 772

I have noticed that in the Google Docs spreadsheets there is an add-on that allows you to interact with the Google Analytics account to access your statistics and I have followed the steps of the official Google guide .

Once the plugin is installed and granted access to my Analytics account after requesting the creation of a new report, it gives me the following error:

"""
There's a problem

It looks like you don't have any Google Analytics
accounts with data.

Note: this add-on integrates with your existing Google
Analytics data. It is not a generic data analysis tool
for Google Sheets.

To learn more about Google Analytics, visit:
https://google.com/analytics.
"""

And then this other one:

"Error: User has no Google Analytics account data."

I thought it was an access problem but then I saw that this add-on does not require the configuration of the Google Analytics API , nor the creation of authentication keys or other similar systems.

Other relevant information is that my Google Analytics account was created only two days ago and has not collected much data, but I have already verified the existence of them.

Could it be that I need to wait longer for the amount of data to be enough to meet the "expectations" of the add-on or do you think this is a different problem?

PS: For those who are curious about why I want to connect these two services, you can find more information in the guide link. In short, its usefulness is to be able to view Google Analytics data graphically on any website (including the monitored site).

api

1 Answers

  1. Best Answer

    If you installed the Plugin, it is very important to ensure that your account has permissions to query Google Analytics data in order to create a report of Google Analytics information.

    In the case that you expose the problem it indicates:

    "Error: User has no Google Analytics account data."

    The problem is not due to permissions, it is because you do not have information to generate the report, the information must be obtained from the view of a property.

    You must create a property: https://support.google.com/analytics/answer/10269537?ref_topic=1009620

    enter image description here

    At this point you should choose to create only "Universal Analytics property" or "Google Analytics 4" and "Universal Analytics property". This would be the difference

    "Google Analytics 4" properties combine app and web measurement; in contrast, the "Universal Analytics property" properties are web-centric. When mapping the "Universal Analytics property" data collection to the "Google Analytics 4" data collection, consider your application's measurement needs.

    Differences between Universal Analytics and Google Analytics 4 data

    enter image description here

    when creating the property in your account, it can be selected to obtain the report:

    enter image description here

    enter image description here

    • 3