Web Design, Internet Marketing, and SEO News

by seenBEST Web Design in Phoenix, Arizona

RSS feed for seenBEST Web Design news Entries (RSS)
Comments (RSS)
About Us
Log in
POLL QUESTION:  

Which social network do you use most often?

View Results

Loading ... Loading ...

Posts Tagged ‘software’

Internet Video Marketing

Thursday, April 26th, 2012

This article is part of a series of twenty articles. Click to read: The Top 20 Web Marketing Concepts Your Next Website Design Company Should Know

 

If a picture is worth 1,000 words, what is a video worth? Video is a great way for you to form a personal connection with visitors to your website, increase conversion rates, and drive traffic to your website from YouTube and elsewhere online. So why do most people avoid creating videos for their business? Many first-time clients say they are too self-critical or don’t have the time to bring their elaborate ideas to life.

 

Look, you don’t have to be a movie star OR have an Oscar winning idea to make a successful video! Just be yourself and talk about things you’re passionate about. If you want to do it yourself, a webcam and simple movie making software will do. Or seenBEST Internet Marketing can help. Our video packages start at only $500 and include idea brainstorming, writing a professional script for you, a recording session where we come to you and record the video using HD video and audio equipment, post video production and editing, and posting your new online and embedding it to your website.

 

 

We can record and publish to the internet for you:

  • Staff bio video
  • Highlights from your events
  • Corporate values
  • Training sessions
  • Landing page sales videos
  • Customer video testimonials

 

Could your Arizona business benefit from video marketing? We travel anywhere in the Phoenix and Scottsdale area. Call (602) 456-0150 for a free consultation.

 

A few examples of on-page videos:

www.mypctechs.com
www.socialnetworkarizona.com
www.weightlosshelpquick.com

 

 


>> Did you like this article? Ping it!

 



seenBEST Web Design

Email Marketing: Keeping Clients Informed

Saturday, September 24th, 2011

This article is part of a series of twenty articles. Click to read: The Top 20 Web Marketing Concepts Your Next Website Design Company Should Know

 
Email marketing is one of the easiest, most inexpensive ways to keep the name of your business in front of your clients on a frequent, consistent basis, and has become an exceptionally popular form of advertising. If you aren’t taking advantage of the benefits of email marketing, consider these statistics:

 

  • A study by the Direct Marketing Association estimated that email marketing would generate an ROI of $42.08 for every dollar spent on it in 2010, outperforming all the other direct marketing channels studied.
  • Nearly 90% of consumers use email (2010 Digital Marketing Fact Book).
  • In 2011, 88% of business-to-consumer firms and 71% of business-to-business firms are using email marketing (Forrester Research).
  • U.S. online retail sales (excluding auto, travel, and prescription drugs) are forecast to reach $248.7 billion by 2014 (Forrester Research).

 

So – what is email marketing?

 

Email marketing is sending electronic mail to a list of customers and prospects to deliver your marketing messages and help you stay in contact with people on your list. Companies send regularly scheduled emails to build customer loyalty and trust, increase sales, and strengthen brand recognition.

 

However, a successful email marketing campaign today is not just about selling your products or services. It is important to understand: consumers don’t want to be sold. According to the Custom Content Council, 73% of consumers prefer to get helpful articles rather than ads from companies. And 61% are more likely to buy from those companies. By sending relevant, informative email communications on a regular basis, you can build a strong relationship with your readers. This relationship will set you apart from the competition, companies that send messages that are often viewed as SPAM in the eyes of the recipients.

 

What are some of the benefits of email marketing?

 

  1. Save money and time – Email is an inexpensive and fast way to reach large numbers of people.
  2. Build your company’s reputation as an expert – If you are too busy to generate your own content, a professional online marketing firm can generate and publish industry specific content for your business.
  3. Grow your prospect list – There are multiple ways to expand your list of email contacts, from website embedded subscription forms, to social media, giveaways, events, and more.
  4. Keep your company visible – Put your name in front of people often so they’ll remember you when they or their friends need you.
  5. Track results easily – Numerous web analytics are available to learn how effective each email was and how to improve future email performance.
  6. All marketing campaigns increase in effectiveness – Combine email with social media, website, newspaper ads, bulk mail, and radio … and multiply the results.
  7. Communicate with people who want your email – Use opt-in lists and advanced email marketing tools to ensure the highest open rates and avoid being blacklisted.

 

There are several important ingredients that must be present in order for an email marketing campaign to achieve the desired results. Great content is only one of those ingredients, successful email marketers know that other processes must be followed closely. To create powerful results, email marketing campaigns must:

 

  • Provide fresh and relevant content.
  • Utilize regularly updated sources of email contacts.
  • Brand the email message properly at time of distribution.
  • Use a compelling subject line to cut through the clutter.
  • Maintain proper controls over the system of email distribution.
  • Empower email marketing with social media and sharing tools to help spread the message further.

 

Our team of online marketing experts at seenBest Web Design in Phoenix, Arizona, help your business maximize email marketing results. We help build email lists from client databases and other sources and then import those lists into the proper email marketing software, based on marketing objectives. We then help brand the email message to match your business cards, websites, and other marketing collateral. We provide content writing services that will create fresh, regular content to use in email marketing campaigns and help inform and energize your client base. From start to finish, we help your company create and manage a regular newsletter email campaign, including template design and content selection. We help embed newsletter/email sign-up forms on websites and utilize other sources, such as social networks, to expand your list and maximize the distribution of your message.

 

We have been helping businesses achieve their marketing goals throughout the Phoenix, Arizona, metro area since 1995. Contact us today for a free expert consultation and find out how we can help your business increase sales and maximize ROI through the use of email marketing. Call (602) 456-0150.

 


>> Did you like this article? Ping it!

 



seenBEST Web Design

Importing a CSV of products to Magento

Thursday, September 16th, 2010

We have recently designed a highly functional new online store for a client of ours using the advanced Magento shopping cart, taking eCommerce for this business to an entirely new level! We ran into a small snag during the initial stages of development as the client has a proprietary database system that stores detailed information for several hundred products. Their database software held everything from product name, pricing information, description. The client did not have the time to recreate all of the product information in the back-end of Magento using the built in tools. So, the challenge: How do we extract this information from their locally installed database information in a way that could be easily imported and put to work in Magento?

Fortunately, the database storing the client product details provides a mechanism to export product information to a CSV file. While it wasn’t pretty, the data was all there on the export. Sorting through 30 fields of data we didn’t need, we found fields for product name, model, color, asking price, category, and photo name. The trick now was figuring out how to map and then import this data into Magento.

The trick that helps you with a Magento import is knowing what’s absolutely necessary to import, and supplying that data in your own custom xls file. To do that, we added a product manually through the Magento interface. Here’s how:

  • Click on catalog/manage products
  • Click on Add Product
  • Click through to enter a name, description, short description, sku, weight, status (enabled), and set visibility.
  • Go to prices, enter a price, and tax class
  • Click to the inventory area and set an initial quantity, then change stock availability to in stock
  • Click to the category area and assign the new product to a category

Now save your product. If everything went according to plan, you will see your new product listed in your store under the selected category you selected previously. Great! Now that we have a functional product to work with, one that appears in the store, it’s time to export that data to a CSV file.

Exporting Magento items:

  • Go to system, import/export, profiles from the admin panel
  • Click on export all products
  • The default values are fine, CSV/Tab Separated, attribute names, all fields
  • Click on run profile to generate your CSV file

Now look in your Magento directory on your server, and find the var/export folder. The file export_all_products.csv will be on your server, download this to your local computer and open it in your favorite spreadsheet program (Excel works well!).

Now comes the tricky part. View export_all_products.csv side by side with a CSV of the data from your other database product. You are going to need to make the data from your previous database match the Magento data. I don’t want to tell you exactly how to do it, there are many different paths you can take to get to the same result. Find the fastest way that works for you. For me, it was as easy as deleting all of the columns from the old database CSV that weren’t used in Magento, renaming the column names to match similar columns in Magento, then creating columns that Magento needed that did NOT exist in the old data and pre-populating it with standard info. The fill function in Excel is extremely useful for this.

At the very least, you will want to make sure you have these columns:

  • store
  • websites
  • attribute
  • type
  • category
  • sku
  • name
  • url_key
  • url_path
  • price
  • weight
  • description
  • short description
  • status
  • tax_class_id
  • visibility
  • enable
  • qty
  • product_name
  • product_type_id

Try to be as complete as possible, and include as many (if not all) of the fields from the original Magento export as you can in your new set of data to import. Leaving out something important could result in a botched import!

When you’re all finished and, depending on the size of data you’re dealing with, several minutes/hours/days/weeks later, you will have a new XLS file that you can save, ready for import to Magento. Go to System, Import, Profiles. Import all products. Be sure to increase the “number of records” to a higher value, like 3, if you’ve already modified and improved your Magento memory settings. I also like to import using the MS Excel XML (save to this format first) as it’s less prone to data errors caused by improper characters in the data stream. Save the file as XML Spreadsheet 2003, change the data type, then use the upload file tool to upload your XML file.

The process CAN take a long time, so be sure you leave the import window up during the process. With a little luck, all of your products have been imported! There is a way to do this while including images, but it gets a little complicated. With the method I’ve discussed, you will need to go in and manually upload images to each item. While that can be somewhat labor intensive, I like having Magento create proper names and file sizes for me for each product.

Enjoy!


>> Did you like this article? Ping it!

 



seenBEST Web Design

Need a digital presence for your business?
Piece of cake! Call Us Now (480) 256-9010


Request a Free Quote

NAME:*
EMAIL:*
PHONE:*
MESSAGE:*
CAPTCHA*