Database Development

Our Database Development Skills

We have an in house team of developers able to provide bespoke database applications, especially those that in interface with websites.

Our clients for this work range from small business up to major multinational corporations and we have produced systems ranging from small website applications through to sophisticated management information systems.

Our preferred development platform is LAMP (Linux server, Apache operating system, MySQL database and PHP programming language). This is a popular choice with government agencies and large business keen to avoid expensive license fees from the alternative Windows based development.

We are ISO 9001 certified and make use of online project management tools to keep track of project progress.

database development

Examples of database development

Finance system databases

We have produced database systems for interfacing between marketing websites and finance product calculators in markets such as loans, pensions and private healthcare. Many of these systems require secure servers as dealing with confidential medical or financial data. They often involve integration with 3rd party calculators or best deal finders.

Mapping and data analysis systems

It is possible to show complex set of data graphically and if the data relates to geographical regions to show this with Google maps or Google earth. We work with Bureau Veritas and defra on many air quality projects to show data on maps on websites. Some of these datasets and very large and require data manipulation and analysis before display.

Management Information systems

We have produced integrated management information systems that deal with all communication between the company and their clients. We have done this in industries such as healthcare and adult education.

This starts with leads generated from the website or by phone or email, includes a record of all communication, generates customisable email responses and PDF attachments, allows for online payments, records all payments received and made (to suppliers) and provides a reporting system for managers. Activities can be scheduled and highlighted in terms of priority. Access and reporting levels available vary with access level.

In one such system we have included a booking and room allocation system making it easy to assign to rooms according to language spoken and gender.

Marketing Information Systems

A much simpler alternative to a full management information system is a marketing system; this tells quickly where good leads or sales have come from and the aim is to provide just the information needed.

Workflow and document tracking

As processes get moved online there is a need for systems which accurately record the process of sending, receiving, auctioning and replying to documents. These projects range from the simple job applications systems to the more complex handling of local authority report submission over many years with multiple levels of review and different reviewers depending on geographical location.

School VLE

This is a VLE (Virtual Learning Environment) aimed at Primary Schools. It enables effective communication of homework between teachers and parents at a level appropriate to their age, and is very quick and easy to use. A key consideration here was a system which reduced workload for teachers and made their job easier. Responses from schools have been very positive in this regard.

Multilingual database development

We have extensive experience of producing database driven systems in multiple languages. Examples of these include:

  • Database to choose the particular ring or spring according to width and various other engineering measurements – in Russian
  • Database to select suitable aircraft for air charter company – in Russian, Arabic, French and English

Web Application Development

With over a decade of experience of in web application development built to high specification we can tackle most projects. Our clients include the Government (Defra), Education providers, Public service providers such as the police, healthcare providers, international companies such as Alcoa, Smalley, travel and tourism companies and businesses and organisations from many different sectors.

We work to ISO 9001 to ensure a high quality. Accessibility and search engine optimised code is standard for all websites and web applications.

Database Design

The majority of web application development we undertake will involve a database. For larger projects getting the database design right is critical for the final performance. Slow websites can be caused by an inefficient database setup and slow database queries.

For large projects we provide a full data analysis and often a work flow analysis as well. On many occasions we have taken existing systems and considerably improved the performance, sometimes by factors of over 20x in terms of speed for users.

We have in house staff skilled at database design and build as well as strategic planning.

Ecommerce Development

We design and develop a range of different ecommerce websites, using an appropriate web application development technology to the size and scale of the website required. Our speciality is search engine optimised online shops, and we ensure all design and development is done to help market the website online.

We are familar with integrating with many different PSPs (Payment Service Providers) to enable taking of payment by credit card securely.

We can provide the full solution including hosting with secure server and certificate if required. We can also advise regarding PCI compliance. Take a look at our ecommerce development expertise, which includes Magento ecommerce development, CS-Cart ecommerce development and small online shop development.

Multilingual Development

We undertaken website design and web application development in over twenty languages including:

  • French, German, Dutch
  • Spanish, Italian, Portuguese
  • Arabic
  • Russian, Turkish, Greek
  • Chinese (traditional), Chinese (simplified), Japanese, Korean
  • Latvian, Lithuanian, Slovakian, Polish, Czech
  • Bengali, Punjabi

 

Multilingual Web Design

The world we live in is becoming more and more multicultural. Developments in communication, led by internet, have allowed international expansion more possible than ever before. Web Designer Vip help our clients to tap into the potential leads and sales of international markets through great multilingual web design.

We utilise our marketing and web design experiences and expertise to build sites in many languages.

French, German, Dutch, Spanish, Portuguese, Arabic, Russian, Chinese, Japanese and more.

Our experience

We have a decade of expertise in building effective and visually compelling websites for a wide range of sectors in many countries. See our map below for areas of the world we have produced websites for.

We can provide great value for your organisation and are keen to pass on our expert knowledge in multilingual web design. We know that there are many factors at play when looking at a design for each language. These include language translation and character sets as well as cultural translation all of which can influence key design decisions.

  • Translation: This should be done by a native speaker to get the best translation, and the context is important too. Dates numbers and currency all have special considerations that are different for each language.
  • Character set: Different languages use different alphabets. Many Western European languages are based on the Latin alphabet, but there are differences in letters used and especially accents. Other languages are based on different scripts, for example Cyrillic. These all require different character sets to be used within the website.
  • Text direction: Most languages in the world are written left to right. The most common exceptions are Arabic and Hebrew which are written right to left. And Chinese and Japanese which may be written top to bottom

The ExtraCMS

What makes Web Designer Vip a great choice for multilingual web design? As mentioned previously Business over the internet is increasingly becoming multinational, with buyers and leads generated all over the world. Our bespoke content management system ExtraCMS is built specifically for languages that use more than one website.

The ExtraCMS has no difficulty handling multilingual websites and non-standard character sets to make you can reach your target audience wherever they may be. It is the preferred choice for institutions such as the British Museum as well as Doctoori, the leading Arabic healthcare information provider.

 

PPC for Tourism: Case Studies

Web Designer Vip has managed many paid search campaigns within the tourism industry. These include PPC campaigns for hotels, for chains of hotels, for guest houses or bed and breakfast places. We have also run paid search campaigns for Tourism Agencies and regional visitor centres and event organisers. Some of these have been with supporting SEO work, others have been standalone PPC campaigns.

PPC for Tourism or Events or Bookings has the important point that once a date has passed the product (the booking) has gone, so products (bookings) have a fixed shelf life. Paid campaigns can be used to generate interest in an area, to generate enquiries for brochures or to send visitors through to make a reservation or booking.

Below are some examples of the paid search campaigns we have provided for clients within the tourism industry.

Tourism campaigns for regional tourist areas

We have worked with Visit Kent and Visit Lincolnshire on awareness campaigns to increase enquires for brochures and event literature. This has usually been in conjunction with offline poster campaigns (on railways) and in magazines and we have provided the PPC setup and management. These campaigns have been both local to the UK and abroad, often targeting specific countries.

PPC campaigns for groups of hotels

We have worked with groups of hotels – for example Handpicked Hotels or Hotels in Holland to advertise specific types of breaks or facilities or offers across a range of individual hotels. We’ve worked with hotels in many countries.

We’ve provided similar paid advertising for groups of guest house or holiday cottages, usually on a regional basis, such as in Cornwall. The campaigns include both general paid advertising for the type of accommodation, and also specific advertising to individual guest houses or cottages.

On the smaller scale we have provide paid search advertising for individual guest houses or holiday accommodation. This works well as it is very targeted.

Paid search for the tourism sector is very seasonal and long term expertise is helpful. Many of the online keyword tools review trends over the last few months  – but in tourism you are better reviewing data from a similar season last year and two years ago to see the seasonally relevant keywords.

 

Case Study: PPC for Online Music Shop

PPC Case Study: Increasing Website Sales

Web Designer Vip started providing PPC services to Sheet Music Direct in August 2011

In just one month, Sales doubled and the ROI was up by 65%

PPC Client

Sheetmusicdirect.com is the leading digital downloads service for musicians. They wanted a PPC Ad campaign to increase sales and boost their return on investment from online advertising.

 

PPC Objective

The PPC campaign objective was to increase the number of conversions and improve sales of digital sheet music, downloadable backing tracks and video music lessons from the website.

Web Designer Vip PPC Approach

To manage the PPC campaign for this online shop effectively, Web Designer Vip undertook

  • A comprehensive review of the PPC campaign including running reports followed by performance analysis
  • Daily monitoring and PPC optimisation
  • Various bidding options tested on some campaigns
  • New campaigns created and new products added
  • New ad copies added and existing ads improved
  • New destination URL’s tested

Web Designer Vip PPC Results

  • All major KPI’s for the AdWords campaign were considerably improved
  • ROI up by 65%
  • Conversion rate up by 27%
  • Number of sales doubled
  • Total sales value increased by 127%

 

Effective PPC management will give significant increases to existing campaign performance and the increased revenue from PPC campaigns will be significantly more than the PPC management fee.

 

Case Study: PPC for B2B Online Shop

Web Designer Vip provided PPC services to Welco from June 2010

Web Designer Vip helped Welco reduce the cost per conversion 4.5 times

PPC Client

Welco (part of the Brady group) sells industrial and commercial workplace equipment.The company had already been running a Google Adwords campaign. they had just upgraded their website to the latest Enterprise Magento platform and were looking for an experienced PPC agency to further improve the account’s performance.

PPC Objective

Following tha launch of new ecommerce store using the open source Magento platform, the PPC objective was to significantly improve conversion figures by increasing conversion rate, reducing the cost per conversion and increasing the number of transactions.

Web Designer Vip PPC Approach

Web Designer Vip took the following approach, combing both strategic planing and operational management of the account.

  • Comprehensive review of the PPC campaign including running reports followed by performance analysis
  • Initial AdWords account optimisation
  • Enabling conversion tracking for three types of conversions: sales, catalogue requests and contact forms.
  • Re-structuring the existing campaign
  • Performing a detailed keyword/market research in order to identify important terms or keywords that are missing in the current campaign
  • Adding a new products campaign
  • Ad copy optimisation: new ads tested, poor performing ads edited or paused
  • New landing pages tested using AB testing
  • Bid management at ad group level and keyword level
  • Multiple reports run in order to calculate profit and ROI at campaign / ad group / keyword level

Web Designer Vip PPC Results for online shop

Within the first month the results exceeded the initial targets set.

  • All Major KPI’s were considerably improved starting with the first month of this work
  • Cost per conversion reduced by 77%

Effective PPC management will give significant increases to existing campaign performance and the increased revenue from PPC campaigns will be significantly more than the PPC management fee.

 

Case Study: PPC for Online Tiles Shop

Web Designer Vip was first approached to undertake Adwords PPC optimisation and management for an online tiles shop back in 2010. The client were having difficulties in getting a good result from their Adwords budget and wanted to increase their return on investment in Adwords in order to grow their business

Adwords PPC for Tiles: Approach

After a full keyword analysis and examination of the conversion potential of the current online shop, we used our experience with ecommerce PPC to begin restructuring the account and adjusting the campaigns to boost the return on investment for the client’s PPC.

  • Bid optimisation for both long tailed and broad match keywords to grow revenue while boosting brand awareness in the marketplace
  • Consultancy and content suggestions to improve website landing pages in order to grow conversion potential and keyword quality scores
  • Testing and ongoing improvement to ad copy to encourage high clickthrough rates and improved conversion rate
  • Use of negative keywords to remove “wasted clicks” and make better use of available Adwords budget
  • Ongoing optimisation around keywords which produced highest revenue based on immediate ROI as well as more in-depth analysis in partnership with the client using % cost of sale modelling

Adwords PPC for Tiles: Results

The graph below shows paid search traffic growth over time (exact figures are not shown to preserve client data confidentiality). Click to enlarge.

The graph below shows the rising number of Adwords traffic conversions (purchases) for the tiles shop (exact figures are not shown to preserve client data confidentiality). Click to enlarge.

The graph below shows revenue growth for the tiles shop for the duration of Adwords PPC management work so far (exact figures are not shown to preserve client data confidentiality). Click to enlarge.

The site currently maintains levels of over 50% more relevant paid search traffic than it did when work first began. Typical results for any given month include (figures taken from real client data):

  • 10% more revenue year on year for Adwords traffic
  • 6% year on year increase in average order value from Adwords traffic
  • 8% year on year increase in revenue from non brand Adwords traffic
  • 9% year on year increase in Adwords traffic for the same clicks budget

 

Ecommerce PPC Case Study: UK Tile Company

Ecommerce Case study - online marketing Digital Marketing Case Study

Ecommerce PPC and SEO campaign for Walls and Floors – a leading online tile retailer.

Target

To increase the revenue from the ecommerce website via both paid search and natural non paid search (SEO).

Summary

Relevant visitors to site improved and revenue from website increased significantly

Our Approach

ExtraDigital tackled the online marketing following a strategic plan to gradually optimise the AdWords account and multi-activity approach for the SEO work.

  • Targeted PPC ad generation
  • Careful monitoring of PPC account to increase sales but maintain average spend
  • Optimisation of valuable product keywords to increase their search engine ranking
  • Offsite article and copy generation to improve SEO

Results

  • 54% more visitors to the site compared to last April
  • High ranking on Google for valuable product keywords