Tag Archives: Media Management +

1997-2014 TSI: AdDept Client: Stage Stores

Posted on by
3

People and events at SRI/Stage Stores. Continue reading →

Everyone with whom I dealt—and there were a great many people over the course of seventeen years—-called the large retailer based on the south side of Houston “Stage Stores”. Even their LinkedIn pages refer to Stage Stores. However, our contracts1 were definitely with a company named Specialty Retailers, Inc. (SRI). The checks that we received were from SRI. This always seemed strange to me, but I managed to piece together from various sites on the Internet something of an explanation.

I spent many hours at the headquarters building on South Main. The visitors’ parking was perhaps thirty to the right of the palm tree.

SRI was incorporated in 1988. I was unable to discover who the original stockholders were or who ran the corporation. I also have no idea what, if anything, SRI did in its first four years of existence.

In 1992 the company purchased a Colorado-based retail company named Fashion Bar, Inc., which had seventy-one stores. The larger ones were branded as Palais Royal or Bealls2. The rest were known as Stage Stores. In the nineties SRI purchased a large number of other stores. Most of them bore the Stage logo. SRI’s headquarters at 10201 South Main3 in Houston was known locally as Stage Stores, and that name, as you can see in the photo, was displayed prominently over the entrance. The only stores that were actually located in Houston were branded as Palais Royal. I recall actually purchasing a leather belt in one of them. Many people in Houston knew about Palais Royal, but Stage Stores and SRI were probably not on their radar.

In late 1996 or early 1997 Doug Pease, TSI’s Director of Marketing, received a call from Brenda Suire4, the Director of Finance for Stage’s Marketing Department. Doug and I flew on Continental Airlines to Intercontinental Airport in Houston to meet with Brenda and some other employees. We were somewhat surprised by the length of the drive from the airport to Stage’s headquarters.

The blue route on the map at left suggests driving through downtown Houston. That route would only be considered if the trip was in the middle of the night. We always took the western loop on I-610.

On the second day in Houston I demonstrated the functionality and design of the AdDept system at the local IBM office. It went over very well.

I recently found in my notes from January of 2001 some of the items that were included in the contract that resulted from that presentation and subsequent negotiations.

I was surprised to discover that in 1997 Stage paid us over $8,000 for the expense payables, sales, MM Plus, and AdSEND (!) interfaces. No wonder we made so much money in those days. We have no choice but to give them the assistance they need to get the first three working. They don’t use AdSEND any more, thank goodness, and I am pretty certain that no one remembers that they paid for this. I don’t remember coding an expense interface for Stage, but we clearly did it in 1998.

As part of that initial contract the programmers at TSI wrote a great deal of new code. Stage Stores had more stores and fewer merchandise departments than the first few AdDept customers. In most of their markets they operated only one store. They were therefore much more interested in the ratios of media dollars spent on each store to the amount of sales that the store generated than in sales and expenses by department. To provide this information we wrote code to accept sales by store from the corporate systems. We also wrote a set of reports that showed the ratio of advertising expenses to sales for each store.

No one at Stage Stores had previously examined the broadcast (i.e., radio and television) advertising too carefully. The buys and audits were done by a lady (I don’t recall her name) from Reynolds Communications. She used SmartPlus5 software to make the schedule and audit the spots that each station ran. Stage soon discovered that she had been spending much too much money on television buys, especially in one-store markets in Louisiana. She knew that the company had a store in those markets, but she had no access to sales data.

As often seemed to happen in AdDept installations, this unexpected revelation allowed Stage Stores to save enough money on an inefficient use of funds to justify most of the cost of the entire system.

Brenda, Floyd, and Denise Bessette at TSI’s office.

Training and installation: In 1997 Stage sent three employees to TSI’s office in Enfield for several days of intensive training: Brenda, Floyd Smith6, and Hugo DuBois7. The emphasis of the training was on how to get the most out of the AdDept software in their environment.

Floyd was Brenda’s right-hand man in the business office. For the first few years—which (for reasons unrelated to the system) were rather chaotic—Floyd was the liaison between TSI and Stage. Hugo, a native of Belgium, managed the department’s local area network. He mainly worked with the production and creative people. I am not sure why he came to Enfield. Hugo’s only role in the project was to connect the network to the AS/400 and to install and configure the software on individual PC’s and Macs so that the department’s employees could access the AdDept system.

After the AS/400 had been delivered, and the network was connected to it, I flew to Houston to install the AdDept software and configure the database. Over the next few months I returned to help them deal with problems, to show them how to use new features, and to gather ideas about further development. I soon discovered that there was a better way to get from Connecticut to Stage. On most trips I flew on Delta or American and landed at Houston’s smaller airport, Hobby. Not only was it much closer to Stage, but there was usually a better choice of flight times.

Denise, Floyd, Hugo, the top of Brenda’s head, and Steve Shaw at TSI’s office.

Within a year or so the system was running fairly smoothly. Then in 1998 Brenda left Stage Stores, and for a while Floyd ran the advertising business office. His primary assistant was Toni Young8. One of the primary AdDept users was Renee Mottu9, who managed the expense invoices.

Fortunately for TSI, for the next year our involvement with Stage was reduced to answering phone calls and resolving mundane issues. I say “fortunately” because even though Stage Stores declared Chapter 11 bankruptcy in 1999, the effect on TSI’s bottom line was minimal. The effect on daily life in Stage’s advertising department was for a considerable period much more severe. My notes after a visit to their headquarters in January of 2000 stressed that “Those poor people spend half of their time trying to persuade newspapers to run their ads.”

Karen is in the red jacket. The man who is obscuring Floyd is, I think, the Advertising Director.

Brenda was replaced by Karen Peltz, who had held a similar position at Foley’s10, the chain of department stores owned by the May Company that was also based in Houston. At the time Foley’s had been using AdDept to solve various problems in its advertising department for five years. I had worked with Karen at Foley’s, but only a little. Eventually Floyd moved to another position at Stage Stores, and Toni Young managed the day-to-day operations of the marketing business office thereafter.

Joanne’s LinkedIn photo.

I had only a few interactions with Joanne Swartz11, the Senior VP of Marketing, and the guy who was Advertising Director. I do not remember his name. I think that Karen reported directly to Joanne.

I dealt with two people in the media area. The woman’s name was Deidre Prince11. I do not remember the guy’s name, and it is not in the notes. I also remember Sandra Green, who used AdDept for buying newspaper space. She seemed to have a lot more difficulty using the system than anyone else did.

My notes: I discovered quite a few email messages that I sent back to TSI’s office from Stage. They are dated between October 1999 and January 2001. I’ll start withe the earliest one

The New Skin bottle and the shaving/ medical kit that I kept it in.

Not a great start today. I woke up at 6 AM. I got up and stumbled around the hotel room for a few minutes. I ironed some shirts and pants. At 6:55 I shaved. I looked in the mirror and saw Dracula. The blood was pouring from my lip. It took over 40 minutes for it to stop bleeding. I painted the New Skin on it. I got dressed and went to Stage. The New Skin held until almost 5 PM. Then I bled all over my shirt and pants, but this time I got it to stop in only about five minutes. Life on the road is so glamorous.

Renee Mottu is looking for suggestions as to how to remove two possums that have taken up residence beneath her mobile home. She rejected my idea of sending in a dachshund. She said that the possums would eat a dog.

I didn’t get to run tonight. Toni Young told me about a good trail. I put on my running duds, followed her directions, and drove around for about 25 minutes looking for the place. I never found it. I drove back to the hotel, got some food, and settled into my room to watch “Norm” and “The Drew Carey” show.

I am pretty sure that the woman with the big hair to the right of Floyd is Renee Mottu. I don’t remember the names of the other two ladies.

The first paragraph refers to a blue-black circle that appeared on my left lower lip in the nineties. It has never caused any pain, and it has not bled in the last decade or so. The story of Renee and her possum continued for a few visits. Before reading the above I had totally forgotten that for a while Norm McDonald had a network television show.

The following are from the subsequent two days on the same trip.

Toni and Floyd.

It was in the 80’s here yesterday, but it felt cooler. There was almost no humidity, which is rare for Houston. Floyd’s office was freezing. He has an electric heater in his office. We had it running most of the day even though we had six people crowded around his PC all day long. I brought sweaters, and I will wear one today.

Stage has network printers. We sent a 40-page report to Floyd’s printer about noon. It was still in SND status when I left at 6 PM. Floyd said it will sometimes not print until the next morning. Have they ever complained about this? I think the culprit may be the faxing. They were faxing all day yesterday.

I noticed at Stage that their floors must not be very level. The pieces of their desk units come together at angles. I also noticed that some units were raised off the floor as much as an inch on one side.

I don’t think that I could possibly in good conscience approve more than five months for the palm tree research project at this time.

How much do you think is the monthly fee that Reynolds Communications charges Stage to handle (including auditing and approving invoices from stations) their broadcast advertising?

I don’t remember the precise answer to the last question, but I am pretty sure that there were two digits to the left of the comma. The next set of emails came from the trip that began on January 11, 2000.

This Silver Medallion card expired many years ago.

I was dreading the flight to Atlanta. I envisioned myself standing in line with the common people now that my silver medallion card has expired. I was delighted to discover that my ticket still says “Silver Medallion.” Half of the flight got on with the medallion status group.

The phone on my seat on the flight from Hartford to Atlanta has a little LCD display. It discloses the NASDAQ closing price every few minutes along with advertisements for various ways to spend your money on the phone.

A lady on the Atlanta flight has striped hair. Not streaks, stripes. She has brown hair intermixed with ½” blonde stripes. I guess it is a look.

The flight from Atlanta to Houston sat in the gate for about 20 minutes. Then we got in the usual long line to take off. It must have been over 100 degrees in the cabin by the time we hit the skies. The guy in the seat in front of me pushed his seat all the way back. I have therefore had to turn 45 degrees and put my laptop on my lap. Even so it is uncomfortable to type. Thankfully there is no one next to me.

Listening to Kiri Te Kanawa sure beats listening to salesmen. On my last few flights the planes were full of families and college students. The passengers on both of Tuesday night’s flights have been mostly middle-aged men.

I still have a 45 minute drive ahead of me after this flight, which won’t get in until about 11:00 central time. I need some caffeine.

I used the air conditioner in the car all the way from the airport to the motel.

… Renee Mottu asked me to hire her. I told her that we needed experienced, or at least trained, programmers. She pressed me on this. She said that she was sure she could learn programming and that Floyd would give her a good reference. By the way, she said all of this in front of Floyd.

I’ll take a dachshund any day.

I remembered to ask Renee what happened to the possums living under her trailer. She said they were still there. I repeated my recommendation about the dog. She said she didn’t have one. I said she should borrow one. She asked me (!) if I knew anyone who had a dog she could use. Later I heard her walking around intoning “Does anyone have a dog I can borrow?”

I think that by 2001 Stage Stores must have been emerging from bankruptcy and resuming their strategy of expansion by purchasing other chains. The biggest of those was the acquisition of Peebles, a chain of 125 department stores based in South Hill, VA.

For some reason the management at Stage wanted to keep track of all expenses and co-op income of the Peebles stores separately. This was the first, but not the last, time that I installed a second AdDept database on the same AS/400. There was still only one set of programs, but each user had two AS/400 user ID’s. Their profiles determined which database would be used.

Here are some of my notes from January of 2001:

Leaping Lanny Poppo became one late in his wrestling career

The meeting in the afternoon went well. Joanne, the advertising VP introduced me as “the resident genius.” The project has been scaled down. We need to be able to do accruals at the store level for media and production at the store level. We also need to be able to do prepaid to expense. One unusual wrinkle is that they do not want to allocate creative costs to stores. They want to be able to get ratios of advertising expense to sales from AdDept, but we must be able to reconcile this with what is in the G/L.

I was glad that I was an outsider at this meeting. The politics was just barely below the surface. Chuck, who I think is the CFO, put Joanne on the spot about something that was not even on the agenda. Their explanations were not at all impressive. The experience had the happy effect of reminding why I did not like working at a larger company.

Toni Young says that she thinks that Renee Mottu never got rid of her possums.

It turns out that what Stage really wants to do most is to start using what they have and what we have previously proposed—SmartPlus interface, sales interface, and expense payables interface. They spoke of the SmartPlus interface as if it were a done deal. I don’t recall them purchasing this module. I brought back the file layout for the expense interface. I did not come back with a lot of specs for new projects. Believe it or not, they want another week of my time. Both Karen and Joanne (the Senior VP) seriously asked me to stay over the weekend and spend next week in Houston. I didn’t tell them this, but I don’t think that I could have lasted for 24 days.

01/07/01: I was surprised to discover that in 1997 Stage paid us over $8,000 for the expense payables, sales, MM Plus, and AdSEND (!) interfaces. No wonder we made so much money in those days. We have no choice but to give them the assistance they need to get the first three working. They don’t use AdSEND any more, thank goodness, and I am pretty certain that no one remembers that they paid for this. I don’t remember coding an expense interface for Stage, but we clearly did it in 1998. I will write up a quote to change it to work the way that the new documentation states.

Toni Young said that she thinks that Renee Mottu had not solved her possum problem.

I saw a sign at Stage Stores offering a $3,000 bonus to any employee that refers someone hired as a senior analyst in IS. The candidate must have five years of COBOL or Oracle experience.

Evidently I had already scheduled most of the rest of the month of January 2001 to travel to other clients so that if I had agreed to stay in Houston over the weekend and the following week, I would have been on the road for twenty-four days in a row! In those days we were charging $1,000 per day for my time. If Stage had still been in Chapter 11, I doubt that they would have proposed spending another $7,000 for another week of my presence. The bankruptcy court would have needed to approve the expense.

AdSend was a service offered by the Associated Press for sending the images of ad layouts to the newspapers. Hugo once told me that the company had twelve T-1 lines (TSI had one), and, according to him it was not nearly enough.

The neighborhood: Stage seemed to be a nice place to work. The headquarters was a fairly nice building located on the south side of Houston. They always provided me with a comfortable place to work, and there was ample parking in spaces reserved for vendors. The building also had a cafeteria that offered good food at very reasonable prices. I always ate lunch there, usually by myself. Many employees arrived at work early and ate breakfast there.

I took this photo of Enron Field under construction. It is now called Minute Maid Park.

It was not too easy to reach by a car driven from the south. Just north of the building Main Street became a divided highway with restricted access. Since I always stayed in a hotel north of the building, I had to drive my rental car to the first exit, drive under the highway, and then take the access road back to Stage’s driveway.

Most of Houston’s explosive growth had been in other directions. There was not much south of Stage’s location. However, just north of the building were the medical centers for which Houston was famous and Enron Field, which is where the Houston Astros played after the Astrodome was abandoned in 1999. I got to see (and photograph) the construction of the new stadium.

According to Yelp Marco’s is closed, but it still has a website.

I usually stayed in a Hampton Inn a few blocks from the stadium. My favorite restaurant was a Mexican place called Marco’s. Located in a hard-to-reach strip mall near my hotel, it was where I first became acquainted with tacos al carbon, one of my favorite dishes. Marco’s had ridiculously low prices. I often told the manager that they should open restaurants in the northeast. They could have doubled their prices and still filled the place every night.

During a couple of multi-day trips to Stage I met up with Sue’s cousin, Mark Davis, for supper. He worked for Exxon Mobil. We usually at an Olive Garden. The conversation was better than the food.

I jogged on the streets near the hotel nearly every evening when I visited Stage. I worked out a route that kept me on streets that had very little traffic.

Eventually I discovered a delightful dirt track that surrounded a golf course in Memorial Park. I drove there every chance that I got. A loop around the track was a little less than three miles. I usually did two loops. There is no chance that I would ever move to Texas. However, if I did, it would be to Houston, and the primary motive would be to gain access to this track every day.

The people: I was quite surprised by the LinkedIn pages of the people with whom I worked at Stage. We had not done much work for the company after 2008 or so. Consequently, I really had no idea who was still working there after that. I discovered that many of them remained at Stage Stores quite a long time after I last saw them or talked with them.

Brenda on Facebook.

TSI’s initial contact, Brenda, departed in 1998. I don’t know why she left Stage so soon after we did the installation. There might be a story there. I don’t recall ever hearing her name mentioned again.

I have many memories of Floyd. He was definitely a family man. He was always cheerful and business-minded. He always ate lunch at his desk. His office was not very large, but it had two doors, which he kept open. Some people used his office as a shortcut to get from one part of the marketing department to another. I was surprised when he and Toni seemed to switch jobs after Karen arrived. That was never explained to me. Floyd was employed by Stage Stores until 2011.

I was acquainted with Karen from her days at Foley’s. When she arrived at Stage, she made it clear to me that one of her top priorities was for the department to make better use of AdDept. A Republican, she assured all of us in January of 2001 that George W. Bush “will not be that bad.” After his two incredibly stupid wars and an economy that totally tanked while he and his cronies watched helplessly, most historian vehemently disagree.

Karen was, to my amazement, an avid biker—not mountain bikes, Harleys. She and her husband rode up to the big gathering in Sturgis, SD, at least once. I have always told people that if you saw me on a motorcycle, you can be certain that I will also be smoking a cigarette and showing off my piercings and tattoos.

Karen worked at Stage until 2013, twice as long as her stint at Foley’s. Her LinkedIn page lists no jobs after she left Stage Stores.

I remember that Hugo drove a Saturn—as did I during that period. His, however, was a coupe. If I had known that Saturn sold two-door cars, I would have bought one. Hugo stayed until 2017.

Toni and Floyd.

I did not really have much personal contact with Joanne, aside from that one meeting that they asked me to attend in 2001. I do remember that on one occasion I overheard Renee accosting her in the hallway. Renee said, quite loudly, “Joanne, I need a raise!” If Joanne replied, I did not hear the answer. Joanne left Stage Stores in 2012.

Toni apparently never left Stage Stores. The more that I worked with her the more that I respected her.

Somebody, Floyd, and Deidre.

When I met Deidre I asked her if she was related to Diana Prince. She did not know whom I was talking about. I guess not everyone was a fan of Wonder Woman on TV and in the comic books.

I think that Deidre was our main contact when I showed the AxN12 system to the department in 2003 or 2004. They enthusiastically endorsed it and used it until they outsourced the buying of newspaper space to an outside company. Deidre left Stage in 2011.

Epilogue: I think that our last major dealings with Stage were the implementation of AxN and the Peebles project. Nevertheless, they were still using AdDept when TSI went out of business in 2014.

Unlike most retailers Stage Stores continued to expand in the twenty-teens by acquiring other chains. In 2017 Stage acquired the assets of the Gordman’s chain of department stores and quickly converted all of them to sell off-priced items. This worked so well that they began to convert most of their other stores to the same format. In the November 2019-February 2020 quarter sales were up 19 percent14.

Then the pandemic struck and Stage Stores was stuck with a lot of debt and 738 stores that could not be expected to generate any revenue in the immediate future. The price of the company’s stock plummeted. In May of 2020 Stage entered Chapter 11 again, and in August it announced that it was liquidating all of its holdings.

1. For some reason SRI insisted on a new contract every year. We had contracts with all of our AdDept clients, but all of the others were open-ended.

2. There is also an unrelated chain of department stores with the Bealls moniker that is based in Florida. My unsuccessful pitch to that company is detailed here.

3. Years after TSI was closed SRI moved to an office building at 2425 West Loop South. I tried to use Google Maps to find the Main Street building with which I was so familiar, but I failed. I think that it must have been demolished.

4. Brenda’s LinkedIn page is here. I had trouble remember her last name. I sent an email to Floyd Smith asking if he knew it. He replied, “Sure. She is also on Facebook..” Confused, I asked again. Floyd wrote, “Suire is her last name.  Sorry about that spell check changed it last time.”

5. The Media Management Plus product was renamed SmartPlus. I think that this may have happened when the company was purchased by Arbitron, the rating service. On the Internet I found a very detailed description of what SmartPlus did. It is posted here.

Floyd’s LinkedIn photo.

6. Floyd’s LinkedIn page is here.

Hugo’s LinkedIn Photo.

7. Hugo’s LinkedIn page can be viewed here.

8. In 1997 I was only 49. I was shocked that year to learn that Toni Young, who was younger than I was, had a grandchild who was by no means an infant. Her LinkedIn page is here.

Toni’s LinkedIn Photo.

9. I found no LinkedIn page for Renee Mottu. Her Facebook page is here. I was surprised to discover that it contained even less than mine does.

10. A great deal more has been written about the AdDept installation at Foley’s. The account is posted here.

11. Joanne Swartz’s LinkedIn page can be viewed here.

12. Deidre Prince’s LinkedIn page is here.

13. AxN was the name that I gave to TSI’s Internet program for management of insertion orders that AdDept users sent to newspapers. Its system design is explicated here. The marketing history is described here. Stage’s use of the system was one of the main reason that the number of subscribing newspapers grew so large—at one point over four hundred!

14. The Philadelphia Inquirer picked up this story from the Washington Post and posted it here.

1991-2006 TSI: AdDept Client: Hecht’s

Posted on by
7

A May Co. division with headquarters in Arlington, VA. Continue reading →

In 1991 I received what probably was the most welcome business telephone call in my life. At the time TSI had only two AdDept1 clients, Macy’s Northeast2, and P.A. Bergner & Co.3 I had recently sent to the advertising directors of several dozen other large retailers a letter that described the AdDept system and the positive effects that it had produced at its first two installations. The phone call was from Barbara Schane Jackson4 of the Hecht Company, a department store chain in the mid-Atlantic area. I did not realize it before that first call, but Hecht’s was one of the divisions of the May Company.

Barbara explained that the advertising department was looking for a system that would handle its administrative requirements. She emphasized that it absolutely must be able to produce the data for the 790, a monthly report required by the May Co. that broke out advertising expenses and co-op at the CCN5 level. She explained that at the end of every month the financial area of the department struggled to get the report out by combining the data from many spreadsheets. They were barely able to do this by leaving six or seven PC’s running all night. There were two big disadvantages. 1) If anything went wrong, they had no plan B. The May Co. required them to file the report within a week after the end of the month. 2) Hecht’s had recently acquired more stores, and they anticipated more acquisitions in the near future. Their PC approach probably could not handle the additional load.

When I assured her that this sounded feasible, Barbara invited us to visit their headquarters in Arlington, VA, and, if possible, do a demo of the system. This was music to my ears. Not only was Hecht’s a very well qualified prospect for the AdDept System. If we did a good job, we would have a much better chance of signing up the eleven other divisions of department stores owned by the May Company that were all very well-qualified prospects for the AdDept system .

Our marketing person at the time was Tom Moran6. Sue Comparetto, Tom, and I drove down to Washington in Sue’s Saturn station wagon. We certainly could not have afforded to buy three round-trip plane tickets at the time. We stayed at a Motel 6 in Maryland just outside of Washington. We could afford nothing better. Actually we could not afford that.

Hecht’s Ballston store.

I don’t remember too many of the details about the visit. We met in Hecht’s Arlington store, which was in the Ballston Common Mall. In addition to Barbara and the advertising director, whose name was, I think, Steve, we also probably met with the media, production, and finance managers. Barbara certainly provided me with all the requirements for the 790 report. It did not seem too daunting. The rules were more complicated than the ones that Macy’s used for their reports by Vice President, but the principles were very similar.

Barbara at some point demonstrated the process that they used at the time, which involved Lotus 123 spreadsheets. I could not believe how adept she was at the use of this product. Her fingers flew around the keyboard executing commands and macros.

After my demo the sale was in the bag.

I did a demo for them at an IBM office in . Barbara later told me that she and Steve had serious doubts about how the answer to their problems could possibly be this ugly. She might have been referring to my appearance, but I think that they were most likely underwhelmed by the AS/400’s7 green screens and the pedestrian nature of its reports. There were no graphics of any sort anywhere. The only flash that my presentation had was how fast the screens appeared. In those days users were accustomed to substantial delays going from one step to the next.

The proposal that I wrote for Hecht’s was much more detailed about the contents of the first stage of the installation than what I had submitted to Macy’s or Bergner’s. We recommended, as I recall, that they purchase a model D10, a box that was considerably faster than TSI’s developmental system, but probably not as fast as the one used by Macy’s and Bergner’s.

The hardware determination was largely guesswork. IBM did not provide the usual performance numbers about its systems. For example, there were no statistics about the clock speed of the processors. I later came to understand why IBM did this, but at that time it seemed very strange that two different models actually had the same processors. The only difference was that the more expensive one had the capacity for more disk drives and memory cards. It did not come with these features; it merely had a way to attach them. I always recommended the more economical system unless the client really had a need for those drives or cards.

The installation began in October of 1991. The process of integrating the necessary changes was, as expected, difficult. However, it was never unpleasant. Barbara was a superb liaison, and most of the modules went in with no significant problems. The changes that I had to make to the cost accounting8 programs caused me quite a few headaches.

At one point I tried to document the steps of the “explosion” process—TSI’s term for the set of program that created the detail and summary files used by the programs that produced the 790 report. I quit after I had produced ten pages. I was not close to finished, and the result was totally unreadable. Every sentence started with the word “If”.

A major enhancement for Hecht’s provided for different types of costs being allocated in different ways. This required establishment of a table of allocation codes as well as an interface with the mainframe’s sales system to obtain the sales by department for the month. We also provided for a set of reconciliation programs to check the consistency of the results.

I distinctly remember two of the first attempts that we made to generate the cost accounting files. In both cases, Barbara submitted the program to run in batch mode (not tying up any input devices). I was in Enfield, but my AS/400 session had “passed through” to Hecht’s system. At the same time I was on the phone with Barbara.

Angus Podgorny was humanity’s last hope at Wimbledon.

In the first instance I was a little bit worried about how large the detail file that the system created might become. I monitored it and what the percentage of the ads that the program had already handled.

After just a few minutes I realized that the file was becoming very large very quickly. “Oh, no!” I warned Barbara. “The program is eating up the disk like the Blancmange! You’ve got to go to the system console and kill the job immediately.”

I am not sure whether Barbara understood the Monty Python reference (in which a Blancmange from planet Skyron of the Andromeda Galaxy eats people in order to win Wimbledon), but she laughed anyway. She certainly knew what a blancmange was; she had actually majored in French. She killed the job in plenty of time, and I deleted the records in the file.

The disk-gobbling program could have been a serious problem. If the the system’s disk drives had approached 100 percent usage, I am not sure what would have happened. It would not have been pleasant; we almost certainly would have had to involve IBM. After the job was killed, and the file was whittled down to size, I had to change the program to summarize in a few places where it had been writing details. This was a major repair, and it took me a while.

Not this guy.

The second incident involved some kind of tricky allocation that I had not anticipated. I don’t remember the details. Barbara had already called two or three times to report that this aspect of the program was not working correctly. Each time I thought that I had fixed it. In the last call I admitted that “I just can’t seem to get this right!” I did not mean that I was giving up on it. In fact, I found the final problem in less than an hour after acknowledging my failures.

When we got the cost accounting program to work perfectly, Hecht’s was very happy.

The airport is at the bottom of this map. Taking the Metro was fine unless there was a problem.

I made quite a few trips to Hecht’s during the first phase of the installation. There were direct flights from Bradley to National Airport in Washington on US Airways. From the airport I took the Metro or a taxi to Ballston. I could be at Hecht’s before business hours, a feat that I could never manage at Macy’s, which was less than half as far away from Enfield.

If my visit was for more than one day, I generally stayed at a Comfort Inn that was within a few blocks of the mall.9 I always left the hotel early in the morning. I bought a Washington Post from the dispenser just outside of the mall—for twenty-five cents! I then took the escalator down to the food court and bought a Big Breakfast or an Egg McMuffin and a large coffee from McDonald’s. I ate my breakfast while reading the Post. I also drank about half of the coffee.

Coffee in hand, I rode the escalator back up. I then entered Hecht’s through the employee entrance, signed in, and took the elevator up to the advertising department. I worked mostly with Barbara. She did most of the training or the other users.

About half the time Barbara and I ate lunch at a restaurant in the mall. It was called the American Restaurant or something similar. We talked mostly about the installation and related matters. She knew that I went jogging in the evenings when I was there; she was surprised that I could survive without my glasses. She was a swimmer. The ropes that marked the lanes evidently kept her from getting lost.

She also told me something about needing to use a shop-vac on one occasion.

All of this seemed a little strange to me. Her husband, Kevin Jackson, also worked in the advertising department. My recollection is that he was an art director; he had no contact with the system. He never came to lunch with us.

Barbara resigned from Hecht’s in May of 1993 to work for Barrister Information Systems, a company that created and marketed a software system for law firms.

After Barbara left, Hecht’s continued to use the system, but they did not ask us for much more work, and they did not take advantage of many of the programs that they had. I do not remember the names of very many employees. In fact, the only one whom I recall was Ellen Horn, and that was mostly due to the fact that I saw her so often at her next stop, Belk.

I discovered quite a few notes about the account that covered the period from 2000-2003. I have somewhat vague memories of some of them. Here are some of the people who were mentioned.

Jim Tonnessen surrounded by his computers.
  • Jim Tonnessen10 was our liaison at the turn of the century. I think that he also managed the department’s network, which was installed after AdDept was functional. Jim took a job with UUNet in February, 2000.
  • Jim was replaced by Clint Gibson, but he also departed in August of the same year.
  • The nexttechnical liaison was Sam Wiafe, who was later known as Kwadwo.11 I guess that he knew computers, but he knew nothing about AdDept, the AS/400, or the needs of the advertising department. The IT people tried to implement a firewall for the AS/440 in order to control access. It was a silly idea that angered me a little.
  • Jennifer Jones12 was the manager of the advertising business office in 2000. Chris Dechene13 held that position before her. I made a trip to Hecht’s in June of 1999 for the specific purpose of getting Chris acquainted with the cost accounting programs. One of the problems that we encountered at Hecht’s was that the financial people were rotated around every two years. So, as soon as anyone got a good handle on the cost accounting process, we could expect them to be transferred to another area. These people also were not exceptionally good at documenting their procedures.
  • Prior to 2000 Hecht’s for some reason did not use one of AdDept’s best features, insertion orders for newspaper advertising. On a trip there in that year I met Renee Gatling14, Ellen Rison, and someone named Sharon. Renee was already pretty good at getting around in AdDept. I convinced them that they should be faxing their orders using AdDept.
  • By the end of 2000 I think that our primary liaison at Hecht’s was someone named Amy. I don’t remember her, but when we installed the Media Management + interface for broadcast, she was involved. The broadcast buyers at that time were named Krista and Tiffany. I found their names in my notes.
  • In October 2002 Brian Kipp, whom I had worked with at Meier & Frank, became the planning manger in the advertising department. Carolyn Thompson and a woman named Renée worked for him.
  • I spent a good deal of time on one visit with Rene Basham15, who was the manager of the advertising business office. I was astounded to learn that she had not been using the reconciliation process that we set up for the cost accounting. I went through this with her and also worked on documenting the process for the next person who was rotated into the slot.

In looking through the notes I discovered two other interesting things. The first was that Hecht’s used a product called Wam!Net to deliver its ads electronically to the newspapers. The Associated Press developed a product called AdSend, which most large advertising departments used. At the time (early 2000) TSI was beginning to roll out our AxN16 product for insertion orders via the Internet, and we were contemplating using the connection that the program established to send ads as well.

One day while I was at Hecht’s in 2002 the performance on the machine was terrible. In the notes I had attributed this to CFINT, an IBM program that I had completely forgotten about. It was a misbegotten effort from IBM to make customers pay more for use of the system for interactive jobs than for batch jobs by slowing the entire system down if the percentage of CPU used by batch jobs was too high!

The main effect of this effort, as far as I could ascertain, was to infuriate the customers. It is possible that the real motivation was to prevent the AS/400 from encroaching on the sales of other IBM systems.

I have one other peculiar recollection. At some point after 2002 I was in the office on a Saturday. It must have been November, and I must have passed through to Hecht’s system to help someone there with a problem. We exchanged a few messages. I then whimsically invited her to come the following day to a big party that I was throwing to celebrate the divestiture of the foliage on the nine maple trees on my property. I recommended that she recruit a bunch of people with their own rakes. An early start would reward them with the spectacular view of the sunrise from the New Jersey Turnpike. I reckoned that they should have time for six or seven hours of New England’s favorite autumnal sport before returning home. They could make it back by midnight unless they encountered traffic.

On February 1, 2006, Federated Department Stores, which had purchased the entire May Co., dissolved most of the former May Co. divisions, and the existing Hecht’s stores were divided between Macy’s East and Macy’s South. Few, if any, employees from Hecht’s headquarters in Arlington went to work for Macy’s.

1. The design of the AdDept system is described in a fair amount of detail here.

2. A description of the Macy’s installation has been posted here.

3. A description of the installation at Bergner’s can be read here.

4. Barbara Schane Jackson has her own consulting firm in 2021. Her LinkedIn page is here.

5. Every department was assigned to exactly one CCN. The CCN’s were the same for each division of the May Company. The N stood for number, but I don’t think that I ever knew what the two C’s referred to.

6. More information about Tom Moran’s career at TSI can be found here.

7. The AS/400 was a multi-user relational database computer introduced by IBM in 1988. It is described in some detail here.

8. In AdDept we used the term “cost accounting” to describe the process of allocating costs to departments (or, in some installations, stores) for the ads in which their merchandise appeared and the cost of more generic ads (called “storewide”). This was a complicated activity that would require a small army of clerks if not done on the computer. Although the May Co. had precise rules about this process, it was almost impossible for the smaller divisions, which ran just as many ads (in fewer newspapers) and had just as many departments, to accomplish it within the deadlines. They therefore cut corners.

9. The mall is now called Ballston Quarter. It was (pretty much) closed down in 2016 and reopened in 2018. The hotel is still nearby.

10. In 2021 Jim works for Lockheed-Martin. His LinkedIn page is here.

11. Kwadwo’s LinkedIn page can be viewed here. In 2023 he was working for Inova Health Systems.

Bridge author.
Oscar winner.

12. Jennifer Jones works as treasurer of a school. Her LinkedIn page can be found here. I wonder how many of her acquaintances have also seen The Song of Bernadette, the movie that won the actress Jennifer Jones an Oscar, and read all thirteen of the articles championing Losing Trick Count in the Bridge Bulletin written by the bridge expert Jennifer Jones. Not many, I wager.

13. Chris Dechene’s LinkedIn page is posted here.

14. Renee Gatling’s profile on LinkedIn can be found here.

15. Rene Basham is still in the Washington area. Her LinkedIn page is here.

16. The design of AxN is described in some detail here

1988-2014 TSI: AdDept: System Structure

Posted on by
2

A complicated system. Continue reading →

People who have not worked in retail advertising will probably have trouble understanding this entry. Nevertheless, because the AdDept system was the focus of my life for so many years, I feel obliged to document as much of its structure as I can remember. It did not occur to me that I might want to undertake such a task until very recently. Consequently, when I closed down TSI in 2014 I discarded almost all of the system’s documentation. The few computer files that I have subsequently found are mostly PageMaker documents. I don’t have that software on my computer, and the files are too large for the services that will convert them to pdf files online. So, I must rely on my memory, which is not as reliable as it once was.

AdDept was designed for and implemented in OS/400, the operating system of the AS/400 and its follow-on hardware. Some of the important and unique features of this operating system are described here. Every line of code that we wrote in 1988 still worked in 2014, and I have no reason to expect the code to stop working any time soon.

All programs were originally written in BASIC. Around the turn of the century IBM stopped supporting BASIC, but TSI was authorized to install the product (a compiler, and interpreters of both BASIC commands and BASIC procedures) on any system that use our software. This only caused one major problem, which is documented here. However, Denise Bessette did not like this arrangement and undertook to convert the programs to ILE RPG. I never appreciated the value of that idea, and I never took the time to learn that language, which is supported on no other system.

All data tables and the major programs in AdDept began with the letter D, which stood for department. This was for TSI’s benefit. The ad agency system used a similar structure, but no files or programs began with D. The second letter in AdDept tables was usually A, I, M, or P, which stood for accounting, (loan room) inventory, media, and production. Programs that were used for cleanup, copying, and other miscellaneous tasks began with DX.

All AdDept programs were stored in the same library1. It was usually named TSIPROG. The data was in a library named TSIDATA. A few clients had additional data libraries for additional companies. At these installations we created a separate library called COMMON or TSIDATACOM to hold the tables that were used for both companies. For example, both companies probably used the same ad types and expense classes (major media). The tables used by both were moved from TSIDATA to the common library. A new data library was created for the data files for the second company. In the beginning it contained empty copies of all of the remaining files in TSIDATA.

No two instances of AdDept were the same, but each had the same TSIPROG library. The settings for each installation were designated in two ways: 1) A set of empty one-byte files, the existence of which activated certain features; 2) a file called DASPECS that contained a very large number of switches, descriptions, and system values. The program to maintain the system values was not on a menu, and users were not allowed to run it.

Everyone needed a user ID to sign on to the system. Those connecting through a network could have any number of simultaneous sessions open.

AdDept’s user table, which was also on no menu and could be run only by the AdDept liaison, limited the programs to which the user had access. If the same employee worked with two different data libraries, a second user ID was required. The two user ID’s would have different library lists.This arrangement may sound cumbersome to people who are used to managing hundreds or even thousands of nested folders, but it did not seem strange to the users of a multi-user system. Furthermore, it was absolutely critical that changes not be made on files in the wrong library. All TSI menus displayed the name of the data library to help eliminate confusion.

The retail calendar was accommodated by the season table. The key was a three-digit number. The first two digits were the fiscal year. The third digit was 0, 1, or 2. 0 meant that a standard twelve-month calendar was used. 1 and 2 were used for 4-5-4 retail calendars, which are described here. This table contained the name of the season, the starting date, and the number of weeks in the season.

Ads were classified by three separate codes:

  1. The one-digit insertion code determined which set of screens was used for data entry. This was a fixed set, but more codes could be added for additional media.
  2. The one-digit expense class identified how the ads were categorized for accounting purposes. Later a sub-class code (blank default) was added for one client.
  3. The two-digit ad type was specified when an ad was created. This table held the insertion code and expense class. It also had a binary field to identify whether color charges were applicable.

Media vehicles, such as newspapers, magazines, and broadcast stations and networks (called pubs in AdDept), were identified by a five character codes combined with a two-digit number (usually 0). For newspapers at least one number was reserved for inserts (usually 10). The users specified the days on which the paper published, whether it was AM, PM, or a combo2 and the paper’s depth (maximum number of inches vertically on a page). For direct mail the pubs were usually geographic markets.

Stores could be identified by a five-digit number.

Every pub had a list of stores that were associated with it. There was also a date-sensitive pub-store allocation table that contained the percentages allocated to each store associated with the pub. The key to this table included an effective date. Less than half the AdDept retailers allocated costs to stores, but the ability to do so was very important to those that did.

AdDept users almost never paid the published rates.

Rates for ROP and inserts were date-sensitive. For ROP separate rates could be entered for black-and-white and several different color choices. There were also tables for linage-based discounts and premiums for things like special positioning such as “back of main”—the last page on the first section of a paper. For inserts a table of usual quantities (thousands of copies) could be created, with rates for each.

The system needed to be able to find the right rate to apply whenever an ad was changed or moved. Costs could also be recalculated en masse when a new contract had been negotiated. These were attractive features.

Probably the best idea that I had when designing the system was to allow the definition of pub groups (identified by five-character codes) to specify sets of pubs in which the same ads often ran. Clients could have hundreds of these or none. When a new ad was created, one pub group could be specified. A schedule could automatically be created with all the pubs in the group.

The hierarchy of participating merchants had five levels in AdDept. The lowest (most detailed) was the department. The system called the other four ADMGP, GRPVP, SENVP, and GRSEN to match Macy’s East’s designations. Most retailers had only two: DMM’s and GMM’s. The May company used “CCN numbers” to group related departments. For each level each client determined the descriptions used on screens and reports.

Employees were identified by three-character codes. Employees could be assigned to production jobs. So, an employee could see a list of all of his open assignments.

The traffic system allowed specification of a code for each production job that determined the job’s production schedule. So, black-and-white ROP ads might have a three-week production schedule with eight steps. The number of days for each step could be specified. Then the system would count backwards from the release date to build a schedule of due dates that accounted for weekends and holidays. The completion dates of each could also be entered (an X meant “today”).

This seemed important to several clients, and we built it precisely the way it was described to us. However, the production employees did not like it. For one thing, most of them used Macs for working on the ads, and they found a text-based system clumsy. I don’t honestly think that they would have liked it much better with a GUI (graphical user interface) as the front end.

The accounting tables were similar to those in the GrandAd System (described here) or any other system. They were designed to be consistent with whatever system was used by the accounting department, but AdDept users did not need to memorize the very long codes that were common in those systems. In AdDept the main entity was the sub-account, which was identified by a five-character code. One corporate G/L account was specified for each sub-account.

The vendor table also had a five-character key. The corporate vendor number was specified there. This table was used for merchandise, media, production, and other vendors.

Categories of production costs were identified by three-digit codes, just as in the GrandAd system.

The Ad Files

The system had one major header file for ads of all types and a number of lists that were associated with it. The ads file3 was identified by the season, a five-digit ad number (usually generated by the system using client-specific rules), and a one character version code (usually blank). The ad number could either be entered or generated by the system. Data entry began with the specification of the run date and ad type. A large amount of information was deduced from those two values. The headline and size4 of the ad were then entered on the header screen, which also contained many other fields.

The second step for ads of all types was the media schedule. If the pub group was accurate, nothing had to be entered here for ROP and inserts. For direct mail the quantities by market were entered.

The third step was the list of participants with percentages and co-op commitments.

Expected production costs could either be entered as one lump sum or detailed by category.

Audit Trails

History records were created for any activity that affected planned, committed, or actual costs or income. Reports and screens were written for viewing them. A few custom reports were also written for clients.

Planning

New ads were ordinarily assigned a status of P, which stood for “planned”. When the plan was completely approved, a program could be run to change the status of all status P ads to A (active). At the same time records of the detail of the costs of those ads at that time were recorded in separate files named DAPLAN (by department or group) and DAPLANST (by store).

Changes could still be made to any aspect of any ad, of course. Those values were considered “committed”. The actual costs were based on the measurements and the invoices from the media and production vendors. Actual co-op was based on the “claims” that had been processed.

In subsequent years several AdDept users let the system build the entire schedule based on the previous year. Thus season 951 could be built based on the ads run in 941. This process was called “anniversarying”.

Cost Accounting

What I called “cost accounting” was commonly called BI later.

Most advertising departments were keenly interested in comparing planned, committed, and actual costs by merchant or by store. AdDept had programs that would create detailed records every night by store and/or merchant for all ads in the current season. The merchant records were stored in DACOMMD (committed) and DAPANDL (actual). The records by store were in DACMDST and DAACTST.

Numerous reports were written to allow comparison of planned, committed, and actual costs and income (from co-op). Some users also queried these files on a regular basis using IBM’s Query/400 product.

Interfaces

Broadcast ads could be fed into the system from Doner, the May Company’s ad agency, and from Media Management + files created either internally or by an agency. There may have been one or two others of these.

A couple of clients used ad agencies for their newspaper ads. TSI constructed interfaces to receive the ad schedules from the papers.

Several interfaces were created to send files to feed corporate Accounts Payable and General Ledger systems.

Sales at the department level could be downloaded from the mainframe. Customized reports helped gauge the effectiveness of ads in comparison with the costs.

Backup

It was easy to schedule a backup nightly and to schedule the cost accounting programs to start when the backup was done. The backup would not save files that had record locks. Any time that a record was read from a program that could update that file (as often occurred), the record was locked to prevent one user from accidentally overwriting the work of another. It was sometimes difficult to persuade users either to make sure that everyone had signed off every night or to shut down the interactive subsystem before backing up and restarting it later.

TSI recognized this problem and warned the users about the possibility of lost data if files were not backed up routinely and correctly. We even offered (for a modest fee) to check their backups every day and notify them by telephone if the backup for the previous nights did not complete correctly. Only one client took advantage of this service.

The failure to check backups resulted in one ugly mess that was described here.

Cleanup

By the standards of the day the cost accounting and history files often became extremely large. A menu of programs that permanently deleted records from old seasons was provided.

Other Modules

The Loan Room inventory system was successfully used by Macy’s East for approximately twenty years.

A Photo Shoots system was also designed for Macy’s East, but it was never implemented. I don’t remember why they lost interest in managing the activities of their studio. The location of the studio in Newark may have been a factor.

Many modules were developed for Belk. One that I remember calculated the store’s use tax liability for direct mail pieces for each jurisdiction.

Saks Inc. in 1999 wanted TSI to design a very complicated system for collecting data from the systems of each of its divisions and, eventually, to produce reports that compared divisions. I was very happy that nothing came of this idea.

A special module was created for Radio Shack to manage its advertisements in magazines.

I suspect that there must have been a dozen more of these modules that I cannot recall. We delivered hundreds of custom programs over the years and quoted a similar number that were never approved.

AdDept was a fabulous system. Because it contained so many features, it was somewhat difficult to demo. The screens and most of the reports were ugly. Nevertheless, as soon as prospective clients understood its potential, it was easy to sell to anyone with a budget.

Unfortunately by the time of the Bush-era Great Recession in 2008, Tarot card readings for most major retailers—especially the ones that did a lot of advertising—began with the thirteenth trump card: Death.

1. “Libraries” were a type of object on the AS/400. They were places to store other objects in the same way that folders or directories are used on PC’s. However, it was not possible to build a “tree” of libraries. All other libraries resided in the QUSR library.

2. Yes, a few papers still published two editions per day in the nineties.

3. As far as the OS/400 was concerned, DMADS, the ads file, and the files that contained all of the lists were equivalent to the tables. However, TSI’s organization and documentation drew a useful distinction between the relatively stable tables that were defined at the beginning of the installation and the much more volatile ad files and transaction files.

4. The size for ROP ads was entered in columns and inches. A full-page broadsheet ad was entered as 6×21. The program knew to adjust the inches to match the paper’s depth. The size for inserts was entered in terms of thousands of copies. The size for broadcast ads was the length of the spot in seconds, usually 15 or 30.

1981-1988 TSI: GrandAd: System Structure

Posted on by
4

The design of TSI’s ad agency system. Continue reading →

This entry is rather wonkish. There are no funny stories. I just wanted to record the details while I could still remember them.

I gave our system the name “GrandAd”, but I doubt that anyone ever called it that. We were lucky if the users called it “TSI” rather than “Mike’s system” or “Sue’s system”. The original programs were designed to be run on a Datamaster with an external hard drive (described here). A few years later the system was converted to run on a System/36 (described here). We also converted it to run on an AS/400 (described here).

In the early eighties, administrative software systems generally fell into two categories: BICARSA (Billing, Inventory Control, Accounts Receivable, Sales Analysis) and GLAPPR (General Ledger, Accounts Payable, Payroll). Accounts Receivable was abbreviated as A/R. The GLAPPR modules were abbreviated as G/L, A/P, and P/R)..

GrandAd contained versions of all of these modules except payroll. I don’t remember even one of our agency clients using TSI’s payroll system. From an accounting perspective the distinctive features were that the GrandAd system had two separate methods of billing—media and other—that fed a rather standard accounts receivable system and a unique “media liability” module. The accounts payable system likewise had two separate sets of data entry programs, one for media vendors and one for others. If a bill from a media vendor included production charges, it could be entered in the media payables program after the media portion was completed.

None of the operating systems used by our customers distinguished between tables and data files, but our documentation usually did. In our parlance a table was maintainable by the users through simple editing. Data files could only be maintained through transactions that always created auditable detail records. Transactions were also usually entered in batches that updated the data files all at once. Changes made to items in tables took place immediately. Some important tables contained a few fields that could not be edited by the users. For example the G/L master file contained thirteen fields for the amounts for each month and adjustments. These fields could only be updated by transactions.

Every table had a unique key. The open item files for A/R, A/P, and media liability also had unique keys, as did the file with job costs by category and the media detail table. Detail files for transactions either had no key or keys that were not unique.

There was also one record-oriented specs table that TSI did not tell users about. We maintained this ourselves. It contained things like the agency’s name and address and a large number of “switches”, mostly binary Y/N designations that indicated whether the agency used optional features or the manner in which it used them.

Here were the principal tables, at least as I remember them:

  • Client: The key was a three-digit number. There was a field on this table for an “associated” client number to handle those cases where one company owned several semi-independent entities. Client #10 was usually used for in-house jobs and #11 for one-shot projects.
  • Job Type: The key was a two-digit number.
  • Job: The key was the client number plus a three digit-job number. The numbers could be assigned by the system. A few agencies had their own job numbering system. We kept this number as a twenty-character reference number. In general, 90000 was used for media billings. Every job was assigned a job type.
  • Job Cost Categories: The cost categories also had three digit keys. The categories were of three principal types: time, agency-owned materials, and vendor costs. The entries in the time categories consisted of hours worked on a job. The entries in the materials categories were dollar amounts. The vendor costs came from the accounts payable system.
  • Employee: The key was a three-character code. Initials were usually used here.
  • Rate: The key consisted of the employee code and the category number. It might also have had a date to allow rates to keep up with inflation.
  • Vendor: Vendors were keyed by a five character code and a two-digit location number. Checks were always cut to the name and address on location #0.
  • Media Type: A two digit code identified types of media—radio, television, magazine, newspaper, mailing house, yellow pages, etc.
  • Pub: Like the vendors, pubs were identified by a five character code and a two-digit number (usually 0). Every pub was associated with one vendor and had one media type. A vendor could have any number of pubs associated with it. Although the name “pub” was derived from “publication”, this table was also used for other media entities.
  • Media Ad: The key was the client number, a five-digit ad number, and a one-character version code (usually blank). The ad number was usually the production job number, but it could be something else.
  • Media Schedule: The key was the media ad key plus the pub key plus the date in the form YYMMDD and a two-digit number to preserve uniqueness. The last field was necessary because the same ad could be run more than once on the same day in the same publication or station. Three costs were stored on each record: net (the amount the agency paid the vendor), gross (net plus agency commission), and charge (the amount the client would pay).

The system provided for the following types of transactions:

Transactions were ordinarily entered in batch mode.
  • Menus specific to each type of transaction allowed for recording of new items, editing or (at least deleting) of items entered but not updated, printouts of the contents of the batch, and updating of data files.
    • Production and fee billing. Invoices could be printed on special multi-part forms or just recorded. The update program created records on the A/R detail file. Summary records on the job file were updated and entries were created in the batch file for the G/L system.
    • Media billing: Detail was selected from the media schedule. The update program created records on the A/R detail file, media liability records, and G/L batch entries. Summary records on the job file were updated.
    • Media payables: The update filled in the amount relieved on media liability records and created A/P Detail records and G/L batch entries. YTD spending on the vendor table was updated.
    • Other payables: The update created G/L batch entries. YTD spending on the vendor table was updated. For production costs job cost detail records were written and the job-to-date costs on the job file and job cost summary file were updated.
    • Checks: Invoices from vendors could be selected for payment in various ways. The update program wrote A/P detail records and entries for the G/L batch.
    • General ledger: Entries were generated by other modules, but they could also be entered one at a time. The update program wrote out journal entries and updated the monthly totals by account.
  • Live entries:
    • Cash receipts: The program to record cash received from clients updated paid amounts on open A/R items, and cash received month-to-date and year-to-date on the client table. It also wrote out A/R detail records and batch entries for the general ledger.
    • Individual disbursements: This program was used for partial payments, write-offs, and other A/P issues that were difficult to handle. It could also print checks, but that feature was seldom used by agencies.

The best thing about AdDept and also the worst thing was the month end reconciliation process. That is, it was the invaluable process that underscored the reliability of the data, but its vigor was still dreaded at the end of each month.

We provided the customers with checklists for what needed to be in agreement with what at the end of the month. For example, the total for the list of items in A/P must be the same as the balance in the A/P account in the G/L. If there were discrepancies, I showed the users the reporting tools to use to find the discrepancy and how to fix it. This could easily consume an entire day, and I often had to help them for two or three months before they understood what was causing the errors and how to fix them.

An account at one installation showed a discrepancy of only ten cents that we discovered was the result of three different errors, each of which was for more than $1,000.

I mostly dealt with the manager of the business office. However, I almost always sat down with one of the principals to go over the cost accounting report by client at least once. This report had columns for each source of income (media commissions, fees, billings for production jobs) and both direct and allocated expenses. A primary purpose of the reconciliation process was to insure that the total profit by client was the same as the total profit on the general ledger1. I tried to make it clear that the allocation of indirect expenses was only as accurate as the timesheets. If some employees (media buyers, for example) were not reporting their time accurately, the accuracy would suffer.

I have no doubt that our competitors did a lot less for their customers. Some tried to support their clients without any on-site visits. Some partnered with locals to provide hand-holding. I feel sure that they must have had some unhappy customers.

We actually used parts of this same process in TSI’s office. An unintended benefit of this rigorous approach was that it was rather easy to catch embezzlers.

The system was not sexy. The screens were green, and the output was columnar. The first few months were frustrating and difficult for almost all users. However, in the end it always saved a lot of time and produced valuable information.

One of our agency clients told us that they used a PC-based system called Media Management Plus2 to purchase broadcast commercials from radio and television stations and to evaluate the performance of the spots. We contacted Glenn DeKraker at the company in New Jersey. He told us that the software had several forms of files that it could produce to feed billing and accounting systems. We chose one of them, and wrote software on the System/36 (it would have been very difficult to do it on a Datamaster) to create records on the ads file in GrandAd’s media system from the records uploaded from the PC.

It worked smoothly from the beginning. We did not need to make any adjustments to our files at all. The users just needed to follow a simple convention when it came to naming the pubs. They had to use the call letters and a one-character code: A for AM, F for FM, and T for television.

This project taught us not to fear building interfaces with other software companies.

The original design of GrandAd was surprisingly stable, especially when the constraints under which we operated are considered. The screens supported nothing but text and had only 78 usable columns and 24 rows. The reports were limited to 132 characters on each line. The amount that could be stored on the hard drives was quite limited. If a customer ran out of room, the options were poor.

It was, thank goodness, never necessary to increase the size of any fields, although we had to pass on requests for proposals from two agencies. One was a New York agency that specialized in theatrical productions, each of which was a separate client, and a separate agency that specialized in want ads. Our biggest problem was in handling the version of the system that was used by TSI. When we started selling the AxN system to newspapers, The 999 clients allowed by the three-digit client number might not be sufficient. Besides, we did not want to intermingle the newspapers with our other clients. We decided to allow alphabetic characters in the client number field.

In retrospect we obviously should have used eight-digit dates from the beginning. We devoted countless hours in the late nineties to fixing this oversight.

1. Occasionally some G/L accounts, such as investment income, were excluded for this purpose.

2. In 2021 the company is now known as CoreMedia Systems. Its website is here.