How Marketers Can Deal with Data Over a Million Rows
Learn how to create pivot tables in MySQL from CSVs of millions of rows in this short tutorial by Mike King.
6 Ways to Develop a Multi-Stream Content Creation Strategy
Learn how each piece of content can spawn multiple pieces and make marketing across channel seamless.
Step-By-Step Twitter Sentiment Analysis: Visualizing Multiple Airlines’ PR Crises
Here’s a how United Airlines can analyze their brand’s sentiment and work to recover from their social media crisis.
Not Your Grandma’s Template: Innovative Design for Your Website
Imagine some websites that you’ve recently visited, and ask yourself, “do they kinda look the same?”. The layout is similar, usually starting with a full-width hero image or looping video with some big tagline overlay. Then follows a CTA and some copy, divided by columns with icons for each one. I have certainly heard my […]
V-Factor: How to Create Marketing Content That Goes Viral
The original title for this blog was V-Factor: How to Make Viral Content but I don’t want to lie to you. Content in of itself isn’t viral because going viral isn’t a guarantee–it’s simply a result of strategically executed content. Content types that go viral one time may fail to garner even half the shares […]
A Content Exercise: Using Link Building Prospecting for Content Brainstorming
Prospecting for link building allows a marketer to delve deeper into the online community they are aiming to reach. On a daily basis, link builders can come across hundreds of relevant sites, absorb new industry-related content, and interact with a multitude of experiences. Adjusting your thought process to focus on content ideas in conjunction with […]
Let Firebase help your next digital campaign development
What is Firebase? “Firebase is a mobile and web application platform with tools and infrastructure designed to help developers build high-quality apps.” —- Wikipedia. So what tools and infrastructure does Firebase have? Firebase has a lot of great features from the development side like a real-time database, authentication, hosting and storage. On the business side […]
Learning New Tech on the Fly
Many view the developer position as one that requires an incredible amount of knowledge and memory retention. These are great skills for any developer to have, but not two that I personally focus on or rely on. My most valuable assets as a developer are my intellect and my ability to learn on the fly. […]
Why Good Companies Make Bad Content
All content is not created equal. With the sheer volume of information on the Internet, we as content marketers know that not every piece shines as brilliant. Just look at the firestorm of controversy around fake news sites and the content providers that promote them. In life and in content, the cream always rises to […]
The Art of Storytelling & How to Use it to Market Your Brand
There is power in a good story and 2016 was a great example of that. The interesting thing I learned about storytelling in 2016 is that they don’t necessarily have to be 100% true to be effective. Instead, the audience just needs to find their own truth within your narrative. Let’s take a brief (I […]
UX/UI Checklist for Web Design
Every UX/UI designer has their own approach when delivering a rich and engaging user experience and interface. Similarly, here at iPullRank, we have our own design criteria and processes. But at a fast-paced startup agency like ours, timing and resources can be limited, so it’s crucial to map our design process with a tried and […]
Clustering vs. Classification: How to Speed Up Your Keyword Research
Modern keyword research is far beyond collecting a list of keywords and search volume. In our previous post “The Persona-driven Keyword Research Process” by our foreseeing founder Michael King, we discussed the importance of mapping keywords to personas and stages in the user journey/need states. However, most marketers who have actually done keyword research are […]
