ABOUT    |    CONTACT    |    GOOD PEOPLE    |     SUBSCRIBE
Showing posts with label Technology. Show all posts
Showing posts with label Technology. Show all posts

February 18, 2009

XBRL : découvrez comment optimiser vos activités de reporting







Cher(e) collègue,

Dans le prolongement de ses différentes actions visant à promouvoir les nouvelles technologies auprès de ses membres et amis, la DFCG vous propose une session de formation pour vous initier au langage XBRL.

Ce standard, libre de droits et dérivé du XML, révolutionne progressivement le monde de la finance ; permettant l’échange, la publication et l’analyse de données financières.

En participant à la formation du 16 mars prochain, vous bénéficierez de tout le savoir-faire technologique développé par l’Association XBRL France, sur un langage qui est au cœur du métier des décideurs financiers et des contrôleurs de gestion.

lundi 16 mars 2009, Paris

Au programme de cette journée :

MATINEE
  • Le standard XBRL : origines comptables et principaux concepts
  • Les taxonomies et les rapports : les fondements XML de XBRL, les outils à disposition du marché et exemple de rapport financier
  • Les réalisations avec XBRL : les premières réalisations, les projets en cours et l’actualité
  • Les atouts de XBRL : pour les directeurs financiers, les analystes et les contrôleurs de gestion

APRES-MIDI

  • Les principales notions du langage XBRL : taxonomie, rapports et notions avancées
  • Cas pratiques : lire les taxonomies IFRS et comptes annuels, création d’un rapport simple (principes et validation), se préparer à l’utilisation de XBRL
  • Exemples concrets : les comptes annuels déposés au Greffe, la rémunération des mandataires sociaux
  • Les opportunités : le reporting interne (données financières et de gestion)


Pour plus d’informations et pour toute inscription, contactez Christine NICOL par mail cnicol@cs.experts-comptables.org ou par téléphone au 00 33 1 44 15 62 54.

February 11, 2009

The age of XBRL has arrived


The Securities and Exchange Commission is officially moving corporate regulatory filings into the Internet Age. This morning the SEC issued a rule mandating that the 500 largest public companies start to file their financial results using the interactive data tagging language known as XBRL by April 13. Read original article.

XBRL tagging is said to make financial statements more searchable and comparable.

By 2010, all so-called accelerated filers, amounting to about 1,800 public companies, must comply with the new rule, and by 2011 all public companies must do so.

During their first year of filing, companies are required to use XBRL for the three primary financial statements -- the income statement, the cash flow statement, and the balance sheet -- as well as for footnotes to the statements, which can be presented in a "block" format. However, by the second year, footnotes must be formatted in a detailed manner.

Companies will have a bit of breathing room regarding their first submission. The SEC is allowing the first XBRL filing to be submitted 30 days after the traditional filing on the regulator's EDGAR database system. But all subsequent financial results must be filed on EDGAR and with XBRL tagging at the same time.

From a global perspective, some observers believe the adoption of XBRL will help move companies toward international financial reporting standards. Indeed, many experts believe that the tagging language makes it easier for companies to migrate from local generally accepted accounting principles to IFRS. Both U.S. and international accounting rulemakers have been working since 2002 to converge local GAAPs with IFRS in an effort to produce one set of global standards. Anything seen as moving that effort forward is viewed as strengthening and adding transparency to financial reporting, in general.

January 27, 2009

This puts it in perspective

More than a billion people are using the internet


THE number of people going online has passed one billion for the first time, according to comScore, an online metrics company. Almost 180m internet users—over one in six of the world's online population—live in China, more than any other country. Until a few months ago America had most web users, but with 163m people online, or over half of its total population, it has reached saturation point. More populous countries such as China, Brazil and India have many more potential users and will eventually overtake those western countries with already high penetration rates. ComScore counts only unique users above the age of 15 and excludes access in internet cafes and via mobile devices.

January 12, 2009

IFRS implications for the CIO


by Sarah JohnsonIn the nation's finance departments, the wince-inducing memories are still fresh of having to lean on IT for help deciphering Sarbanes-Oxley. Yet CFOs are being faced once more with turning to their technology counterparts for guidance in a major financial reporting project.

The job this time — converting to a new accounting language — could require changes to IT systems, too.

Accounting experts are recommending that those conversations begin now, as the Securities and Exchange Commission inches toward mandating that all U.S. publicly traded companies use international financial reporting standards. (more...)



January 05, 2009

Spreadsheet skills: exorcising phantom links

man in striped shirt at laptopAs part of our new series providing solutions to common spreadsheet issues encountered by finance professionals, we look at how to locate and remove unintended links. By Liam Bastick, associate director with BPM Analytical Empowerment.


Query

Whenever I open certain Excel workbooks, I get a message asking if I want to update the links. I’m unsure how to search my workbook to find out what these links are. Please help!



Update Links Prompt (Excel 2003)

Advice

In this instance, the user wishes to find the links and decide individually whether they should be retained or removed. (If the intention is merely to remove them, you may wish to consider the free Microsoft add-in, Delete Links Wizard.)


The first step is to ascertain what type of links you have. One way of doing this is to select Edit-->Links in Excel 2003 or earlier, or use the Connections section of the Data tab (see graphic below) in Excel 2007. Also Alt + E + K, the keyboard shortcut, works in all versions of Excel.


Location of Edit Links in Excel 2007

However this command will not be available in all instances. If it is, you will probably have Formula Links. If Edit-->Links is available, a dialog box will appear.


Edit Links dialog box (illustration)

There may be more than one file linked. Upon inspection, you may notice that one or more file may simply be an older version of the active workbook. If so, the active workbook can be substituted for each file in turn by clicking on the Change Source button (Alt + N) and following the directions. This will remove these referencing errors.


You may not have access to some files and this may cause errors if the file is inadvertently updated. By selecting the Break Link button, these links can be replaced by their current values. This action cannot be undone so you may wish to save the file beforehand in order to rectify errors.

Formula links

If you do have formula links, it is relatively straightforward to search for them:

  • Close all workbooks except the active workbook with the links in.
  • In Excel 2003 / earlier, on the Edit menu, click Find. In Excel 2007, click on Find & Select on the Editing section of the Home tab – or use Ctrl + F in all versions.

Location of Find & Select in Excel 2007

  • Click Options
  • In the Find what box, enter [
  • In the Within box, click Workbook
  • In the Look In box, click Formulas
  • Click Find All
  • In the box at the bottom, look in the Formula column for formulas that contain [
  • To select the cell with a link, select the row in the box at the bottom.

Find Dialog box (illustration)

Other ‘phantom’ links

There are other types of links - often referred to as ‘phantom’ links as they are harder to locate than formula links. But once you know, it’s easy!

Name links

This is probably the most common cause of phantom links: names that reference ranges in other workbooks.

Using Define Name in Excel 2003 or earlier or Name Manager in Excel 2007 (or Ctrl + F3), we can get a list of all the names in the workbook:


Define Name (Excel 2003 or earlier)

Name Manager (Excel 2007)

By scrolling through the list of names and examining the ‘Refers to’ section (a little cumbersome prior to Excel 2007, admittedly), names referring to other workbooks or containing erroneous references such as #REF! can be changed or deleted.

Chart links

If you have charts in your workbook, there are various places where hidden links could be lurking. Click on each text box or title and examine the formula bar, , for references to other workbooks.


Click on each data series in the chart and examine the SERIES formula for external references. These links can be removed by copying (as values!) the data located into the active workbook.

Object links

External references can also be attached to objects. The simplest way of reviewing objects in a workbook is to use the highly underrated Go To-->Special function (use the F5 function key and then click Special). In the next dialog box, select Objects, then click OK.


Go To Dialog Box Go To Special: Selecting Objects


By pressing the Tab key and examining the formula bar, each object can be reviewed in turn for external references.

And finally…

Once you have completed the above process, unless your workbook includes web queries containing parameters (this could be an article in itself), all links should now have been reviewed. If the intention was to remove all such links, simply save and reopen once all deletions have been made.

If you have a spreadsheet query, email liam.bastick@bpmglobal.com or visit the BPM website.

Back to Insight front page

January 03, 2009

IFRS Around the World

Updated Map of Status of International Financial Reporting Standards 3/1/2009


  • RED IFRS APPROVED
  • ORANGE STATED MOVE TO IFRS ADOPTION - BRAZIL, CANADA...
  • YELLOW ADAPTING TO IFRS - USA, MEXICO, CHINA


ORIGINAL POST 27/08/2007



















  • The US SEC announced that it will issue a Proposing Release this summer that will request comments on proposed changes to the SEC’s rules. The changes would allow the use of IFRSs as issued by the IASB in financial reports filed by foreign companies registered in the US. Currently, foreign companies are required to reconcile their financial statements according to US generally accepted accounting principles (GAAP). The SEC also plans to issue a Concept Release on the question whether all registrants (including US companies) should be able to report under either IFRSs or US GAAP.

  • The Council of the Institute of Chartered Accountants of India decided in July to adopt IFRSs with effect from the accounting periods commencing on or after 1 April 2011, for public interest entities such as listed entities, banks, insurance and large entities.


  • China announced that its central-level State-Owned Enterprises and large to mid-scale companies will all adopt China’s new accounting standards that comply with IFRSs by the end of 2009. The decision does not include SMEs, which make up the majority of China’s companies.

  • The Brazilian Market Regulatory Agency (CVM) published in July an instruction that openly traded Brazilian companies will have until 2010 to present their consolidated statements in accordance with IFRSs. From 2007, listed companies can opt to present their consolidated financial statements based on IFRSs.

  • The Korean Financial Supervisory Commission and the Korea Accounting Standards Board unveiled a roadmap for the adoption of IFRSs at a ceremony in Seoul. All companies in Korea, apart from financial institutions, will be permitted to apply IFRSs, as adopted by Korea, by 2009. Full adoption of IFRSs for listed companies, including financial institutions, will become mandatory by 2011.

  • Representatives of the IASB have attended the regional standard-setters meeting in Manila and met standard-setters from Brunei, Indonesia, Malaysia, Philippines and Taiwan.

The IASC Foundation held its third IFRS conference in Zurich on 23 and 24 May. Nearly 400 people from 42 countries attended. ‘Delegates appreciate the opportunity to discuss theirspecific circumstances with Board members and senior staff’, said Michael Wells, Senior Manager of the IASC Education Initiative, who organised the conference. ‘Our conferences are aimed at anybody who is involved in or affected by IFRSs’, underlined Wells. ‘It provides the opportunity to meet and discuss IFRS developments with IASB members and project managers.’ The Zurich conference was opened by Sir David Tweedie, Chairman of the IASB. The first day was dedicated to presenting views on IFRSs from the analyst and preparer community.Presentations were given by senior representatives from Novartis, UBS and Standard & Poors,followed by discussion rounds. Keynote speaker for the conference was the Chief Accountant of the US Securities and Exchange Commission (SEC), Conrad Hewitt. His speech focused on the underpinnings of the international financial reporting system. Of particular interest were the next steps the SEC intends to take relating to the acceptance of IFRSs.The second day focused on the IASB’s active agenda projects. The programme began with a general presentation on the Board’s recent activities followed by five intensive break-out sessions on developments in major projects: the conceptual framework, the reporting entity,consolidations and joint ventures, financial statement presentation, and business combinations.‘Feedback is invaluable, and has been very positive’, said Wells. He added ‘We listened to comments from past conferences, and this year extended the duration of break‑out sessions to allow more interaction. Furthermore, we held separate half-day pre-conference workshops on specialised aspects of financial reporting.’ In August this year the conference and workshops will, for the first time, take place in Asia, being hosted in Singapore. ‘We have decided to change location every year to underline the Foundation’s global objective’, said Wells. But this is not the only effort to be inclusive. ‘We also offer discounts of up to 70 per cent to people from emerging and developing countries’, he added.

December 07, 2008

The risks of risk management

Banks now employ thousands of highly-qualified mathematicians to quantify risk for them. So why did they not foresee the credit crunch? Quantitative finance lecturer Paul Wilmott explains how a failure to see beyond the numbers might be to blame. Read original article.

We have learned the hard way how important it is to measure and manage risk.

Despite the thousands of mathematics and science PhDs working in risk management nowadays we seem to be at greater financial and economic risk than ever before.

To show you one important side of banking I would like you to follow me in an exercise with parallels in risk management.

You are in the audience at a small, intimate theatre, watching a magic show.

The magician hands a pack of cards to a random member of the audience, asks him to check that it is an ordinary pack, and to give it a shuffle.

The magician turns to another member of the audience and asks her to name a card at random. "Ace of Hearts," she says.

Pick a card, any card

The magician covers his eyes, reaches out to the pack of cards, and after some fumbling around he pulls out a card.

The question to you is what is the probability of the card being the Ace of Hearts?

Think about this question while I talk a bit about risk management.

Feel free to interrupt me as soon as you have an answer.

Oh, you already have an answer? What is that, one in 52, you say? On the grounds that there are 52 cards in an ordinary pack.

It certainly is one answer.

But aren't you missing something, possibly crucial, in the question?

Ponder a bit more.

Calculator keypad
Risk managers employed by banks are often highly-qualified mathematicians

One aspect of risk management is that of 'scenario analysis.' Risk managers in banks have to consider possible future scenarios and the effects they will have on their bank's portfolio.

Assign probabilities to each event and you can estimate the distribution of future profit and loss. Not unlike our exercise with the cards. Of course, this is only as useful as the number of scenarios you can think of.

You have another answer for me already?

You had forgotten that it was a magician pulling out the card.

Well, yes, I can see that might make a difference.

So your answer is now that it will be almost 100% that the card will be the Ace of Hearts - the magician is hardly going to get this trick wrong.

Are you right?

Think just a while longer while I tell you more about risk and its management.

The risks of probabilities

Sometimes the impact of a scenario is quite easy to estimate. For example, a bank might ask what will happen to the value of their assets if interest rates rise by 1%.

After some mathematical analysis they will come up with an answer - which will depend, for example, on how many bonds they hold.

But estimating the probability of that interest rate rise in the first case might be quite tricky. And more complex scenarios might not even be considered.

What about the effects of combining rising interest rates, rising mortgage defaults and falling house prices in America?

Hmm, it is rather looking like that scenario didn't get the appreciation it deserved.

Back to our magician friend.

Are those the only two possible answers? Either one in 52 or 100%? Suppose you had billions of dollars of hedge fund money riding on the outcome of this magic trick - would you feel so confident in your answers?

(A hedge fund betting on the outcome of a magic show, how unrealistic! But did you know that there is at least one hedge fund that 'invests' in poker players, funding their play and taking a cut of their winnings? So who knows what they will think of next?)

When I ask finance people this question, I usually get either the one in 52 answer or the 100% answer.

Some will completely ignore the word 'magician,' hence the first answer.

Some will say "I'm supposed to give the maths answer, aren't I? But because he's a magician he will certainly pick the Ace of Hearts."

Rather frighteningly, some people trained in the higher mathematics of risk management still don't see the second answer even after being told.

Human behaviour

This is really a question about whether modern risk managers are capable of thinking beyond maths and formulas.

Workers at Canary Wharf
The human side of finance
Do they appreciate the human side of finance, the herding behaviour of people, the unintended consequences - what I think of as all the fun stuff?

There is no correct answer to our magician problem.

The exercise is to think of as many possibilities as you can.

For example, when I first heard this question an obvious answer to me was zero.

There is no chance that the card is the Ace of Hearts.

This trick is too simple for any professional magician.

Maybe the trick is a small part of a larger effect - getting this part 'wrong' is designed to make a later feat more impressive...the Ace of Hearts is later found inside someone's pocket.

Or maybe on the card are the winning lottery numbers - which are drawn randomly 15 minutes later on live TV.

Or maybe the magician was Tommy Cooper.

When I ask non mathematicians, this is the sort of answer I get.

Once you start thinking outside the box of mathematical theories the possibilities are endless.

And although a knowledge of advanced mathematics is important in modern finance I do rather miss the days when banking was populated by managers with degrees in History, who had been leaders of the school debating team.

A lot of mathematics is no substitute for a little bit of commonsense and an open mind.

December 05, 2008

BBC Special Report - Downturn

For the latest news click here



HOW TO COPE DURING THE DOWNTURN

TOOLS

Should you worry about your debts? Take the BBC's Debt Test
The BBC's Financial Healthcheck will give you tips how to cope with problems ranging from savings to pensions
The Consumer Credit Counselling Service offers an in-depth Debt Remedy advice tool

THE BASICS

Find out how the downturn took shape
Puzzled by the jargon? We explain
The big numbers in context
Why do we need economic growth?
And find out what's actually a recession





VIDEO REPORTS

BBC viewer Video stories: Coping with the downturn

October 10, 2008

Salesforce.com Links With Amazon and Facebook

Salesforce.com moved deeper into the world of cloud computing on Monday, announcing partnerships that link its Force.com hosted applications platform with services from Facebook and Amazon Web Services. Read article


The deal with Facebook allows Salesforce customers to build applications on its Force.com platform that appear natively inside Facebook, CEO Marc Benioff announced at the start of Salesforce.com's Dreamforce conference in San Francisco.

He showed an example of a recruiting application that an employee could embed in their Facebook page, where they can then use their social connections to recruit new employees for their company.

The Amazon partnership makes the company's on-demand storage and computing services available from Force.com. A developer in need of extra storage, for example, could offload some of their data onto Amazon's S3 storage service, Benioff said. They can also use Amazon's EC2 computing service.

Addressing a packed hall of Salesforce.com customers, Benioff painted a picture of a computing Wild West in which cloud platforms from different vendors are combining to create new opportunities and challenges.

"These are crazy times; these are whacky times," he said. "No one can predict these times, but there's never been a better time for cloud computing."

China Martens, a senior analyst with The 451 Group, said it makes sense for cloud providers to combine their services. "They don't really compete and they each have their own specialty, so it makes sense to have the integration," she said.

Combining the services may also ease fears about getting locked into a cloud platform, she said, something some customers have worried about. But she wondered about the implications of mixing personal data with business applications on Facebook.

"What kind of issues does that throw up? Maybe we need to start drawing rings around personal and professional data," she said.

Executives from Facebook and Amazon joined Benioff on stage for the announcements. Sheryl Sandberg, Facebook's chief operating officer, said she hoped the partnership would pave the way for a new wave of enterprise applications on the social-networking site.

In the recruiting application demonstrated here, the interface looked like a standard Facebook program but was hosted on Salesforce.com's servers and built using its Visual Force user-interface tool. Developers can download a new toolkit, Force.com for Facebook, free from the Force.com Web site today, Benioff said.

Salesforce.com added 4,100 new CRM (customer relationship management) customers during its July quarter, Benioff said, for a total of 47,700. It expects to pass US$1 billion in annual revenue for the first time this fiscal year.

Competition is increasing, however, as more packaged-software vendors start to offer their products as hosted services. Oracle, SAP and Microsoft already offer hosted CRM, and Microsoft last week announced a new project, Azure, that will compete with Force.com by providing a platform for building hosted applications.

Benioff mocked Azure, calling it "vaporware," and suggested that Microsoft will lock developers into its platform. The future will be about combining open cloud platforms that create "the best of all worlds," he said.

"This isn't about one vendor standing on stage and saying it's only our OS, our devices and our ecosystem, like we saw last week," he said, referring to the Azure launch. "Those days are over."
Monday's speeches here focused on the Force.com platform; Tuesday's will address the applications suite, Benioff said. He hinted that presidential hopeful Barack Obama will make an appearance during Tuesday's speech, though he didn't say if it would be in person or by video.
Monday's announcements take Salesforce.com further from its core business of providing an online CRM service. Force.com was a first step in that direction, providing a platform where companies can build and host add-ons for its CRM programs. Salesforce.com is now trying to diversify further.

Earlier Monday it announced Salesforce.com Web Sites, where it offers to host internal and public Web sites for its customers. Those Web sites link to a customer's back-end Salesforce.com applications, so that changes on the back-end appear immediately on the Web sites.
The service is in beta now and slated for introduction next year, Benioff said. Salesforce Professional customers get up to 250,000 page views per month for no charge, Enterprise customers get 500,000 page views, and Unlimited customers get 1 million. Additional page views cost $1,000 per month for 1 million pages, or $3,000 per month for 5 million pages.

July 25, 2008

Advice on How to Stop Shopping Cart Abandonment

Pamela Picard

Principal, Scarletts Closet Sample Sale

Scarlett's Closet Sample Sale tracks incomplete transactions. We contact the buyer to determine if they simply changed their minds or had a problem we can assist to solve. It doesn't stop abandonment, but it occasionally rescues a sale.

Joshua Dreller

Director, Media Technology at Fuor Digital

Great topic!

I've done this many times so here's the basic framework:

1) Tag all pages/steps through the process so you can track visitor behavior.
2) Find any high drop points from step to step. Basically any click rate from step to step that is below 100% is an opportunity. Of course, 100% is an ideal and unreachable, but that's the goal.
3) Optimize those pages (see below for suggestions)

Three Analytics Suggestions
- look at the referrers of the traffic going to your shopping cart.
Is one of your advertising channels sending you traffic but have high abandonment rates? If so, maybe you should put your ad dollars somewhere else.
- look at the types of products and sections on the website that users who reach your shopping cart visit. Are certain pages/products attributing to less or more abandonment. Maybe you need more videos of your products/services as users from those pages are not abandoning so high?
- Are users who abandon their carts coming back later and buying? Or buying offline? Or calling your 800 number for info? Maybe initial abandonment rates don't matter. Using Web Analytics you can track those returning visitors and find your average sales lag cycle.

There are many reasons why people may abandon their cart. The main one is that they are browsing so they want to see how much the product is in the cart including tax, shipping, extra fees, etc so they can truly compare pricing.

However, there are generally some basic usability steps you can take to decrease user abandonment such as:

- decreasing the number of steps needed to check out
- accepting a variety of payment options
- don't ask for anything you don't need (such as if they want to subscribe to your newsletter)
- don't ask for info you don't need (i.e. social security number, job title, etc)

The most important one is: MAKE IT EASY. Make it easy to add/remove, see shipping costs, ask questions, find phone numbers, etc. DON'T MAKE ME THINK by Steve Krug is a great usability book. My bible actually.

Last, a quote:

"A September 2006 MarketingSherpa.com article presented the results of a shopping cart abandonment survey study of 1,100 e-commerce marketers. The average reported cart abandonment rate was 59.8%. Roughly one out of every two visitors who adds an item to their shopping cart ultimately abandons it instead of completing their purchase."

from http://www.searchmarketingstandard.com/articles/2007/05/tackling-the-shopping-cart-abandonment-rate.html

Links:

Akshay Kumar

Marketing Consultant at Dell

E, I dont think that a lot of online companies do a good job defining abandonment in the first place. If companies know what constitutes an abandonment, they will be able to formulate strategies and metrics to counter it. I think of abandonment as an act during which a shopper may do two things: 1) Put something in the cart and not complete the sale before leaving the site 2) Put something in the cart and then throw it out
The first involves tracking a cart and follow up activities after the customer has left and the second involves tracking a cart and real time actions while the customer is shopping.

Aldo Timothy Daquioag

Search Engine Marketing Specialist at Zimplizity Solutions

Hello E.

After defining your abandonment. Get a good analytic tracking tool. There are several free web analytic tool like Google Analytics.
This tool will help you identify where your shoppers are having a hard time or where are they abandoning your site. With this you will be able to find out what are the frictions on the certain page. Maybe its just a simple button or placement of call to action and several other details.

Why would you write something about a topic that you are not a 100% sure. I think the people who should write about this are the ones who had the first hand experience doing it. or you can get them to send some case studies for you which I what you are doing right now.

Reducing abandonment rate is more on the persuasion and usability of the cart. There are lots of book and articles about this on the web all you have to do is enhance it or study them carefully so you can use them as baseline for your ebook.

Im including some of the sites I found. Grok is from Futurenow Inc. they are really good persuasion engineers.

I hope I've been helpful. Send me a line if you need anything else.

Links:

Claire Devereux Thompson

Owner, Sterling Advertising Company

Hello E

This is such a good subject - I am also interested in what has prompted you to write about it, although I believe that you are asking this question to get multiple viewpoints rather than because you don't know about it.

To use website analytics to understand abandonment of any path, you first need to map that path. What is the optimal path through your pages that a shopper should take? Is it landing page, cart, shipping, payment otpions, checkout? Is it landing page, suggested items, wishlist, cart, suggested items, cart, payment, shipping, checkout? Etc. This is your sales funnel.

Once you have that path you can use analytics to see where people are dropping out of your sales funnel. You can measure exactly how many people went from page 1 to the last page, and you can figure out where they fell out of the process and work on those pages.

For example, your shopping cart might be being abandoned at the shipping page. If so, you can use analytics to understand that this is where one of your issues is, as that's a high exit page. Perhaps your shipping options are not clear, or are too expensive, too restrictive, too many options that require research to understand.
Whatever the problem, analytics can only show you where the problem is. So, for our example of the shipping page being a high abandonment area, we now have a baseline to measure improvement against and can begin to work on the problem and track it.

Let's say that we decide that we need to explain why our crystal goblets need special packaging that drives shipping rates up - we write a paragraph of text that really promotes the fact that we care deeply about the consumer and that they get what they expect when it arrives, in good condition. We then add this to a shipping page, with 50% of shoppers getting this version with the shipping description and 50% getting the old version, and then we use website analytics to compare the two.

Did it make a difference? If so, did it solve the problem? If it did, then you're in great shape. If it didn't, go back and try something else. Keep testing and reading your anaytics against your benchmark, and you'll get there eventually.

Hope this helps. Good luck with the book.

Claire

James Curcuruto

Marketing and Advertising Professional

Hello E,

Here's what I do; I take the visitors that browsed the longest or put an item in the shopping cart and then send them a "Special Offer" email (ie 10% off or Free Shipping). Obviously the offer code is unique on the special offer so I can track results and I have had a 1.05% conversion from the special offer. Not a huge response but sometimes you have to pay big $ to get a 1% return so for free, it's great!
Good luck with your book.
Jim C -
Owner
www.FrameThatMoment.com

Links:

Erik Small

Online Marketing Manager at Ipswitch, Inc.

First and foremost, tag all pages of the shopping flow using an analytics package like Omniture, so you have metrics of how many visitors are hitting your cart. You'll see data on each page of the flow and determine which pages are causing the biggest drop-off. And, determine the overall shopping cart conversion to set a baseline to try and improve. Typically, the page that asks for the most personal information or credit card number will lose the most visitors. Optimize the poor performing pages by running an A/B split test. Example: If initial overall conversion is 30% (70% abandonment), some simple changes through testing and improving page navigation can increase conversion +5% or more. Sometimes it's an ongoing process -- Read data, setup a test, analyze results, repeat.

Marina Mann

eCommerce | Digital Marketing | Mobile Professional

Although I would love to see you "...stop shopping cart abandonment", it may be an optimistic goal. There are a number of best practices in terms of persuading your customers to complete the buy online, however assuming all customers intend to buy when they put items in the cart is not a fair assumption. In my opinion, the Web checkout is a complicated emotional experience conjuring up need, desire, anxiety and most importantly happiness. Increasing conversion doesn't start at the shopping cart, it starts at the power page (or entry page) and can be qualified in the context of cross-channel visitor engagement, brand relationship and lead generation.

Clearly, Analytics tools won't give you info on your customers' emotional state, but it's important to pick the right analytics tool that will help you understand the data in context. You'll also need to design your site for analytics for help in understanding visitor volume trends, conversion funnels, clickstreams forward and reverse path analysis, page popularity and so on. Keep in mind that, if you're a cross-channel eCommerce site vs. a pure play, the same shopping cart abandonment data will glean different insights.

The best case study is Amason's one-click-buy and Apple's licensing and adaptation of the same.

Feras Alhlou

Senior Online Marketing/Analytics Consultant;Google Adwords Qualified Professional;Google Analytics Authorized Consulant

Hi E,

There are several analytics books, by established analytics experts that touch on the subject, you might want to check out these books as you write your ebook.

The authors/books that come to mind are:
- Eric Petersons' Web Analytics Demystified
- Avinash's Kaushik's Web Analytics - An Hour a Day
- Brian Clifton's Advanced Web Metrics with Google Analytics
- The articles and blog posts by the folks at FutureNow

While these books are not specific to shopping cart abandonment, they do have chapters on eCommerce, conversion rates, funnels and metrics to measure abandonment rates and improve conversion rates.

Hope this helps,
Feras

Browse Categories

View All

Advertising and Promotion

July 24, 2008

Website of the Week

BetterManagement provides articles, webcasts and conferencesaddressing performance management, business intelligence, ITmanagement and other critical business management issues.

July 17, 2008

Information is Power

A great article which really shows the power and value of information.


Barack Obama's super marketing machine
He knows your neighborhood, your favorite products and even when you open your e-mail. How Obama is betting on vast, corporate-style voter outreach to win the White House.
By Mike Madden

June 19, 2008

LinkedIn networking valued at $1bn

By in San Francisco

The biggest online social network intended for professional use has been valued at more than $1bn, putting it among a small group of private internet companies to have crossed that threshold before going public. Read original article.

LinkedIn, whose members use the site to do things such as making professional contacts, recruiting staff or finding new jobs, said it had raised $53m from a group of venture capitalists led by Bain Capital, taking the total raised to $80m in all.

Besides carrying job advertising, LinkedIn charges members a subscription for "premium" services that let them do things like make professional introductions through the network. It also has a "software as a service" business, charging a subscription to corporate recruiters to help them manage their hiring on the site.It will generate revenues of $75m-$100m this year, more than double 2007 .The latest investment, for about 5 per cent of the company, gives LinkedIn a "pre-money" valuation of $1.015bn

Dan Nye, chief executive.

Decision Media News is Officially a "Gazelle"

By Ross Tieman

The cultural fusion at Decision News Media is palp­able. English and Irish accents on the newsdesk contrast strangely with the palm trees and umbrella pines visible through the windows. Read original article.

On a wall in the company's sweeping new office, at Le Belem, in the neo-classical town of Montpellier in southern France, is a framed certificate signed by Renaud Dutreil, France's small business minister. It declares DNM a "gazelle", one of the 2,000 fastest-growing small and medium businesses in France. But next to it are awards for the editorial excellence of its websites from Britain's Periodical Publishers Association.

Montpellier, more than 1,000km due south of Europe's publishing hub in London, may seem an unlikely home for an English-language online publishing business.
But then Franck Metzger and Jean-Marc Cogogne, the company's founders and joint managing directors, are hardly conventional entrepreneurs.
It is their peculiar blend of French planning, business school thinking and thorough grasp of British business methods that has en­abled DNM to thrive.
Both grew up in southern France, then met in Lille at the Institut d'Administration des Entreprises in 1991. They were classmates on a masters prog­ramme in international marketing, part of a government programme to equip budding French executives to sell French exports in UK markets. But after their obligatory six-month posting to British firms, the government plan went awry. "Most of the people who started on the course with us fell in love with the UK," says Mr Metzger. Degrees in hand, the pair, now firm friends, high-tailed it to London.
London was buzzing, both culturally and economically, and it was easier to find a job there than in slow-growth, high-unemployment France. "I bought the Evening Standard and got a job the next day," says Mr Metzger. "It couldn't have happened in France."

They stayed for seven years, Mr Cocogne as manager in a company making point-of-sale displays for the cosmetics industry, Mr Metzger as an advertising manager for business-to-business magazines, and then a newspaper. They acquired a profound respect for the primacy of the customer, flexible labour markets and the agility businesses need to survive.
But after the birth of their first children, they decided to move back to France.
Our wives had to give up their jobs, as soon as you have a child, many of the advantages of a big city become inconveniences.
Mr Cocogne.


Today, DNM runs 22 dedicated B2B news websites. The stories are written by a team of 14 journalists in Montpellier, plus others in main markets. Foodnavigator.com, DNM's first news site, is now the dominant source of innovation news worldwide for food industry managers. The stable has ex­panded to cover food production and packaging, dairy, confectionery, bakery, beverages, laboratory equipment, pharmaceuticals and cosmetics.

In addition, DNM sends out half a million newsletters to executives in these industries each day, giving it a valuable database in the industries it covers. In 2007, it generated sales revenues of €4.3m, up 40 per cent on 2006. For a company that started with €10,000 of the founders' savings only nine years ago, that is quite an achievement.