Get click count on bit.ly and goo.gl

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

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

Thank you!!! it worked perfectly.

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

Ludvik

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:

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

Thanks again for great help!

Ludvik