Google Analytics - GA4 - Integer vs Decimal Issue resulting from cube data type

Hi apmulhearn ,
Based on your description and the screenshots provided, the heart of the problem seems to be that multidimensional datasets require integer values, but Google Analytics provides decimals for certain metrics.
You can do this by converting the data type from decimal to integer before adding the metric value columns to the multidimensional dataset. This can be done by rounding the number or truncating the decimal portion. If you are using a custom query to fetch data from Google Analytics, you may have the opportunity to adjust the query to round or truncate the values before returning them. This can be circumvented by ensuring that the data type matches the expectations of the multidimensional dataset from the source.
Applying rounding or fraction allowance steps after the fact does not work due to errors, so address data type mismatches as far upstream in the data processing pipeline as possible.

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly