Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wneiton
Resolver I
Resolver I

Google Analytics Multiple Site

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

1 ACCEPTED 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

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Employee
Employee

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Anonymous
Not applicable

@v-yuezhe-msft 

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
Not applicable

@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" ))

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.