WebCitz would like to welcome Jackpot Mufflers, a division of Fuel Moto Inc. Jackpot Mufflers specializes in performance exhaust systems and EFI tuning components for Harley Davidson Touring Models. Please visit their JackPot Mufflers website to learn more!
WebCitz would like to welcome Toronto Fairy Parties! The entertainers at Toronto Fairy Parties offer magical birthday parties, enchanted adventures and long lasting memories for young girls’ birthday parties. If you are in the Toronto area and are looking for birthday party entertainment, check out their website at TorontoFairyParties.com!
If you are looking to start a new paid search marketing campaign with Google then you might be interested in taking advantage of a current offer they have for $75 worth of free credits after you spend $25. You can learn more at http://www.google.com/ads/adwords-coupon.html
WebCitz would like to introduce Furry Partners, an ecommerce company offering an array of animal lover gifts for dogs, cats and even barnyard animals like horses, small critters and bugs. At their website you can find everything from dog houses, animal apparel, and animal-themed decorations. You can visit their website at www.furrypartners.com!
WebCitz is excited to be attending a Cardinal Path webinar at 12:30pm CST about WASP (Web Analytics Solution Profiler) for Chrome. WASP is a free browser plug-in that is a must-have tool for analysts, marketers and developers. With WASP you can identify all the tags on your site, understand how and where they are firing, examine the content of each and understand how to optimize these to improve site load, easily identify and debug complex code, and much more. Cardinal Path will be offering a high-level walk through to show us what the value and benefits are and share how marketers, analysts and developers can leverage the tool to drive business improvement. Best of all, WebCitz will receive a link to an early release version of the tool! As most of you know, we were in San Francisco, CA USA back in July for an entire week soaking in a lot of great knowledge from Cardinal Path’s instructors! Learn more at http://webanalyticssolutionprofiler.com/.
WebCitz would like to introduce The Wine Gear Store, a retail and ecommerce company offering a wide collection of wine accessories. At their website you can find wine accessory gizmos, gadgets, goodies and apparel for the wine collectors and wine lovers. They have wine gear ranging from aerators, chillers, racks, utensils and more! You can visit their website at www.winegearco.com!
If you have ever worked with a spreadsheet that had lots of data – perhaps thousands or tens of thousands of rows – then you know the importance of formulas. We would like to share a handy formula with you that will check a cell for a trailing comma (or other character) and remove it. Please keep in mind that this formula actually checks to see if the last character is a comma – it will not just remove the last character in the cell no matter what – a crucial check for anyone that might not have such a problem on all cells.
In the above formula, you will notice that cell A1 is being checked to see if there is a comma at the last position. If a comma is found then it will remove the comma, but if another character is found it will leave it alone. To change it from a comma to another character, such as hyphen, simply change the formula to look like the following:
We hope this comes in handy for someone! Please remember to always keep backups of your files and data before making any changes!
Here is a great picture from within the office last Friday, featuring Corey giving Peyton a pep talk before the big game this past Sunday. As you might know, this pep talk must have been beneficial since it supposedly helped Peyton and company beat out a team whose quarterback threw for over 500 yards with 5 touchdowns, breaking franchise records and entering into an elite select group of quarterbacks. It should be known that we are a pro Green Bay team – we just like to have fun with the Fat Head!
There is a new version of Magento CE! Please be aware that Magento 126.96.36.199 Community Edition has been released. If you are running a Magento website, please consider updating for security and reliability improvements. The majority of the improvements are related to security, tax calculations, USPS fixes (from the July 2013 USPS API update) and performance. If you are interested in having WebCitz implement this new version of Magento CE on your website please request a Magento upgrade service.
WebCitz is excited to be attending a Cardinal Path webinar for enhanced knowledge in Attribution and Product Listing Ads! This is definitely going to be a great benefit for some of our marketing customers! As most of you know, we were in San Francisco, CA USA back in July for an entire week soaking in a lot of great knowledge from Cardinal Path’s instructors!
Google Analytics Attribution: http://www.google.com/analytics/features/attribution.html
Google AdWords Product Listing Ads: http://www.google.com/ads/shopping/getstarted.html