Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Complicated Match/Lookup in between dates formula?

  1. #1
    New Member
    Join Date
    Jul 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Complicated Match/Lookup in between dates formula?

    Objective: I am trying to obtain a number (ID) from Table A based off of the Date and Number in Table B. What I am trying to say in my formula is that if Phone Number in Table B is equal to a Phone Number in Table A, and the Date in Table B in the same row as that Phone Number is between the Start and End Date in Table A, then I want the corresponding ID from Table A generated in the first column in Table B.

    Furthermore, if the phone number matches but it does not fall between a one of the list of dates, I need it to pull the ID from the closest range of dates before it.

    For instance, the last row in Table B has a Master Date of 4/22/19, however there is no date range in Table A for it, so it is pulling the ID from the date ranges of 3-26-19 to 4-1-19 because it is the closest date ranges before the master date.

    Hopefully this makes sense and there is some wizard out there who can accomplish this. Multiple formulas building on each other is fine as well.





    Table A

    Name ID Date Start Date End Phone Number
    Apple
    375
    12/30/2018
    1/5/2019
    210-908-5231
    Pear 224
    12/30/2018
    1/5/2019
    210-361-8442
    Grape 846
    3/26/2019
    4/1/2019
    210-361-5592
    Lemon 552
    5/26/2019
    6/1/2019
    210-361-5592



    Table B

    ID Master Date Phone Number
    224 1/3/19
    210-361-8442
    846 3/27/19 210-361-5592
    846 4/22/19 210-361-5592

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,261
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    This array formula turned out.

    Maybe someone else can help you with a shorter one.

     ABCDEFGHI
    1NameIDDate StartDate EndPhone Number IDMaster DatePhone Number
    2Apple37530/12/201805/01/2019210-908-5231 22403/01/2019210-361-8442
    3Pear22430/12/201805/01/2019210-361-8442 84627/03/2019210-361-5592
    4grape84626/03/201901/04/2019210-361-5592 84622/04/2019210-361-5592
    5lemon55226/05/201901/06/2019210-361-5592    

    CellArray Formula
    G2{=IFERROR(INDEX($B$1:$B$5,LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2),ROW($A$2:$A$5)),1)),INDEX($B$1:$B$5,MA X(IF(ABS($C$2:$C$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)),ROW($B$2:$B$5),IF(ABS($D$2:$D$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)),ROW($B$2:$B$5))))))}



    Array formulas
    Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
    Note: Do not try and enter the {} manually yourself
    Regards Dante Amor

  3. #3
    New Member
    Join Date
    Apr 2019
    Location
    Porto - Portugal
    Posts
    16
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?



    Code:
    =sum(if($e$2:$e$5=l2;if(k2>$c$2:$c$5;if(k2<$d$2:$d$5;j2;index($b$2:$b$5;match(min(abs($c$2:$c$5-k2));abs($c$2:$c$5-k2);0)));index($b$2:$b$5;match(max(abs($c$2:c$5-k2));abs($c$2:$c$5-k2);0)));"no"))
    So, I used this formula and dragged the fill handle and get the exact results as you, 224;846;846. I already blocked the cells.
    IMPORTANT: When you enter the formula, don't press just ENTER, instead press CTRL + SHIFT + ENTER. It will appear "{}" on the formula. This is because you have to cell by cell and compare with your master date.

    Hope I could help.

  4. #4
    New Member
    Join Date
    Apr 2019
    Location
    Porto - Portugal
    Posts
    16
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Sorry, didn't see your response. Perhaps yours is better than mine. But they are very similar!

  5. #5
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,261
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Quote Originally Posted by tico_ocit View Post
    Sorry, didn't see your response. Perhaps yours is better than mine. But they are very similar!
    Welcome to the forum!

    Do not worry. The important thing is to deliver the best response to the OP.
    They are similar, but you missed to include the dates in column D, to also verify with those dates which is the closest.

    -------------

    The same formula but a little shorter.

    Zelle Formel
    G2 {=IFERROR(INDEX($B$1:$B$5,LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2),ROW($A$2:$A$5)),1)),INDEX($B$1:$B$5,MAX(((ABS($D$2:$D$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)))+(ABS($C$2:$C$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2))))*ROW($B$2:$B$5))))}
    Regards Dante Amor

  6. #6
    Board Regular Sam_D_Ben's Avatar
    Join Date
    Oct 2012
    Location
    New Jersey, USA
    Posts
    371
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Great' here i am staring at both the formulas
    Sam_D_Ben

  7. #7
    New Member
    Join Date
    Apr 2019
    Location
    Porto - Portugal
    Posts
    16
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Quote Originally Posted by DanteAmor View Post
    Welcome to the forum!

    Do not worry. The important thing is to deliver the best response to the OP.
    They are similar, but you missed to include the dates in column D, to also verify with those dates which is the closest.

    -------------

    The same formula but a little shorter.

    Zelle Formel
    G2 {=IFERROR(INDEX($B$1:$B$5,LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2),ROW($A$2:$A$5)),1)),INDEX($B$1:$B$5,MAX(((ABS($D$2:$D$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2)))+(ABS($C$2:$C$5-H2)=MIN(ABS($C$2:$C$5-H2),ABS($D$2:$D$5-H2))))*ROW($B$2:$B$5))))}



    Code:
    =sum(if($e$2:$e$5=l2;if(k2>$c$2:$c$5;if(k2<$d$2:$d$5;j2;index($b$2:$b$5;match(min(abs($c$2:$c$5-k2));abs($c$2:$c$5-k2);0)));index($b$2:$b$5;match(min(abs($c$2:c$5-k2));abs($c$2:$c$5-k2);0)));"no"))
    I think I did compare, but used MAX when I should used MIN, because you always want the minimum difference.
    I tryed yours and get all done. Although when you use
    Code:
    LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2)
    I don't know what "*" are for? Never used before.
    Been wondering why your formula use "," and mine ";".

  8. #8
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,261
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Quote Originally Posted by tico_ocit View Post
    Code:
    =sum(if($e$2:$e$5=l2;if(k2>$c$2:$c$5;if(k2<$d$2:$d$5;j2;index($b$2:$b$5;match(min(abs($c$2:$c$5-k2));abs($c$2:$c$5-k2);0)));index($b$2:$b$5;match(min(abs($c$2:c$5-k2));abs($c$2:$c$5-k2);0)));"no"))
    I think I did compare, but used MAX when I should used MIN, because you always want the minimum difference.
    I tryed yours and get all done. Although when you use
    Code:
    LARGE(IF(($E$2:$E$5=I2)*($C$2:$C$5<=H2)*($D$2:$D$5>=H2)
    I don't know what "*" are for? Never used before.
    Been wondering why your formula use "," and mine ";".
    "*" is a nested if.

    if (condition, if (condition, true))
    or
    if (condition * condition, true)


    "," or ";" It is the argument separator that you have configured by region.
    Regards Dante Amor

  9. #9
    New Member
    Join Date
    Jul 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    These do not seem to be working when I switch the columns I am using into the formula and I can not figure out why. I could send you the actual workbook I am using, however I do not see an attachment button anywhere.

    The formula seems to not have errors, however it is pulling the incorrect numbers.
    Last edited by jwillits; Aug 16th, 2019 at 11:36 AM.

  10. #10
    New Member
    Join Date
    Jul 2018
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Complicated Match/Lookup in between dates formula?

    Here is the actual data from my workbook. Note that this info is contained on different pages. In this case, could you write the formula trying to get the Related Weekly Spend number from Sheet2 into the column on Sheet1?

    The rules are the same as that I need the Tracking Number to Match from Sheet1 to Sheet2, and then I need the Date in Sheet1 to fall between the Date of the Matching Tracking Number. If there is none, I need it to go to the date range before it.


    Sheet1

    Related Patient Related Weekly Spend Date Time Tracking Number
    #N/A 6/2/2019 3:56 PM 210-960-9944
    #N/A 6/1/2019 2:52 PM 210-239-2304
    #N/A 6/1/2019 2:12 PM 210-610-9726
    #N/A 6/1/2019 11:35 AM 210-263-3116
    #N/A 5/31/2019 2:30 PM 210-361-3306
    29787 5/31/2019 2:25 PM 210-610-9726
    #N/A 5/31/2019 1:16 PM 210-239-2304
    29632 5/31/2019 10:35 AM 210-361-1720
    #N/A 5/30/2019 3:05 PM 210-610-9726
    29634 5/30/2019 2:57 PM 210-610-9726
    19666 5/30/2019 2:28 PM 210-960-9944
    #N/A 5/30/2019 1:44 PM 210-361-1720
    #N/A 5/30/2019 11:56 AM 210-944-4129
    29626 5/30/2019 10:21 AM 210-361-1720
    #N/A 5/30/2019 10:20 AM 210-361-1720
    #N/A 5/30/2019 10:20 AM 210-361-1720
    29622 5/30/2019 10:18 AM 210-361-1720
    #N/A 5/30/2019 10:17 AM 210-361-1720
    #N/A 5/30/2019 10:17 AM 210-361-1720
    #N/A 5/30/2019 10:16 AM 210-361-1720
    #N/A 5/30/2019 10:16 AM 210-361-1720
    29624 5/30/2019 10:16 AM 210-361-1720
    #N/A 5/30/2019 10:16 AM 210-361-1720
    29625 5/30/2019 10:16 AM 210-361-1720


    Sheet 2



    Related Weekly Spend Clinic Referral Detail - Sources Related Referral Detail Referral Detail - Record ID# Weekly Cost # of Times Ran Advertised Number Cost Per Spot Callrail calls Week Start Date Week End Date Tracking Number
    375 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 375 12/30/2018 1/5/2019 210 908-5231 210-908-5231
    397 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 397 12/30/2018 1/5/2019 210 361-8442 210-361-8442
    262 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 262 5/26/2019 6/1/2019 210 361-5592 210-361-5592
    291 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 291 5/26/2019 6/1/2019 210 361-1720 210-361-1720
    338 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 338 5/26/2019 6/1/2019 210 239-2304 210-239-2304
    356 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 960-9944 $45.43 356 5/26/2019 6/1/2019 210 960-9944 210-960-9944
    374 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 374 5/26/2019 6/1/2019 210 263-3116 210-263-3116
    396 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 396 5/26/2019 6/1/2019 210 908-5231 210-908-5231
    418 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 418 5/26/2019 6/1/2019 210 361-8442 210-361-8442
    428 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 428 5/26/2019 6/1/2019 210 361-3306 210-361-3306
    493 Male Medical Group (SO) Newspaper SA Express-News 6 $2,680 2 (210) 610-9726 $1,340 493 5/26/2019 6/1/2019 210 610-9726 210-610-9726
    261 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 261 5/19/2019 5/25/2019 210 361-5592 210-361-5592
    269 Slimedica (San Pedro) TV SA Live (KSAT) 114 $1,750 1 (210) 361-1480 $1,750 269 5/19/2019 5/25/2019 210 361-1480 210-361-1480
    290 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 290 5/19/2019 5/25/2019 210 361-1720 210-361-1720
    301 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 301 5/19/2019 5/25/2019 210 361-8667 210-361-8667
    337 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 337 5/19/2019 5/25/2019 210 239-2304 210-239-2304
    355 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 960-9944 $45.43 355 5/19/2019 5/25/2019 210 960-9944 210-960-9944
    373 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 373 5/19/2019 5/25/2019 210 263-3116 210-263-3116
    395 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 395 5/19/2019 5/25/2019 210 908-5231 210-908-5231
    417 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 417 5/19/2019 5/25/2019 210 361-8442 210-361-8442
    433 Male Medical Group (SO) TV SA Live (KSAT) 114 $2,500 1 (210) 361-1203 $2,500 433 5/19/2019 5/25/2019 210 361-1203 210-361-1203
    453 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 47 (210) 361-5581 $60.96 453 5/19/2019 5/25/2019 210 361-5581 210-361-5581
    460 Male Medical Group (SO) Radio KONO 101.1 103 $0 15 (210) 361-5581 $0 460 5/19/2019 5/25/2019 210 361-5581 210-361-5581
    480 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 51 (210) 361-5581 $22.16 480 5/19/2019 5/25/2019 210 361-5581 210-361-5581
    492 Male Medical Group (SO) Newspaper SA Express-News 6 $1,148 1 (210) 610-9726 $1,148 492 5/19/2019 5/25/2019 210 610-9726 210-610-9726
    260 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 260 5/12/2019 5/18/2019 210 361-5592 210-361-5592
    289 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 289 5/12/2019 5/18/2019 210 361-1720 210-361-1720
    336 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 336 5/12/2019 5/18/2019 210 239-2304 210-239-2304
    354 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 354 5/12/2019 5/18/2019 210 659-7070 210-659-7070
    372 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 372 5/12/2019 5/18/2019 210 263-3116 210-263-3116
    394 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 394 5/12/2019 5/18/2019 210 908-5231 210-908-5231
    416 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 416 5/12/2019 5/18/2019 210 361-8442 210-361-8442
    452 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 452 5/12/2019 5/18/2019 210 361-5581 210-361-5581
    459 Male Medical Group (SO) Radio KONO 101.1 103 $0 15 (210) 361-5581 $0 459 5/12/2019 5/18/2019 210 361-5581 210-361-5581
    479 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 53 (210) 361-5581 $21.32 479 5/12/2019 5/18/2019 210 361-5581 210-361-5581
    491 Male Medical Group (SO) Newspaper SA Express-News 6 $5,557 3 (210) 610-9726 ######## 491 5/12/2019 5/18/2019 210 610-9726 210-610-9726
    509 Slimedica (San Pedro) Radio MIX 96.1 152 $215 29 $7.41 509 5/12/2019 5/18/2019 #VALUE! #VALUE!
    512 Slimedica (San Pedro) Radio MAGIC 105.3 151 $200 29 $6.90 512 5/12/2019 5/18/2019 #VALUE! #VALUE!
    259 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 259 5/5/2019 5/11/2019 210 361-5592 210-361-5592
    288 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 288 5/5/2019 5/11/2019 210 361-1720 210-361-1720
    300 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 300 5/5/2019 5/11/2019 210 361-8667 210-361-8667
    335 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 335 5/5/2019 5/11/2019 210 239-2304 210-239-2304
    353 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 353 5/5/2019 5/11/2019 210 659-7070 210-659-7070
    371 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 371 5/5/2019 5/11/2019 210 263-3116 210-263-3116
    393 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 393 5/5/2019 5/11/2019 210 908-5231 210-908-5231
    415 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 415 5/5/2019 5/11/2019 210 361-8442 210-361-8442
    427 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 427 5/5/2019 5/11/2019 210 361-3306 210-361-3306
    451 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 451 5/5/2019 5/11/2019 210 361-5581 210-361-5581
    458 Male Medical Group (SO) Radio KONO 101.1 103 $0 15 (210) 361-5581 $0 458 5/5/2019 5/11/2019 210 361-5581 210-361-5581
    478 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 52 (210) 361-5581 $21.73 478 5/5/2019 5/11/2019 210 361-5581 210-361-5581
    490 Male Medical Group (SO) Newspaper SA Express-News 6 $5,557 3 (210) 610-9726 ######## 490 5/5/2019 5/11/2019 210 610-9726 210-610-9726
    508 Slimedica (San Pedro) Radio MIX 96.1 152 $215 28 $7.68 508 5/5/2019 5/11/2019 #VALUE! #VALUE!
    511 Slimedica (San Pedro) Radio MAGIC 105.3 151 $200 30 $6.67 511 5/5/2019 5/11/2019 #VALUE! #VALUE!
    258 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 258 4/28/2019 5/4/2019 210 361-5592 210-361-5592
    268 Slimedica (San Pedro) TV SA Live (KSAT) 114 $1,750 1 (210) 361-1480 $1,750 268 4/28/2019 5/4/2019 210 361-1480 210-361-1480
    287 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 287 4/28/2019 5/4/2019 210 361-1720 210-361-1720
    334 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 334 4/28/2019 5/4/2019 210 239-2304 210-239-2304
    352 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 352 4/28/2019 5/4/2019 210 659-7070 210-659-7070
    370 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 370 4/28/2019 5/4/2019 210 263-3116 210-263-3116
    392 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 392 4/28/2019 5/4/2019 210 908-5231 210-908-5231
    414 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 414 4/28/2019 5/4/2019 210 361-8442 210-361-8442
    432 Male Medical Group (SO) TV SA Live (KSAT) 114 $2,500 1 (210) 361-1203 $2,500 432 4/28/2019 5/4/2019 210 361-1203 210-361-1203
    450 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 68 (210) 361-5581 $42.13 450 4/28/2019 5/4/2019 210 361-5581 210-361-5581
    457 Male Medical Group (SO) Radio KONO 101.1 103 $0 15 (210) 361-5581 $0 457 4/28/2019 5/4/2019 210 361-5581 210-361-5581
    477 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 59 (210) 361-5581 $19.15 477 4/28/2019 5/4/2019 210 361-5581 210-361-5581
    507 Slimedica (San Pedro) Radio MIX 96.1 152 $215 35 $6.14 507 4/28/2019 5/4/2019 #VALUE! #VALUE!
    510 Slimedica (San Pedro) Radio MAGIC 105.3 151 $200 41 $4.88 510 4/28/2019 5/4/2019 #VALUE! #VALUE!
    257 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 257 4/21/2019 4/27/2019 210 361-5592 210-361-5592
    286 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 286 4/21/2019 4/27/2019 210 361-1720 210-361-1720
    333 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 333 4/21/2019 4/27/2019 210 239-2304 210-239-2304
    351 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 351 4/21/2019 4/27/2019 210 659-7070 210-659-7070
    369 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 369 4/21/2019 4/27/2019 210 263-3116 210-263-3116
    391 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 391 4/21/2019 4/27/2019 210 908-5231 210-908-5231
    413 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 413 4/21/2019 4/27/2019 210 361-8442 210-361-8442
    426 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 426 4/21/2019 4/27/2019 210 361-3306 210-361-3306
    449 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 449 4/21/2019 4/27/2019 210 361-5581 210-361-5581
    456 Male Medical Group (SO) Radio KONO 101.1 103 $0 13 (210) 361-5581 $0 456 4/21/2019 4/27/2019 210 361-5581 210-361-5581
    476 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 53 (210) 361-5581 $21.32 476 4/21/2019 4/27/2019 210 361-5581 210-361-5581
    256 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 256 4/14/2019 4/20/2019 210 361-5592 210-361-5592
    285 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 285 4/14/2019 4/20/2019 210 361-1720 210-361-1720
    299 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 299 4/14/2019 4/20/2019 210 361-8667 210-361-8667
    332 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 332 4/14/2019 4/20/2019 210 239-2304 210-239-2304
    350 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 350 4/14/2019 4/20/2019 210 659-7070 210-659-7070
    368 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 368 4/14/2019 4/20/2019 210 263-3116 210-263-3116
    390 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 390 4/14/2019 4/20/2019 210 908-5231 210-908-5231
    412 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 412 4/14/2019 4/20/2019 210 361-8442 210-361-8442
    448 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 448 4/14/2019 4/20/2019 210 361-5581 210-361-5581
    455 Male Medical Group (SO) Radio KONO 101.1 103 $0 15 (210) 361-5581 $0 455 4/14/2019 4/20/2019 210 361-5581 210-361-5581
    475 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 53 (210) 361-5581 $21.32 475 4/14/2019 4/20/2019 210 361-5581 210-361-5581
    255 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 255 4/7/2019 4/13/2019 210 361-5592 210-361-5592
    284 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 284 4/7/2019 4/13/2019 210 361-1720 210-361-1720
    331 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 331 4/7/2019 4/13/2019 210 239-2304 210-239-2304
    349 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 349 4/7/2019 4/13/2019 210 659-7070 210-659-7070
    367 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 367 4/7/2019 4/13/2019 210 263-3116 210-263-3116
    389 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 389 4/7/2019 4/13/2019 210 908-5231 210-908-5231
    411 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 411 4/7/2019 4/13/2019 210 361-8442 210-361-8442
    425 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 425 4/7/2019 4/13/2019 210 361-3306 210-361-3306
    447 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 447 4/7/2019 4/13/2019 210 361-5581 210-361-5581
    454 Male Medical Group (SO) Radio KONO 101.1 103 $0 15 (210) 361-5581 $0 454 4/7/2019 4/13/2019 210 361-5581 210-361-5581
    474 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 53 (210) 361-5581 $21.32 474 4/7/2019 4/13/2019 210 361-5581 210-361-5581
    489 Male Medical Group (SO) Newspaper SA Express-News 6 $3,229 1 (210) 610-9726 $3,229 489 4/7/2019 4/13/2019 210 610-9726 210-610-9726
    506 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $957 1 (210) 951-2205 $957 506 4/7/2019 4/13/2019 210 951-2205 210-951-2205
    525 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $957 1 (210) 951-2205 $957 525 4/7/2019 4/13/2019 210 951-2205 210-951-2205
    254 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 254 3/31/2019 4/6/2019 210 361-5592 210-361-5592
    283 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 283 3/31/2019 4/6/2019 210 361-1720 210-361-1720
    298 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 298 3/31/2019 4/6/2019 210 361-8667 210-361-8667
    330 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 330 3/31/2019 4/6/2019 210 239-2304 210-239-2304
    348 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 348 3/31/2019 4/6/2019 210 659-7070 210-659-7070
    366 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 366 3/31/2019 4/6/2019 210 263-3116 210-263-3116
    388 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 388 3/31/2019 4/6/2019 210 908-5231 210-908-5231
    410 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 410 3/31/2019 4/6/2019 210 361-8442 210-361-8442
    446 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 68 (210) 361-5581 $42.13 446 3/31/2019 4/6/2019 210 361-5581 210-361-5581
    473 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 55 (210) 361-5581 $20.55 473 3/31/2019 4/6/2019 210 361-5581 210-361-5581
    505 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $957 1 (210) 951-2205 $957 505 3/31/2019 4/6/2019 210 951-2205 210-951-2205
    524 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $957 1 (210) 951-2205 $957 524 3/31/2019 4/6/2019 210 951-2205 210-951-2205
    253 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $850 1 (210) 361-5592 $850 253 3/24/2019 3/30/2019 210 361-5592 210-361-5592
    282 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 282 3/24/2019 3/30/2019 210 361-1720 210-361-1720
    329 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,174 7 (210) 239-2304 $167.71 329 3/24/2019 3/30/2019 210 239-2304 210-239-2304
    347 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $318 7 (210) 659-7070 $45.43 347 3/24/2019 3/30/2019 210 659-7070 210-659-7070
    365 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $465 7 (210) 263-3116 $66.43 365 3/24/2019 3/30/2019 210 263-3116 210-263-3116
    387 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 387 3/24/2019 3/30/2019 210 908-5231 210-908-5231
    409 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 409 3/24/2019 3/30/2019 210 361-8442 210-361-8442
    424 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 424 3/24/2019 3/30/2019 210 361-3306 210-361-3306
    488 Male Medical Group (SO) Newspaper SA Express-News 6 $980 1 (210) 610-9726 $980 488 3/24/2019 3/30/2019 210 610-9726 210-610-9726
    504 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $957 1 (210) 951-2205 $957 504 3/24/2019 3/30/2019 210 951-2205 210-951-2205
    523 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $957 1 (210) 951-2205 $957 523 3/24/2019 3/30/2019 210 951-2205 210-951-2205
    252 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 252 3/17/2019 3/23/2019 210 361-5592 210-361-5592
    281 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 281 3/17/2019 3/23/2019 210 361-1720 210-361-1720
    297 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 297 3/17/2019 3/23/2019 210 361-8667 210-361-8667
    328 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 328 3/17/2019 3/23/2019 210 239-2304 210-239-2304
    346 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 346 3/17/2019 3/23/2019 210 659-7070 210-659-7070
    364 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 364 3/17/2019 3/23/2019 210 263-3116 210-263-3116
    386 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 386 3/17/2019 3/23/2019 210 908-5231 210-908-5231
    408 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 408 3/17/2019 3/23/2019 210 361-8442 210-361-8442
    445 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 47 (210) 361-5581 $60.96 445 3/17/2019 3/23/2019 210 361-5581 210-361-5581
    472 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 53 (210) 361-5581 $21.32 472 3/17/2019 3/23/2019 210 361-5581 210-361-5581
    503 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 503 3/17/2019 3/23/2019 210 951-2205 210-951-2205
    522 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 522 3/17/2019 3/23/2019 210 951-2205 210-951-2205
    251 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 251 3/10/2019 3/16/2019 210 361-5592 210-361-5592
    280 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 280 3/10/2019 3/16/2019 210 361-1720 210-361-1720
    312 Slimedica (San Pedro) TV SA Live (KSAT) Commercial 136 $4,500 9 (210) 941-2984 $500 312 3/10/2019 3/16/2019 210 941-2984 210-941-2984
    327 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 327 3/10/2019 3/16/2019 210 239-2304 210-239-2304
    345 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 345 3/10/2019 3/16/2019 210 659-7070 210-659-7070
    363 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 363 3/10/2019 3/16/2019 210 263-3116 210-263-3116
    385 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 385 3/10/2019 3/16/2019 210 908-5231 210-908-5231
    407 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 407 3/10/2019 3/16/2019 210 361-8442 210-361-8442
    423 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 423 3/10/2019 3/16/2019 210 361-3306 210-361-3306
    444 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 43 (210) 361-5581 $66.63 444 3/10/2019 3/16/2019 210 361-5581 210-361-5581
    471 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 54 (210) 361-5581 $20.93 471 3/10/2019 3/16/2019 210 361-5581 210-361-5581
    487 Male Medical Group (SO) Newspaper SA Express-News 6 $980 1 (210) 610-9726 $980 487 3/10/2019 3/16/2019 210 610-9726 210-610-9726
    502 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 502 3/10/2019 3/16/2019 210 951-2205 210-951-2205
    521 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 521 3/10/2019 3/16/2019 210 951-2205 210-951-2205
    384 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 384 3/4/2019 3/10/2019 210 908-5231 210-908-5231
    406 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 406 3/4/2019 3/10/2019 210 361-8442 210-361-8442
    431 Male Medical Group (SO) TV SA Live (KSAT) 114 $2,500 1 (210) 361-1203 $2,500 431 3/4/2019 3/10/2019 210 361-1203 210-361-1203
    486 Male Medical Group (SO) Newspaper SA Express-News 6 $980 1 (210) 610-9726 $980 486 3/4/2019 3/10/2019 210 610-9726 210-610-9726
    501 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 501 3/4/2019 3/10/2019 210 951-2205 210-951-2205
    520 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 520 3/4/2019 3/10/2019 210 951-2205 210-951-2205
    250 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 250 3/3/2019 3/9/2019 210 361-5592 210-361-5592
    267 Slimedica (San Pedro) TV SA Live (KSAT) 114 $1,750 1 (210) 361-1480 $1,750 267 3/3/2019 3/9/2019 210 361-1480 210-361-1480
    279 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 279 3/3/2019 3/9/2019 210 361-1720 210-361-1720
    296 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 296 3/3/2019 3/9/2019 210 361-8667 210-361-8667
    311 Slimedica (San Pedro) TV SA Live (KSAT) Commercial 136 $4,500 9 (210) 941-2984 $500 311 3/3/2019 3/9/2019 210 941-2984 210-941-2984
    326 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 326 3/3/2019 3/9/2019 210 239-2304 210-239-2304
    344 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 344 3/3/2019 3/9/2019 210 659-7070 210-659-7070
    362 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 362 3/3/2019 3/9/2019 210 263-3116 210-263-3116
    443 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 64 (210) 361-5581 $44.77 443 3/3/2019 3/9/2019 210 361-5581 210-361-5581
    470 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 61 (210) 361-5581 $18.52 470 3/3/2019 3/9/2019 210 361-5581 210-361-5581
    249 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 249 2/24/2019 3/2/2019 210 361-5592 210-361-5592
    278 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 278 2/24/2019 3/2/2019 210 361-1720 210-361-1720
    325 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 325 2/24/2019 3/2/2019 210 239-2304 210-239-2304
    343 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 343 2/24/2019 3/2/2019 210 659-7070 210-659-7070
    361 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 361 2/24/2019 3/2/2019 210 263-3116 210-263-3116
    383 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $850 1 (210) 908-5231 $850 383 2/24/2019 3/2/2019 210 908-5231 210-908-5231
    405 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 405 2/24/2019 3/2/2019 210 361-8442 210-361-8442
    422 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 422 2/24/2019 3/2/2019 210 361-3306 210-361-3306
    442 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 442 2/24/2019 3/2/2019 210 361-5581 210-361-5581
    469 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 58 (210) 361-5581 $19.48 469 2/24/2019 3/2/2019 210 361-5581 210-361-5581
    485 Male Medical Group (SO) Newspaper SA Express-News 6 $784 1 (210) 610-9726 $784 485 2/24/2019 3/2/2019 210 610-9726 210-610-9726
    500 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 500 2/24/2019 3/2/2019 210 951-2205 210-951-2205
    519 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 519 2/24/2019 3/2/2019 210 951-2205 210-951-2205
    248 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 248 2/17/2019 2/23/2019 210 361-5592 210-361-5592
    266 Slimedica (San Pedro) TV SA Live (KSAT) 114 $1,750 1 (210) 361-1480 $1,750 266 2/17/2019 2/23/2019 210 361-1480 210-361-1480
    277 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 277 2/17/2019 2/23/2019 210 361-1720 210-361-1720
    295 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 295 2/17/2019 2/23/2019 210 361-8667 210-361-8667
    324 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 324 2/17/2019 2/23/2019 210 239-2304 210-239-2304
    342 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 342 2/17/2019 2/23/2019 210 659-7070 210-659-7070
    360 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 360 2/17/2019 2/23/2019 210 263-3116 210-263-3116
    382 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 382 2/17/2019 2/23/2019 210 908-5231 210-908-5231
    404 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 404 2/17/2019 2/23/2019 210 361-8442 210-361-8442
    441 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 441 2/17/2019 2/23/2019 210 361-5581 210-361-5581
    468 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 58 (210) 361-5581 $19.48 468 2/17/2019 2/23/2019 210 361-5581 210-361-5581
    499 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 499 2/17/2019 2/23/2019 210 951-2205 210-951-2205
    518 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $1,554 1 (210) 951-2205 $1,554 518 2/17/2019 2/23/2019 210 951-2205 210-951-2205
    247 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 247 2/10/2019 2/16/2019 210 361-5592 210-361-5592
    276 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 276 2/10/2019 2/16/2019 210 361-1720 210-361-1720
    323 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 323 2/10/2019 2/16/2019 210 239-2304 210-239-2304
    341 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 341 2/10/2019 2/16/2019 210 659-7070 210-659-7070
    359 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 359 2/10/2019 2/16/2019 210 263-3116 210-263-3116
    381 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 381 2/10/2019 2/16/2019 210 908-5231 210-908-5231
    403 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 403 2/10/2019 2/16/2019 210 361-8442 210-361-8442
    421 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 421 2/10/2019 2/16/2019 210 361-3306 210-361-3306
    440 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 440 2/10/2019 2/16/2019 210 361-5581 210-361-5581
    467 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 53 (210) 361-5581 $21.32 467 2/10/2019 2/16/2019 210 361-5581 210-361-5581
    484 Male Medical Group (SO) Newspaper SA Express-News 6 $784 1 (210) 610-9726 $784 484 2/10/2019 2/16/2019 210 610-9726 210-610-9726
    498 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 498 2/10/2019 2/16/2019 210 951-2205 210-951-2205
    517 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 517 2/10/2019 2/16/2019 210 951-2205 210-951-2205
    246 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 246 2/3/2019 2/9/2019 210 361-5592 210-361-5592
    265 Slimedica (San Pedro) TV SA Live (KSAT) 114 $1,750 1 (210) 361-1480 $1,750 265 2/3/2019 2/9/2019 210 361-1480 210-361-1480
    275 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 275 2/3/2019 2/9/2019 210 361-1720 210-361-1720
    294 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 294 2/3/2019 2/9/2019 210 361-8667 210-361-8667
    314 Slimedica (San Pedro) TV Great Day SA (KENS 5) Commercial 137 $2,400 6 (210) 941-3481 $400 314 2/3/2019 2/9/2019 210 941-3481 210-941-3481
    319 Slimedica (San Pedro) TV Spectrum Commercial 154 $1,505 47 (210) 469-5822 $32.02 319 2/3/2019 2/9/2019 210 469-5822 210-469-5822
    322 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 322 2/3/2019 2/9/2019 210 239-2304 210-239-2304
    340 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 340 2/3/2019 2/9/2019 210 659-7070 210-659-7070
    358 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 358 2/3/2019 2/9/2019 210 263-3116 210-263-3116
    380 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 380 2/3/2019 2/9/2019 210 908-5231 210-908-5231
    402 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 402 2/3/2019 2/9/2019 210 361-8442 210-361-8442
    430 Male Medical Group (SO) TV SA Live (KSAT) 114 $2,500 1 (210) 361-1203 $2,500 430 2/3/2019 2/9/2019 210 361-1203 210-361-1203
    439 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 48 (210) 361-5581 $59.69 439 2/3/2019 2/9/2019 210 361-5581 210-361-5581
    466 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 56 (210) 361-5581 $20.18 466 2/3/2019 2/9/2019 210 361-5581 210-361-5581
    483 Male Medical Group (SO) Newspaper SA Express-News 6 $784 1 (210) 610-9726 $784 483 2/3/2019 2/9/2019 210 610-9726 210-610-9726
    497 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 497 2/3/2019 2/9/2019 210 951-2205 210-951-2205
    516 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 516 2/3/2019 2/9/2019 210 951-2205 210-951-2205
    245 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 245 1/27/2019 2/2/2019 210 361-5592 210-361-5592
    274 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 274 1/27/2019 2/2/2019 210 361-1720 210-361-1720
    304 Slimedica (San Pedro) TV SA Living (WOAI) Commercial 134 $1,120 8 (210) 941-4062 $140 304 1/27/2019 2/2/2019 210 941-4062 210-941-4062
    307 Slimedica (San Pedro) TV Daytime at 9 (KABB) Commercial 135 $1,260 6 (210) 981-3280 $210 307 1/27/2019 2/2/2019 210 981-3280 210-981-3280
    313 Slimedica (San Pedro) TV Great Day SA (KENS 5) Commercial 137 $1,400 6 (210) 941-3481 $233.33 313 1/27/2019 2/2/2019 210 941-3481 210-941-3481
    318 Slimedica (San Pedro) TV Spectrum Commercial 154 $1,505 47 (210) 469-5822 $32.02 318 1/27/2019 2/2/2019 210 469-5822 210-469-5822
    320 Slimedica (San Pedro) TV SA Live (KSAT) Commercial 136 $3,150 6 (210) 941-2984 $525 320 1/27/2019 2/2/2019 210 941-2984 210-941-2984
    321 Male Medical Group (SO) Billboard Billboard (281/Beside Our Building) 155 $1,270 7 (210) 239-2304 $181.43 321 1/27/2019 2/2/2019 210 239-2304 210-239-2304
    339 Male Medical Group (SO) Billboard Billboard (1604/Braun) 156 $344 7 (210) 659-7070 $49.14 339 1/27/2019 2/2/2019 210 659-7070 210-659-7070
    357 Male Medical Group (SO) Billboard Billboard (35/Eisenhauer) 157 $503 7 (210) 263-3116 $71.86 357 1/27/2019 2/2/2019 210 263-3116 210-263-3116
    379 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 379 1/27/2019 2/2/2019 210 908-5231 210-908-5231
    401 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 401 1/27/2019 2/2/2019 210 361-8442 210-361-8442
    420 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 420 1/27/2019 2/2/2019 210 361-3306 210-361-3306
    438 Male Medical Group (SO) Radio KISS 99.5 18 $2,865 68 (210) 361-5581 $42.13 438 1/27/2019 2/2/2019 210 361-5581 210-361-5581
    465 Male Medical Group (SO) Radio KTKX 106.7 105 $1,130 48 (210) 361-5581 $23.54 465 1/27/2019 2/2/2019 210 361-5581 210-361-5581
    482 Male Medical Group (SO) Newspaper SA Express-News 6 $980 1 (210) 610-9726 $980 482 1/27/2019 2/2/2019 210 610-9726 210-610-9726
    496 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 496 1/27/2019 2/2/2019 210 951-2205 210-951-2205
    515 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 515 1/27/2019 2/2/2019 210 951-2205 210-951-2205
    244 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 244 1/20/2019 1/26/2019 210 361-5592 210-361-5592
    264 Slimedica (San Pedro) TV SA Live (KSAT) 114 $1,500 1 (210) 361-1480 $1,500 264 1/20/2019 1/26/2019 210 361-1480 210-361-1480
    273 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 273 1/20/2019 1/26/2019 210 361-1720 210-361-1720
    293 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 293 1/20/2019 1/26/2019 210 361-8667 210-361-8667
    303 Slimedica (San Pedro) TV SA Living (WOAI) Commercial 134 $1,160 8 (210) 941-4062 $145 303 1/20/2019 1/26/2019 210 941-4062 210-941-4062
    306 Slimedica (San Pedro) TV Daytime at 9 (KABB) Commercial 135 $1,680 8 (210) 981-3280 $210 306 1/20/2019 1/26/2019 210 981-3280 210-981-3280
    310 Slimedica (San Pedro) TV SA Live (KSAT) Commercial 136 $3,800 9 (210) 941-2984 $422.22 310 1/20/2019 1/26/2019 210 941-2984 210-941-2984
    317 Slimedica (San Pedro) TV Spectrum Commercial 154 $1,505 47 (210) 469-5822 $32.02 317 1/20/2019 1/26/2019 210 469-5822 210-469-5822
    378 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 378 1/20/2019 1/26/2019 210 908-5231 210-908-5231
    400 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 400 1/20/2019 1/26/2019 210 361-8442 210-361-8442
    437 Male Medical Group (SO) Radio KISS 99.5 18 $2,475 69 (210) 361-5581 $35.87 437 1/20/2019 1/26/2019 210 361-5581 210-361-5581
    464 Male Medical Group (SO) Radio KTKX 106.7 105 $1,150 30 (210) 361-5581 $38.33 464 1/20/2019 1/26/2019 210 361-5581 210-361-5581
    481 Male Medical Group (SO) Newspaper SA Express-News 6 $1,960 2 (210) 610-9726 $980 481 1/20/2019 1/26/2019 210 610-9726 210-610-9726
    495 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 495 1/20/2019 1/26/2019 210 951-2205 210-951-2205
    514 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 514 1/20/2019 1/26/2019 210 951-2205 210-951-2205
    243 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 243 1/13/2019 1/19/2019 210 361-5592 210-361-5592
    272 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 272 1/13/2019 1/19/2019 210 361-1720 210-361-1720
    302 Slimedica (San Pedro) TV SA Living (WOAI) Commercial 134 $1,160 8 (210) 941-4062 $145 302 1/13/2019 1/19/2019 210 941-4062 210-941-4062
    305 Slimedica (San Pedro) TV Daytime at 9 (KABB) Commercial 135 $1,260 6 (210) 981-3280 $210 305 1/13/2019 1/19/2019 210 981-3280 210-981-3280
    309 Slimedica (San Pedro) TV SA Live (KSAT) Commercial 136 $3,800 11 (210) 941-2984 $345.45 309 1/13/2019 1/19/2019 210 941-2984 210-941-2984
    316 Slimedica (San Pedro) TV Spectrum Commercial 154 $1,560 48 (210) 469-5822 $32.50 316 1/13/2019 1/19/2019 210 469-5822 210-469-5822
    377 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 377 1/13/2019 1/19/2019 210 908-5231 210-908-5231
    399 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 399 1/13/2019 1/19/2019 210 361-8442 210-361-8442
    429 Male Medical Group (SO) TV SA Live (KSAT) 114 $2,500 1 (210) 361-1203 $2,500 429 1/13/2019 1/19/2019 210 361-1203 210-361-1203
    436 Male Medical Group (SO) Radio KISS 99.5 18 $2,575 51 (210) 361-5581 $50.49 436 1/13/2019 1/19/2019 210 361-5581 210-361-5581
    463 Male Medical Group (SO) Radio KTKX 106.7 105 $1,250 32 (210) 361-5581 $39.06 463 1/13/2019 1/19/2019 210 361-5581 210-361-5581
    494 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 494 1/13/2019 1/19/2019 210 951-2205 210-951-2205
    513 Male Medical Group (SO) Internet Search/Website SA Express-News Web 158 $597 1 (210) 951-2205 $597 513 1/13/2019 1/19/2019 210 951-2205 210-951-2205
    242 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 242 1/6/2019 1/12/2019 210 361-5592 210-361-5592
    271 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 271 1/6/2019 1/12/2019 210 361-1720 210-361-1720
    292 Slimedica (San Pedro) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-8667 $1,000 292 1/6/2019 1/12/2019 210 361-8667 210-361-8667
    308 Slimedica (San Pedro) TV SA Live (KSAT) Commercial 136 $1,950 6 (210) 941-2984 $325 308 1/6/2019 1/12/2019 210 941-2984 210-941-2984
    315 Slimedica (San Pedro) TV Spectrum Commercial 154 $1,425 45 (210) 469-5822 $31.67 315 1/6/2019 1/12/2019 210 469-5822 210-469-5822
    376 Male Medical Group (SO) TV Daytime at 9 (KABB) 113 $750 1 (210) 908-5231 $750 376 1/6/2019 1/12/2019 210 908-5231 210-908-5231
    398 Male Medical Group (SO) TV SA Living (WOAI) 111 $750 1 (210) 361-8442 $750 398 1/6/2019 1/12/2019 210 361-8442 210-361-8442
    419 Male Medical Group (SO) TV Great Day SA (KENS 5) 112 $1,000 1 (210) 361-3306 $1,000 419 1/6/2019 1/12/2019 210 361-3306 210-361-3306
    435 Male Medical Group (SO) Radio KISS 99.5 18 $2,672 53 (210) 361-5581 $50.42 435 1/6/2019 1/12/2019 210 361-5581 210-361-5581
    462 Male Medical Group (SO) Radio KTKX 106.7 105 $1,250 32 (210) 361-5581 $39.06 462 1/6/2019 1/12/2019 210 361-5581 210-361-5581
    241 Slimedica (San Pedro) TV Daytime at 9 (KABB) 113 $750 1 (210) 361-5592 $750 241 12/30/2018 1/5/2019 210 361-5592 210-361-5592
    263 Slimedica (San Pedro) TV SA Live (KSAT) 114 $1,500 1 (210) 361-1480 $1,500 263 12/30/2018 1/5/2019 210 361-1480 210-361-1480
    270 Slimedica (San Pedro) TV SA Living (WOAI) 111 $750 1 (210) 361-1720 $750 270 12/30/2018 1/5/2019 210 361-1720 210-361-1720
    434 Male Medical Group (SO) Radio KISS 99.5 18 $1,400 30 (210) 361-5581 $46.67 434 12/30/2018 1/5/2019 210 361-5581 210-361-5581
    461 Male Medical Group (SO) Radio KTKX 106.7 105 $950 26 (210) 361-5581 $36.54 461 12/30/2018 1/5/2019 210 361-5581 210-361-5581

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •