Collectives™ on Stack Overflow

Find centralized, trusted content and collaborate around the technologies you use most.

Learn more about Collectives

Teams

Q&A for work

Connect and share knowledge within a single location that is structured and easy to search.

Learn more about Teams # Load the JSON key file with open('key.json', 'r') as f: service_account_info = json.load(f) # Create a service account object service_account = service_account_info['client_email'] # Create a Google Analytics Reporting API client client = google.analytics.data.BetaAnalyticsDataClient() # Set the view ID view_id = '74466483' # Set the date range start_date = '2023-01-01' end_date = '2023-05-01' # Define the metrics and dimensions metrics = ['ga:sessions', 'ga:bounce_rate', 'ga:average_time_on_page', 'ga:entrances', 'ga:pageviews', 'ga:unique_pageviews'] dimensions = ['ga:source', 'ga:page'] # Run the report report = client.run_report( view_id, start_date, end_date, metrics, dimensions # Write the report to a CSV file with open('report.csv', 'w') as f: writer = csv.writer(f) writer.writerow(report.header) for row in report.rows: writer.writerow(row) ERROR: $ python CompanyName.py Traceback (most recent call last): File "C:\Users\Daniel Kamen\Desktop\CompanyNameCode\CompanyName.py", line 14, in <module> client = google.analytics.data.BetaAnalyticsDataClient() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\MYNAME\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\LocalCache\local-packages\Python311\site-packages\google\analytics\data_v1beta\services\beta_analytics_data\client.py", line 426, in __init__ self._transport = Transport( ^^^^^^^^^^ File "C:\Users\MYNAME\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\LocalCache\local-packages\Python311\site-packages\google\analytics\data_v1beta\services\beta_analytics_data\transports\grpc.py", line 148, in __init__ super().__init__( File "C:\Users\MYNAME\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\LocalCache\local-packages\Python311\site-packages\google\analytics\data_v1beta\services\beta_analytics_data\transports\base.py", line 100, in __init__ credentials, _ = google.auth.default( ^^^^^^^^^^^^^^^^^^^^ File "C:\Users\MYNAME\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.11_qbz5n2kfra8p0\LocalCache\local-packages\Python311\site-packages\google\auth\_default.py", line 648, in default raise exceptions.DefaultCredentialsError(_CLOUD_SDK_MISSING_CREDENTIALS) google.auth.exceptions.DefaultCredentialsError: Your default credentials were not found. To set up Application Default Credentials, see https://cloud.google.com/docs/authentication/external/set-up-adc for more information.

I was given administrator access to my company's google analytics account, so I'm really lost at whats needed to run this. The goal is to export the company data into a csv file to help transition our old data into GA4

I really am lost so I'm not sure what to try.

That's because, as documentation explains, the method BetaAnalyticsDataClient() does accept an optional options object, that has credentials inside.

Whether it isn't provided, it will search for default ones (that in your case aren't instantiated).

To specify them, simply:

client = google.analytics.data.BetaAnalyticsDataClient(options={"credentials":{"client_email": service_account, "private_key": "YOUR_KEY"}})
Or, for a more readable alternative, create a dict outside and call it.
credentials_dict = {
    "options": {
        "client_email": service_account,
        "private_key": "YOUR_KEY"
client = google.analytics.data.BetaAnalyticsDataClient(options=credentials_dict)
Either, if you have gcloud SDK in your computer, you can visit the suggested link in the error message and setup a default credential!
Hope it actually fixes your problem. I do not have Google Analytics credentials so I cannot test it.
                So since I have service_account_info being creeated through the json file, should remove the service_account = service_acount_info['client_email']? I believe I'd still need to read the json file
– Daniel Kamen
                May 4 at 15:15
                @DanielKamen i see what you did there.. the problem is: you aren't using this service_account variable. You just instantiated it. It should be enough to put it into the dictionary i specified
– Marco Frag Delle Monache
                May 4 at 15:18
                Got the credential issues resolved, thank you!  Now Im getting these errors which are weird considering I've imported everything needed.  line 3, in <module>     import googleanalytics   File "C:\...\site-packages\googleanalytics_init_.py", line 3, in <module>     from . import auth, commands, utils, account, auth, blueprint, columns, errors, query, segments   File "C:.._init_.py", from . import oauth   File "C:\...\oauth.py",     from oauth2client import client   File "C:\\client.py",      import urlparse ModuleNotFoundError: No module named 'urlparse'
– Daniel Kamen
                May 4 at 15:45
        
Thanks for contributing an answer to Stack Overflow!
Please be sure to answer the question. Provide details and share your research!
But avoid …
Asking for help, clarification, or responding to other answers.
Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.