Media Calendar: Difference between revisions

Revision as of 06:16, 8 January 2012

A Media Calendar is an overview of the of all ads in a calendar format with various formatting options.

Filter

Date Range

Shows time period for which we want to view Media Calendar.

Select start date and stop date.

Time Range

Filter for specific time range in case of Television or Radio Ads.

Enter time range for which you want to view ads.

Schedule Number

Shows no. of schedule whose ads we want to display.

Enter Schedule Number or Press F7 to Search or F6 to Create New.

Filter 2

Company

Filter for specific company(s).

Enter existing company code or Press F7 to search or Press F6 to create new. Click on (+) to select multiple companies.

Client Group

Filter for all clients associated with the client group

Enter an existing Client Group Code or Press F7 to Search or F6 to Create New. Click on the (+) icon to select multiple Groups.

Client

Filter for specific client(s).

Enter an existing Client Code or Press F7 to Search or F6 to Create New. Click on the (+) icon to select multiple Clients.

Brand

Filter for specific Brand(s).

Enter existing Brand Code or Press F7 to search or F6 to create new. Click on (+) icon to select multiple brands.

Media Type

Filters for specific Media Type(s).

Enter an existing type code or Press F7 to search or F6 to create new. Click on (+) icon to select multiple Types.

Market

Filters for specific Market(s).

Enter an existing Market Code or Press F7 to search or F6 to create new. Click on (+) icon to select multiple Markets.

Supplier Group

Filter for all suppliers associated with the supplier group

Enter an existing Supplier Group Code or Press F7 to Search or F6 to Create New. Click on the (+) icon to select multiple Groups.

Supplier

Filter for specific Supplier(s).

Enter an existing supplier Code or Press F7 to Search or F6 to Create New. Click on the (+) icon to select multiple Suppliers.

Vehicle

Filter for specific vehicles(s).

Enter vehicle Name/part of the name or Press F7 to Search or F6 to Create New. Click (+) to select multiple vehicles.

@@ Line 1: / Line 1: @@
-[[image:Mediacalendar.jpg]]
+[[image:Media_Calendar.jpg]]
-A Media calendar generates a report which is an overview of the list of ads in a calendar format with various formatting options.
+A Media Calendar is an overview of the of all ads in a calendar format with various formatting options.
-This report can be used for many types of analysis but the column headings are fixed as the days of the month. A version of this report which allowed us to control how the analysis is done columnwise would be a more sophisticated version of excels "pivot table".
+== Filter ==
+=== Date Range ===
+Shows time period for which we want to view Media Calendar.
-=== Filter ===
+Select start date and stop date.
-{{Filter}}
+=== Time Range ===
+Filter for specific time range in case of Television or Radio Ads.
-=== Format ===
+Enter time range for which you want to view ads.
-Atleast one Row field and one Data field is required in order to generate the report.
+=== Schedule Number ===
+Shows no. of schedule whose ads we want to display.
-==== Rows ====
+Enter Schedule Number or Press F7 to Search or F6 to Create New.
-Allows you to specify the various rows you want on the report with the options of choosing multiple rows. You can specify various types of data to appear in a row format.
+== Filter 2 ==
+=== Company ===
+Filter for specific company(s).
-==== Data ====
+Enter existing company code or Press F7 to search or Press F6 to create new. Click on '''(+)''' to select multiple companies.
-Allows you to select what data you want on the report with the option of choosing multiple data fields. Each of the options selected here reflects on the date columns.
+=== Client Group ===
+Filter for all clients associated with the client group
-=== Sample Report ===
+Enter an existing Client Group Code or Press F7 to Search or F6 to Create New. Click on the '''(+)''' icon to select multiple Groups.
-[[image:Repmediacalendar.jpg]]
+=== Client ===
+Filter for specific client(s).
+Enter an existing Client Code or Press F7 to Search or F6 to Create New. Click on the '''(+)''' icon to select multiple Clients.
+=== Brand ===
+Filter for specific Brand(s).
+Enter existing Brand Code or Press F7 to search or F6 to create new. Click on '''(+)''' icon to select multiple brands.
+=== Media Type ===
+Filters for specific Media Type(s).
+Enter an existing type code or Press F7 to search or F6 to create new. Click on '''(+)''' icon to select multiple Types.
+=== Market ===
+Filters for specific Market(s).
+Enter an existing Market Code or Press F7 to search or F6 to create new. Click on '''(+)''' icon to select multiple Markets.
+=== Supplier Group ===
+Filter for all suppliers associated with the supplier group
+Enter an existing Supplier Group Code or Press F7 to Search or F6 to Create New. Click on the '''(+)''' icon to select multiple Groups.
+=== Supplier ===
+Filter for specific Supplier(s).
+Enter an existing supplier Code or Press F7 to Search or F6 to Create New. Click on the '''(+)''' icon to select multiple Suppliers.
+=== Vehicle ===
+Filter for specific vehicles(s).
+Enter vehicle Name/part of the name or Press F7 to Search or F6 to Create New. Click '''(+)''' to select multiple vehicles.