Get click count on bit.ly and goo.gl


#1

Hi,

I am (unsuccessfully) trying to use RegExpFindOnUrl to scrape the click count on these type of url's:

http://bit.ly/keringet+

and

https://goo.gl/#analytics/goo.gl/TTKL6/all_time

Anyone here able to write the right regexp if at all possible?

Ludvik


#2

Will look at goo.gl later, but regarding bit.ly:

=RegexpFindOnUrl(URL;"user_clicks"":\s(\d+),";1)

I recommend using the official Bitly Connector which allows you to get clicks based on shortlink:

image

The Bitly Connector is located under Others->URL Shorteners


#3

Thank you!!! it worked perfectly.

Any chance of making this work for goo.gl as well?

Ludvik


#4

Gool.gl fetches the stats from javascript so it is not possible with just the Xpath formula. One solution is to use our PhantomJS Cloud Connector like this:


#5

Thank you!! will need to look into that ASAP I understand.!

Thanks again for great help!

Ludvik