Load data into PowerBI from Social Media stored in Google Analytics

[Michael_94]

Hi All,

I'm trying to load Social Media Data from Google Analytics into my PowerBI Model, but the only social media related data I can find there is Traffic Sources (displays traffic from Social Media into my Website). 

I have for example tracked my social media campaigns with Analytics, how can I access this data via PBI?

[ReportMaster · Accepted solution]

Yeah that's a handicap GA4 or GA has, it cannot track everything. Mostly, you'll find important metrics that you won't be able to track with it. I don't know what social media you are advertising in, but I use an analytics tool like windsor.ai to integrate my data from social media platforms (like Fb Ads, IG Ads, Tik Tok Ads, Snapchat, Pinterest, etc) to PBI easily. That way I can get and use the important metrics each of this platforms has which GA4 can not show and it saves me a lot of time, which is the most important thing

[v-yinliw-msft]

Hi @Michael_94 ,

Could you please tell me how your data is stored? How is it stored? Excel? Or some kind of database?

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.