Learn business growth with Google Analytics 4 Forums Google Analytics 4 Trouble listing Metrics and Dimensions with Google Analytics Data API in SSIS Integration using Kingswaysoft

  • Trouble listing Metrics and Dimensions with Google Analytics Data API in SSIS Integration using Kingswaysoft

    Posted by John on 6 January 2023 at 3:03 pm


    I’m currently exploring the integration of GA4 with SSIS using Kingswaysoft and I’ve encountered an issue I hope someone can help me resolve. When I attempt to use ‘Google Analytics Data API’, I’m not seeing any Metrics & Dimensions displayed in the dropdown list I’m working in visual studio 2019.

    The following link should direct you to the list of Metrics and Dimensions that are supposed to be found under both ‘Google Analytics Data API’ and ‘Google Analytics Real-time Data API’: https://developers.google.com/analytics/devguides/reporting/data/v1/api-schema

    Could you guide me towards the possible solution to this problem so I can properly access the necessary drop down dimensions and metrics list for ‘Google Analytics Data API’?

    Thanks in advance!

    I was expecting the metrics and dimensions list to match that of GA4. The connection Manager seems to be functioning correctly, as I have input the necessary Property ID for Data API.

    I also tested the Google Analytics Real-Time Data API and had no issues, but when I attempt to use the Google Analytics Data API, I run into the problem described above.

    • This discussion was modified 11 months, 3 weeks ago by  Manan.
    Grayson replied 11 months, 3 weeks ago 3 Members · 2 Replies
  • 2 Replies
  • Benjamin

    21 February 2023 at 5:35 am

    Thank you for your question. If you are not seeing the dimensions and metrics in the dropdown list of the ‘Google Analytics Data API’ in SSIS, it could be because the token you are using does not have the necessary permissions to access them. As a result, only the dimensions and metrics that you have access to are being displayed.

    To resolve this issue, you can try granting the account that is authorizing the token the appropriate permissions. This can be done by ensuring that the account has the necessary access rights in the Google Analytics console. Once you have updated the account’s permissions, you will need to generate a new token.

    After generating the new token, try using it in the SSIS component and check if the dimensions and metrics you are looking for are now populated in the dropdown list. If they are, it means that the permissions issue has been resolved successfully.

    We hope this explanation helps you. Please give it a try and feel free to share any updates with us if you need further assistance.

  • Grayson

    12 April 2023 at 3:23 pm

    In the context of integrating GA4 with SSIS using KingswaySoft, I don’t have specific knowledge about KingswaySoft’s GA4 component. However, based on my experience with a UA to GA4 reporting project, I can provide some insights.

    In Google Analytics, a metric represents a countable quantity, such as the number of cows. For example, if you have 10 cows, the metric is “I have 10 cows.”

    On the other hand, a dimension provides additional details or descriptions about the metric. Using the cow example, you can have dimensions like the color of the cows. For instance, “I have 6 black cows and 4 white ones.”

    It appears that when selecting a metric or dimension in the KingswaySoft’s GA4 component, there might be filtering implemented to exclude incompatible dimensions. For example, if you try to add the dimension “pagePathPlusQueryString” to your queries, you may receive an error message like:

    “Please remove pagePathPlusQueryString to make the request compatible. The request’s dimensions & metrics are incompatible.”

    Since you have purchased the product, it would be beneficial to reach out to KingswaySoft for assistance with the challenges you are facing. They should be able to provide guidance on how to access the necessary drop-down dimensions and metrics list for the Google Analytics Data API.

    Please note that my response is based on general understanding of the concepts involved and may not directly apply to the specific implementation of KingswaySoft’s GA4 component.

Log in to reply.