Logo Lira
  • Home
  • Services
    • eCommerce PPC Management
    • Shopify PPC Management
    • eCommerce PPC Audit
    • Google Shopping Management
    • Performance Max Management
    • Microsoft Shopping Management
    • Amazon PPC Services
    • Real Estate PPC Management
    • SaaS PPC Management
    • Lead Generation
    • Bing Ads Management
  • Portfolio
  • Blog
  • Resources
    • Library
      • eCommerce
      • SaaS
      • Real Estate
    • Downloads
    • E-commerce Glossary
    • ACOS to ROAS Calculator
    • Shopify Google Shopping Feed
  • About Us
    • Team
    • Google Premier Agency
  • Contacts
Get in touch
Logo Lira
  • Home
  • Services
    • eCommerce PPC Management
    • Shopify PPC Management
    • eCommerce PPC Audit
    • Google Shopping Management
    • Performance Max Management
    • Microsoft Shopping Management
    • Amazon PPC Services
    • Real Estate PPC Management
    • SaaS PPC Management
    • Lead Generation
    • Bing Ads Management
  • Portfolio
  • Blog
  • Resources
    • Library
      • eCommerce
      • SaaS
      • Real Estate
    • Downloads
    • E-commerce Glossary
    • ACOS to ROAS Calculator
    • Shopify Google Shopping Feed
  • About Us
    • Team
    • Google Premier Agency
  • Contacts
Get in touch
  • Home
  • Services
    • eCommerce PPC Management
    • Shopify PPC Management
    • eCommerce PPC Audit
    • Google Shopping Management
    • Performance Max Management
    • Microsoft Shopping Management
    • Amazon PPC Services
    • Real Estate PPC Management
    • SaaS PPC Management
    • Lead Generation
    • Bing Ads Management
  • Portfolio
  • Blog
  • Resources
    • Library
      • eCommerce
      • SaaS
      • Real Estate
    • Downloads
    • E-commerce Glossary
    • ACOS to ROAS Calculator
    • Shopify Google Shopping Feed
  • About Us
    • Team
    • Google Premier Agency
  • Contacts
  • Home
  • Services
    • eCommerce PPC Management
    • Shopify PPC Management
    • eCommerce PPC Audit
    • Google Shopping Management
    • Performance Max Management
    • Microsoft Shopping Management
    • Amazon PPC Services
    • Real Estate PPC Management
    • SaaS PPC Management
    • Lead Generation
    • Bing Ads Management
  • Portfolio
  • Blog
  • Resources
    • Library
      • eCommerce
      • SaaS
      • Real Estate
    • Downloads
    • E-commerce Glossary
    • ACOS to ROAS Calculator
    • Shopify Google Shopping Feed
  • About Us
    • Team
    • Google Premier Agency
  • Contacts

Home > How Web Analytics Helps Identify Breakdowns in eCommerce Websites and What Actions Should Be Taken by Online Marketing Team (Real Case)

E-commercePPC

How Web Analytics Helps Identify Breakdowns in eCommerce Websites and What Actions Should Be Taken by Online Marketing Team (Real Case)

April 2, 2021 by Aleksandr Akhmadyrshin

We will share a case from our practice — how we discovered a breakdown in the payment system of an online store, what reports were used and what actions were taken.
The article will be useful not only for digital advertisers but also for owners or
managers of e-commerce projects. At the end of the article, there is a useful feature and
advice on Google Smart Shopping campaigns, which are rarely written about.

 

 

Briefly about the project: our client is from Russia, he has an online store on the Shopify platform for the USA market. Our agency works on sales through digital marketing within the specified budgets and target profitability. The main revenue is generated from PPC, on average 75-80%.

How the Problem Was Discovered

It’s easy to detect if something is wrong with the payment system when all payments fall off at once. The revenue graph immediately drops to zero. You can’t miss this.

But it’s different when only some of the payments get cancelled. As it happened to us — only payments by credit cards were not functioning, but everything worked with online payment systems (in our case, PayPal). The graph declined smoothly.

Shopify Analytics Report: At First Glance, Revenue Decline Looks OK

IMPROVE YOUR E-COMMERCE SITE

Need professional E-commerce PPC Audit? We are here to help!

Get in touch with us and receive a free audit.

Get in Touch

The breakdown occurred on March 8th, in the middle of the day. First two days of the recession were not taken seriously. That wasn’t that level where you have to take it seriously. The PPC worked properly. It looked as if the chart would any day hit the rising wave again. But from that moment on, we kept a closer eye on the report.

On the third day, we saw a continuing recession, and we started to look for the reason.

The first thing we checked was the availability of best-selling products in stocks as the lack of these items caused a prolonged recession previously. Sometimes best-selling items can be sold out faster than the new deliveries are planned (the client transports goods to the USA from Russia, where the production is located under its own brand, transportation takes up to 3 months).

The best-sellers were checked in the main Google Shopping Campaign, which generates most of the sales. Everything was in stock except one item that was not a clear sales leader. Rather, all revenue was distributed evenly across several products. In addition, sales revenue generated by this product did not match the volume of the downturn. Conclusion: the sold-out product did not have an impact on the main recession.

3 products

To check the availability status of a product in the Google Shopping campaign, you need to go to the Product section and sort the products by Conversion Value, the availability status will be in the Product Status column

As a next step, we’ve checked if there were any distortions in the traffic by the channels. All channels worked without anomalies. It turned out that at the top level, user behavior did not change, interest in our products has remained the same. The next logical step was to go down to the deeper levels of the funnel. We checked the conversions from stage to stage: Visiting the product card → Adding a product to the cart → Checkout → Transaction. And here deviations were found.

4 transactions and checkout shipping

Custom dashboard in Google Data Studio: transactions went down, while checkouts remained the same

Checkouts and transactions tend to correlate among themselves due to a constant conversion rate. The correlation was interrupted on 03/08 — a clear sign of a problem.

Such a problem can be seen only in reports where data is presented in dynamics. Tables or other dashboards with static numbers won’t help. Combined charts work best — you can check all stages of the funnel at once.

Engineers of the agency are setting up such reports in Google Data Studio for each project. This allows us to receive basic information on the KPI of the project online and track other important indicators.

How the Problem in the Payment System Was Identified

We already knew that the reason for the recession was a breakdown of the payment system. Suppose we didn’t, then what should we do after looking at the recession graph? After all, there may be several reasons: sending form stopped working, the payment page won’t open, some features of the website have fallen off, conversion tracking tag has been removed accidentally, the price is not shown at the checkout stage, etc. All this might happen. There is only one way — each hypothesis must be followed and tested, starting with the most expected one.

Shopify platform provides a great report on abandoned checkouts for e-commerce stores. That’s what we checked at first.

4 abandoned checkouts

Shopify report on abandoned carts with completed checkout 

In this report, you may want to dig deeper into each abandoned order and see all the data of each one of them. Valuable information we’ve found — the history of payment processing errors.

One of the users tried to make a payment 4 times, but he did not succeed.

We found many refusals like that. There were visitors who tried to pay 7 times from 3 different cards, waited for some time, and then tried again. These were clearly targeted and loyal customers. The very first error message just happened on March, 8th, i.e. matches entirely with the beginning of the revenue recession. The problem was found.

The error was reported to the client. It turned out that he received email notifications from QuickBooks (software responsible for accounting). Support service wrote about problems with the QuickBooks Merchant Services Account. But the request was not promptly taken into work and was skipped afterwards. The problem could have gone unnoticed for a while.

The error in all payments was as follows:

[{“code”=>”PMT-3000”, “type”=>”account_error”, “message”=>”The merchant account could not be validated.”, “infoLink”=>”https://developer.intuit.com/v2/docs?redirectID=PayErrors“}]

On March, 11th the problem was fixed with the help of QuickBooks technical support, payments worked. But that’s not all.

What Had to Be Done After Troubleshooting

After everything was fixed, it would be logical to relax and calm down. But two resulting problems appeared, which could be passed by due to inattention. First, we’ve got a lot of lost customers. Second, ad campaigns using smart strategies received incorrect conversion data within three days. These problems had to be fixed as well.

Email Newsletters

Emails were sent for all those from abandoned checkouts immediately on the day the payment error was fixed. We offered a discount and promised that now everything is working and the purchase can be completed. It was done to smooth the situation. We managed to return 13% of customers.

Adjustments of Google Ads Campaigns

The main revenue of the store is generated by Smart Shopping Campaigns,  bidding strategy — “Maximize conversion value”. Smart Shopping campaign sets bids on auctions, chooses places, devices, time, audience, etc. It does it in a way that increases conversion rates and value for a given budget every time.

The indicator that everything is going well is the conversion rate (transaction rate in our case) and targeted profitability. If you have a sufficient number of conversions and required profitability, you can continue to work with the founded audience, if you have no conversions — you have to cut off the audience.

Within three days, Smart Shopping campaign connected with the right audience who wished to make a purchase but could not because of technical errors. The machine learning algorithm recognizes this audience as an incorrect one and excludes it. Hence, even after fixing the problem, we could not get back to the previous conversion rate.

But this could be fixed. In Google Ads, you can exclude data on which algorithms were trained. In practice, it is not a sufficiently known tool, and it wasn’t written much about it though the benefits from using this option are significant. 

Data Exclusions in Google Ads

7 data exclusions

Data exclusion interface in Google Ads

To exclude data, go to the Shared library → Bid strategies → Advanced Controls → Data exclusions → Click on the “+” button, then choose settings you need and save. Details can be found here.

After being excluded, the data does not get erased and can always be found in reports. But the algorithm stops learning from it.

Data exclusion is useful in case of any technical failures of a website or the tracking tag — when data is distorted or not being transmitted at all. But you should not get carried away with it, otherwise, it will backfire.

 

Today, optimization of advertising campaigns comes down to improving the quality of data on which machine algorithms are trained. Managing this data could help a business to succeed. 

We have shared one of the data management tools with you. We hope this article will help you find necessary reports and improve advertising campaigns. Also, you can always request the setup and support of your advertising in the agency.

Check out other valuable articles and guides in our e-commerce PPC library.

If you have any questions, write them in the comments or use the special form to send a question in case it contains confidential information.

e-commerce ppc
How to Cope With Google Smart Shopping Campaign And Take It to Stable ResultsHow to Cope With Google Smart Shopping Campaign And Take It to Stable ResultsFebruary 9, 2021
5 Must-Have Shopify Apps That We Use to Scale Ecommerce Sales at LiraMay 26, 20215 Must-Have Shopify Apps That We Use to Scale Ecommerce Sales at Lira
5 1 vote
Article Rating
Subscribe
Login
Notify of

0 Comments
Inline Feedbacks
View all comments
Subscribe to Lira Blog Updates
PPC insights for experts and newbies
* = required field
Featured author image: How Web Analytics Helps Identify Breakdowns in eCommerce Websites and What Actions Should Be Taken by Online Marketing Team (Real Case)

Artem Akulov

Hi! I'm the Founder & CEO at Lira Agency. Welcome to our blog! Ask questions and share your insights in comments.

Recent Posts
  • 13 Best Advertising Platforms for E-Commerce May 12, 2023
  • Google Shopping Ads: How to Use Them Effectively to Drive Sales April 28, 2023
  • ACOS VS ROAS March 23, 2023

Earn 2x Revenue with Lira

Enter your eCommerce website:

    Logo Lira

    Making strong companies all over the world even stronger with thoughtful PPC management

    [email protected]

    Google Premier Partner Lira Agency

    Facebook Business Partner Lira Agency

    Privacy Policy | Terms & Conditions

    Copyright © 2023 Lira. All Rights Reserved

    #integrio_button_6472facc6bfe3 .wgl_button_link { color: rgba(253,253,253,1); }#integrio_button_6472facc6bfe3 .wgl_button_link:hover { color: rgba(253,253,253,1); }#integrio_button_6472facc6bfe3 .wgl_button_link { border-color: rgba(33,107,34,1); background-color: rgba(33,107,34,1); }#integrio_button_6472facc6bfe3 .wgl_button_link:hover { border-color: rgba(66,150,43,1); background-color: rgba(66,150,43,1); }#integrio_button_6472facc6bfe3.effect_3d .link_wrapper { color: rgba(33,107,34,1); }#integrio_button_6472facc6e990 .wgl_button_link { color: rgba(255,255,255,1); }#integrio_button_6472facc6e990 .wgl_button_link:hover { color: rgba(255,255,255,1); }#integrio_button_6472facc6e990 .wgl_button_link { border-color: rgba(33,107,34,1); background-color: rgba(33,107,34,1); }#integrio_button_6472facc6e990 .wgl_button_link:hover { border-color: rgba(66,150,43,1); background-color: rgba(66,150,43,1); }#integrio_button_6472facc6e990.effect_3d .link_wrapper { color: rgba(33,107,34,1); }#integrio_button_6472facc79cb7 .wgl_button_link { color: #ffffff; }#integrio_button_6472facc79cb7 .wgl_button_link:hover { color: #ffffff; }#integrio_button_6472facc79cb7 .wgl_button_link { border-color: #216b22; background-color: #216b22; }#integrio_button_6472facc79cb7 .wgl_button_link:hover { border-color: #216b22; background-color: #216b22; }#integrio_button_6472facc79cb7.effect_3d .link_wrapper { color: #216b22; }#integrio_soc_icon_wrap_6472facc800d5 a{ background: #216b22; border-color: #216b22; }#integrio_soc_icon_wrap_6472facc800d5 a:hover{ background: #3c8e25; border-color: #3c8e25; }#integrio_soc_icon_wrap_6472facc800d5 a{ color: #ffffff; }#integrio_soc_icon_wrap_6472facc800d5 a:hover{ color: #ffffff; }
    We use cookies to store your preferences and visits in order to provide the most relevant experience. By clicking "Accept All", you accept ALL cookies. Visit "Cookie Settings" to make changes.
    Cookie SettingsAccept All
    Manage consent

    Privacy Overview

    This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
    Necessary
    Always Enabled
    Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
    CookieDurationDescription
    cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
    cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
    cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
    cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
    cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
    viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
    Functional
    Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
    Performance
    Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
    Analytics
    Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
    Advertisement
    Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
    Others
    Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
    SAVE & ACCEPT
    wpDiscuz