177
Advertiser and Agency Red Books™ : Advertisers

Last Loaded on Web: Thursday, May 01, 2008

Last Update To Bluesheet: January 11, 2006

Bluesheet Contents     PDF version

File Description Dialog File Data Special Features Basic Index Rank Rates
Subject Coverage Database Content Contact Additional Indexes Map
Tips Document Types Indexed Terms and Conditions Limit Report Options
Print Counterparts Geographic Coverage Sample Record Sort Predefined Format Options


File Description [top]

Advertiser & Agency Red BooksTM: Advertisers, produced by National Register Publishing, a division of Reed Elsevier Inc., contains business profiles and corporate linkage for over 29,000 top U.S. and international companies - both public and private - that annually spend more than $200,000 U.S. to advertise their products and services, as well as name and titles for 117,000 industry professionals.

Records include company name and address, business description, SIC codes, product types, trade names, sales figures, and phone and fax numbers. Additional details include: types of advertising media used, advertising agencies employed by the company, approximate dollars spent in each type of advertising medium, a breakdown of the products handled by each agency employed by the company, and e-mail addresses for key personnel.

Information is obtained from questionnaires completed by the companies, supplemented by company press releases and telephone research conducted by National Register Publishing.



Tips [top]

USE FILE 177

to find information on advertisers in public and private sectors.

USE CO=

to search for Advertiser company name.

USE AG=

to search for the Advertisers Agency company name.

USE MG=

to search on a specific media used. EXPAND MG= to view the types of media.

USE REPORT

to build reports in tabular format.

CONSULT DOCUMENT

4287 (http://library.dialog.com/products/aids/4287.pdf) for a listing of Media Types, Classifications, and preformatted reports.



Subject Coverage [top]

Advertiser & Agency Red Books: Advertisers, is the online equivalent of the esteemed National Register Publishing publications Standard Directory of Advertisers and Standard Directory of International Advertisers.

In-depth company profiles on individual advertising agencies can be found in the companion file Advertiser & Agency Red Books: Agencies (File 178).



Print Counterparts [top]

  • Standard Directory of Advertisers
  • Standard Directory of International Advertisers


Dialog File Data [top]

Dates Covered: Current
File Size: 19,223 records as of January 2006
Update Frequency: Monthly


Database Content [top]

  • Directories


Document Types Indexed [top]

  • Directories


Geographic Coverage [top]

  • International


Geographic Restrictions [top]

  • None


Special Features [top]

  • ERA Available (REDIST only)
  • Graduate Education Program
  • KWIC and HILIGHT Available
  • Remove Duplicates (RD, ID) Available
  • REPORT Available
  • PreFormatted REPORTs Available


Contact [top]

Advertiser & Agency Red Books.

Advertisers is produced by LexisNexis Group. Questions concerning the file should be directed to:

Advertising Red Books
LexisNexis Group
121 Chanlon Road
New Providence, NJ 07974

Telephone: 908-665-2854
800 Line: 800-340-3244, ex 3693
Fax: 908-790-5405


Terms and Conditions [top]

For Dialog's Redistribution and Archive Policy, enter HELP ERA online. The following terms and conditions also apply.

Copyright Reed Reference Publishing, a division of Reed Elsevier Inc. 1997. All rights reserved. Limited reproduction of output is permitted for distribution within the user's internal operation, contingent upon payment of multiplier fee. Licensor makes no representations or warranties, express or implied, including warranties of merchantability or fitness for a particular purpose. REED REFERENCE PUBLISHING SHALL HAVE NO LIABILITY FOR LOST PROFITS OR CONSEQUENTIAL DAMAGES RELATED TO THE USE OF (DATABASE) WHETHER SUCH DAMAGES ARE FORESEEABLE OR WHETHER SUCH DAMAGES ARE DEEMED TO RESULT FROM THE FAILURE OR INADEQUACY OF ANY EXCLUSION OR OTHER REMEDY. This database has been supplied under license by Reed Reference Publishing, a division of Reed Elsevier Inc. ("RRP"), and copyright and other proprietary rights are owned by, or licensed exclusively through, RRP. Trademarks are used by RRP under license from Reed Elsevier Properties Inc. or Reed Publishing (Nederland) BV. The Subscriber or subscriber to this database ("Subscriber") acknowledges that the database is the product of RRP's extensive gathering and coordination of information, selection therefrom of information considered by RRP to be relevant and useful, and original arrangement of selected information. Duplication, copying, storing, or down-loading in print or electronic format is not permitted without prior written authorization from RRP, except for reproduction of the results of discrete searches of the database which amount to only limited quantities of reasonable portions for use by the Subscriber and for use within the Subscriber's organization upon payment of a multiplier fee through the ERA Service for Dialog or through payment of a transactional fee to the Copyright Clearance Center. The permission hereby granted for limited copying is conditioned on including on all copies the attribution of RRP as the source of information, and a suitable notice of copyright. Under no circumstances may copies, in any media, be made for resale or redistribution. Subscriber acknowledges that the rate of user fees paid for access to the database, and the limitations of liability set out below, are based in part on the expectation that the Subscriber will bear the risk of any loss which might be incurred due to the use or reliance by the Subscriber or Subscriber's customers on information contained in the database.


Dialog Standard Terms & Conditions apply.


SAMPLE RECORD [top]

       DIALOG(R)File 177:ADV & AGENCY RED BOOKS: ADVERTISERS 
       (c) 1997 Reed Elsevier. All rts. reserv. 
     
            00010004 
  /CO,CO=,     Charles Jacquin et Cie, Inc. 
  /OC, OC=     2633 Trenton Ave. 
  CY=,ST=,ZP=     Philadelphia, PA  19125 
  CN=     COUNTRY: USA 
       NUMBER OF CORP. AFFILIATES:  2 
  NO=     NRPC COMPANY NUMBER: 014755000 
  EM=     NUMBER OF EMPLOYEES:  175 
       YEAR FOUNDED:         1884 
       COMPUTER INFO:        Computer System/ 
                             Hardware: DEC VAX 11/750 
       TELEPHONE: 215-425-9300 
       FAX:       215-425-9438 
  CL=,/DE     CLASSIFICATION: Wines & Liquors 
       DESCRIPTION OF BUSINESS: Mfr. & Importer of 
         Liquors & Wines 
        PRIMARY SIC CODE: 
  PC=,P2=,/DE       2084 Wines, brandy, and brandy 
  SC=,S2=,/DE       spirits, nsk 
        SECONDARY SIC CODE(S): 
  SC=,S2=/DE       2085 Distilled and blended liquors 
         5182 Wine and distilled beverages 
        TRADE NAMES & PRODUCTS: 
  TN=,/PN       BIRELL  (Non-Alcoholic Beer) 
         BOCADOR  (Rum & Coladas) 
         CHAMBORD LIQUER ROYALE DE FRANCE  (Liquor) 
         DEVONSHIRE CROWN LIQUOUR  (Liquor) 
         JACQUIN  (Liquors & Cordials) 
         LONDON TOWER  (Gin) 
         PENNSYLVANIA DUTCH  (Egg Nog) 
         SAVORY AND JAMES  (Sherries & Ports) 
  SA=       SALES: $60,000,000 
         FISCAL YEAR END: 09/30/96 
  EX=       APPROX. TOTAL EXPENDITURES: $4,000,000 
  MG=       TYPES OF MEDIA USED: 
              Network T.V. 
              Cable T.V. 
              Consumer Mags. 
                (...) 
         EXECUTIVES: 
  NM=       Cooper, Norton J.    Pres. & Chief Exec. 
                              Officer 
         Small, Mark          Chief Fin. Officer 
         O'Brian, Kevin       V.P.-Mktg. & Sls. 
         Heinz, William       Pur. Agent & Plant Mgr. 
         AGENCIES: 
  AG=,/OC,OC=       Whitehall Advertising, Inc. 
         Company Type: Advertising Agency 
  NU=       NRPC Company Number: 012978000 
         Corporate Address: 
           2633 Trenton Ave. 
           Philadelphia, PA 19125 
           USA 
         Phone: 215-425-9300 
         Kwasizur, John V.P. 
         SUBSIDIARIES: 
  /OC,OC=       Saxony Distillers Et Cie, Inc. 
         Company Type: Subsidiary 
  NU=       NRPC Company Number: 014755001 
         Corporate Address: 
         2633 Trenton Ave. 
         Philadelphia, PA 19125 
         USA 
         Phone: 215-425-9300 


BASIC INDEX [top]

SEARCH
SUFFIX
DISPLAY
CODE
REPORT
(FIELD
LENGTH)
FIELD NAME

INDEXING

SELECT EXAMPLES

None None None All Basic Index Fields Word S LIQUOR?
None None None Basic Document Word
/CO CO CO (32) Company Name1 Word S CHARLES(W)JACQUIN/CO
/DE DE None Description2 Word S WINE?/DE
/OC None None All Occurrences of Company Name1 Word S SAXONY(W)DISTILLERS /OC
/PN PN None Product Name, Brand/Trade Names, and SIC Description1 Word S EGG(W)NOG/PN

1 Searchable in the Basic Index and in the Additional Indexes.

2 DE includes Description of Business, Classification Field, Generic Product Field, and Trade Name.


ADDITIONAL INDEXES [top]

SEARCH
PREFIX
DISPLAY
CODE
REPORT
(FIELD
LENGTH)
FIELD NAME

INDEXING

SELECT EXAMPLES

None None None Type of Financial Information
None AD None Address
AG= AG None Advertising Agency Phrase S AG=WHITEHALL ADVERTISING?
None AN AN (10) DIALOG Accession Number
None CA None Corporate Affiliations
CL= CL CL (32) Company Classification Name Phrase S CL=WINES & LIQUORS
CN= CN CN (20) Country Name Phrase S CN=USA
CO= CO CO (32) Advertiser Company Name1 Phrase S CO=CHARLES JACQUIN?
CY= CY CY (27) Advertiser Company City Phrase S CY=PHILADELPHIA
EM= EM EM (11) Number of Employees Phrase S EM>=100
EX= EX EX (15) Approximate Total Expenditures Numeric S EX=4M:10M
FT= FT None Trade Status Phrase S FT=IMPORT
None FX FX (17) Fax Number
MB= MB MB (15) Business Publications Media Dollars Numeric S MB>=300K
MD= MD MD (15) Direct Mail Media Dollars Numeric S MD=100K:500K
ME= ME ME (15) Exhibit/Shows Media Dollars Numeric S ME>100K
MG= MG None Media Group Name Phrase S MG=RADIO
None ML None E-mail/URL
MM= MM MM (15) Magazine Media Dollars Numeric S MM>=200K
MN= MN MN (15) Newspaper/Journal Media Dollars Numeric S MN=5K:10K
MO= MO MO (15) Outdoor Media Dollars Numeric S MO>100K
MP= MP MP (15) POP Media Dollars Numeric S MP>=100K
MR= MR MR (15) Radio Media Dollars Numeric S MR>50K
MT= MT MT (15) Production Media Dollars Numeric S MT>50K
MV= MV MV (15) TV Media Dollars Numeric S MV>=100K
MW= MW MW (15) Web/Internet Media Dollars Numeric S MW>=100K
MY= MY MY (15) Yellow Pages Media Dollars Numeric S MY=20K:100K
None MZ MZ (15) All Other Media Types
NM= NM None CEO/Executive Name Phrase S NM=COOPER, NORTON?
None NN None Company Name Note
NO= NO NO (11) NRPC Company Number Phrase S NO=014755000
NU= NU NU (11) Agency NRPC Company Number Phrase S NU=012978000
OC= None None All Occurrences of Company Name1 Phrase S OC=SAXONY DISTILLERS?
P2= None None 2-digit Primary SIC Code Phrase S P2=20
PC= PC PC (6) Primary SIC Code Phrase S PC=2084
S2= None None 2-digit SIC Code Phrase S S2=20
SA= SA SA (15) Sales or Revenue or Income or Premiums or Billings or Assets Numeric S SA=60M
SC= SC None Standard Industrial Classification (SIC) Code Phrase S SC=2085
ST= ST ST (7) Advertiser Company State Phrase S ST=PA
None TE TE (17) Telephone Number
TN= TN None Brand/Trade Name1 Phrase S TN=BIRELL
XR= XR XR (32) Former Company Name Phrase S XR=HART SKI?
None YF YF (6) Year Founded
ZP= ZP ZP (9) Postal Code Phrase S ZP=19125


LIMIT [top]

SUFFIX FIELD NAME EXAMPLES
/MEDIA Record contains dollar figures for media breakdowns (present for approximately 10% of records)) S S2/MEDIA
/NONUS Non-U.S. Companies only S S3/NONUS
/US U.S. companies only S S2/US


SORT [top]

SORTABLE FIELDS EXAMPLES
CL, CN, CO, CY, EM, EX, MB, MD, ME, MM, MN, MO, MP, MR, MT, MV, MW, MY, PC, SA, ST, ZP SORT S2/ALL/CO


RANK [top]

RANK FIELDS EXAMPLES
All phrase- and numeric-indexed fields in the Additional Indexes can be ranked. RANK AU S3


MAP [top]

MAP FIELDS EXAMPLES
NU MAP NU TEMP EX/NO=


REPORT OPTIONS [top]

 
Output can be displayed in table format. REPORT codes with field lengths in parentheses are listed in the Search Options tables. Default table width is 72 characters; use SET H 132 to set maximum table width. Consult document #4287 for information on how to build preformatted reports (http://support.dialog.com/searchaids/dialog/pdf/4287.pdf).


USER-DEFINED FORMAT OPTIONS [top]

User-defined formats may be specified using the display codes indicated in the Search Options tables. TYPE S3/TI,JN/ALL


PREDEFINED FORMAT OPTIONS [top]

NO.
DIALOGWEB
FORMAT
RECORD CONTENT
1 -- DIALOG Accession Number
2 -- Company Name, Address, Contact Information, and Description of Business
3 Medium Company Name, Address, Contact Information, Description of Business, and Management Names
4 -- Company Name, Address, Contact Information, Description of Business, and Products and Services
5 Long Full Record except Branches (media percentages are calculated by The Dialog Corporation)
6 -- Company Name and NRPC Number, and Number of Branches
7 -- Full Record with up to 30 Branches (media percentages are calculated by The Dialog Corporation)
8 Short Company Name and NRPC Number, and Number of Branches
9 -- Full Record with up to 30 Branches
10 -- National Address (excludes country)
19 Full Full Record and all Branches (media percentages are calculated by The Dialog Corporation)
20 -- International Address (includes country)
K -- KWIC (Key Word In Context) displays a window of text; may be used alone or with other formats


DIRECT RECORD ACCESS [top]

FIELD NAME EXAMPLES
DIALOG Accession Number TYPE 00123977/9
DISPLAY 00654322/5
PRINT 00654321/9


Rates [top]

Rates For File: Advertiser and Agency Red Books™       : Advertisers[177]
Cost per DialUnit:                 $3.64
Cost per minute:                   $1.35
Report Elements                    $0.10
Rank Elements                      $0.00

Format    Types   Prints
     1    $0.00    $0.00
     2    $1.94    $1.94
     3    $2.32    $2.32
     4    $2.65    $2.65
     5    $3.29    $3.29
     6    $0.11    $0.11
     7    $3.89    $3.89
     8    $0.11    $0.11
     9    $3.89    $3.89
    10    $0.70    $0.70
    19    $4.59    $4.59
    20    $0.92    $0.92
    23    $2.65    $2.65
KWIC95    $0.00       NA
REDIST/COPY Multiplier Table:

      Range      Multiplier
        1-2       1.00
       3-25       1.50
     26-100       3.00
    101-200       4.00
    201-500       6.00
   501-1000       8.00
 1001 or more    10.00
------------

Note: Preformatted Reports in File 177
are charged by row as follows:
Expenditure reports         $.40/row
Sales reports               $.40/row
Media reports               $.50/row
[top]



All contents Copyright © Thomson Reuters. All rights reserved.
If you have any questions about, problems with, or corrections for our Web site,
please contact Customer Service for assistance.