Product Category Hierarchy metric from Google Analytics to Big Query

Hi everyone,

We started using the trial version of Supermetrics for Google Big Query to get data from Google Analytics and the only issue we faced so far is that we can't find the Product Category Hierarchy metric in the Big Query dataset. We did find this metric in the Fields section of the documentation, but it's not listed in the Data Warehouse Tables. Does this mean that it's not possible to get this metric?

We have also tried to edit the schema in Big Query and add this metric but it does not seem to be working this way either. Is there something we might be missing? Or is there a way to get the Product Category Hierarchy metric uploaded to Big Query too?

Thanks a lot in advance,


  • Hi Lili,

    Thanks for your question.

    You are right, Product Category Hierarchy is currently missing from the data warehouse tables, but I hear from our devs that they will attempt to add it soon. We'll let you know when this is done. Thanks for your patience.


    Heidi / Supermetrics

  • Hey Heidi,

    Thanks a lot for your reply, looking forward for the updates!

    Best regards,


Login to post a comment