Collecting Ad Material For Print - Golf Inc.
Table of Contents
Overview of SOP- This SOP will demonstrate how to find and collect missing ad material necessary for our print magazines.
Maghub
Username: membership@crittendenresearch.com
Password: Crittenden123$
Production Calendar: https://docs.google.com/spreadsheets/d/1tpeWMeESbU-xum_GLga5lw71Q3H4KPxGxn3cQoGEY3Y/edit#gid=118651920&fvid=1776672473
Quick Guide:
1.)Run Consolidated Production report
2.) Fill in fields with necessary information
3.) Export, and sort report
4.) Save as PDF
5.) Send to Reps
Detailed Guide
Run consolidated production report. Find this report on Ad Orbit by going into reports → all reports→ production/design→consolidated production report.
Fill in the necessary fields. This will be:
Brand- (example: golf inc)
issue date - (select first day of month and last day of month)
Then, edit display fields to show primary reps.
3.) Click get report→export report
On Exported report, delete all extra fields leaving only company, rep, ad size, approval, and status.
Delete the rows where statuses show done or file uploaded. This means they are complete and do not need to be included in the report.
4.)Save as pdf