Ad Index How To

In Magazine Manager:

Open: Reports > Production > Ad Index

For Product. select The Equiery

For Issue, select issue being worked on (Sep 2021).

For Year, select current year (2021)

Click Search

When report opens, click on the Ad Size column header to sort.

Scroll through the display ad sizes to make sure they all have a category selected and a website if applicable. If not, use the search bar to navigate to client record. Select a category from the dropdown menu (on right below rep name). Add website to Website URL section if client has one. 

Also, if they are an MHC member, check that box in the Contact Groups section. Uncheck import box (client will show up in export for each contact group selected)

When you go to the second page, it may show up blank…just scroll up.

When finished, click search (top left) and pull up the same report again, so all the info you just added appears.

Click the hamburger button and select export. Open the exported CSV file in excel.

Delete anything that does not appear in the ad index.

Double check that ads are in the correct category and names display as you want them to for that month. 

Sort spreadsheet by Category then by Company Name.

Copy Company Name, Page Number and Website columns into Indesign file. 

Indesign file is set up to auto format

*service directories don’t change much, so I would just give the designer a list of who to add and who to delete each month, instead of reflowing that whole column.