Archive for the ‘E-Commerce’ Category

More Accurate Google Analytics

Friday, January 23rd, 2009

I was recently reviewing the Google Analytics for the site here, and noticed that the traffic was rather high. Upon further investigation I found that many hits where coming from myself! Well, on a smaller traffic blog such as this, having very many “self” visits included might give one a false indication of traffic. Another area this might cause bloated traffic is if you have multiple users editing, viewing or otherwise interacting repeated on your site.

For me, I found this out after viewing the Maps portion of my analytics and seeing that my home state had the most traffic. I do promote a bit locally, so I investigated further. At that point I realized that the majority of visits were from myself – adding posts, previewing them, checking the site, checking changes etc. So, what is one to do? I filtered my IP from the analytics.

Now I can do this because I have a static IP. Don’t have that? Ask your ISP, most for a small charge will set it up for you and for small monthly charge let you keep it. This way, the static IP can be filtered from your analytics results and not impact the bottom line on your view of traffic.

To accomplish this filtering process, once logged into Google Analytics click on the Analytics Settings. Next, under the Actions column in the row of the site you wish to add the filter to, click edit. At this point, you want to find the Filter section, and choose Add New Filter. This will give you something like the image below, where you can choose from several options to filter from. You can choose to filter domains, IP addresses and more. The one you want to select is Exclude All Traffic From an IP Address.

filtersetup It is important to note how the IP address is notated: 192\.168\.0\.1 – notice the backslash before the period. You can exclude a single IP address by including all four octets or you can exclude and entire range by including fewer octets: 192\.168\.0\. note that it ends with the \. this will exclude all hosts on the 192.168.0. network. So if you have multiple users in your company that view your site repeatedly with multiple IPs from the same network, you can effectively exclude all visits from staff this way.

Reblog this post [with Zemanta]

Web Development & Design Portfolio

Thursday, January 15th, 2009

Billy J. Nab's Portfolio

Billy J. Nab's Portfolio

The new web design and development portfolio has been launched, and is now available. New samples and references will be added over the coming weeks, so keep checking back for updates to it! It currently highlights the past three years of experience, being the most relevant. It will begin to feature more graphic design samples and much more programming examples as I prepare them and add to them. Having nearly 8 years worth of code to sift through and find relevant and still viable samples for today’s web has been a challenge, but one I have been meeting head on.

You can find it here: Billy J. Nab’s Portfolio

Reblog this post [with Zemanta]

Amazon, PayPal and Unauthorized Transactions

Thursday, December 18th, 2008
paypal credit card!
Image by laihiu via Flickr

I logged in to my PayPal account yesterday only to notice a charge attempting to come through for Amazon.com on my PayPal Debit card. The funny thing is, the only purchases I have made at Amazon.com this year were paid using a different card, and those transactions have already cleared with the card issuer.

So begins finding out what is going on.

1:30AM Mountain Time

First call was to Amazon.com’s 24-hour customer support. The lady that answered the phone was very friendly, though had a thick accent and obviously didn’t have very good English skills. How do I know this? After providing my email address nearly 4 or 5 times and she still had it incorrect I got the feeling she didn’t understand the basic alphabet when spelled out, even using phrases such as A as in apple, B as in boy to clarify the letters.

So then on to order numbers. I provided her with two order numbers, neither of which she could find in the system. Imagine that. They were placed with Amazon merchants, not directly with Amazon, and thus I explained this to her. Again, she verifies the order numbers and no surprise she had at least 2 digits wrong in each of them, so now I have the feeling she can’t even understand numbers 0-9. So we verify 3-4 more times the order numbers.

At this point, we are nearly 20 minutes into the support call and she still has yet to locate my account, so I ask if she can look it up by my name, by a credit card number, by my address or anything else. She says she can’t do that and mumbles about something else. Finally she puts me on hold for nearly 3 minutes and then comes back asking for my name so she can pull up my account. Mind you I have explained at this point 3 times that the purpose of the call is to report a fraudulent charge coming from Amazon.com to my debit card, that is unrelated to my purchases last week, since they used a different card and had already cleared the issuing bank.

So she pulls up my account, notes the two order from last week, which is amazing since she claimed to have had the proper order numbers before. She then asks which order I am disputing. I explain to her I am not disputing any of the items or order, but I am trying to file a claim of fraudulent charges coming from Amazon.com. She puts me on hold again for several minutes.

After she comes back on the line, the first thing she asks for is my debit card number. No explanation, just “May have your debit card number sir?” I ask her why she needs that at this point, considering she had so much trouble finding me in their system, considering she couldn’t get the order numbers proper and considering she has misunderstood the entire purpose of the call. She said she would like to start an investigation into my orders and needed the debit card number. I explained, once again, that it was being used for an order I DID NOT place. She says she is not sure how she can help me with that, but it would help if she could get my debit card number anyway. At that point I ended the call.

8:30AM Mountain Time

I call PayPal customer support, input the code given from the customer support web site, choose my menu options properly and get to a live person in under 2 minutes. Now that’s cool. The lady that answers the phone pulls up my account, verifies a few bits on information the first time, no problem. She obviously can understand English much better than the Amazon customer service representative I spoke to about 7 hours ago.

She sees the two authorizations that have been attempted by Amazon.com, for $1.00. I validate that I have not used the PayPal debit card on Amazon.com to complete a purchase, though for a time it was listed as one of my payment methods with Amazon.com. She says the card number was probably compromised, or someone has inadvertently switch digits in their card making it the same as mine, which has happened in the past. She notes the best thing to do is to cancel the card and issue a new one. I agree.

Within less than 6 minutes, PayPal answered my call, verified my information, canceled the debit card, issued a new one and apologized for any inconvenience, even thought it does not appear that they are at fault. Take that Amazon.com!

For an interesting read on what I feel may have happened, just check out this blog post here about a potential credit/debit card hack happening. A quote from there reads, “Amazon seems to be a current favorite, based on the fact that a number of the irate forum posters recently shopped there.” The issue in my case is, this card was not used on Amazon.com during my purchases, and in fact the card that Amazon.com was trying to authorize had not been used in several months, since September 2008.

Reblog this post [with Zemanta]

Available for Freelance and other work

Monday, October 6th, 2008

I am currently accepting new projects, either on a freelance basis or on an employment basis. The employment basis may be either a temporary, temp-to-hire, contract-to-hire or direct hire situation. At this time I am not available for relocation, so local opportunities (those that are not available via telecommuting/offsite work) must be within the Front Range to Southern Colorado area.

Use my contact page if you are interesting in discussing any potential opportunities.

PHP – Creating Effective User Acces: Database Design

Wednesday, October 31st, 2007

Okay, when we look at creating effective user access, the first thing we have to look at is the database design. As I mentioned in the overview post of this series, we will not look in-depth at how to connect to a MySQL database, the code will be shown, but not explained. However, we do need to explain a decent table layout, as well as define what tables are needed in our example here.

One thing I should mention is some specifics that I will be basing the rest of this series off of, in others here is the list of requirements I am going to meet. While the list is not extensive or exhustive, it provides a good base to which you should be able to extend to fit your requirements list.

  1. The site needs to log users in and out.
  2. The site needs to keep users logged in for a minimum of 15 minutes.
  3. The site needs to keep users logged longer if they desire to choose “Remember Me”.
  4. The site needs to authenticate on all pages.
  5. The site needs to logout users by session timeout, cookie timeout and user forced logout.
  6. The site should log all login attemps, whether successful or not for security purposes.
  7. The site should be able to provide the user with their last login date and time.
  8. The site should operate over a secure connection.
  9. The site should lock an account after three unsuccessful login attempts, if the account login name is correct and the password is wrong, and it should stop accepting submissions if the user name is not found within three attemps and log the error.

On to the MySQL database definition…..

(more…)