Forum Discussion
Retrieve external Data from google facebook youtube
I have to source data from multiple social platforms for ads costs and returns. I have the following sources I need to connect to:
1. FB ads manager
2. Google DCM
3. Youtube DBM
4. GDN DBM
5. Adwords
I need all your inputs/suggestions on how can i get my data from these sources.
Will get data -> blank query -> advanced editor work, if I write the api url along with fields. I cannot test it yet, so not sure.
Urgent help needed!!!!
Thanks in Advance.
3 Replies
Hi abhishekg1391,
1. FB ads manager
There is FB connector for Power BI desktop. you can use it directly.
2. Google DCM
Maybe you can try to use custom connector to have a try.
3. Youtube DBM
Please refer to this blog.
4. GDN DBM
Maybe you can try to use custom connector to have a try.
5. Adwords
Maybe you can try to use custom connector to have a try.
Regards,
Frank
Hi Frank,
Thank you for the reply.
Fb Connector availbale is for Likes/Comments etc. This connector can not be used for Ads data.
For others I don't have good knowledge on M language and will not be able to create connectors for the same.
I was thinking if I can directly use Get Data -> Web and enter a url which can fetch the data. I need help in writing this URL.
For that case, I would suggest you to try connecting your data sources with a 3rd party tool, that would save you a lot of time compared to other options. I currently use Windsor.ai make my reports and it has all those connectors, so maybe as a workaround it can be useful since PBI doesn't have native connectors for those sources
