Posts

by on

Nate Bargatze once observed that his neighborhood handyman had a business card that said confidently, “How hard could it be?” I know enough about the latest version of WordPress to be dangerous – to myself and others. So when a customer asked me to make a WordPress site exactly like their old site on a new domain, of course I said, “Sure. How hard could it be?” Copy and paste, right? Well, not exactly.

The existing site runs on an earlier version of PHP code. The latest WordPress installation uses the latest PHP. Using files from the existing site to build the new site meant updating everything to PHP 8. I know how to how to feed pages into Anthropic’s Claude A.I. engine to make those updates, but the process was going to take me weeks, and when I say, “weeks”, I mean months, while I work on other stuff.

So, rather than start by installing the latest WordPress release (6.9) and then layering in the old look and feel, called a “Theme,” I decided to work backwards, doing a literal copy and paste of the existing database into a new one on the new domain, and another copy and paste of the operating system and theme files.

SQL Databases connected to various WordPress sites as they appear in a web host control panel

Then, I could go into the database and make any updates right in the database files. Note it’s not the recommended method whatsoever. Why did I do this? The new site worked fantastically well from the visitor’s perspective. The pages looked good. The navigation worked perfectly. There was only one problem: all the usernames and passwords I needed to login to the “backend” of the site – where you can do the editing using WordPress’s handy site editor – didn’t work, at all. And my attempts to reset passwords got me nowhere.

Now a WordPress developer, someone who works with PHP all the time, would have a much better idea of the glitches that were making it impossible to get into the site editor. Well, I am not that guy. But as you already know from the title of this post, there is a “guy” who knows all about every version of WordPress, and every version of PHP. His name is Claude.

Claude solved my problem in roughly 20 seconds.

Here’s what I asked:

I have a WordPress site at [example].com that I built by copying the database and files for the site at [old-example].com Because I built it as a copy, without actually going through the WordPress installation process as discussed here. I can’t seem to login with the usernames and passwords found in the tables of the SQL database. How can I get a username and password to login to [example].com?

Before I could even grab a second cup of coffee, Claude gave me not one, but three, options to fix things, with varying degrees of difficulty. Actually, the options were all examples of copy and paste! You just had to know what tools to use, and Claude explained what those were and exactly how to use them.

I had already tried the second option he gave me, so I tried the first, and BOOM, problem solved. I didn’t even need to mess with the third option, which was the most technical. (But, again, it was copy and paste into a database editor called “phpMyAdmin,” an app that’s readily available in any web hosting website.)

Why use Claude instead of ChatGPT? Aside from the question of which company has an inkling of a moral compass, Claude simply did a better job of explaining things in terms I could understand. Try pasting my rambling prompt above into ChatGPT and you’ll see what I mean. It makes a lot of assumptions about my level of understanding when it comes to databases and tools used to modify them.

In addition to the three options, Claude gave me a bunch of other suggestions for related issues to check on and fix, things I would not have thought of. As a WordPress expert, Claude knows how to address a website’s PHP programing as a whole, like a good mechanic who can see that your tires are worn when you bring your car in for an oil change.

Kudos to Claude. I’ll definitely be going back to “him” the next time I get stuck with WordPress, PHP, and whatever else hangs me up – like how to do without dating apps?

by on

In case you haven’t heard, ChatGPT is new software that uses artificial intelligence (along with human “trainers”) to answer questions. Like many forms of natural language-based AI machine learning, the human trainers refine the answers and tell ChatGPT how it can improve them. Some answers to basic questions are surprisingly good, and others are not so hot.

The widespread excitement around ChatGPT is that it may replace human writers in some cases, or significantly reduce the time required to do less important writing work. Is this a huge leap forward in a long line of robot-based solutions to the need for written content? Microsoft is investing billions in the company that created ChatGPT, and is thinking about giving it a shot at improving search results in its Bing version of Google search. But, at least for the foreseeable future, I don’t think it’s going to be as successful as all the latest buzz suggests.

According to knowledgeable sources, the Bing search engine will probably be using ChatGPT to answer some questions in its search results pages rather than what it currently offers as the “best” results. Why? Because they hope to beat Google at satisfying users, getting people to switch to Bing, and generating more ad revenue. Which one will win, ChatGPT-generated results or results from Google’s proven and constantly improving search algorithm? TL;DR Google.

As with Bing search results in general, Bing’s are currently inferior to Google’s. Let’s compare the search results for “chat gpt” in Bing vs. Google. Bing offers the Wikipedia definition for “Chat Generative Pre-Trained Transformer” as the first result at the top left of the page AND in the sidebar on the right. Redundant results are unhelpful.

Bing search results for "chat gpt"
Above: Bing search results for “chat gpt”

Google, on the other hand, offers a link to a page on the website of the company that created ChatGPT, OpenAI – along with other helpful links to the site, including the homepage – as the first result. Which of these is more useful? For one thing, the title of the Google result begins with the search term itself: “ChatGPT”. If I’m searching for “chat gpt” and not “chat generative pre-trained transformer”, I may not even know it’s the same thing. As the user experience saying goes, Don’t Make Me Think. Also, Google shows me the primary source, the most authoritative source for the explanation, from the OpenAI website, AND it puts the Wikipedia result in the sidebar at the top of the results page. Google lets me choose which one to read. Choice versus redundancy. Which do you prefer?

Above: Google search results for “chat gpt”

Most people will click the first result at the top left, rather than the one in the sidebar. This has been proven in many tests done on search results. But, if human readers do want more information from what is probably the second best result, Google offers the Wikipedia definition on the right.

And let’s think logically about the answer to the related question: Which result will be more authoritative and useful to the human reader, Wikipedia or ChatGPT’s AI generated result? Right now, the obvious answer is Wikipedia. It’s written by humans, curated by humans, and edited by humans. The best ChatGPT’s AI can do is APPROXIMATE Wikipedia and/or OpenAI’s answers. Human readers want human answers. ChatGPT is an ARTIFICIAL substitute. Could ChatGPT do better than either one? Maybe, just maybe, in the future. Right now the answer is clearly No.

Microsoft Bing is essentially going to perform a pointless A/B test. When the results are in, Google will win, and they won’t even have to lower the quality of their own results to do so.

Bing search results for “chat gpt”
(Author’s note: My blog post above was written on Jan 31, 2023. As of Feb 2, 2023, Bing results appear to have changed to match Google, and ads are appearing above the organic results.)

Google search results for “chat gpt”

by on

Here’s a look at Insect Shield’s growth in 2020 and 2021 on the organic search channel. Our business is highly seasonal, peaking in the spring. Compare April 2020 traffic to April 2021.

I did the work myself using Shopify, SEMrush, Google Search Console, Screaming Frog, Google Analytics, various keyword research tools, and a lot of hands on experience gained over the years.

Note the progress we have made against our number one competitor, Amazon. We overtook them in June of last year. Today our visibility in SERPs for high conversion rate keywords like “insect repellent clothes”, “women’s insect repellent clothes”, and dozens more, is 43% vs. their 31% (bottom chart).

In July 2021, we added commercial content to one of our top informational search intent pages about insects. We saw a drop in overall traffic, but a significant improvement in conversions from that landing page. We will continue this strategy with other informational pages in 2022.

In the B2C world, very few eCommerce websites can beat Amazon for commercial search intent keywords, which is one reason B2C companies have to sell on Amazon to keep up. Amazon is no longer just an additional sales channel, it’s an absolutely essential sales channel. But which one would you rather have rank number one in search results on Google and Bing?

Do you want to pay the 15% fee to Amazon, as well as having to constantly give in to their methods of squeezing you on profit margins AND get no access to user information, like email or SMS messaging sign ups, and return purchase and life-time value metrics? Or would you rather sell from your own website, keep your own profit margin, and get all that highly valuable user data? The choice is obvious: optimize your own website for organic search, and then, of course, optimize your Amazon product descriptions for search, as well. McBuzz Communications can help you do both.

by on

Shopify was the right choice for our new ecommerce platform.

On January 12, 2021, Insect Shield moved from a first generation ecommerce platform called Able Commerce to Shopify. The difference has been striking.

Making improvements to usability and search engine performance is so much easier. Things that would have taken hours using a $125/hour developer can now be done in 60 minutes or less by a $75/hour contractor. Adding pages, making updates, edits and basic SEO can be done quickly and easily in-house.

The selection of apps available to add features and functionality is truly amazing. We use an insanely good, free app for our affiliate program that would have cost thousands of dollars to integrate with our legacy web platform.

Most remarkable is what happened to our ecommerce conversion rate. Our organic search conversion rate went from 4.2% to 6.3%. Paid search CVR went from 4.6% to 6.4%. And, as you might expect (because Shopify is a modern, user experience-focused platform), our overall conversion rate on mobile increased by 36%: from 2.7% to 3.7%. When 60% of sessions are on mobile, a 3.7% CVR drives serious revenue growth.

We transferred a solid site structure and nice look-and-feel over from our old site, but the conversion rate success is primarily due to Shopify. None of us at Insect Shield has second thoughts about moving to the new platform.

Insect Shield's ecommerce conversion rate for organic traffic increased from 4.2% to 6.4% YOY March through June.
Organic conversion rate year-over-year from Feb 28 through June 26 (dates offset to align days of the week)