Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have different sites on google analytics and I would like to compare them.
When I connect to google analytics I can only see information about a single site.
How can I do to have multiple sites and compare them ?
Thanks
Solved! Go to Solution.
Hi Lydia,
Thanks for the link, I execute it, but it doesn't work, but I've found the solution, what really work was the link bellow,
https://whitepages.unlimitedviz.com/2017/01/analyzing-wordpress-site-power-bi-google-analytics
Regards,
Wneiton
@wneiton,
You can connect to different Google Analytics sites using Power Query, for detailed steps, please review the following blog.
https://powerbloggerbi.com/2016/06/09/google-analytics-multiple-site-and-power-bi/
Regards,
Lydia
Hi Lydia,
Thanks for the link, I execute it, but it doesn't work, but I've found the solution, what really work was the link bellow,
https://whitepages.unlimitedviz.com/2017/01/analyzing-wordpress-site-power-bi-google-analytics
Regards,
Wneiton
hi all..
just wondering if there are alternative to obtain the same results other than the method below?
https://powerbloggerbi.com/2016/06/09/google-analytics-multiple-site-and-power-bi/
Thank you.
@Anonymous My way works (just did this today) but its time consuming.. I connected each site & associated metrics as a seperate data source to PBI (i.e., go to connected, connect to the view and select the resources). I then added a new column for each data source with the website name. You can do this by opening the table and entering WebsiteName = "yourdomain.com" . After that, i created an excel file with a single column with all my website names. I then added that as ANOTHER data source. When i did that, i was able to open the relationship manager section and drag the website name from my Excel file table into the Website Name column i created for each website table. This lets me create things like 1 barchart for all site sessions etc.,. to add a universal date and region filter, you need to create a region table to join all your websites to (also need region in the data source export). To filter by date, you can literally past the below query in a new table and the who date table will create for you.
Global Date =
ADDCOLUMNS (
CALENDAR (DATE(2013,1,1), DATE(2021,12,31)),
"DateAsInteger", FORMAT ( [Date], "YYYYMMDD" ),
"Year", YEAR ( [Date] ),
"Monthnumber", FORMAT ( [Date], "MM" ),
"YearMonthnumber", FORMAT ( [Date], "YYYY/MM" ),
"YearMonthShort", FORMAT ( [Date], "YYYY/mmm" ),
"MonthNameShort", FORMAT ( [Date], "mmm" ),
"MonthNameLong", FORMAT ( [Date], "mmmm" ),
"DayOfWeekNumber", WEEKDAY ( [Date] ),
"DayOfWeek", FORMAT ( [Date], "dddd" ),
"DayOfWeekShort", FORMAT ( [Date], "ddd" ),
"Quarter", "Q" & FORMAT ( [Date], "Q" ),
"YearQuarter", FORMAT ( [Date], "YYYY" ) & "/Q" & FORMAT ( [Date], "Q" ))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |