The Oscars as seen on Twitter

While we live in the era of digital media, and more specifically the era of social media, it’s undeniable that mass media still have a lot to say. I believe the reason is simple: online conversations wouldn’t happen without things to talk about.

That is what events like the Oscars have been providing for 87 years: conversation topics. The difference is that now we don’t have to throw a party at home or wait until we get to the office or the school the next day to talk about it. We can do it live on Twitter, and not just with the people we know but with the millions of people watching the same thing.

On this cool data visualization from Twitter you can see exactly that: the Oscars led the online conversation, minute by minute. People quickly forgot about the movies that were not being mention on the screen, but kept posting about what they were seeing live.

the oscars on twitter
Same on WordPress.com: the embed code won’t work and you don’t get to see the animation. Click on the image to visit Twitter’s site.

How to help a web designer help you

If you need help with a web design project you might probably think that the first thing to do is finding the best freelancers and agencies to see who can do the best job. But if that’s the case you are wrong: the first step is to know what you need and what you want. You can’t just go around asking them to send you a proposal to build a website if you don’t provide enough information about what you are looking for.

The reason? A website can be done in a billion different ways. A Tumblr blog with a default theme can be ready to go in less than 15 minutes and without spending a dime on graphic design or extra functionalities, but that is of no help to you if what you want is an e-commerce site to compete with Amazon.com (which would take a massive investment and quite a few months of work). So here are a few questions you should be ready to answer if you really want to help a web designer help you:

1) What’s the website for?

Easy: the overall goal of your website. If you just want to have a simple page with some information about the company and a contact form, the designer will understand that there is no need to budget for a a system to accept credit card payments. But if you want to sell stuff online he’ll look into different ways to manage your inventory or how to load all the images more efficiently to make the shopping experience better.

You should also think about your specific needs. If you just say that you want an e-commerce site, then a basic Shopify plan could be enough for you. But if you want to show different products to different users, or you need your sales team to access client information that shouldn’t be public, then you have to look into something else. Multilingual sites, receiving payments from different countries, user registration… the list can be as long as you want.

2) How do you want your website to look like?

Plenty of times, when someone approaches a web designer they already know how they want their website to look like. But for some reason they don’t say it. That’s a big mistake. Knowing what you like and the style you are looking for is a great help for the designer. And don’t worry, a good professional will find a polite way to tell you if your idea sucks, if it would be too expensive to build or how you could make it better.

One thing I like to do is ask potential clients to look at the websites of their competitors and list which ones they like and which ones they don’t, and write a few words on why they like/dislike those sites. You can also browse a website theme collection to see what’s the world wide web looking like these days.

3) What’s your budget?

Last but not least, there is no way around sharing your budget. Even if you share your goals and needs, and how you want your website to look like, there always are cheaper and more expensive solutions to the same problem.

For example, the cost of the design depends on two things: how important is for you to have a custom layout and how much can you spend on it. If you don’t need anything special and have a tight budget, you can buy a template from a site like Themeforest, and maybe get a designer to make a few teaks to it. But if you need something unique then you’ll need a bigger budget. The same applies with functionality: you can develop a solution for your specific problem or find an existing one that is not perfect but does the job.

WordPress SQL queries to change the site URL

Changing a WordPress site domain is a common practice for developers, as you normally don’t work using what will be the final website’s URL. While I believe Backupbuddy’s plugin tools to export and import a website are by far the easiest way to move a website to a new URL, it can also be done directly on the database with this four SQL queries that:

  • Change Siteurl & Homeurl
  • Change GUID
  • Change URL in Content
  • Update Post Meta
UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = REPLACE (guid, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com');

UPDATE wp_posts SET post_content = REPLACE (post_content, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com');

UPDATE wp_postmeta SET meta_value = REPLACE (meta_value, 'http://www.oldsiteurl.com','http://www.newsiteurl.com');

For more details on how this works, and a few more SQL queries for WordPress, I recommend this article on onextrapixel.com.

What’s social strategy?

Social strategy must solve a social problem in a way that others cannot easily duplicate and that either lowers costs or differentiates the business by adding value to its existing offer.

I found this mantra in the article “Why Your Social Strategy Is Broken And How To Fix It”, and I think it’s the perfect way to express what anyone should have in mind when thinking about social media and digital strategy: what should this do for me that is valuable both for me and my audience?