Spreadsheet: 119097d1314196436-conditional-formatting-pfp-product-dashboard-skeleton2
Sheet: Ad Info Database

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | ACCOUNT TYPE | CMR NAME | CMR/CLIENT | GSM | ISM | NSM | ESTM | EST |  | START DATE |  | END DATE | Fields | ACCOUNT TYPE | CAMPAIGN NAME | ADVERTISER NAME | CMR/CILENT | CMR NAME | CLIENT NAME | GSM | NSM | ISM | EST | ESTM | START DATE | END DATE | IMPRESSIONS SCHEDULED | IMPRESSIONS DELIVERED | CLICKS | CTR | BUDGET | % DELIVERED | TARGETED/ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | AA Accident Attorneys | AA Accident Attorneys | 284-0525 | [NAME] INC. | CONSUMER LAW GROUP ADS, INC | [NAME] | TANC AGIUS | [NAME] | X |  | 2010-07-01 00:00:00 | 2010-12-31 00:00:00 |  |  |  |  |  |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | AAA Auger Plumber | AAA Auger | 982-5555 | NEW DIMENSION MARKETING & RESEARCH | ADVANCED FOUNDATION REPAIR | [NAME] | TANC AGIUS | [NAME] | X |  | 2010-03-28 00:00:00 | 2011-03-27 00:00:00 |  |  |  |  |  |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | AAA Auger Plumber | AAA Auger | 982-5555 | NEW DIMENSION MARKETING & RESEARCH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | ABC Insurance | Insurance | 982-2010 | NEW DIMENSION MARKETING & RESEARCH | PAUL DARDEN COMPANY | [NAME] | TANC AGIUS | [NAME] | [NAME] | NATALIE CHILDS | 2010-04-20 00:00:00 | 2011-04-19 00:00:00 |  |  |  |  |  |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | ACDelco | ACDelco | 376-0055 | SMG DIRECTORY MARKETING | AC DELCO | PAT ASH | [NAME] REENDERS | ROGER BURNHAM | X |  | 2010-07-01 00:00:00 | 2010-08-31 00:00:00 | 2000000 |  |  |  | 20000 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | ADT | ADT | 232-5500 | TMP DIRECTIONAL MARKETING, LLC. | ADT SECURITY SERVICE | FIRMON HARDENBERGH | DEBORAH USSERY | [NAME] | X |  | 2010-07-01 00:00:00 | 2010-09-30 00:00:00 | 1521564 |  |  |  | 15215.64 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Union Privlege | Union Privlege | 000-0000 | CLIENT CODE NOT FOUND | CLIENT CODE NOT FOUND | CLIENT CODE NOT FOUND | CLIENT CODE NOT FOUND | CLIENT CODE NOT FOUND | CLIENT CODE NOT FOUND | CLIENT CODE NOT FOUND | 2010-11-15 00:00:00 | 2011-11-14 00:00:00 | 300000 |  |  |  | 4500 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | AIS Mobile Banners | AIS-Auto insurance Specialists | 364-0208 | MICHAELS WILDER INC. | AUTO INSURANCE SPECIALISTS INC | FIRMON HARDENBERGH | DEBORAH USSERY | ZAC ZARLING | X |  | 2011-06-03 00:00:00 | 2011-12-03 00:00:00 | 1700000 |  |  |  | 20400 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Allstate Insurance Company | Allstate Insurance Company | 424-4241 | BERRY NETWORK, INC. | ALLSTATE CORPORATE TRADEMARK | FIRMON HARDENBERGH | [NAME] | [NAME] | X |  | 2011-01-15 00:00:00 | 2011-12-31 00:00:00 |  |  |  |  | 240000 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Ally Bank Trial | Ally Bank | 475-5940 | SMG DIRECTORY MARKETING | ALLY BANK | [NAME] | AAA | AAA | X |  | 2010-11-01 00:00:00 | 2011-10-31 00:00:00 |  |  |  |  | 25000 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | [NAME] | Alpha Ecological | 232-2009 | TMP DIRECTIONAL MARKETING, LLC. | ALPHA ECOLOGICAL | FIRMON HARDENBERGH | DEBORAH USSERY | ZAC ZARLING | LAUREN ELLIOTT | AMANDA HINES | 2011-03-17 00:00:00 | 2011-09-01 00:00:00 | 1527241 |  |  |  | 18326.892 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Winter Moving and Storage, Inc | [NAME] | 456-9100 | BERRY NETWORK, INC. | ATLAS VAN LINES INC | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | KEVIN MCQUEEN | AMANDA HINES | 2010-11-01 00:00:00 | 2011-02-28 00:00:00 | 200000 |  |  |  | 2400 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Bail Bonds | Bail Bonds | 982-5000 | NEW DIMENSION MARKETING & RESEARCH | BAD BOYS BAIL BONDS (5000) | [NAME] | TANC AGIUS | [NAME] | X |  | 2010-03-28 00:00:00 | 2011-03-27 00:00:00 |  |  |  |  |  |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Bellin Health Campaign | Bellin Health | 432-3142 | BERRY NETWORK, INC. | BELLIN-GASTROENTEROLOGY ASSOCIATES | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] GORDON | AMANDA HINES | 2010-12-08 00:00:00 | 2011-08-31 00:00:00 | 140700 |  |  |  | 1688.4 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Brightstar | Institute of Technology | 623-7000 | RADCLIFFE GROUP, INC. | BRIGHTSTAR EDUCATION | CHERI RUSHING | EST | [NAME] | NIKKI SMITH | [NAME] | 2011-05-01 00:00:00 | 2011-09-01 00:00:00 | 306900 |  |  |  | 3682.8 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Carolina Self Storage | Carolina Self Storage | 854-0160 | AD VENTURES, INC. | CAROLINA SELF STORAGE CENTERS | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2010-12-01 00:00:00 | 2011-11-30 00:00:00 | 22800 |  |  |  | 2737.8 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion | Champion of Tulsa | 854-6225 | AD VENTURES, INC. | [NAME] (C2) | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2010-09-15 00:00:00 | 2010-12-15 00:00:00 | 159333 |  |  |  | 1910 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion | Champion of Memphis | 854-6173 | AD VENTURES, INC. | CHAMPION MEMPHIS | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2010-09-15 00:00:00 | 2010-12-15 00:00:00 | 83333 |  |  |  | 1000 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion  - Akron, OH | Champion | 854-6139 | AD VENTURES, INC. | CHAMPION ST LOUIS  (C1) | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-08-01 00:00:00 | 2011-10-15 00:00:00 | 144000 |  |  |  | 1728 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion  - Birmingham, AL | Champion | 854-6139 | AD VENTURES, INC. | CHAMPION ST LOUIS  (C1) | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-08-01 00:00:00 | 2011-10-31 00:00:00 | 344000 |  |  |  | 4128 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion - Greenville, SC | Champion Greenville | 854-6124 | AD VENTURES, INC. | CHAMPION GREENVILLE | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-09-01 00:00:00 | 2011-12-15 00:00:00 | 115333 |  |  |  | 1384 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion  - Huntsville, AL | Champion | 854-6139 | AD VENTURES, INC. | CHAMPION ST LOUIS  (C1) | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-08-01 00:00:00 | 2011-10-15 00:00:00 | 152000 |  |  |  | 1824 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion  - Indianapolis, IN | Champion | 854-6140 | AD VENTURES, INC. | CHAMPION ATLANTA | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-09-01 00:00:00 | 2011-12-15 00:00:00 | 702000 |  |  |  | 8424 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion  - St. Louis, MO | Champion | 854-6139 | AD VENTURES, INC. | CHAMPION ST LOUIS  (C1) | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-08-01 00:00:00 | 2011-10-15 00:00:00 | 886000 |  |  |  | 10632 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion Raleigh | Champion Raleigh | 854-6200 | AD VENTURES, INC. | CHAMPION WINDOW MFR & SUPPLIES, INC. | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2010-12-01 00:00:00 | 2011-11-30 00:00:00 | 199000 |  |  |  | 2390.4 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Carolina Self Storage | Carolina Self Storage | 854-0160 | AD VENTURES, INC. | CAROLINA SELF STORAGE CENTERS | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2010-12-01 00:00:00 | 2011-11-30 00:00:00 | 22800.15 |  |  |  | 2737.8 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion - Greenville, SC | Champion Greenville | 854-6124 | AD VENTURES, INC. | CHAMPION GREENVILLE | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-09-01 00:00:00 | 2011-12-15 00:00:00 | 115333 |  |  |  | 1384 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion | Champion Knoxville | 854-6135 | AD VENTURES, INC. | CHAMPION KNOXVILLE | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2010-11-01 00:00:00 | 2011-02-01 00:00:00 | 83333 |  |  |  | 1000 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Champion - Greenville, SC | Champion Greenville | 854-6124 | AD VENTURES, INC. | CHAMPION GREENVILLE | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] | AMANDA HINES | 2011-09-01 00:00:00 | 2011-12-15 00:00:00 | 115333 |  |  |  | 1384 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | AAA Auger Plumber | AAA Auger | 982-5555 | NEW DIMENSION MARKETING & RESEARCH | ADVANCED FOUNDATION REPAIR | [NAME] | TANC AGIUS | [NAME] | X |  | 2011-04-22 00:00:00 | 2012-04-22 00:00:00 | 32069 |  |  |  | 384.828 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Insurance | ABC Insurance | 982-2010 | NEW DIMENSION MARKETING & RESEARCH | PAUL DARDEN COMPANY | [NAME] | TANC AGIUS | [NAME] | [NAME] | NATALIE CHILDS | 2011-04-22 00:00:00 | 2012-04-22 00:00:00 | 59652 |  |  |  | 715.8240000000001 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Insurance | ABC Insurance | 982-2011 | NEW DIMENSION MARKETING & RESEARCH | STOR-N-MOR SELF STORAGE (305123) | [NAME] | TANC AGIUS | [NAME] | [NAME] | NATALIE CHILDS | 2011-04-22 00:00:00 | 2012-04-22 00:00:00 | 59652 |  |  |  | 715.8240000000001 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | ACDelco |  | 376-0055 | SMG DIRECTORY MARKETING | AC DELCO | PAT ASH | [NAME] REENDERS | ROGER BURNHAM | X |  | 2010-11-01 00:00:00 | 2011-11-01 00:00:00 | 980000 |  |  |  | 4800 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Allstate Insurance Company | Allstate Insurance Company | 424-4241 | BERRY NETWORK, INC. | ALLSTATE CORPORATE TRADEMARK | FIRMON HARDENBERGH | [NAME] | [NAME] | X |  | 2011-07-06 00:00:00 | 2011-12-31 00:00:00 | 24000000 |  |  |  | 240000 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | [NAME] | Alpha Ecological | 232-2009 | TMP DIRECTIONAL MARKETING, LLC. | ALPHA ECOLOGICAL | FIRMON HARDENBERGH | DEBORAH USSERY | ZAC ZARLING | LAUREN ELLIOTT | AMANDA HINES | 2011-03-01 00:00:00 | 2011-09-01 00:00:00 | 1527241 |  |  |  | 18326.892 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | [NAME] | Winter Moving and Storage, Inc | 456-9100 | BERRY NETWORK, INC. | ATLAS VAN LINES INC | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | KEVIN MCQUEEN | AMANDA HINES | 2010-11-01 00:00:00 | 2011-02-28 00:00:00 | 200000 |  |  |  | 2400 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Bad Boys Bail Bonds | Bad Boys Bail Bonds | 982-5000 | NEW DIMENSION MARKETING & RESEARCH | BAD BOYS BAIL BONDS (5000) | [NAME] | TANC AGIUS | [NAME] | X |  | 2011-04-22 00:00:00 | 2012-04-22 00:00:00 | 24468 |  |  |  | 293.68 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Bad Boys Bail Bonds | Bad Boys Bail Bonds | 982-5000 | NEW DIMENSION MARKETING & RESEARCH | BAD BOYS BAIL BONDS (5000) | [NAME] | TANC AGIUS | [NAME] | X |  | 2011-04-22 00:00:00 | 2012-04-22 00:00:00 | 97872 |  |  |  | 1174.76 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Citizens Bank | Citizens Bank | 737-0433 | TELEPHONE DIRECTORY SERVICES | CITIZENS BANK | CHERI RUSHING | EST | [NAME] | [NAME] | [NAME] | 2011-05-23 00:00:00 | 2012-05-23 00:00:00 | 250000 |  |  |  | 3000 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Columbus Regional Healthcare System | Columbus Regional Healthcare System | 432-0709 | BERRY NETWORK, INC. | VHA - COLUMBUS REGIONAL HEALTHCARE SYSTEM | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] GORDON | AMANDA HINES | 2010-09-01 00:00:00 | 2011-08-01 00:00:00 | 619271 |  |  |  | 7431.25 |  | ROS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile | Conway Regional Media Net Campaign | Conway Regional Health System | 432-0704 | BERRY NETWORK, INC. | VHA-COMMUNITY PHYSICIANS NETWORK | FIRMON HARDENBERGH | [NAME] | MIKE ERICH | [NAME] GORDON | AMANDA HINES | 2011-03-01 00:00:00 | 2012-02-01 00:00:00 | 170000 |  |  |  | 2040 |  | Targeted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mobile