Product groups by cost of Google Analytics

[Anonymous]

How can I get the costs of my "product groups" (for example brand) out of google analytics?

[RH-BIP]

Did you manage to resolve this? 

@v-lili6-msft could you help please?

[v-lili6-msft]

hi, @Anonymous

You could use  Google Analytics connector to connect to Google Analytics and get relevant data, then create calculate measure or

calculate column to get the result.

https://docs.microsoft.com/en-us/power-bi/service-google-analytics-connector

Best Regards,

Lin

[Anonymous]

It is impossible to get product brand and cost in one table I think.

Or should I expand my selection, but with which columns?

[v-lili6-msft]

hi, @Anonymous

I have not connected to Google Analytics, but there should be product brand and cost data or other relevant data in the dataset but not in the same table, Otherwise, how do we get the result in the view? so please check them in other tables and be careful of the relationship among them, then you could also create the relationship and model in Power bi.

Best Regards,

Lin

[Anonymous]

Hi @v-lili6-msft,

That's just my problem. Ik don't find the way to couple "product brands" from the e-commerce table to "Costs" on the Adwords table.
I also cannot couple "product brands" with any "campaign ID" or "Ad Groups ID".

[Anonymous]

Here you have a clear vieuw of the data I would like to have in Power BI