How do I reverse a t.co URL to the originating Tweet?

Question

I'm going through our site analytics, and have a load of t.co URLs which were referrers to a promotion we were doing. I'm trying to figure out if there is a way to reverse those back to the original tweet where they originated, through the Twitter API or other means. I can't seem to find a good means to do this though, is there one?

Dockage

Answer 1

This is not possible with the public APIs that twitter provides.

If I understand correctly you want to find a tweet that originally had a particular t.co link embedded. i.e. The t.co when followed resolves to your site, not the twitter tweet.

Af

Answer 2

When a t.co forward points to a tweet, it goes to the web page for that tweet and the HTML for the page will include the canonical URL.

The ugly way to get this information is to use wget or curl to grab the HTML destination which will include the URL for your initial tweet.

A better way to do it is with the Python module, Requests (you will need to install this module first). Here's a quick command line script that will do it:

#!/usr/bin/env python

import requests

shorturl = raw_input("Enter the shortened URL in its entirety: ")
r = requests.get(shorturl)

print("""
The shortened URL forwards to:

    %s
""" % r.url)

That code will work on any of those URL shortening services, not just Twitter's t.co site.

I did my testing with Python 2.7, but chances are that the above code will work with Python 3.x. Either way, Requests is your friend, see the documentation for details:

http://docs.python-requests.org/en/latest/index.html

The redirection and history section covers this example.

I don't know of a way to do it through the Twitter API and it may not be possible if all URL shortening is automatic. Still an API based solution would only work with the t.co addresses, whereas the code above will work on any other shortened URL or any URL which redirects (e.g. HTTP 301 or 302 response codes) to another location.

Edit (better a bit later than never): After using the above to find where the t.co forward actually points to, there will be three or four types of possible results. The most common being that it is what the OP believes they all are, a shortening to a URL pasted into a tweet and, to be fair, that is what most of them are.

The other possibilities are that it links back to the tweet itself, this usually only appears with some rather long tweets (not sure how much that increases in frequency with the character limit increase too); as well as forwarding to the URL of a status independent of a the tweet author's status URL, which is often the case with embedded media (images and video); plus forwards to the URL of a tweet which is being quote tweeted or retweeted.

Given the OP's original scenario, none of those internal Twitter usages should ever be seen and only the "normal" forwarding is of concern here. Now searching for the t.co address at twitter.com avails us nothing, regardless what combinations are used.

Searching the target address, however, that which is revealed by scripts like the one at the start of this answer, however, is quite another matter. That will produce the the results of every tweet which is publicly accessible and which posted that link. There are, however, some drawbacks including:

1. The search results will include tweets where other forwarding services were used as well.
2. There is no way to tell whether all the tweets which linked to that URL generated the same t.co address or not.
3. If not, there is no way to see which t.co forward was utilised by which tweet.

Nevertheless, in conjunction with complete referrer logs on a web server, it may be possible to narrow that further. Assuming the referrer URL reports the URL of the tweet and not simply twitter.com. That, however, is more likely to be determined by the manner in which the person clicking on the link did so (i.e. were they just seeing the tweet in a stream or had they expanded it enough to display its full URL).

I suspect the effectiveness of referrer logs will be sporadic and likely reduced on smartphones and tablets where the apps in use are less likely to have expanded tweets in that way in order to then provide that data to third party websites.

#!/usr/bin/env python3

import requests
import urllib.parse

shorturl = input("Enter the shortened URL in its entirety: ")
r0 = requests.get(shorturl, verify=True)
t0 = "https://twitter.com/search?f=tweets&q="
t1 = urllib.parse.quote_plus(r0.url)
r1 = requests.get("{0}{1}".format(t0, t1), verify=True)

# the results will be in r1.content
# there may be some benefit from cutting the http:// or 
# https:// from r0.url before creating the quoted string in t1.

That, however, is as good as it gets ... without paying Twitter for enhanced data access.

Sigismund

Addendum: if you need to check a redirect on a HTTPS site then change line 6 to this: r = requests.get(fwdurl, verify=False) – Sigismund

Addendum to the addendum: changes in recent versions of the requests module will produce a warning message for verify=False, but certificate checking has been improved since last year. So now change line 6 to r = requests.get(fwdurl, verify=True) and that's fine for HTTP as well as HTTPS. Also, being the only answer and getting the bounty makes someone's downvote hilarious. – Sigismund

This returns the URL the shortened link forwards to, but OP is asking for a way to return the URL of the tweet that created the shortened link. – Carditis

@Glacials I finally got around to fixing this thing with about the best you can get out of reverse engineering Twitter without forking over vast amounts of cash for access to their corporate data analytics services. It's not a bulls-eye, but I'll be impressed if anyone works out a way to land one on this question. – Sigismund

Why is using curl "ugly"? It's a very widely available tool, and invoking it only takes one command line option. No need to read Python code, or even install Python. – Musculature

Answer 3

1. Find out which is the original URL the shortened URL is pointing to e.g. by using a service like http://www.getlinkinfo.com
2. Paste that original URL into Google's search box

If you are specifically looking for references from Twitter do like this: site:twitter.com "https://example.com"

Iredale

Answer 4

If you use the Twitter search APIs, you can find tweets that mention the t.co URL (if they're visible to you) and find the link that way.

Here’s some Python for doing that, taken from a longer blog post I wrote:

from requests_oauthlib import OAuth1Session


sess = OAuth1Session(
    client_key=TWITTER_CONSUMER_KEY,
    client_secret=TWITTER_CONSUMER_SECRET,
    resource_owner_key=TWITTER_ACCESS_TOKEN,
    resource_owner_secret=TWITTER_ACCESS_TOKEN_SECRET
)


def find_tweets_using_tco(tco_url):
    """
    Given a shortened t.co URL, return a set of URLs for tweets that use this URL.
    """
    # See https://developer.twitter.com/en/docs/tweets/search/api-reference/get-search-tweets.html
    resp = sess.get(
        "https://api.twitter.com/1.1/search/tweets.json",
        params={
            "q": tco_url,
            "count": 100,
            "include_entities": True
        }
    )

    statuses = resp.json()["statuses"]

    tweet_urls = set()

    for status in statuses:
        # A retweet shows up as a new status in the Twitter API, but we're only
        # interested in the original tweet.  If this is a retweet, look through
        # to the original.
        try:
            tweet = status["retweeted_status"]
        except KeyError:
            tweet = status

        # If this tweet shows up in the search results for a reason other than
        # "it has this t.co URL as a short link", it's not interesting.
        if not any(u["url"] == tco_url for u in tweet["entities"]["urls"]):
            continue

        url = "https://twitter.com/%s/status/%s" % (
            tweet["user"]["screen_name"], tweet["id_str"]
        )

        tweet_urls.add(url)

    return tweet_urls

Tankersley

Answer 5

Twitter's t.co URL shortener simply redirects to another URL in the HTTP response. To find that other URL, you only need to fetch the t.co URL and look at the location header in the response. curl can do this:

curl -v <t.co URL>

To extract only the URL from all that information, you can use:

curl -w "%{redirect_url}" <t.co URL>

The -w option tells curl to output only the redirect_url variable.

Musculature

Answer 6

List of tweets that referred to your pages is available under Social networks and then Trackbacks menu directly in Google Analytics.

Floats

Answer 7

This is how you find the original tweet:

1. Click the t.co link to find the original URL
2. Go to https://twitter.com/explore (#)
3. Copy and paste the link into the on "search twitter" search box
4. You will see the tweet(s) with the link

Fabled