Array
(
    [position] => 1
    [fixed_position] => on
    [theme_sticky_selector] => 
    [display_scroll_offset] => 100
    [height] => 0
    [position_offset] => 0
    [display_after] => 1
    [animate_delay] => 0.5
    [auto_close_after] => 0
    [reopen_button_image_url] => 
    [reopen_button_offset] => 0
    [keep_closed_for] => 0
    [keep_closed_cookie_name] => wpfront-notification-bar-keep-closed
    [max_views] => 0
    [max_views_for] => 0
    [max_views_cookie_name] => wpfront-notification-bar-max-views
    [hide_small_device] => all
    [small_device_width] => 640
    [small_window_width] => 640
    [message] => All of our Training Courses are available online as self-paced learning. 
    [display_button] => on
    [button_text] => Find out More 
    [button_action] => 1
    [button_action_url] => https://www.daytodayebay.co.uk/online-remote-amazon-ebay-training-or-consulting/
    [button_action_new_tab] => on
    [button_action_url_noopener] => 1
    [button_action_javascript] => 
    [filter_date_type] => start_end
    [start_date] => 
    [start_time] => 
    [end_date] => 
    [end_time] => 
    [display_pages] => 1
    [include_pages] => 
    [exclude_pages] => 
    [landingpage_cookie_name] => wpfront-notification-bar-landingpage
    [display_roles] => 1
    [include_roles] => []
    [bar_from_color] => #231f20
    [bar_to_color] => #231f20
    [message_color] => #ffffff
    [button_from_color] => #ffd22d
    [button_to_color] => #ffd22d
    [button_text_color] => #231f20
    [open_button_color] => #00b7ea
    [close_button_color] => #555555
    [close_button_color_hover] => #aaaaaa
    [close_button_color_x] => #000000
    [custom_class] => 
    [custom_css] => 
    [last_saved] => 1648500299
)
eCommerce

Calculating the Cost of Google Shopping Changes

Key Dates:

Traffic from Google Organic

Click for Bigger Picture

13  February 2013 Google Shopping Transition Begins

End of June 2013

Google Shopping Change Complete

I am trying to find out the cost of not having Google Shopping lately. If I could
find how much traffic I am getting from Google Shopping, it would be great! Unfortunately, Google Analytics does not show traffic from Google shopping separately and is mixed with Google organic results.

Traffic from Google Shopping

However, Google Merchant centre shows daily number of clicks on Google Shopping feed. With this report I can now find out what is the average number of clicks from Google Shopping. Hurray!

Here’s the way I calculated cost of not being in Google Shopping:

  • Find out Avg. Clicks per day  – 100
  • Get Estimated Annual Traffic – 365 x 100 = 36500
  • Get Goal Conversion from your Analytics – 5.47%

(Only conversion from Google)

  • Estimated Sales = 5.47% of 36500 =  1997
  • Get Average Order Value from your Sales =  £20
  • Estimated Sales from Google Shopping =  1997 x £20 = £39,940

 I am also now able to find out percentage of sales Google Shopping is bringing to the business. 

  • Get Total Sales (eg. 2012) = £115,000
  • % of Sales from Google Shopping = (£39,940 / £115,000 )% = 34%

 It is a numbers game and the good thing is that you are now able to estimate the cost of not being there. As you can see above if your business is getting 34% of sales from Google Shopping it will be fatal not to think about it now.

There are quite a few experts around and if you happen to ready this post please comment your opinion !

After the discussion comments from Linked In, thought it would be good idea to show how to track Google Shopping Traffic with Analytics. Simply create a Filter as show in the picture below and you can easily track Google Shopping traffic from the filter day.

Google shopping Filters

Now you are sorted ! You can see traffic & Sales from Google Shopping. 

google shopping traffic

 

You may also like
Free Online Seller meet-up event in Newport next week
What is Boffer ?
footer content

As Seen On

error

Enjoy this blog? Please spread the word :)