Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
How can I get the costs of my "product groups" (for example brand) out of google analytics?
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
It is impossible to get product brand and cost in one table I think.
Or should I expand my selection, but with which columns?
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
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".
Here you have a clear vieuw of the data I would like to have in Power BI
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |