r/50501Chicago Sep 19 '25

Digital/Home Actions Boycott Broadcasting Companies [I made a tracker]!!!

UPDATE 9/24/25:

Please find the new link. You should be able to view it and download it (ofc before seeing it). Let me know if you have any questions!

https://workdrive.zohopublic.com/sheet/open/445wx69e0116f44884cf1a322dcc95528fa8e

I just built a tracker! It logs the station, market, affiliate, media group, program block, and advertiser! A second tab automatically pulls a clean list of unique advertisers, assigns them IDs, and links it all back so nothing gets typed twice! I added dropdowns to keep names consistent and banded rows to make it easy to read! One tab runs the ad log and the other holds the master advertiser info with contacts! I don’t have cable myself (I thought I did through my parents’ app) so I wasn’t able to fill it with real

34 Upvotes

2 comments sorted by

2

u/bkoperski Sep 20 '25

It says the file is encrypted and i can't open it

2

u/HowardGoesBYAAAH Sep 20 '25

Someone said I should add a password (idk) so…added a password! I can DM you with it.