Your Excel formulas cheat sheet: 15 tips for calculations
Manage inventory and sales channelsTools and services for Amazon sellersTools and services for eBay sellersFind and buy profitable inventoryHandle challenges of cross-border tradeManage orders and shipmentsGet outside help to growAccounting, taxes and loansAutomate pricing and track competitorsManage reviews and seller feedbackSell on social media and web storesExclusive deals for membersThis posted was originally published in January 2014 and updated in June 2017.For sellers who only have a few product lines in an uncompetitive niche, monitoring the pricing of competitors is easy – they can simply update their prices manually. This is a great position to be in, but it is not the reality for most sellers. The majority need many SKUs to be successful and often face stiff competition. These sellers need to automate repricing in order to survive.Despite this, a number of sellers are concerned about using marketplace repricing software as they see automatic repricing as a “race to the bottom”. This is a logical argument, but not necessarily correct as repricing is about more than simply having the lowest price.So in this post, I will demystify repricing software: what it is, how it works, the differences between repricing on eBay and Amazon and, ultimately, how to choose the right tool for you.In essence, marketplace repricing is simply a seller making changes to the price of products they offer on platforms like Amazon and eBay. They might do that for any reason, but typically it’s in response to competition.On marketplaces, the offers from different sellers are shown side-by-side so buyers can compare prices very easily – uncompetitive prices disappear into the background noise. To be successful, sellers need to find a way to rise above the crowd.There are three factors that best characterize marketplace repricing today: huge scale, easily available automation technology, and the sophisticated seller ranking algorithms that marketplaces use.The volume of activity on marketplaces like eBay and Amazon is enormous, and the scale of repricing is huge too. For example, Amazon.com implements more than 2.5 million automated price changes every day to stay competitive not only with other sites, but also merchants selling on their own third-party marketplace. High street retailers like Walmart and Best Buy also change their prices constantly – in their cases around 50,000 times each month.Major retailers have been “spying” on each other for decades, and setting their prices accordingly – before the internet they would send staff to competing stores to manually note down prices. Ecommerce has made price comparison easier for the retail establishment, and also made automatic repricing possible for marketplace sellers of almost any size. Repricing tools are available as standalone services, or as part of integrated marketplace management tools. Repricing software is itself a competitive market, with plenty of options available.The third factor is the most complex: successful marketplace repricing is not just about price. Amazon and eBay have sophisticated algorithms which decide how sellers rank for every product and keyword search – price is not the only factor they consider. The seller with the lowest price does not always sell the most.Repricing? Hell yeah! Even simple rules work on Amazon, without software. One of the businesses I’ve worked with gets an extra 1,000 to 1,500 orders every single week because of automatic repricing. It’s amplified because their competitors don’t have repricing software, but still it’s obscene what it can do. Matthew Ogborne, Co-founder, UnderstandingE.comIn the Web Retailer directory, we cover the following categories of repricing tools:Marketplace repricers allow more sophisticated rules than simply “be the cheapest”, or even work without rules and determine automatically which price will maximize total profit. Sometimes repricing software will actually raise prices – using one does not commit a seller to the race to the bottom, and can even help avoid it.You can get repricing software in one of two ways: as a specialist tool that just does repricing, or as part of an integrated marketplace management system.Specialist repricing tools have the typical advantages of most single-purpose software:On the other hand, if you already use a marketplace management system and it includes a repricing function, that should be a quick and inexpensive way to start learning about repricing, even though you might move to a standalone repricer later.If you are considering changing your marketplace management system (or thinking about using one for the first time), it’s worth investigating its repricing support. It is not a core feature like inventory, listing or order management though, so it’s not worth changing to a management system for its repricing support if it’s lacking elsewhere.Browse the directory for Marketplace Repricing tools, including reviews, news, related discussions, compatibility information and pricing.Current listings include XSellco Price Manager, FeedVisor, RepricerExpress, Appeagle, Sellery, PricingLab Smart Price, AlphaRepricer and many more.Price tracking tools allow you to monitor the activity of your competitors. You can get data on their prices, promotions and any changes to their catalog, for instance whether an item is out of stock. These tools won’t make automatic changes to your prices. They provide you with actionable data on your competitors and it’s then down to you to make the changes accordingly.The data is collected by “scraping” online retailers and marketplaces. You choose what you want the tool to scrape and it starts collecting information. The price tracking tool then yzes the data and creates reports. You can either view these online or download the raw data for use in your ecommerce system. Some trackers also have APIs that you can make use of for more direct integration with other systems.Browse the directory for Price Tracking tools, including reviews, news, related discussions, compatibility information and pricing.Current listings include Competera, Competitor Monitor, Incompetitor, PriceLab, Pricing Intelligence, Prisync and many more.Repricing is still very much associated with Amazon, so it’s not surprising to see almost all repricers offer Amazon support.The important question to consider is if you want to reprice on any other marketplaces. Relatively few repricing tools support eBay. Of those that do, ChannelMAX and Appeagle rely on listings being associated with eBay’s product catalog– they can only reprice cataloged items against other cataloged items. Price Spectre supplements catalog IDs with keyword matching and claims good accuracy with that approach.The directory has separate categories for repricing tools that are compatible with Amazon and compatible with eBay.Most repricing tools have low entry-level pricing, and remain very affordable even for a high volume of 20,000 SKUs. For high-volume sellers with very thin margins, RepriceIt followed by RepricerExpress, ChannelMAX and Mean Repricer are all well under $100 per month for 20,000 SKUs. They do differ in update frequency, however.Four repricers position themselves at the top end of the market: Marketplace Repricing, WisePricer, FeedVisor and Teikametrics. Sellers new to repricing, even if they have very high volumes, would benefit from learning on an entry-level tool rather than a high-end repricer. But those with sizeable budgets and repricing experience might benefit from taking a demo of a high-end system, to see if they offer any additional opportunities.All repricers allow more sophisticated control than simply beating the lowest price by a penny. Many provide that control by allowing the user to define a set of rules that tell the repricer what to do for a specific product or group of products, for example:Rules-based repricing offers a huge amount of control, and that flexibility can be very useful. The downside is the time and effort the seller needs to spend deciding what the rules should be, and configuring the system.The alternative approach is algorithmic repricing. You only need to provide an algorithmic repricer with the minimum price you are willing to accept for your products. The system will then use its own predefined rules, competitor data and price experimentation to find the optimal price – one which maximizes sales while keeping the price as high as possible.Note that with algorithmic repricers you rely entirely on the effectiveness of their algorithm – two algorithmic repricers could achieve quite different results. In contrast, two rules-based repricers with exactly the same configuration should set the same prices.ChannelMAX is an example of a rules-based repricer, offering sixty repricing rules. FeedVisor is a purely algorithmic repricer, having no rule settings at all. Appeagle allows the seller to choose either rules-based or algorithmic repricing, on a product-by-product basis. WisePricer also supports both rules-based and algorithmic repricing.Repricers vary quite widely in how often they will check for price changes. For example:Frequency matters most when competition is high, particularly if competitors are also repricing. At peak sales times, waiting an hour or more to react to price changes could result in a significant loss of sales. Sellers with highly seasonal trading could look for a solution which allows the frequency to be “boosted” temporarily rather than committing to a higher fee in the long term.When people talk about marketplace repricing, they are often – without even mentioning it – only talking about Amazon. For many, marketplace repricing and Amazon repricing are synonymous.It is possible to reprice automatically on other marketplaces, but on Amazon the practice is more common and the technology more mature. There are three important factors driving that: the strength of the Amazon catalog, the “Buy Box”, and Amazon’s own support for repricing technology.From the outset Amazon has been underpinned by a product catalog. On Amazon, it is not possible to list a product that isn’t connected back to the catalog, although you can add new products to it. If you do add new products, they become part of the core catalog and other sellers can offer them too.The catalog-driven nature of Amazon means it’s very easy to find a specific product. In fact, if the catalog is working as it should, each unique product will exist only once and have a single product detail page. That is in stark contrast to eBay’s listing-driven approach where searches often yield thousands of results for the same product.When a product has one description, one set of images, one collection of reviews, and so on, there is relatively little left to distinguish between multiple sellers of that product. How does that affect Amazon sellers? Well, they must do their utmost to optimize the few attributes under their control – and the one thing Amazon sellers can control fully and frequently is price.When a group of Amazon marketplace sellers get together the conversation will quickly turn to the Buy Box, and specifically to “winning the Buy Box”. The tone will run the whole gamut of enthusiasm, resentment, confusion and violent disagreement. To the uninitiated, the heated conversation will be completely baffling.The Buy Box is simply the box at the top right corner of the product detail page which contains the “Add to Cart” (or Basket) button. The format varies, but an example is shown here. (This particular Buy Box is for a product that is not available new either from Amazon or a third-party seller who uses Amazon FBA to fulfill their orders.)Winning the Buy Box means being the seller who gets the order when a buyer adds a product to their cart and completes check out – in the example shown “my Goods” has won the Buy Box.There is common ground on the criteria for determining the Buy Box winner:The last one, customer experience, is where Amazon lumps in a whole bunch of other factors. Those factors are used to determine Buy Box eligibility, which is just the possibility of winning the Buy Box, and include:Amazon do not disclose exactly how the different factors interact, where the cut-off points are, or what the other metrics might be.Amazon’s Buy Box algorithm is sophisticated, constantly being updated and tuned, and is certainly not transparent.Feedvisor have produced a comprehensive guide called The Buy Box Bible. They have given me permission to reproduce the summary “Cheat Sheet” from the guide below. Download the full guide for a lot more information on each metric.Amazon doesn’t allow repricers to completely run riot on their marketplace. Pricing errors have happened in the past, including a mundane book about flies being repriced to over twenty million dollars, and a repricer malfunction in 2012 causing thousands of items to be listed for a penny.To prevent customers being disappointed by erroneous prices, Amazon detects potential errors and can deactivate affected listings. Sellers can avoid this by setting minimum and maximum prices or by opting out entirely (or UK version, Amazon login required).Browse the directory for Marketplace Repricing tools that are compatible with Amazon, including reviews, news, related discussions and pricing.Sellers who concentrate just on Amazon or eBay can have polarized viewpoints on the merits of each marketplace. That’s not surprising: eBay’s roots are as a trading community, while Amazon has always been a retailer in its own right and is an unusually ferocious competitor (see The Everything Store).Repricing is one of the many areas where eBay and Amazon sellers differ: it’s much less common on eBay. I think this could be down to the eBay selling culture and eBay’s approach as a listing-driven marketplace. Interestingly, there is a very important factor pulling in the other direction: eBay’s Best Match algorithm.eBay has a product catalog, but its use is optional except for some electronics and media categories (UK version). A lot of the time the catalog is not used, and sellers can always add their own images and description.Even the listing title (which a layperson might expect to be an unambiguous way to identify the product for sale) is normally optimized, by using the maximum number of characters allowed and including popular search keywords.What this means is that it is much more difficult to identify identical products on eBay than on Amazon, and therefore to reprice accurately. It’s not unusual for eBay sellers to dismiss repricing on eBay as unacceptably risky, unnecessary or even impossible.Despite the difficulties of repricing on eBay, there are automatic eBay repricers available. The developer of dedicated eBay repricer Price Spectre, NullApps, has explained in the Web Retailer forum and on their own site how they are able to reprice on eBay – by supplementing catalog listings with keyword matching.Not a lot of eBay sellers think about repricing tools, but they should. If you are selling new items, have a condition to only monitor new items and don’t go against auction items – just monitor fixed price. You might run into some listings that are incorrect, so look in your system to see if there are any issues or errors once in a while. As long as you set it up correctly the first time, you shouldn’t have any issues. Carlo Silva, CEO, 2nd OfficeeBay’s default sort order for search results is Best Match. eBay have been honing the Best Match algorithm since 2008, and although it has not been yzed to the same extent as winning the Buy Box on Amazon, there is expert opinion and seller observations indicating that quite similar factors are considered, such as:Several other factors have been suggested as having an impact on Best Match, but without much consensus or compelling evidence. For example, there are reports that eBay’s search engine penalizes listings with a sophisticated design. If this really does have an effect, I think it is more likely to be due to poorly formatted HTML and not just the presence of a design.Best Match is our measure of the Buy Box for eBay. When we manage to land the space in Best Match that’s a measure of success for us. Amazon has their rules well documented – how you get into the Buy Box position – eBay does not have those rules quite as well down, so they fluctuate a little bit. It’s a very hungry baby to make sure eBay repricing works effectively. Zee Mehler, Chief Marketing Officer, AppeagleeBay and Amazon differ in many ways, but most dramatically in the display of products offered by multiple sellers. Amazon shows a single product page with the Buy Box showcasing the best offer, and puts other sellers’ offers on a separate page. eBay shows all sellers’ listings as search results, and orders them to show the best offers at the top.But if Amazon took the full list of sellers’ offers and made that their primary product page, or eBay consolidated all their separate product listings onto one page and showcased the top offer, the two marketplaces would look very similar.The effect of both Amazon’s Buy Box and eBay’s Best Match is almost identical – to push low-priced products offered by sellers who provide great customer service to the forefront . Amazon’s Buy Box and eBay’s Best Match aren’t all that different, so why shouldn’t repricing be as effective on eBay as it is on Amazon?Browse the directory for Marketplace Repricing tools that are compatible with eBay, including reviews, news, related discussions and pricing.The “race to the bottom” or “race to zero” is closely associated with automatic repricing. It’s a logical argument: if sellers consistently beat each others’ prices, even by a small amount each time, prices will inevitably drop to a level where sellers are losing money and have to exit the market, or go out of business.After prices hit rock bottom you might expect them to rise back to a stable level. But with very low barriers to entry, new sellers can quickly come on board and start the race again. On eBay in particular, there is a constant churn of new sellers who will compete desperately on price – either to build feedback, clear inventory they have overpaid for, or simply through inexperience.So how can sellers avoid joining the race to the bottom, or at least minimize the impact it has on them? That’s a question that goes to the heart of selling on marketplaces, and it doesn’t have a straightforward answer. Sellers cannot just remove price from the competitive landscape, but they might be able to sidestep the problem and avoid competing solely on price. Here are some suggestions.On eBay, you can distinguish yourself as a seller in a number of ways. For example:Encourage buyers to trust you as a seller, help them understand exactly what you are selling, and clearly explain why they should buy it. Take advantage of eBay’s flexibility, because none of this is possible on Amazon (except if you add your own products to their catalog – but even then only to a limited extent).Branding is so essential. Decide if you are selling in a category, and pick a branding that has some kind of tie and invokes an emotional response in your buyer. If you’re selling everything under the sun, have a strong brand that’s consistent but almost emotionless. Elizabeth Hitchins, Freelance Consultant, KidsonTalksNot having the lowest price may reduce sales, but it is not necessarily the kiss of death. Both Amazon and eBay include many factors in their algorithms – sales can certainly be made without having the lowest price. And if your competition isn’t up to scratch in other areas, even more sales can be made without having the lowest price.On Amazon the Buy Box can rotate between multiple sellers, if the algorithm ranks them equally. eBay provides a more level playing field as Best Match determines only the order of results, not a single overall “winner”. The important thing to understand is that it’s not an all-or-nothing battle on either marketplace.Retail can be simplified quite dramatically: in order to succeed you either need to be the least-cost provider or you need to offer something that nobody else has. Both of those fall to your buying processes – focus on buying the right products at the right price. Once you’ve got the right products, you can position them differently and you can approach different channels. Dan Burnham, Head of Account Management, eSellerProHow do you offer something nobody else has? Sellers have to answer that question themselves, and it will not be easy. If it was, everyone else would be doing it and it would no longer be something nobody else has (also the central fallacy of most get-rich-quick schemes).There are, however, models for sourcing and product creation that are used often and can be successful:Online selling is a retail business. Small businesses who sell only online may not think they have much in common with the old world of high-street retail, but when it comes to sourcing and developing products there is not a vast difference. Learning and inspiration can be found by studying traditional retailers as well as online competitors.Buyers want low prices, and the marketplaces, whose business it is to satisfy buyers, do a fantastic job of getting those low prices for them. Marketplace sellers can choose to sell competitive products (which the majority are) or try to carve out a unique niche which protects them from direct competition – even if it’s only for a little while.The reality is that most sellers will offer products that many others also sell. In that case, it’s crucial to have competitive prices. In an environment where millions of sellers are present, the job of manually monitoring the competition and adjusting prices is hard – often prohibitively so. That’s where automatic repricers come in.Repricing is not a silver bullet for eBay and Amazon sellers, but nothing is. It’s a type of automation that should be assessed and measured, and adopted fully if it provides a positive return on investment. The marketplaces automate their decision on who the best seller is, so every marketplace seller should work to understand how that decision is made and use everything they can to make it work in their favor.A good one to read folks. I am looking forward to have live discussion on this topic tomorrow 7- 8 pm with #oswtalkInteresting read. However, one area that is not addressed in terms of repricing is the effect it could have on customer perceptions. One of the reasons we have not embraced repricing tools is the potential for customers to pay one price and see it lower, from us, the next day. Most of my customers will need to by many of our products regularly and I am hoping to convert them to our website. Additionally, Amazon, at least in the US, doesn’t allow you to have a higher price on Amazon than your lower price on any other site. So, you would have to reprice your website as well as Amazon, Ebay, New Egg, etc. The additional work and potential negative view by customers would seem to make repricing counter productive.Thanks Jack. I remember discussing buyer perceptions with a repricing tool supplier when I was researching this. They thought that buyers were generally unaware of repricing, and I am inclined to agree. But I can see that might be different with repeat purchases of the same product – as you have pointed out.“Price Parity” is mentioned under “Step Three: Choose Products to Reprice” and as you say it is still in force in the US, though not in Europe. You would have to set the maximum price to the price on your site to ensure your Amazon price doesn’t go higher.I think the main thing is that every business is different and repricing won’t be right for everyone. Still it may be worth considering – perhaps it would work for just some of your products?As a seller for 15 years I tell you this article is perfectly written and extremely informative. Congratulations and keep the good writing.Hi Andy, Your list appears to omit AMan Pro which has repricing as well as order and listing management. AMan Pro has a free, fully functioning 21 day trial and costs $49.99 per month or $499 per year regardless of the number of SKUs.Thanks Kevin – http://www.spaceware.comThanks for this, Andy. It’s a great overview of repricing tools. Easily the best one out there.great article. im new to this and it has given me a lot of helpful info to start with. thank youA good and fair article Andy. A little tip I learned when I used to drop ship (I now solely buy in products). There was another seller who carried the same products from the same drop shipper. Whereas my repricer was set to ‘price match’ +/- 10% of my RRP the other seller would undercut by 1p. This was just a race to the bottom until I was selling everything at 90% of RRP. I therefore set the repricer to be +2p and sure enough my price increased by 1p every hour and so did his until several days later we reached the next seller or 110% of my RRP. He still had the buy box, maybe 60% of the time compared to my 40%, but at least I was making a good return on the sales.So, as Andy says in the article, use the repricer wisely and spend time setting the initial criteria to avoid the ‘race to the bottom’.I am shopping for a repricer. I would like to know how Splitly compares with the tools you mentioned. Thank youHi Casey, thanks for commenting.Splitly is an Amazon listing split-testing tool, which can be useful when you “own” your listing e.g. private label or a traditional brand. It’s not a repricing tool for competitive listings – i.e. listings with offers from multiple sellers.Hello Andy, I can not say enough how much I enjoyed the article. I read it again today. I have a few more questions for you if you do not mind: 1. Splitly.com has a repricer called Profit Peak. what do you think of them? 2. I own 100% buy box of my products. I believe it is still beneficial for me to use repricer to stay competitive. do you agree? Which repricers would you recommend, that is specialized in gaining competitiveness rather than Buy Box? 3. I intend to find out the optimal price to charge for my products> ( My current margin is 35-40%. there is wiggle room). do you think I can accomplish the goal while using an algorithm-based repricer? 4. would you be able to elaborate on when to use rule-based vs algorithm-based repricer? Million thankscaseyHi Casey,Very few repricers are designed for private label products where the competition is against other products rather than for the Buy Box for the same product.So I think you would need a tool that is very specialized for private label repricing. Profit Peak that you have found is one, although it’s really a split-testing tool for pricing rather than repricing against competitors directly (I’m not saying that’s a bad thing – just different). Sellery from Seller Engine is a “normal” repricer but it has the ability to change pricing based on sales velocity, stock levels and inventory age. They’ve written a good piece on that here: https://sellerengine.com/how-to-use-sellery-to-effectively-boost-private-label-sales/Feedvisor launched a private label repricer a while back but I can’t find any information on that any more.In summary, for you (and private label sellers in general) I don’t think it’s a case of rules-based vs algorithmic but more about whether to price manually or use one of the few repricing/testing tools that has good PL features. This might be a gap in the market!On June 26th I read the updated version of this article that was posted. It had a nice matrix chart showing all the repricers, each benifit and cost. I did not take a screen shot but I wish I did.It appears that the chart has been removed or the link to it. Is there a way I can get it back? It was very helpful and I wasn’t expecting it to disappear after I bookmarked this article.Hi Jim, thanks for the comment.Apologies for removing the chart. I know it was useful but it also caused confusion as it was only showed a small selection of the repricers out there and it was difficult to keep up to date. Instead we are putting our efforts into the repricers category of our directory. It doesn’t provide as much information at a glance as the matrix, but when you go into each listing there’s a lot more depth including user reviews.Thanks Andy for the quick response.I do understand the reason but I don’t have the time to study all of them or subscribe to their trial period as some of them don’t tell you the cost up front.If anyone does take the time to put the matrix back together, please share.ThanksYour email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of comments by email. You can also subscribe without commenting.
Free Expense Tracking and Budget Tracking Spreadsheet Best Photos of Daily Expenses Worksheet - Free Printable Daily ... Expense tracker, Printables and Toddlers on Pinterest 1000 ideas about Expense Tracker on Pinterest | Budget Planner ... 8 Best Images of Business Expense Tracker Printable - Free ... Printable Expense Tracker | BLACK DECKER Laminating 1000 ideas about Expense Tracker on Pinterest | Budget Planner ... Expense tracker, Free printables and Printables on Pinterest Expense Tracking Template - 7 Download Free Documents in PDF ... Almost Debt Free: Expense Tracking with the Queercents Free ... Expense Tracking Template - 7 Download Free Documents in PDF ... Expense Tracking Template - 7 Download Free Documents in PDF ... Expense Tracker Spreadsheet Download Excel Personal Expense Tracker - 7 Templates for tracking ... Revealed: My End of the Month Money Tracking Ritual (Free Income ... 8 Best Images of Business Expense Tracker Printable - Free ... 1000 ideas about Expense Tracker on Pinterest | Budget Planner ... FREE Printable Expense Tracker (and instruction sheet ... Best Photos of Expense Tracking Sheet - Expense Tracking ... Monthly Blog Income and Expense Tracker - Free Printable Using our free SEO "Keyword Suggest" keyword yzer you can run the keyword ysis "expense tracker" in detail. In this section you can find synonyms for the word "expense tracker", similar queries, as well as a gallery of images showing the full picture of possible uses for this word (Expressions). In the future, you can use the information to create your website, blog or to start an advertising company. The information is updated once a month. The list of possible word choices used in conjunction with 'expense tracker'List of the most popular expressions with the word 'expense tracker'Top SEO News (July-August, 2017)The Italian Antimonopoly Authority fined WhatsApp service developers for 3 million euros. This information was reported reported by Reuters. According to the agency, WhatsApp imposed conditions on the users that obliged them to agree to data transfer to Facebook parent company. In particular, they were persuaded that without agreeing on this they would not be able to continue using the service. The WhatsApp press service commented on this situation the following way: "We are considering this decision and preparing a response to the authorities." The supervisory authorities of all EU countries demanded that WhatsApp last year to suspend the transfer of Facebook data because of users’ doubts' in agreeing on the conditions. The fact that WhatsApp will open Facebook access to the user base became known in August 2016.Google My Business has launched a new tool using which users will be able to create a free business card website for their company. You need to verify ownership of the company page in My Business to access the tool. The data and photos placed on it will be used to create the website. The website appearance can be configured, and its contents supplemented. If you change the company’ data, the website will be automatically updated. In addition, it will be optimized for cross-platform devices. Having created a website you can publish it immediately or do that later. A window that offers you to create a website appears after the confirmation of the company page. This function is also available in the "Website" menu. For more information about this feature see the Help Center. According to Google, 60% of small businesses do not have their own website. With the help of a new tool they will be able to create them.Google reports that in the coming months, it will completely stop cooperation with certificates issued by WoSign and StarCom certification centers. The change will take effect with the release of Chrome 61, which is expected in mid-September. It will affect the certificates issued before October 21, 2016, the period of validity of which has not yet expired. Last year, Google Chrome 56 stopped trusting the certificates from WoSign and StarCom, released later October 21, 2016. After the release of Chrome 57, the browser partially stopped trusting the old certificates. An exception was made for websites that are among the first million in the Alexa rating. From now on, all certificates from these centers will be banned. "Starting with Chrome 61, the white list will be removed, which will lead to a complete cessation of trust in the existing root certificates of WoSign and StarCom and all certificates that they have given out. Websites that still use certificates from StarCom and WoSign should urgently consider replacing them, so as to minimize any inconveniences to Chrome users," reports Google. It should be recalled Mozilla announced about freezing its cooperation with WoSign and StartCom in September 2016. Starting with the Firefox 51 the certificates are considered to be invalid. At the same time, the support of certificates issued before October 21, 2016 is still preserved.Google’s spokesman John Mueller said that the server's 503 response code should be used within a few hours, but not weeks. 503 error means that the server is temporarily unable to process requests for technical reasons (this may be a maintenance, overload, etc.). This is a good method to help Google understand that the website will be unavailable for a limited period of time. However, it is not recommended to use it for longer than a few hours. According to Mueller, "weeks" does not mean temporary. He also added that the webmasters are misleading Google in this case. If it's not accessible for weeks, it would be misleading to include it in search, imo. It's an error page, essentially. - John ☆ .o (▽ ≦ ≦) o. ☆ (@JohnMu) June 8, 2017 We should remind you that John Mueller previously told how not to lose the position in the search engine, if there is a need to temporarily suspend the website (for a day or more) either due to technical maintenance or for other reasons.Google AdWords users all around the world noticed that is a new keyword-level bidding interface is launching soon. Google will show recommended bids for different ad positions on the page, even if the bid simulator for this keyword is not available. Some phases were also changed a little bit. Instead of the "top of the page" is now replaced by "over all organic results"; instead of "first position" the tab "over all other ads" will be now used. There was no official launch announcement yet. Let us remind you that Google AdWords changed algorithm of work of the Optimizer of the price for conversion last week. Earlier this tool could raise the maximum bid for prospective clicks by no more than 30%. Now this restriction is lifted.In most cases Google does not penalize or lower websites for using a sticky footer. Thus, there is no need to worry about possible problems due to the use of this technique. This information was stated by the Google search representative Gary Illyes on Twitter. At the same time, Illyes advises to avoid obsession, so as not to cause irritation among users when sticking the footer. Nah, I would not worry about that, but do not try to make them as less obtrusive as possible. You really do not want to annoy your users. - Gary "鯨 理" Illyes (@methode) July 28, 2017 It should be recalled that in April the search rep, John Mueller, said that Google does not punish websites for posting end-to-end text and links into the footer of the page. The content of this block is not regarded by the search engine as the main page on the website. Earlier this month it became known that the location of internal links on the page does not affect their weight.Read about SEOFacebook and other social media sites ranked as the second most effective marketing method among US small and medium-sized businesses (SMBs) surveyed in January 2015. (Source: eMarketer)Based on Q3 2015 data from SaleCycle, when retailers send email notifications about abandoned carts, the emails have a healthy 40.5% open rate. (Source: eMarketer)Mobile ads now makes up a very significant 78% of Facebook’s advertising revenue, up from 76% in Q2. (Source: TechCrunch)A survey by Bizrate Insights found that 23% of potential online buyers purposely abandon their shopping carts in order to collect coupons that sellers send to try and close the sale. (Source: E-Consultancy)Lead generation (cited by 61% of corporate marketers) and Web site traffic (57%) are the top SEO objectives for marketers at enterprise companies in 2015. 54% want to improve traffic conversion rates. Just 24% cited attributing sales and revenue to SEO as a top goal. (MediaPost)38% of mobile users search at least one time per month for a local business. (Source: BrightLocal)view also: