cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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

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
4 REPLIES 4
Highlighted
Microsoft
Microsoft

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

@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

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.
Highlighted
Helper III
Helper III

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

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.

Highlighted
Frequent Visitor

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

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.

 

 

Highlighted
Regular Visitor

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

Thank you. worked quite well

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors