How I do it : Bulk URL shortening for #socialmedia updates
I post a lot of updates on social media some for marketing and others for social selling activities.
30 a day x 5 profiles = 150 updates [a day] x 7 days = 1050 updates [a week] x 52 weeks = 54,600 updates [a year].
This doesn’t really take into account the retweets I push from influencers or other interesting updates I find throughout the day, this is just what I have scheduled as updates. But I’ll write that post another time.
What I want to focus on is a way that you can take all of the collected and curated content you have and generate customized shortened URLS for them so you can easily have the updates scheduled for social marketing activities across platforms like Twitter and LinkedIn.
It was a huge pain for me, I had a handful of spreadsheets with hundreds if not thousands of titles and URLs for blog posts that fit a niche and would have to open each on and then shorten the link through Bitly or other shortening app. It was a rough life so I decided to do a bit of research and find a social marketing hack or method that would give me shortened URLs in bulk.
Now I am going to share this tip with you.
Bulk URL Shortening Tool for Social Marketing
1. Get a bitly account
Go get a free bitly.com account and log in to your account. Go to your account settings page. In settings, under advanced, you’ll see “Legacy API Key”, click the link and your credentials are shown (have this page open as you’ll need the keys in the the next steps)
2. Get a copy of this URL shortening Google spreadsheet
Be signed in on your Google account and click this link to download the Google Docs spreadsheet
A copy of the spreadsheet will open. Now go to “File” -> “Make a copy” (Important: as this creates a copy which you can edit
3. Customize the Google doc setting
The spreadsheet has two tabs; the “Settings” and the “Bitly URL Shortener” tab, and they are located down at the bottom left corner.
First off, head to the “Settings” tab, paste your Bitly login key into the first cell and your API key into the second cell.
4. start adding URLs
Now go to the second tab “Bitly URL Shortener” and paste in up to 50 URLs into the URL column (column B3). The Bitly free API comes with a 50 URLs at a time limit.
Your bit.ly URLs should now appear in the Short URL column (column C3).
Now I have a custom URL “koka.bz” which is something I bought and then configured bitly to use when I shorten links. without a custom URL you will get shortened links that look like bit.ly/yourlink.
This has been a game changer for me when it comes to creating bulk updates that I can use through one of my social media profiles to share news and information about the industry.
Big shout to Setaris for showing me the way.
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/SWuURkQb3F
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/W444pd5MPy
How I do it : Bulk URL shortening for #socialmedia updates | via @kokasexton http://t.co/YWDUzlgFAu
How I do it : Bulk URL shortening for #socialmedia updates | via @kokasexton http://t.co/e5MLDRYl2x
How I do it : Bulk URL shortening for #socialmedia updates via @KokaSexton http://t.co/ATVzAfkU2Z
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/lCRcjDw3Tz
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/4o6HfaY5jT
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/rkYlf0PVOv
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/mxQE6W3yND
How I do it : Bulk URL shortening for #socialmedia updates | via @kokasexton http://t.co/7hVj6MWst7
#SMTIPS How I do it : Bulk URL shortening for #socialmedia updates http://t.co/D26e6GOPMJ
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/0RvOTEtUSa
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/bvQARzrxNf
How I do it : Bulk URL shortening for #socialmedia updates – http://t.co/kwiQoRJyEj
Bulk URL shortening for #socialmedia updates http://t.co/FuxxPOwJTt
How I do it : Bulk URL shortening for #socialmedia updates – http://t.co/6GA54zp1UI
This is an extremely useful way to shorten URLs in bulk. #socialmedia #tips http://t.co/Je8RKpwxaZ
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/B04mOFCvI7
Bulk URL shortening for #SocialMedia updates by @KokaSexton http://t.co/sJjzh5xt68
How I do it : Bulk URL shortening for #socialmedia updates | via @kokasexton http://t.co/Sbx0wWSxPT
http://t.co/WDjss05Yjx – How I do it : Bulk URL shortening for #socialmedia updates
.@kokasexton shows you how to use #Excel to shorten your links in bulk: http://t.co/0zOCHQBX4S
Need to shorten large numbers of URLs quickly? Then this is article is for you. http://t.co/ghaKjOLmHR
How I do it : Bulk URL shortening for #socialmedia updates | via @kokasexton ► http://t.co/o6tI9Iwq0g
How I do it : Bulk URL shortening for http://t.co/xyExnzQLY3
How I do it : Bulk URL shortening for #socialmedia updates | via @kokasexton http://t.co/nJKI1XeehN
Simply awesome! Bulk URL shortening technique for #social media updates by @kokasexton http://t.co/GC0DKoP4Ir
How I do it : Bulk URL shortening for #socialmedia updates – http://t.co/Pbpvp97on7
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/kdsxArCKPz
How I do it : Bulk URL shortening for #socialmedia updates http://t.co/XmbLklfatn
One step with @squeezecmm! RT @kokasexton: How I do it : Bulk URL shortening for #socialmedia updates http://t.co/UBrzJzvaOy
#SocialFA Top Story: How I do it : Bulk URL shortening for #socialmedia update… http://t.co/mIMqk1eReC, see more http://t.co/HhEj41CtUy
How I do it : Bulk URL shortening for http://t.co/WrJuMdERdz
How I do it : Bulk URL shortening for #socialmedia updates | via @kokasexton https://t.co/d6eDDzTxje