Currently we do a 30 minute process of checking, by hand, each and every advertiser in our publication to see what page it's on or if we're accidentally leaving it out. I want to be able to somehow automate the process with "trackers" embedded in each ad, like an invisible box to be grouped that would sync up with a spreadsheet of some kind. As it is now, if we do our by-hand check of 30 minutes and then later move an ad, we have to redo the entire process or risk printing the publication with a missing ad.
We've done things the old fashioned way for years and I'm hoping someone here will have a solution. I mean, how do big companies track ads and boxes in a publication with 100s of pages and ads and coupons?!?
Perhaps a variation on the way I build "Index to Advertiser" TOCs will work. I add "tags" to ads which are grouped text frames set to non-printing. In my case I use a topic and the name of the advertiser, both with prefix codes that allow me to sort alphabetically in the TOC. In your case it would probably work to simply use the advertiser name, create a text anchor, and use a cross-reference in a table on the pasteboard someplace with a list of the advertisers for the issue and the cross-refs of where the ad is located.