• About Us
    • New York
  • Work
  • Capabilities
  • Careers
  • Technology
  • Blog
  • Contact Us
  • About Us
    • New York
  • Work
  • Capabilities
  • Careers
  • Technology
  • Blog
  • Contact Us
July 06, 2015

WRGMG: Table Formatting

Posted by Preston Smith

You know what really grinds my gears? Poor table formatting. It can be hard enough to stare at a large table of numbers and try to find what you need, but sometimes it’s more difficult than it should be thanks to poor formatting. In this episode of WRGMG, let’s take a look at some common errors I’ve seen and even made myself that make tables tough to read.

We’ll start off with a real-world table I have seen in a report. The creative names have been changed to protect the identity of the reporter.

original-1

 

1)  Use Consistent Column Widths

When you look at the table, you are immediately drawn to the wider columns. “They’re taking up more space, so they must be important.” Do we really want to put more importance on view through conversions than we do on ROI? Highly doubtful.

Make sure all of your columns in the data part of the table have the same width to avoid putting emphasis on any of them. Don’t be afraid to use abbreviations for “impressions” or “conversions” to help the column headers fit.

colwidth-2

2) No Centered Columns

Centered columns can cause problems with reading the data as well as the labels. Let’s look at total conversions first. In the previous picture, it’s hard to see the difference in the magnitude from one row to the next when the numbers are centered. If we just right-align the numbers, it is now much easier to see the difference between 1,059 and 858. As for the creative strategy names, centering them isn’t too bad if they are all roughly the same length. However, when the length varies as it does in our example, it’s tough to read when the words start at different positions in each line. Let’s left-align those so we don’t have to go back and forth to find the start of each new line.

nocentered-3

3) Consistent Formatting

You get one formatting for numbers, one for currencies, and one for percentages. That’s it. If you are using commas in clicks, which you should be, you need to use them in total conversions. If you are using the accounting formatting in CPO, media cost shouldn’t be the currency setting in Excel. And of course, fix those ROI units.

formatting-4

4) Too Many Gridlines

While gridlines do help us look at numbers in tables, too many of them can just make us go cross-eyed. Try using every 5th horizontal gridline or so and lightly shading ever other row. You will find that your table is much easier to read.

gridlines-5

 

And there we have it! We’ve taken that messy table and turned it into something much easier on the eyes.  All it took was 4 simple steps. So the next time you are putting a report together, take a couple of extra minutes and clean up the formatting of your table.

And that, people, is what grinds my gears.

 

analyticsdataexcelreporting
Previous
Next

Latest White Papers

  • Shifting Plans for 2020 & Beyond
  • Game On: How Brands Can Log Into A Diverse Multi-Billion Dollar Industry
  • What CCPA Means For Brands
  • How Google is Improving Consumer Data Privacy
  • Ways to Prepare for the Cookieless Future
  • See all White Papers

Featured Posts

  • Ad Age Names PMG #1 Best Place to Work in 2021
  • MediaPost Names PMG Independent Agency of the Year
  • PMG Client Portfolio Trends During Amazon Prime Day 2020
  • A Closer Look at the Congressional Big Tech Market Power Report
  • What to Know About Reddit

Categories

  • Consumer Insights
  • Content
  • Creative Design
  • Data Analytics
  • Development
  • Digital TV & Video
  • Ecommerce
  • Industry News
  • Local
  • Mobile
  • Paid Search
  • PMG Culture
  • Programmatic & Display
  • SEO
  • Social Media
  • Structured Data
Fort Worth

2845 West 7th Street
Fort Worth, TX 76107

Dallas

3102 Oak Lawn Avenue
Suite 650
Dallas, TX 75219

Austin

823 Congress Avenue
Suite 800
Austin, TX 78701

London

33 Broadwick Street
London
W1F 0DQ

New York

120 East 23rd Street
New York, NY 10010

Get in touch

(817) 420 9970
info@pmg.com

Subscribe to the PMG Newsletter
© 2021 PMG Worldwide, LLC, All Rights Reserved
  • Contact
  • Privacy Policy
 Tweet
 Share
 Tweet
 Share
 Tweet
 Share
 LinkedIn
We and our partners use cookies to personalize content, analyze traffic, and deliver ads. By using our website, you agree to the use of cookies as described in our Cookie Policy.