Forum Discussion

andrescaso's avatar
andrescaso
Resolver I
6 years ago
Solved

Problem with Google Analytics data

Hi all, I connected GA to the desktop version of Power BI, but the data (in days, users, and channel) in BI doesn't match with GA reports. After reading a lot of post, I was filter between dates in P...
Need Help
  • CmdrKeene's avatar
    CmdrKeene
    Helper IV
    6 years ago

    Thanks for posting this andrescaso - I'm also trying to resolve some similar Google Analytics issues.

     

    Another post had mentioned adding this:

     

        samplingLevel=  "LARGE",

    While yours shos to add:

     

        #"samplingLevel" = HIGHER_PRECISION

    Which one is the proper syntax?  Do quote marks belong around the "samplingLevel" parameter name, or the value (large or higher_precision)?

     

    Also do you know where the values are documented?  What's the difference between large and higher_precision?

    • andrescaso's avatar
      andrescaso
      Resolver I
      6 years ago

      Hi CmdrKeene 

      you can find the info in the support or GA, in this URL https://developers.google.com/analytics/devguides/reporting/core/v3/reference?hl=en#samplingLevel

       

      mmm the value "LARGE" a think is not valid value

      I copy for you the explanation of this parameter:

      samplingLevel

      samplingLevel=DEFAULTOptional.Use this parameter to set the sampling level (i.e. the number of sessions used to calculate the result) for a reporting query. The allowed values are consistent with the web interface and include:
      • DEFAULT — Returns response with a sample size that balances speed and accuracy.
      • FASTER — Returns a fast response with a smaller sample size.
      • HIGHER_PRECISION — Returns a more accurate response using a large sample size, but this may result in the response being slower.
      If not supplied, the DEFAULT sampling level will be used.See the Sampling section for details on how to calculate the percentage of sessions that were used for a query.
       
      Regards
      • CmdrKeene's avatar
        CmdrKeene
        Helper IV
        6 years ago

        I so far can't seem to retrieve valid results (matching the Google Analytis website) no matter what I try.  I think I must just have too much data to query in this way.