Tag Archives: agency

The Heroes Within: Why Hero Banners can Save Your Target Audience from Boredom

The Heroes Within_Why Hero Banners can Save Your Target Audience from Boredom

Having a business is a commitment made long before we created our own brand. Why? That’s because before creating the brand itself, we must plan everything from the start; what steps do we need to take? What are the important elements that can help in running a business? How do we keep the business running smoothly? Yes, keeping a business is like guarding kids so that they won’t disappear on us. For that reason, many business owners take those important elements in developing a business very seriously. One of them is having a website. Nowadays, the majority of businesses use websites to increase their credibility and work performance. Are you a business owner? Or are you someone who works for a business? Keep reading if you need to know more about this in this article!

The use of a website is not a common thing anymore when it comes to business, because a website is important in many ways, as using it can help with so many things as well. First, with a website, people can see how reliable your business is, and with a website, it can also help with SEO process which can let you be more visible on the internet so that your target audience can find you. That being said, having a website alone doesn’t mean the task is miraculously done. There are also essential elements that can create functional and good quality website that can boost its performance. One of them that will be discussed today in this article is web design. Web design will basically determine how your website looks like and how it can impact your sales. With trends increasing, one more trend can save the day; hero banner.

What is hero banner and why does it become the “it”?

When you visit a website and you see a large centred image right below the navigation bar, it is most likely that the website you are visiting is using a hero banner. Hero banner is basically a large image with high quality resolution that is placed right at the centre of the webpage intended for “centre of attention” purposes. When users are visiting your website, it is common for them to get bored after some time, for that reason, the large image can somehow generate at least the feelings of wanting to stay longer browsing your website. Here are the reasons why hero banners can become the hero of your website.

Hero banners can give a sense of validity and reliability

Using a hero banner that includes real people photos or visual content with high quality can give a sense of legitimacy and reliability. However, don’t use stock photos that will likely give you completely opposite results. Something like this can become a good example for that.

web design tips

Or you can also go with this.

web design tips 2

Hero banners can evoke emotion

If your website is about charity event, using the right image as the hero banner with the right content writing can also evoke emotions from your visitors. Below is the example of the positive impact of a donation expressed in one single high quality image.

hero banner tips

Hero banners can build trust

You can boost your business credibility by building trust with a message included in a large image of a hero banner. That message would be nothing if not followed by a hero banner that will boost the value of the message. See the examples below.

hero banner tips 2

web design idea

Hero banners are great for increasing conversion

Simply put, hero banners are more engaging than its predecessors. It is because most people are highly visual. That’s why having high quality imagery at the top of your page can help create a positive first impression. If you do it well by directing visitors with the right message, you can:

  • Help a visitor intuitively find the desired content on a website
  • Give a visitor more control over what is being viewed
  • Provide complete content so that visitors can find it easily

The bottom line, hero banners are highly captivating.

Being the first thing to be seen by visitors when they are accessing your website, hero banner has chances of enhancing everything on the website just by one look at it, making it almost impossible for visitors to leave your page right away. If you are a business owner thinking about making a website for your business, it is highly recommended for you to include hero banner for your website design. Not only will it entertain people who visit your website, but it also gives you the positive impact on your business, as it can increase your popularity as well as build trust between your business and your potential customers. If you need more information about web design, feel free to contact us and our team will be ready to help you.

Perpendicular Search: The Difference between Horizontal and Vertical Search

Perpendicular Search_The Difference between Horizontal and Vertical Search

Do you remember how Google was way back in 2004? I still do. The internet was still relatively new to my 14-year-old self back then that I still somewhat vaguely remember how Google search engine results page (SERP) look like back then. It was a couple of years after my family switched to a proper broadband connection after years of intimate struggles with dial-up and thanks to my sterling grades at the time, I was finally given a computer of my own.

Horizontal and vertical search

Right now, when I type in the word ‘Mission Impossible’ into Google, the SERP will be populated by a smorgasbord of different types of content. The right hand side is filled with what is known as Google’s knowledge card, displaying details about the first film in the series such as posters and screenshots, synopsis, cast members and other relevant search queries. The actual SERP lists Wikipedia and IMDB entries on the film and the series as a whole, news updates on the new Mission Impossible: Fallout film and trailer for that same film, plus suggestions at the bottom for other Mission Impossible films, films featuring Tom Cruise and other action films.

Had I typed in the exact same word on Google 14 years ago, all I’d get would just be articles. Wikipedia entries and IMDB entries and maybe the Rottentomatoes page of the first film would pop up in the results. If I want to look up some images on the film, I’d have to switch to Google image search and if I want to see a trailer for the film, I’d have to pop over into YouTube. Google and search engines in general have come a long way in the past 14 years.

This current version of Google search engine that we have right now uses what is called a universal or horizontal search. It pulls in contents from across all four corners of the internet, blending web pages, images, videos, news etc to provide you with the most wide-ranging result possible. The Google search from 2004 uses what is now called a vertical search, in that it only covers web pages while image and video search is covered by Google image search and YouTube. Understanding this difference and how to utilize it is crucial in understanding how SEO services work.

The universal reach of horizontal search

It is referred to as such because horizontal search is wide-ranging but shallow and would cover any topics relating to your search query. All of the major search engines, Google, Bing and Yahoo, fall under this umbrella. Generally, when someone is starting the search process for a particular object/subject, a horizontal search engine is what they start with. A horizontal search won’t always give you the answer to what you’re looking for but they can always be relied upon to point you in the right direction.

The laser-like focus of vertical search

In contrast, a vertical search is a narrow but deep look into a subject by limiting coverage into a single type of content, website or even a geographical region. There are a huge number of examples for a vertical search engine. YouTube and Vimeo for videos, Google image search for images, Google scholar for scientific journals and the search function in Amazon are several examples. If a website has a built-in search function then that particular site could qualify as a vertical search engine. Due to the specialized nature of vertical search, this is usually employed when a user already knows what they’re searching for.

So, which to optimize for?

In short, both. Using Google as an example, the SERP would display local search results depending on the query, which means that if you optimize for Google you can kill two birds with one stone, optimizing for both horizontal and vertical search. The tricky thing is in dealing with specialized websites as depending on the field of business, there can be a lot to choose from. For food alone for example, you’ve got Yelp, Zomato, TripAdvisor and even Facebook in addition to Google reviews. You have your work cut out to maintain your presence across all of those platforms.

E-commerce is where things might get a little complicated. Due to the sheer number of items available in those sites, retail giants like Amazon with their own search algorithm and SEO methods. When you start peddling your goods across different retail sites, optimizing for each would be difficult so focusing on a select few or even just one is advisable. If you operate your own website on top of that, you’re going to have to decide which takes priority in your SEO efforts.

Ways to Use Google Apps Script to Fetch Databases to a Google Spreadsheet

How to Use Google Apps Script to Fetch Databases to a Google Spreadsheet_YWF

It is pretty common to export information from a WordPress database to an Excel sheet or in a CSV format. However, you may realize that there is a problem with exporting and importing files. One of the most common ones is that the process is sometimes not too intuitive and all files need to be updated at regular intervals.

However, now you can forget those old days, as today, you can solve the problem by using Google Apps Script to link your WordPress database to a Google spreadsheet which automates the workflow. As a web developer, you surely want to know how a Google Apps Script can be used to fetch database values from WordPress through the Google Apps Script Spreadsheet Service. So, here is some information about it that you need to know.

What is Google Apps Script?

Through Google Apps Script, you can automate tasks across Google products and third party services and build web applications. In many cases, Google Apps Script is also known as a JavaScript cloud scripting.

This is why you can do a lot of new things with Google Apps like Docs, Sheets, and Forms through the Google App Script. Other benefits that you can get from the Google App Scripts are:

  • Add custom menus, dialogs, and sidebars to Google Docs, Sheets, and Forms.
  • Write custom functions for Google Sheets
  • Publish web apps – either standalone or embedded in Google Sites
  • Interact with other Google services, including AdSense, Analytics, Calendar, Drive, Gmail, and Maps.

Furthermore, with the Google Apps Script Spreadsheet service, you can create access and modify Google Sheets files.

Creating a Google Apps Script with Spreadsheet

If you want to create a Google Apps Scripts with Spreadsheet, the steps will be as follows:

  • Create a New Spreasheet
  • Click on “Tools ->Script Editor”
  • The editor window will appear in a new tab
  • When writing the script, there are several Classes and methods that you can choose. Some of them are as follows:
  1. Classes
  • BorderStyle
  • DataValidation
  • ContainerInfo
  • Range
  1. Methods
  • getChartType()
  • getRanges()
  • setColours()

 

Below is the Sample app script example that will store the spreadsheet data into the log:

function logProductInfo() {

var sheet = SpreadsheetApp.getActiveSheet();

var data = sheet.getDataRange().getValues();

for (var i = 0; i < data.length; i++) {

Logger.log(‘Product name: ‘ + data[i][0]);

Logger.log(‘Product number: ‘ + data[i][1]);

}

}

  • Don’t forget to debug the script after writing the script. You can debug the icon easily by clicking on debug icon and if debugging is successful with no error then you can “Run” the script by clicking on run icon.
  • Click on “View->Logs” to view the Log.

 Google Apps Script and WordPress

You can also use Google Apps Script with WordPress in many ways. For example, you can connect with the WordPress database. Via JDBC service, Google Apps Script can access many relational databases. It is actually a wrapper around the standard Java Database Connectivity standard. In Google Apps Script, the JDBC service supports the Google Cloud SQL, MySQL, Microsoft SQL Server, and Oracle databases.

You can read the following example that will demonstrate the database connection:

function myFunction() {// make the connectionvar connection = Jdbc.getConnection(“jdbc:mysql://db IP or host name:port number/DB name”, “User name”, “password”);// perform the queryvar SQLstatement = connection.createStatement();var result = SQLstatement.executeQuery(“SELECT * FROM DB_NAME”);// choose a range in sheetvar ss = SpreadsheetApp.getActiveSpreadsheet();var cell = ss.getRange(‘A2’);// loop through result object, setting cell values to database datavar row = 0;while(result.next()) {for(var i=0; i<4; i++) { // four fields per recordcell.offset(row, i).setValue(result.getString(i+1));}row++;}// tidy upresult.close();SQLstatement.close();connection.close();}

By running this code, you will get the values from the database and add the fetched values into the currently active spreadsheet. You can also add values into the database, in which those values can be used in WordPress. For instance, it is possible to register all of the users’ data in a spreadsheet in one go through the Google Apps Script.

Conclusion

In order to easily map your WordPress database to a Google Spreadsheet, you can use the Google Apps Script. Another advantage that you can get by applying this method is that you can simply run this script to update your spreadsheet as per your database. Furthermore, you don’t need to constantly import and merge files in order to keep your online and offline databases in sync. This makes this application highly useful, especially for developers who want to use Google APIs for many purposes.