West Palm Beach .Net User Group

September 2, 2009 15:42 by NielsenData

iNeta .Net User Group AssociationI'm please to be speaking at the .Net user group in West Palm, my old stomping ground!  Many thanks to Scott Klein, noted .Net author and coder for having me down to the beach to spend some time with the great folks down there.  I will be giving a lecture on the Atomic Data Model, the X-Y-Z method of site expansion, and an in-depth analysis of one of their website projects live while we discuss it.

The event will be held at the following address at 6:30 for pizza and 7:30 for the lecture:

1750 North Florida Mango
Suites 302 & 303
West Palm Beach, Fl 33409
561-840-8080

Get Directions

For more information on the Atomic Data Model, please see my blog entries about that at:  Atomic Data Modeling - Part 1


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

SEO Site Expansion and Atomic Data Modeling

July 24, 2009 08:59 by NielsenData

Jared Nielsen speaking at the Jacksonville Code Camp, August 29th, 2009 at the University of North Florida in JacksonvilleI'm grateful to the folks at the Jacksonville Code Camp (www.JaxCodeCamp.com) for expanding their sessions to include my latest search engine optimization and SQL Server 2008 atomic data modeling seminar.  I will be covering some exciting topics including how to leverage OLAP and OLTP technologies for their best uses in the Atomic Data Model, ways to expand the influence of your website using the X-Y-Z site expansion method, and ways to leverage atomic fragments of your long-tail keywords for search engine domination.

Be sure to register for the Jacksonville Code Camp today and join me for my seminar track at the University of North Florida on August 29th, 2009!

To see my profile at Jax Code Camp: Click Here >>

To see the list of sessions at the Jacksonville Code Camp: Click Here >>

To see the session brief:  Click Here >>

To register: Click Here >>


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Atomic Data Modeling and SEO Speech in Miramar Florida

June 24, 2009 19:53 by NielsenData

I'm pleased to be speaking to the Miramar group of the Florida Dot Net group at www.FlaDotNet.com.  You can register for this event at the following website:  Click here to register.  I will be discussing how proper search engine capabilities start at the database level using atomic data modeling practices.  The samples of the atomic data model will include how to layer in object inheritance at the SQL Server level, utilizing some new features in SQL Server 2008 including the intrinsic Hierarcy data type and a nice overview of search engine techniques that can benefit from a highly optimized and atomic database.  I hope to see you there!

You can get a head start by reading my blog series on the topic at:

www.NielsenData.com - Atomic Data - Best Business Practices for Product Catalog Data

There are other resources that ascribe to the Atomic Data Modeling concept which you can find at:

Zimbio.com - The Atomic Data Warehouse

Wikipedia.org - Data Warehousing and the use of Atomic Data within the Data Mart

Other announcements of this event include:


Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Speaking at the Houston Tech Fest

January 9, 2009 01:35 by NielsenData

 

Houston Tech Fest with Jared Nielsen Speaking for www.NielsenData.comIt's about that time again so I'm going to be speaking once again.  Please join me at the Houston Tech Fest in Houston (naturally) Texas for my seminar on finding your Search Engine and Data "Superman" amid your "Clark Kent" business.  Being able to identify as a coder the business methods needed to get proper search engine (SEO) rankings while satisfying good design criteria an reusability is important.  This seminar will walk you through such advanced topics as:

 

  • Atomic Data Modeling
  • Fast Page Load with Highly Normalized Data
  • Content Distribution Networks and Edge Caching
  • SEO and SEM Techniques in Code
  • Funneling "Juice" with your Web Traffic
  • Comparison Shopping Syndication
  • Expanding Marketing Channels through Code

Join my Houston Tech Fest Group on Facebook!


Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

That's No Moon... It's a Space Station! - JaxDUG seminar on SEO and SQL Database Design

October 29, 2008 11:20 by NielsenData

Jacksonville Developer Users Groups JaxDUG

In an obtuse blend of incisive marketing strategy combined with hard-core database design, I will be speaking at the Jacksonville Developers User Group on November 5th at the Seashell room in Building 500, Bank of America Building, 9000 Southside Boulevard, Jacksonville, Florida.

The first seminar in my series, "Jedi Mind Tricks for Business", I will be exploring the database work that can be done in anticipation of marketing's demands for high speed, infallible reliability, and no cost solutions for SEO integration of websites.... it's just the tip of the iceberg folks...

For directions, please see this link:

http://www.jaxdug.com/Events/MeetingLocations/tabid/63/Default.aspx

 


Currently rated 3.0 by 2 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Featured Story on CNN (TV and CNN.com)

October 29, 2008 11:14 by NielsenData

A nice thank-you to the guys at CNN for running the story of my cubicle on their evening news and on their homepage.  Wasn't expecting it but it was a nice kudo:

http://www.ireport.com/docs/DOC-33852


Currently rated 3.0 by 2 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Featured Story on Carpetology Blog

October 29, 2008 11:04 by NielsenData

Here's a fun article about the benefits of plush carpeting to complete my Extreme Cubicle Makeover:

 http://carpetology.blogspot.com/2008/08/carpet-for-your-tent-carpet-for-your.html

"Don't you agree that high design such as this in the workplace, particularly in a cubicle, can only elevate, enhance and improve?  I do have one suggestion. A larger rug. For that matter, what about wall-t0-wall carpet for this cubicle? It would add to the richness of the experience, help absorb unwanted noise from neighboring cubicle mates and generally enhance the work environment." - Christine Whittemore, Director of In-Store Innovation for Solutia's Wear-Dated carpet fiber.


Currently rated 3.0 by 2 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

e-Barnett.com implemented my earliest e-Commerce system

October 29, 2008 10:43 by NielsenData

Here's a blast from the past...

Barnett, Inc. Chooses 'AutoStock' Supply Chain And E-Commerce Management Software

http://findarticles.com/p/articles/mi_m0EIN/is_/ai_54534095

 


Currently rated 3.0 by 2 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

www.MrsStrong.com - Mrs. John L. Strong Stationers

October 29, 2008 10:27 by NielsenData

I was contacted by a gentleman in New York to do an evaluation of an e-business that caters to the luxury market in niche metropolitan areas.  Mrs. Strong Stationers provide high quality, high margin gifts and stationery through their website.

Below is my evaluation of their project:

MrsStrong.com

Search Optimization

META Information

Description

The Description tag needs to be adjusted to accommodate proper (but non-exploitive) repetition of critical keywords.  Reliance on mottos and standard phrases should defer to crucial keywords in order of precedence.  Instead of

Keywords

Keywords need to be analyzed in terms of conversion ratio per dollar spent.  When I search for “fine stationery” the site is not on the first page.  The initial strategy needs to rely on paid search initially to generate the required revenue boost and traffic load necessary to seed the natural search (see natural search below).

You are not capitalizing on misspellings, which are going to be more than common with the word “stationery”.  While the proper spelling is classy and elite, we want to be sure that we are diverting all traffic to us (regardless of grammatical correctness).  Consider registering domains and emphasizing keywords for “stationary” as well, even if they are demoted or concealed.

Keywords need to be analyzed for KEI compliance.  There are many combinations that should be leveraged throughout the home and landing pages.

Title

The title is key real estate to deliver your branding message and you are only delivering the name “Mrs. John L. Strong”.  Consider adding a keyword laced message next to it: “Mrs. John L. Strong – purveyor of fine stationery”.  This delivers powerful influence on the naturals.

Search Results

Prime Visibility

You are invisible on the search engines.  If you aren’t on the first page, you either don’t exist or you aren’t credible.  If PPC budgets are a concern, then we can take tertiary strength keywords and fund them (very inexpensive).  If budget is not an issue, then we launch a frontal assault on the higher ranked pages immediately with a well funded PPC campaign.  This will let them know that we’ve arrived and we’re not going anywhere.  Once the competition starts to figure that out, it will put pressure on them to up their budgets and start an arms race.  While we just increased the costs of our competitors, we will quietly be vacuuming up all the secondary and tertiary keywords that are inexpensive but have far higher conversion rates.  Our $ per conversion will increase while theirs will decline substantially.

We need to tune the natural search carefully to drift somewhat away from the “what we are selling” element to the “how your life will change by buying our products” tone.  This will give us ample opportunity to channel the search engines to that rich keyword-laced content, while the “shoppers” are not diverted from buying.  This is done with a carefully constructed pattern of NOFOLLOW and precedence placements in your layout.

Standout Imagery is not being utilized on the search results and skyscraper advertisements.  By layering in Google Checkout as part of your payment offering (very plebeian I know..) it provide outstanding visibility of your PPC placements on page 1 of the search results.

The Homepage is very focused on branding and is torpedoing the SEO power of the home as the primary landing page.  It does a decent job of segmentation, but fails to deliver proper search engine visibility due to keywords being embedded in graphics or FLASH, choosing look over function, and other factors.   We can re-engineer the page without losing the “style” but it must involve certain sacrifices.

Consider layering in <div> injection on the FLASH so you can stream useful text to the search engines while the customer sees the graphical immersion you want.

Page Mechanics

Load Speed

The page loads are interminably slow.  You are selling “lifestyle” to people that hardly have the time (or interest) to wait for anything.  If you want to preserve the “style” then move the primary DNS of the site to an edge caching network which sources from your original origin servers.  I will have to do an analysis that verifies that this won’t pollute your viewstate or postback integrity, but once that is done your page load will decrease from 21.54 seconds to 0.5 seconds. That is a whopping 4200% increase in speed and must have an impact on your conversion ratio.

I found as I was “browsing” the catalog that I didn’t want to wait for even the product thumbnails so I ended up cruising through the site without seeing the products at all… Until I ended up on the product detail page.

FLASH Considerations

Your use of FLASH has pros and cons, but the current implementation lacks the proper Javascript for modern browsers that “activates” the FLASH.  This adds an unnecessary click and an annoying popup on all modern browsers… see below:

 

Page Compression

Modern browsers support GZIP page compression which your website is not utilizing.  This leaves your modern browsers with an experience that is as slow as the older browsers for no reason.  This could cut your page load speed down significantly.  Speak to your hosting provider to enable this for your site.

Page Weight

The size of your page is an astronomical 3,121,587 bytes.  Compare this to the target size which should be 100,000 bytes.  The longer a page loads, you exponentially lose conversion power.  This also has various other disadvantages (chances for errors go up, bandwidth costs exponentially rise, local machines slog through your site, etc).

Consider a cleanup where images are streamlined and made web-ready, FLASH is demoted from integrally packaged images to asynchronously called from web services, dynamically cached constructed images, etc.

Rewritten URLs

You are not leveraging URL aliasing.  This eliminates an extremely powerful influencer on the natural search penetration of your site.  Nobody is going to search for “.php?ID=746” to find your site… so don’t show that to them (or the search engines).  Consider the URLs like www.mrsstrong.com/catalogue/page.php?cPath=23_32 and then compare that to www.mrsstrong.com/gifts/calendars/Pagoda_Calendar .  It’s clear to see which one would provide better conversion and natural search rankings.  Consider the use of a standardized URL Rewriter with database lookup so it’s automated and you don’t end up out of sync with manually maintained URL rewriting configuration files.

Traffic

Traffic Profile

 

The site came on the scene in 2007 and is fading in the face of steep competition from the other sites.  This is 100% due to lack of an effective PPC, affiliate, and natural search strategy.

You should analyze the crane.com and finestationery.com websites for competitive intelligence.

Analysis

Analytics

I note the use of Google Analytics, but no use of Website Optimizer or Conversion Analysis.  You need to expand your analytics penetration to flag landings and conversions.  I also highly recommend cart interim analysis tags that can help you determine cart abandonment rates and other factors (like conversion values, etc).

Pull Marketing

Email

Cart Abandonment

Your site doesn’t leverage cart abandonment which is a critical step that carries an additional 20% conversion “re-bonus” if it’s implemented properly.

Email Registration

The instant email confirmation email is timely but has several flaws (See the incomplete domain information):

 

The email is also lacking any analytics or tracking beacons that will enable you to measure email acceptance.  This is an important strategy in email conversion rates.

Branding is always important.  This confirmation email is a perfect time to layer in graphical or stylistic branding.  Consider a stylized signature and elegant HTML wrapping that is compatible with the majority of email clients.  This can also facilitate proper beaconing.

New Account Registration

The new account registration as placed can act as friction to the ordering process.  Because of the likelihood that a popup will distract the customer from completing their order, it makes sense to put a “continue your purchase” link in the email that direct the customer (if they click on the popup from their mail client) back to the ordering process they were distracted from.   This is effectively a “dead end” page that interrupts a very important process flow.

Branding in this confirmation email could be tastefully done and would facilitate more beaconing.

The suspension of disbelief is important to maintain.  Calling the storefront an e-boutique rather than boutique has the tendency to shock them out of the disbelief that they are actually “in a boutique.”  Consider treating the website as a normal boutique in the phrasing and tone of the site.

The additional “thank you for registering” page is an unnecessary click and interrupts the process flow of the site.  Cart abandonment is the most difficult challenge, so eliminating this in lieu of a thank you message on the cart is preferable.

Checkout

Security

The Gift Options tab exposes the internal database customer ID value that is otherwise concealed in the osCsid.  This could be exploited by a savvy hacker to reveal information about the customer.   It also makes it somewhat easier to decrement the value and try to “surf” other customers.  Having sequential customer IDs is rarely a good idea.

Shipping

The concealment of the shipping rates can cause a customer to click “back” once they are at the checkout_payment.php page because they may not be sure what the shipping rate is.

I like the implementation of the multi-ship feature.  It may make sense to have the chosen shipping address to persist for items added subsequent to the shipping address being chosen.  Drag and drop would be very elegant here.

Payment

There is no confirmation of the payment amount at the time the credit card is being asked for.  This can have a significant impact on conversion.

Customer Memory

The browser forgets the user if the session is lost.  This requires a customer to log back in, even though the session timeout wasn’t met.  Anonymous checkout will resolve this to some degree, but you need to have a longer term cookie for persistence so you can capitalize on personalization.

Account

Anonymous Purchase

Not everyone wants to deliver their full profile information just to shop on your site.  Certainly you will harvest certain data from their credit card information, but the anonymous checkout feature has the benefit of reducing friction in the order process.  This will increase your conversions.

Payment Methods

Gift Certificates

There is no method of redeeming a gift certificate online.  This can be a powerful conversion tool, particularly for past-deadline shopping (too close to Christmas)

There is no method of obtaining an electronic gift certificate.  I realize this may fly beneath the level of the type of class the site is attempting.  There may be a “classy” hybrid where the online gift cert is designed to work with an iPhone for example, so we are borrowing some corollary brand equity from someone else that reinforces and “floats” the brand without drifting into the “tech” branding.

 

Currently rated 4.0 by 4 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Atomic Data - Best Business Practices for Product Catalog Data Structures - Part 1

October 29, 2008 09:42 by NielsenData

This is the first installment in a series that blends website architecture, data structures, and SEO marketing into a collaborative design pattern.

Designing a product catalog is one of those "better get it right" projects that any e-commerce firm faces.  When you discuss lifespans of projects, this one has the longest lifespan of them all.  Since I've been through this a couple of times, I thought I would share my thoughts and designs as I delve into yet another one.

There are a lot of political and technical pressures put on a product catalog from many departments within an organization including IT, Marketing, Executive, Operations, and particularly the "Industry Expert" within any company.  It is important to not only recognize them, but to appreciate them.  At the end of the day, almost everyone is "right" in their desires to have the catalog data serve them in a certain way.  As you put yourself in their shoes by doing a proper discovery before you start designing you should try to not only understand what they want, but why they want it.

Atomic Data

Your marketing team will call this "flexibile product information", your IT team may call this "dynamic product data", but at the end of the day, it's product data that is smashed into all of its discrete component pieces.

This is one of the first pressures that will be placed on you and you need to be prepared to deal with it properly.  It is important to understand that there is a competing struggle in any database design... Flexible vs. Fast.  If you think of a product as a construction made from legos, then the properties of those products are the individual lego pieces.  The concept of "atomicity" means that you can assemble your lego construction with Red, Blue and Green legos to make a space ship... and then you can rearrange those same Red, Blue and Green legos and build a house.

Now you've all seen the non-atomic way of building a product.  It's a row in a product table and it tends to look like this:

 

You are limited however when you decide to stock a product that has a "Sub Sub Type", or a product that only has one color, or a product that has two vendor brands on it.

You also have a design flaw where you are "numbering instances" of properties.  In this case "Color1" and "Color2" are going to cause problems for you when you want to search by "Color".

There is also a failure to properly "atomize" the data with things like "SubDept" being equal to "Ladies Apparel".

Let's compare this model to one that is fully "fourth normal" or highly "atomic".

 

Lets analyze this model.  The product is statically registered in a much abbreviated product table.  It serves now primarily as a hook that you can hang things from.  We've decided to establish all of our atomic types as "Type", "Gender", "Vendor", "Brand", and "Color".  You can see how this can be reused.  For the "Live Strong Velocity Ladies Sport Top" it makes sense that Color (to this product) "means" White and Yellow... but to other products the same property of "Color" could "mean" other colors.

You can also see the intrinsic hierarchy here that establishes "Apparel" as a "top category" over "Top" and likewise, "Top" as a parent category over "Tank Top".  This enables you to still utilize hierarchies in your product data representations while granting you also the ability to search ad-hoc through your product data in a non hierarchical manner by using the raw properties.

 I have taken an apparel data model and created a good sample of how the property to product mappings for a decent catalog could be structured:

 

This model describes the relationship between products and properties but also illustrates some of the intrinsic relationships between the properties themselves.  For example, if you mapped a City to a product, you could "infer" what State and Country relationship existed by recursing through the Property-to-Property relationships.

So... which data model is right?  The answer could likely be ... Both!  It really depends on your requirements which we will discuss in Part 2 - Best Business Practices for Product Catalog Data Structures - Speed versus Flexibility.

  

Currently rated 4.0 by 2 people

  • Currently 4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5