Easiest way to gather Bitly click data on a daily/weekly basis

[Black_magic100]

I have 350+ links and would like to know the best way to retrieve the click data for each link. I'd imagine the answer is a REST API, but my knowledge on the topic isn't great and would like to know the best way to integrate this data with power BI

[v-yuezhe-msft]

@Black_magic100,

In Power BI Desktop query editor, you can define the Power Query code to connect to Bitly data with REST API. There is an example for your reference.

And you can review the following articles about how to receive Bitly click data with its API.

https://dev.bitly.com/authentication.html
https://dev.bitly.com/link_metrics.html


Regards,
Lydia

[Black_magic100]

I just can not seem to figure it out.  I feel completely lost TBH.  There doesn't seem to be any forum posts that are looking to do the same thing I am doing.

[UnlimitedExcess]

Hi @Black_magic100 ,

I figured it out.

1. Create a "New Source" and use the web connector.
2. Use the basic link option.
3. Replace the bolded parts with your token and the bitly link. https://api-ssl.bitly.com/v3/link/clicks?access_token=ACCESS_TOKEN&link=LINK
   1. If you don't know what an access token is, check out this link to learn more (https://support.bitly.com/hc/en-us/articles/230647907-How-do-I-find-my-OAuth-access-token-)
4. That's it!
5. If you want to pull things besides link clicks, check out this documentation (https://dev.bitly.com/link_metrics.html).

Let me know if you have any more issues.

[leonarciso_b2w]

The bit.ly upgraded some syntax to v4. Anyone can help me to connect PBI to bit.ly?

[mukizarayner]

Thank you. worked quite well