joi, 28 noiembrie 2013

Happy Thanksgiving

Here's What's Happening Here at the White House
 
 
 
 
 
 
  Featured

Happy Thanksgiving

In his weekly address, President Obama gave thanks to all the men and women defending our freedom and acknowledged their sacrifice might mean they can’t spend the holidays with their families. The President also recognized that as Americans, we gather together this Thanksgiving to lift up those who need a helping hand, letting us move forward as a country and lead us to a brighter tomorrow.

See President Obama's Thanksgiving message.

Happy Thanksgiving! Watch this week's Weekly Address.

 

 
 
  Top Stories

"Popcorn, you have a full reprieve from cranberry sauce and stuffing. We wish you well."

President Obama pardoned two 20-week-old, 38-pound turkeys named Popcorn and Caramel -- and announced Popcorn as the official "National Thanksgiving Turkey," after the American public weighed in on their favorites via Twitter, Facebook, and Instagram.

READ MORE

Going Big for Small Business Saturday

This Saturday, November 30th, Senior Advisor Valerie Jarrett will join a number of White House and Cabinet Officials, along with millions of Americans around the country, in paying tribute to small businesses that drive our economy, and help to define the spirit of our communities.

READ MORE

Report from the Road: Community Colleges Leveraging Partnerships for Economic Growth

Over the last three years, this administration has made unprecedented investments in the community college system through the Trade Adjustment Assistance Community College and Career Training grant program. Secretary Perez and Dr. Jill Biden speak on the role they play.

READ MORE


Did Someone Forward This to You? Sign Up for Email Updates

This email was sent to Email Address

Unsubscribe | Privacy Policy
Please do not reply to this email. Contact the White House

The White House • 1600 Pennsylvania Ave NW • Washington, DC 20500 • 202-456-1111


Seth's Blog : Culture and selfishness

 

Culture and selfishness

One person selfishly drops a piece of litter on the ground, the other selfishly picks it up.

Everything we do is done because it's better than not doing it. "Better" is the complicated term. Better might mean, "gives me physical pleasure right now," for some people, while better might mean, "the story I tell myself about the contribution I just made gives me joy and satisfaction."

Society benefits when people selfishly choose the long view and the generous view. The heroes we look up to are those that sacrificed to build schools, to overcome evil, to connect and lead--even though it didn't necessarily help them in the short run.

Culture, then, provides the bridge between childish, naive instincts to only do what feels good now, to only help ourselves and maybe our kids. Culture makes it too socially expensive to brag about not giving money to charity or, to pick an absurd example, to kill the infirm and the less fortunate. We reduce sociopathic behavior by establishing norms and rewarding those that contribute while shunning and punishing those that don't.

Marketers have a huge role in this, because we are the amplified culture creators. When we sell people on quick satisfaction now, is it any wonder that people buy it?

In the US, today some people will give thanks for what they personally have. Others will focus more on what has gone right for family and friends. And others will dig deeper and think hard about what they can do to take an even longer view, and to create a platform where even more people will be thankful a year or a decade from now.

Sure, we're all selfish, but our culture rewards those who take their selfishness to the long-term, to the narrative of leader and caretaker and gardener, not merely self-interested consumer.

One of the greatest things to be thankful for is the fact that we live in a culture that pushes each of us to be thankful and generous. It didn't have to turn out that way, and I'm glad it did.

       

More Recent Articles

[You're getting this note because you subscribed to Seth Godin's blog.]

Don't want to get this email anymore? Click the link below to unsubscribe.




Your requested content delivery powered by FeedBlitz, LLC, 9 Thoreau Way, Sudbury, MA 01776, USA. +1.978.776.9498

 

miercuri, 27 noiembrie 2013

Mish's Global Economic Trend Analysis

Mish's Global Economic Trend Analysis


Time for Banks to Be Banks, Not Hedge Funds or Slush Funds; Free Money Math vs. 100% Gold Backed Dollar

Posted: 27 Nov 2013 01:31 PM PST

In the wake of all the misguided pleas for negative interest rates in Europe (hoping to get banks to lend), comes news US banks warn Fed interest cut could force them to charge depositors

Leading US banks have warned that they could start charging companies and consumers for deposits if the US Federal Reserve cuts the interest it pays on bank reserves.

Depositors already have to cope with near-zero interest rates, but paying just to leave money in the bank would be highly unusual and unwelcome for companies and households.

The warning by bank executives highlights the dangers of one strategy the Fed could use to offset an eventual "tapering" of the $85bn a month in asset purchases that have fuelled global financial markets for the last year.

Minutes of the Fed's October meeting published last week showed it was heading towards a taper in the coming months – perhaps as soon as December – but wants to find a different way to add stimulus at the same time. "Most" officials thought a cut in the interest on bank reserves was an option worth considering.

Executives at two of the top five US banks said a cut in the 0.25 per cent rate of interest on the $2.4tn in reserves they hold at the Fed would lead them to pass on the cost to depositors.

Banks say they may have to charge because taking in deposits is not free: they have to pay premiums of a few basis points to a US government insurance programme.

"Right now you can at least break even from a revenue perspective," said one executive, adding that a rate cut by the Fed "would turn it into negative revenue – banks would be disincentivised to take deposits and potentially charge for them".

Other bankers said that a move to negative rates would not only trim margins but could backfire for banks and the system as a whole, as it would incentivise treasury managers to find higher-yielding, riskier assets.

About half of the reserves come from non-US banks that do not have to pay the deposit insurance fee. Their favourite manoeuvre is to take deposits from money market funds and park them overnight at the Fed, earning millions of dollars risk-free. Cutting the interest on reserves would stop that.
Excess Reserves



Free Money Math

The Fed pays .25% interest on excess reserves.
A quarter of a percent on $2.4 trillion happens to be $6,000,000,000 (six billion) annually.

Time for Banks to Be Banks, Not Hedge Funds or Slush Funds

Printing money that just sits overnight at the Fed allowing banks to make risk-free profits on $2.4 trillion in excess reserves is of course ridiculous.

It is also ludicrous for banks to complain about the take-away of free money that it should not be getting in the first place.

The Fed has so distorted the economy that no true pricing mechanism exists on anything.

Should banks feel the need to charge depositors interest on deposits, then so be it. That's the way it should be in the first place.

100% Gold Backed Dollar

In a true free market economy, with a 100% gold-backed dollar (where one dollar represented a fixed amount of gold, as opposed to a fixed price of gold), banks would of course charge a fee for safekeeping and other services.

The closer we get to that model the better, regardless of complaints by banks or others.

Notice the emphasis on safekeeping.

A 100% gold backed dollar would not stop lending. It would stop fractional reserve lending, lending of money in demand accounts, and lending of money for greater terms than the bank has use of funds.

Banks could not lend money available on demand (checking accounts), but they could lend money in interest bearing accounts such as CDs, for the term of the CD.

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com

War Between Spain and Germany Erupts Over Next Round of Watered Down Stress Tests; Germany Complains About the "Carry Trade"

Posted: 27 Nov 2013 11:05 AM PST

On October 23, ECB president Mario Draghi announced new bank stress tests. At the time, I offered a "Draghize" Translation. Here is a small snip.
Translating Draghize

For those of you who do not speak Draghize I offer these translations.

Draghize: "Banks do need to fail to prove the credibility of the exercise".
Mish: We are carefully scrutinizing several non-critical banks, looking for a couple of scapegoats, hoping to fool the public regarding the credibility of the exercise.

Draghize: "If they do have to fail, they have to fail. There's no question about that."
Mish: If any big banks are in trouble. They won't fail. There's no question about that.

Draghize: "The test is credible because the ultimate purpose of it is to restore or strengthen private sector confidence in the soundness of the banks, in the quality of their balance sheets"
Mish: The test is credible because we say it is.
War Erupts Over How Much to Water Down Stress Tests

Via translation El Confidencial reports War between Spain and Germany Erupts Over the Hardness of Stress Tests
The new stress tests of European banks have caused the outbreak of a new confrontation between the governments of Spain and Germany. Until now, it was Spain who argued in favor of a tough exercise, similar to what Spain had to undergo when seeking bailout funds.

By contrast, Germany (supported by France and Italy) preferred more lax exercises that do not bring to light the shame of their banks balance sheets of billions in toxic assets, including Spanish mortgage securitizations.

But now the German authorities found one flank to counterattack: the huge public debt exposure of Spanish banks, which they believe should be penalized in these exercises, which can be catastrophic for our financial system when it just starts to lift head.

Sovereign Debt Not All Risk-Free

The German authorities consider that if the tests need to be hard, then they should be hard in every way, including sovereign debt. In addition, the German central bank seeks to distinguish between the sovereign debt of their country and peripherals. It is what they call "enforce the triple A".

The penalty is a recurring request from the Bundesbank. Its president, Jens Weidmann, has warned several times about the risk posed by this link between governments and entities, and has called for a regulatory change that public debt is not considered a risk-free asset.

"It makes no sense that risk-free treatment is given to BBB Spain titles. Sovereign debt cannot all be considered as zero risk equally. Only those with the highest rating can be considered risk free" is the argument from Germany.

Germany Complains About the "Carry Trade"

Weidmann's claim is deeper than a mere fight stress tests estate. In its latest monthly report, the Bundesbank takes offense at the stratospheric rise in the positions of the Spanish banking debt: an increase of 133 billion euros over two years, to around 300 billion euros today. This is explained by the famous carry trade with which banks borrow very cheap on the open bar ECB liquidity at 0.75%, then invest in public debt paying 4% interest.

Spanish officials claim it makes no sense to penalize these asset as if they were bad loans. But the answer to this argument is simple: a stress test is by definition a simulation of a worst case scenario that the current (or adverse stressed scenario) and that scenario should take a further fall in bond prices and an increase yields.

If the Bubdesbank imposes its criteria, the result can be disastrous for some of our institutions. Some industry sources are confident that the Spanish government reaches a deal with the German to "not to hurt each other."
Germany Convinced of Easy Stress Tests

Via translation, also consider Merkel stands up to Guindos Regarding Stress Tests
According to a source familiar with the situation, "Germany is convinced that the test will be very light because of so much opposition to make the stress tests a serious exercise."

In fact, postponing these tests from the last quarter of 2013 to the first quarter of 2014 is another sign of the imposition of the German thesis. Neither France nor Italy wants very rigorous stress tests so as to not aerate the shame of their own banks.

French reluctance is justified by the enormous exposure with their banks in recent years. As for the Italians, "they are in a state of denial as that Spanish banks had before the disaster," explain the sources cited. "And the worst is that they usually get away with it, not least because Mario Draghi is Italian."
"Deal to Not Hurt Each Other"

In return for watering down stress tests on certain toxic assets that French banks, German banks, and Italian banks do not want, industry sources think a deal will be reached to also not include skyrocketing sovereign debt of Spanish banks.

Conclusion: expect another stress-free test.

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com

Damn Cool Pics

Damn Cool Pics


Around the World in 80 Drinks [Infographic]

Posted: 27 Nov 2013 09:30 AM PST

This is a striking infographic which delves into the world's most popular drinks, and the countries which produce them better than anyone else. Sit down for a Scotch in Scotland, a Sangria in Spain or an Almdudler in Austria. How many have you tried?

Click on Image to Enlarge.



Something to think about this Thanksgiving:

The White House Wed., November 27, 2013
 

 

 http://whitehouse.gov/share/When-You-Sit-Down-To-Thanksgiving

 

 

This email was sent to e0nstar1.blog@gmail.com
Sign Up for Updates from the White House
Unsubscribe | Privacy Policy
Please do not reply to this email. Contact the White House

The White House • 1600 Pennsylvania Ave NW • Washington, DC 20500 • 202-456-1111

 

Checkout Page Optimization: Just Follow the F.A.C.T.S.

Checkout Page Optimization: Just Follow the F.A.C.T.S.


Checkout Page Optimization: Just Follow the F.A.C.T.S.

Posted: 26 Nov 2013 03:15 PM PST

Posted by Yoast

Editor's note: This post was co-authored by Joost de Valk and his brother Thijs de Valk.

At Yoast, we've recently written about how we've drastically changed our checkout page. This process and our findings gave us the idea to do a best practice of sorts on checkout pages. As it is, a lot of checkout pages are far from optimal, and this short film from Google Analytics is rather harsh but lays it out quite well:

There are some elements to a checkout page that, in general, really help your conversion rate. Ignore these findings at your own peril. I'll be looking at the following factors, all of which have a serious impact on your conversion rate: Focus, Assurance, Clarity, Time, and Social proof.


Focus

A page needs focus for people to understand what it is you want. On the checkout page this is doubly true; if your focus isn't on the process of checking out, people will get confused. And confused people don't convert.

An easy way to add focus to your checkout page is to implement calls to action. Calls to action are somewhat of a science, and people have performed a lot of tests to find the call to action that will work on any website. However, we believe it all depends on context.

Call to action

You should always use a color for your call to action (CTA) that stands out in your design. Usually we recommend people use a color they haven't already used in their design (or at least that page). Next, bigger is better. The bigger you make your CTA, the more attention it will draw to itself, thus the more focus it will render.

Obviously the size of your button needs to stay workable. Also think about the shape of your CTA. We like to use calls to action that are shaped like an arrow, because they give people a sense of direction. The shape of your CTA alone will give people a sense of forward movement, which is associated with all things positive:

Button2

Lastly, the copy on your CTA is of importance as well. In general, be short and concise. People don't like reading buttons, they just want to know where it leads.

Clutter

Especially on your checkout page, you need to remove as much clutter as possible. By clutter we mean "mess" on your website that distracts from the main goal. Any element on a page that's not aimed toward that page's main goal is clutter, and too much clutter makes your page lose focus altogether.

Clutter that is "outbound" (takes your visitor to another page) is especially bad. Make sure that the most important thing on the page is your checkout process. This can mean removing breadcrumbs, products you're cross-selling and sometimes even a "continue shopping" button.


Assurance

Assurance is something people crave. People have to feel safe on your website and its pages, because if they don't, they simply won't spend their money there. So be sure to give them the safest feeling possible.

Safety signs

One of the most important things is to assure people your website is ok using safety signsâ€"signs that mean the page/site you're currently viewing is free from malware and is "hacker proof." People want a visible affirmation that the page they're viewing is safe, especially if that page is the checkout page. They want assurance that their money will be safe. So don't just expect people to understand your website is safe; show it.

Payment methods

People want to know as soon as possible if you're offering the payment method they want to use. So it's best to show the credit card logos of the companies you support. If you support PayPal, include that as well, obviously. To avoid clutter, we've done this on our checkout page:

Logos

This way, it actually adds clarity to the payment options, assures people we have their kind of payment method, and reduces clutter by not showing it somewhere else.

Unexpected costs

As in the video, people do not like to be surprised at the counter. That's why unexpected costs are the #1 reason people abandon their shopping carts. To prevent this, you need to assure people that there won't be any unexpected costs. This can be as simple as adding a line like "there will be no additional costs" next to the total of the visitor's shopping cart.


Clarity

Clarity and conversion are often mentioned in the same sentence. If your copy and your pages aren't clear, they just won't convert as much as they could. So be sure to make your checkout page process as clear as possible.

Progress bar

A progress bar gives people insight in how far along the process of checking out they are, and also adds the positive effect of gamification. This gamification effect means people will want to get to the next step as fast as possible. On our own checkout page we've decided to have people always step in on the second step. The first step is choosing a product:

The reason we do this, is because the visitor has already taken the hardest and biggest step in your process: he chose a product he wants to buy! So validate that step and make them feel good about it. This way the visitor has already done part of the process without any effort.

Product images

It has to be very clear that the product people have added to their shopping cart is actually the product they want. Showing pictures of your product is by far the easiest way to do this. An added bonus is that (decent) pictures actually increase your conversion rate.

Inline validation

Another form of clarity is inline validation. This makes it very clear for users whether they've correctly filled in the field or not:

validation1 Error

This kind of immediate feedback is very clear and actually makes people more likely to complete the entire form. And in fact, creating inline validation for your form fields isn't hard at all, as we explained in a post on the technical aspects of implementing inline validation recently.


Time

Time plays an important role in your conversion rate. You literally just have seconds for your page to load and convince your visitor that they should stay on that page.

Site speed

In order to convince your visitors within that few-second window, your site needs to be fast enough. Having a website that's too slow, can literally cost you money. This is especially important if you have a (large) user base on mobile devices.

Cookie expire time

You can actually have your website "remember" what people added to their shopping cart. This information is stored in cookies, and you can determine how long this information will be stored. Only 50% of your shopping cart visitors will buy within an hour. After that, it takes people a lot longer to make a decision.

If you want 80% of your shopping cart visitors to buy what they added to the cart, you'd have to save those items for 7 days. Doing this will make sure people can leave your website, come back later and simply pick up where they left off. This makes it a lot easier for people and removes the risk of having people go through the choice and thought process of picking one of your products twice.


Social proof

Social proof is a powerful way to persuade people. There's nothing more useful for influencing people than other people telling them your product is awesome. Social proof works because people will get more confidence in a product if they, for instance, read good reviews from other people. The manufacturer of a product is always going to say their product is fantastic. Having other people talk about it, simply makes it more objective, and thus more trustworthy.

However, you have to take care, because social proof can also seriously backfire. You have to make sure you're using positive social proof. Positive social proof means providing people with things they can gain from using your product, instead of what they're risking not to gain (negative social proof). Telling people what they're risking, or worse, how many other people are risking it, can have the exact opposite effect of what you're trying to achieve. People will only find more reason not to use your product.

Testimonials

Testimonials are stories or pieces of text from actual users about your product. If positive, these can have great impact on people. Always be sure to use as much information of the person giving the testimonial as possible. Adding pictures has been found to increase trust, even if the picture didn't make any sense at all. However, a picture of a face always draws more attention:

This actually has a drawback, because people looking right at you will keep your attention. If at all possible, it's best to have the eyes of the person in the picture pointed to an important element on your page, such as your call-to-action.

Lately we've been reading a lot about 'mini stories'. These are basically testimonials, but written like short stories. When written right, mini stories are supposed to have a kind of seductive effect on people.

Numbers

Telling people how many went before them in buying your products persuades people to also buy your products, especially if it's a high number. This is due to multiple things, among which peer pressure is probably the most important. It's basically trust based on numbers. Peer pressure means people are afraid to "stay behind" if a lot of other people have already done something. When using this tactic, be sure to use the exact number of people who've bought something or signed up, and to not round anything up. It turns out that for your visitors exact numbers are more believable.

Authority

Telling people what other important people or businesses have used your product or service is a great way of persuading people. Especially if you use the kind of people and businesses you know your visitors will like. This is all because of the Halo Effect, which means people's impression of you can be influenced by their overall impression of you. So if you make that overall impression more positive by naming those great names working with you, they'll think more highly of you.

Up to you

Your checkout page needs every much bit of thought as the rest of your website. In fact, if you manage to convert more people here, this will be the closest thing to direct money you'll ever find in Conversion Rate Optimization. So what do you think? Let us know!


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Automate Your SEO Reporting by Exporting Your Leads into Excel

Posted: 26 Nov 2013 03:02 AM PST

Posted by Brian_Harnish

For any SEO who collects email leads from web forms, the dreaded part of their existence tends to be the end of the month, when it comes to reporting conversion results to clientsâ€"verifying, re-verifying, downloading, and exporting them to generate the all-important month-end reports. It can take hours and can be very tedious, but the information gleaned from this process is well worth it. There are, however, ways to optimize your workflow to the point that it almost feels like cheating your way through the process.

By using standalone programs or macros (mini scripts within a program), a project that would normally take hours turns into minutes, and I want to take this opportunity to teach you how to do this on your own. I will use a standalone program and a macro that I found through my research to demonstrate the process so you can get a better idea of what is involved.

How to scrape leads from your Gmail (or almost any other email client)

There are a wide variety of ways to scrape leads from Gmail. You can spend the money to get a program like UBot that will help you automate the task without much effort. You can get a program like iMacros, and spend the time learning how to build proper macros that will scrape from your email box. You can spend the time to learn how to program scripts using Grease Monkey, or you can program your own stand-alone scripts. Whatever you do, you will want a solution that is as quick and easy as possible and helps to automate the task without adding much effort. I found a program on Black Hat World that is made to work on Windows, so you Mac users will need to install Windows to use it. You can download the program here.

While I am aware of the hesitation involved in downloading anything from black-hat websites, my own tests of this tool have worked out well. There are comments and reviews about this tool around the web, and it seems to work well for many users. My own research has not found an instance of this tool doing anything nefarious behind the scenes, and I would not hesitate to use it in my own email scraping.

How it works

This program works by accessing the Gmail account that is added to it and exporting the To:, From:, Body:, and Date: fields from each email. Here is how to use it:

  1. Select the email settings you wish to use to download your emails. You can select To:, From:, Subject, and Date. The "Body" export is disabled; according to the tool's creator it would end up scraping all of the HTML.

  2. Enter your username. This is your full email address (username@domainname.com).
  3. Enter your password.
  4. Enter the server and port number you wish to use. By default, it's set to pop.gmail.com and port # 995.
  5. Select whether or not you wish to use a secure connection. This will allow the program to access Gmail whether or not a secure connection is available. If your email does not actually require a secure connection, be sure to uncheck the box.
  6. Once these settings are selected, it will save a file in the email extractor folder with a name that looks like this: 10-1-2013-1-00 AM_Username@gmail.com.
This program is quite useful for those who either do not have or just don't use Microsoft Outlook. If you have Outlook but are not comfortable with downloading and using this program, you can set Gmail to send your messages to Outlook, and then set up Outlook macros to to export all messages to Excel (covered later in this article).

Be sure you don't violate your host's terms of service

This program can also work for other email hosts. Try it! Be sure to put in your applicable login details, and you should be able to scrape your emails without any trouble. However, be sure that you are actually allowed to scrape email from your host. Not all hosts will allow you to do so. Before using egregious scraping on your email account, just double check your terms of service (ToS) so that you don't accidentally get yourself banned from your email service. Why would an email service not allow scraping? Well, it can cause bandwidth issues if you have hundreds upon hundreds of thousands of emails to export. If this becomes an issue, you may raise an eyebrow or two at your email provider. So, be sure that you really want to do this if you want to place such a large load of use on the email services. The author of this article is not responsible for things that may happen if you do not follow specific terms of service regulations. For your reference, here are the terms of service from several common providers:

Gmail ToS: Gmail does not have any terms that specifically prohibit scraping emails. While Gmail does state you may not access it using a method other than the interface, this is a very gray area that does not provide examples. If someone is collecting lead information for a valid reason like monthly reporting for their own use, there shouldn't be an issue. If, however, someone is using access via another method in order to take down the Gmail service, then I would imagine this is where the Terms of Service here comes into play. And this is why I mentioned the large bandwidth usage that downloading thousands of emails can cause to a server, for example. Be sure you really want to proceed before doing so and make sure you won't be somehow banned from your email service as a result. We are not responsible for egregious misuse of a service with intentions to cause interference of the service through significant bandwidth use.

MSN ToS: Does not have any terms that ban exporting emails using any of these methods to export emails. (Be sure to read your own ToS).

Yahoo! ToS: Does not seem to have any terms that prohibit exporting emails. (Be sure to read your own TOS).

Hostgator email limits: While ToS doesn't specifically seem to limit scraping or exporting of emails, there are policies and limits in place. According to Hostgator's mail policy and limits page, "Each connecting IP is limited to 30 POP checks per hour." Possible interference issues with Hostgator services and this software can occur if you are using the software 100s of times per hour, for example. However, because it uses at least one pop check in order to download your emails, you shouldn't have too many issues unless you continue multiple downloads of emails from your account per hour. In which case, you will "likely get a password error indicating that the login is incorrect." Such an issue corrects itself within an hour and the email checking will automatically unlock.

Also according to their mail policy and limits page, their VPS plan and Dedicated do not have the same restrictions as their shared accounts do, so you will probably have more success with high-volume scraping on your own private servers.

A fair warning, however: I haven't specifically tested this with Hostgator, so be sure to use caution when exporting too many times.

Importing your scraped file into Excel

Once you have scraped your email and it saves it as a text file, it shows up all garbled. What we want to do now is import it into Excel so it displays all of the tab-delimited items as columns, so that we don't have to manually copy and paste every single one. To do this, let's open up our file in Excel by clicking on File > Import.

It will ask you: What type of file do you want to import? By default it has selected the CSV format but let's select the text file format since our program saved this to a text file.

Now, click the file that you want to open and click on "Get Data." The text import wizard will pop up showing you settings to choose from. Select the "Delimited" option unless it is already checked by default. Then click on Next.

In this step you can set the delimiters that your data contains. Remember when we selected the semicolon back while importing our file? Select the semicolon option here. Then, let's click on next.

Here, we can set up our columns and set the data format. For our purposes, however, let's just go with the default options.

Now, it will ask you where you want to put the data. You have a choice of Existing Sheet (which starts at =$A$1), new sheet, and pivot table. For the purposes of this article, let's just go with the default and click on OK.

Here, you see we have perfectly aligned columns and data without much work. Now you can move forward with formatting these columns and data in whatever orientations or pivot tables you like.


How to download leads from Outlook to Excel

For those who use Outlook, depending on your version, it can be cumbersome to get the data out of the program and can take longer than in just about every other program. Thankfully, Outlook features macros which can be used to export all of your data in the span of just a few seconds!

Step 1: Find or create the macro script you want to use

There are a ton of options and configurations available for this task. For our purposes, we will use modified versions of the scripts located here.

Before we get started, we will need to get the basic code from the very first code snippet, shown below. This code only exports the Subject, Received Time, and Sender of the email message. Our goal is to modify this script so that our new code will extract the entire body of the message and output it to the spreadsheet as well. Don't worry! I am going over each line of code that we modify in this tutorial! This way, you will understand exactly what we are doing and why.


  Sub ExportMessagesToExcel()    Dim olkMsg As Object, _       excApp As Object, _       excWkb As Object, _       excWks As Object, _       intRow As Integer, _       intVersion As Integer, _       strFilename As String    strFilename = InputBox("Enter a filename (including path) to save the exported messages to.", "Export Messages to Excel")    If strFilename <> "" Then       intVersion = GetOutlookVersion()       Set excApp = CreateObject("Excel.Application")       Set excWkb = excApp.Workbooks.Add()<br>  Set excWks = excWkb.ActiveSheet       'Write Excel Column Headers       With excWks          .Cells(1, 1) = "Subject"          .Cells(1, 2) = "Received"          .Cells(1, 3) = "Sender"    End With    intRow = 2    'Write messages to spreadsheet    For Each olkMsg In Application.ActiveExplorer.CurrentFolder.Items       'Only export messages, not receipts or appointment requests, etc.       If olkMsg.Class = olMail Then          'Add a row for each field in the message you want to export          excWks.Cells(intRow, 1) = olkMsg.Subject          excWks.Cells(intRow, 2) = olkMsg.ReceivedTime          excWks.Cells(intRow, 3) = GetSMTPAddress(olkMsg, intVersion)          intRow = intRow + 1       End If    Next       Set olkMsg = Nothing       excWkb.SaveAs strFilename       excWkb.Close    End If    Set excWks = Nothing    Set excWkb = Nothing    Set excApp = Nothing    MsgBox "Process complete.  A total of " & intRow - 2 & " messages were exported.", vbInformation + vbOKOnly, "Export messages to Excel"  End Sub  Private Function GetSMTPAddress(Item As Outlook.MailItem, intOutlookVersion As Integer) As String    Dim olkSnd As Outlook.AddressEntry, olkEnt As Object    On Error Resume Next    Select Case intOutlookVersion       Case Is < 14          If Item.SenderEmailType = "EX" Then             GetSMTPAddress = SMTP2007(Item)          Else             GetSMTPAddress = Item.SenderEmailAddress          End If       Case Else          Set olkSnd = Item.Sender          If olkSnd.AddressEntryUserType = olExchangeUserAddressEntry Then             Set olkEnt = olkSnd.GetExchangeUser             GetSMTPAddress = olkEnt.PrimarySmtpAddress          Else             GetSMTPAddress = Item.SenderEmailAddress          End If    End Select    On Error GoTo 0    Set olkPrp = Nothing    Set olkSnd = Nothing    Set olkEnt = Nothing  End Function  


In order to get started, fire up your version of Outlook. I'm using a relatively old dinosaur version (Outlook 2003), but the steps can easily be found online for all versions. Most Windows versions should allow you to use Alt+11 to open the Visual Basic code editor, which we are going to fire up next. To do this, follow these steps:

Step 1: Click on Tools.
Step 2: Click on Macro.
Step 3: Click on Visual Basic Editor.

Next, we are going to copy and paste our code here into the editor window. Now, I used the revision 1 script and modified the original version to extract text from the body by coding the following lines. One after line 19, and one after line 29:

.Cells(1, 4) = "Message" <-- This line tells the macro program to add another column to the first row that is labeled "Message". This will add a new column that displays the text extracted from the email. This one was added after line 19.

.excWks.Cells(intRow, 4) = olkMsg.Body <-- This line tells the macro program to extract the message text from the Body of the email. This way, we have an extremely easy and fast method of verifying all of our important conversion emails that we are going to be using in our reporting.

Now that we have our script ready, let's go to the Visual Basic macro editor.

In the project window underneath the project, right-click within the window, click on insert, and then click on module. This will bring up a VbaProject.OTM file that you can add your code into, as shown in the following screenshot:

Once you have made your desired modifications (or if you desire to use the original script and copied and pasted it, just click on the floppy disk in the upper left hand corner and save the file. Or you can use Ctrl+S to save it. Then, close the Visual Basic editor.

Next, we're going to run our newly modified macro! First, make sure the folder that you want is selected and all the leads you want to export to an excel spreadsheet are in that folder. Then, let's click on Tools > Macro > Macros.

Next, you will see a Macros window pop up. We need to click on the macro we want to run, and then click on run.

True to the nature of the script, you will be prompted with a dialog box that asks you what you want to name your file. Let's call it "ExcelExportTest". It will save it into your My Documents folder. Fire up Excel, and open your brand new spreadsheet. Here is the final version of our example, complete with all extracted elements of that folder:

Wrap-up

By using these methods, it is possible to greatly reduce the time that you spend on manually verifying and copying/pasting leads from your email box. It will be completely automated! Once you get the hang of using these methods, most of your time will be spent in the formatting phase that comes next. So, it will be necessary to spend this time adding some proper formatting that will help make your reports beautiful and impactful.


Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!