How to pull all Google analytics data into Azure blob storage using azure services specifically ADF ?

Question

How to pull all Google analytics data into Azure blob storage using azure services specifically ADF ?

Anonymous

Hi, I have a connection from ADF into the Azure bob storage with a JWT token but the JSON output does not serve much information about the customer purchasing analytics that I can use in Power BI. Please have a look at the output file which I have collected from GA analytics.

User's image

Anonymous

2023-09-11T10:42:22.4466667+00:00

Please reply @KranthiPakala-MSFT

Many thanks GS
Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2023-09-13T15:25:44.2433333+00:00

Hi @Anonymous
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2023-09-14T14:35:43.8133333+00:00

@Anonymous Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

Anonymous

2023-09-11T10:42:22.4466667+00:00

Please reply @KranthiPakala-MSFT

Many thanks GS
Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2023-09-13T15:25:44.2433333+00:00

Hi @Anonymous
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2023-09-14T14:35:43.8133333+00:00

@Anonymous Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Smaran Thoomu 24,110 Microsoft External Staff Moderator

Hi @Anonymous
Welcome to Microsoft Q&A platform and thanks for posting your question here.
Based on your query, it appears that you are trying to extract data from Google Analytics and store it in Azure Blob Storage using ADF.

If the JSON output from Google Analytics does not provide much information, there are a few things you can try to get more information:

The Google Analytics API provides a lot of flexibility in terms of the data that can be extracted. You can try modifying the API query to include additional dimensions and metrics that provide more information about the customer purchasing analytics.
If the JSON output format does not provide the required information, you can try using a different output format, such as CSV or Avro. Azure Data Factory supports multiple output formats, and you can choose the format that best fits your requirements.
If the data in the JSON output needs to be transformed to provide more information, you can use data transformation activities in Azure Data Factory to transform the data. Azure Data Factory provides a wide range of data transformation activities, such as mapping, aggregation, and filtering, that can be used to transform the data.

Kindly refer to this article for your reference Extract data from Google Analytics with Azure Data Factory
I hope this information is useful! Feel free to ask if you have any more questions.

Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2023-09-17T17:36:21.8433333+00:00

@Smaran Thoomu Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2023-09-18T12:05:34.86+00:00

@G S Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Anonymous

Hi @Smaran Thoomu Thanks for your reply, the reply was quite useful to understand the process, but I am still getting the error, I have got the GA4 account access but still it shows unauthenticated..

Failure happened on 'Source' side. ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 401 Unauthorized, please check your activity settings.
Request URL: https://analyticsdata.googleapis.com/v1beta/properties/285208119:runReport.
Response: {
  "error": {
    "code": 401,
    "message": "Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See https://developers.google.com/identity/sign-in/web/devconsole-project.",
    "status": "UNAUTHENTICATED"
  }
}
,Source=Microsoft.DataTransfer.ClientLibrary,'

Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2023-09-20T09:40:14.58+00:00
Hi @Anonymous

To help us investigate and address the issue, we would appreciate it if you could provide the details:

Please try connecting to the Google API via Postman or any other external tool and let us know if it is working fine.

If the connection is successful, please share the configuration of your ADF pipeline with us.

Share via

How to pull all Google analytics data into Azure blob storage using azure services specifically ADF ?

0 additional answers

Your answer