Campaign Reports
Orders by Period
navigate to the menu Analysis -> Campaign Reports -> Orders by Period.
User selects the financial period(s) and choses a digital product group, and an option to break out data by rep or by campaign line, and all the details of advertiser, brand, line item ID hyperlink, amounts and invoices.
Break by line will show one line per order
Break by rep will show two (or more) lines on any order that was shared between two or more reps.
The system loads in daily data from Google for Ad Server numbers. This allows users on the Period Report and the Pacing Report to set an “Served Data as of Date” to view the data. Enter the date to view the data based on served as of this date.
Product Group Analysis
In the menu system, Navigate to Analysis -> Campaign Reports -> Product Group Analysis.
Choose a product or product group from the drop-down menu and choose the starting month and year and click “Get Data”.
Note the Confirmed amount for any of the months you’re interested in, then click the hyperlink to the month under the Confirmed column. This opens the details for the orders from that month for the product.
Note that the Actual Gross Amounts match the figures on the Product Group Analysis screen, unless these amounts are zeros, where the system then reflects the Estimated Gross Amounts. These calculations are per line item, so the totals reflected in the product group analysis can be a mix of actuals and estimates.
Product Group Sales Performance
In the Executive Dashboard (See User Security -> Advertising for Default Home Page Options to get the Executive Dashboard), click on the Product Group Sales Performance tile. This report provides a more in-depth analysis of the campaigns by product group or by product.
As a prerequisite, user should create groups of different products, such as a group for websites, another for e-newsletters, and so forth, or a group which includes different websites and e-newsletters for a specific industry. This is an organizational decision for the user to make.
This report provides the net revenue for each month starting the month which user chose in the drop-down criteria. Each month will have listed the number of orders per status, the budget, budget vs. confirmed orders, last year’s figures and confirmed numbers of this month versus that of last year. Similarly, there are other tabs which provide summary of orders for each advertiser, agency and PIB/industry displaying the total orders confirmed, total reserved and last year’s figures.
12-Period Analysis
Navigate to the menu Analysis -> Advertising Reports -> 12 Period Analysis. You can also access this same report using the Executive dashboard tile "Product Analysis."
Choose the report to display by the Product Group or the Product and select the corresponding data as the Product or Group menu will change based on this selection to show the product list or the group list.
Select the start financial period of the report and this will show the following 12 periods.
Select the sales rep group, and the tracking currency from the lists.
Choose the “Summarize by” field to show the desired report details. Options are: Advertiser, Parent Account, Agency, Order Rep, Brand Rep, PIB/ Industry Code, Territory or Ad Type, GL Type, or Product.
The data displays in numbers and graphics.
Click the tab “Current vs. Prior Year and the compared revenue data between the current and previous year will display.
Data Difference in Reports
Note that if user compares the amount in the orders by product to the same column amount on the 12 Period Advertisers by Product Report, there may be a difference. One report produces the amount by date and the other by period, but running for every day in the period, user expects to see the same number in both reports.
The Orders by Product Report has many columns (estimates, actuals etc.), while the 12 Period one has one number for each month.
The difference between the two amounts is that on the orders by product report, user is looking at actuals. On the 12 Period report:
If there are actuals, the report ignores the estimate and uses actuals (even if they are different)
If there are no actuals, the report uses the estimate instead. This way, user can report into the future and can report in the past on campaigns where user may not yet have finalized the actuals).
Users may have many reports in the past that have zero actuals and had estimates.
The report uses the estimate, so that a past month report is the total of estimates and actuals, whereas the other report reflects just actuals. This is because users may have campaigns in the past that they have not yet reconciled.
Also, if you click on the rep name in the results, the campaign brand rep’s data is what displays, while the line rep data displays when you click on the amount in the period-month column.
Expiring Campaigns
Campaign Performance
User selects the type, product group and date range. User can narrow down the search by advertiser or campaign ID to view the details of the campaigns, including clicks and quantities served, actual clicks and quantities.
My Current Campaign Delivery
User selects the timeframe of the current month or the full length of lines and views the campaign line item information as well as the GAM information. The GAM information includes the following:
Delivered percent which provides the data:
Currently Delivered: This is the Impressions, Clicks or Units Currently Delivered on this Line Item.
Elapsed Time of this Line: This is a progress bar indicating where this line should be as a percentage of the elapsed time. Remaining to Deliver: This is the difference between the Estimated Impressions, Clicks or Units versus the Current Impressions, Clicks or Units. Percent Delivered of Total: This is Current Delivered quantity expressed as a percentage of the estimated total.
Estimated to date total till the end of the current month.
Served to date which is the total current quantity.
Over/Under delivery which is the difference between the served to date and estimated to date.
Last updated which is the last update of this data. The updates are always refreshed according to the GAM setup.
The Digital Campaign Delivery report can be customized by user, similar to some of our other report screens. There is a configure output tab, so that you can choose which fields you would like to see in the on-screen version of the report and in the Excel output version of the report.
E-Newsletter Position Availability
This is a report which provides the user with a section and position availability for each e-newsletter user can access. This includes the date, day of the week, maximum allowed, and positions already booked for this newsletter.
Adjustment Usage Report
This report reflects the adjustments applied to orders in a product group or by various products within a start and end date range.
Navigate to the menu Analysis -> Campaign Reports -> Adjustment Usage Reports.
Choose the type to be Product, then check the box(es) for the different products or select group and choose a product group. Then enter a date range during which the products run and the statuses of orders you’d like to search for adjustments. You can choose to include or exclude contract adjustments. Click “Select Data”.
The system displays the orders with their adjustment details and hyperlinks to drill through to the campaign or line.
Incentives Report
This report shows a list of all incentives configured in the system. Can optionally filter by type of incentive, product group advertiser and or valid dates.
Classified Listing Order Report
This report shows a list of all classified orders for the selected Category Tree. Search by product or by product group for a period of time
Links are available for quick access to the campaign, line, or advertiser.
Edition Report
Report displays orders for one or more editions in an issue date or date range. Multiple Editions can be selected in the Edition Dropdown.
Campaign Budget Analysis
Campaign Budget Analysis Report is a report which provides graphical and numerical analysis of the revenue vs. expense report for campaigns. Click the menu tile “Campaign Budget Analysis” and run the query by any of the available criteria. For example, the date range during which the campaign is running, the order status, the sales rep or the product group.
See Campaign Reports
Issue Analysis
Issue analysis displays a given issue in the selected product and compares to the comparison issue from the prior year (if setup in issue configuration)
Zones Report
Select a product, a dimension, and a date range to bring back circ counts for each zone (and parent/grandparent) for each date in a given Sun-Sat week.
Last updated
Was this helpful?