February 16, 2023
New
Digital Media Revenue Recognition
A new field has been added to Impression and Targeted Display digital media products called 'Revenue Recognition'. By default, this field is set to 'distribution across all months', which means the quantity and cash values for the item will be split up evenly across each month that the item spans. If you change the setting on the product to 'front-load first month', the quantity, gross, and net amount of the item will all be put into the first month that the item is running, and the rest of the months will be set to 0. If you use this option, your tickets will be grouped automatically.
The Slot Inventory Report has been brought to your dashboard this release with the addition of a Slot Inventory widget. It contains all the same information as the report, the only restriction being you can only view one product on the widget at a time. You can choose between the table and pivot view, and add the widget to your dock for easy access throughout the site.
Product Level Dynamic Attributes
There is a new ability this release to set up line item attributes for product types, or even specific products, rather than a generic line item attribute. When adding or editing a ticket dynamic attribute, if you check the 'Show on Line Item' box, you'll now see additional, optional fields.
First, you'll see a multi-select dropdown for Product Type. This allows you to pick and choose if you only want the attribute to apply to particular product types, such as Event line items, or Digital Media. If you leave this field blank, the attribute will apply to all of your line items. If you choose a product type, the attribute will only be displayed on that product type, and not others.
If you choose the Digital Media product type, you will see two additional fields: Product Subtype, and Products. Product Subtype allows you to choose which dynamic attribute products you wish the attribute to apply to (impression, slot, reserved, or targeted display). If left blank, the attribute will apply to all digital media line items. If you choose a subtype, the attribute will only show on those digital media products. Product allows you to get even more granular, and choose the specific products that the attribute should be used on. This gives you a lot of flexibility, in that you can pick and choose very specific items that an attribute should be used for. If left blank, the attribute will apply to all products in the chosen subtypes.
If you choose the Service product type, you will see an additional Products field. This works the same as the Digital Media product field. You can pick and choose which specific service products the attribute can be used on, and ignore others. If left blank, the attribute can be used on all service products.
Publication Sales Pacing Report
The new Publication Sales Pacing Report shows you how your sales are performing comparatively, year over year. The report finds sales scheduled for the current year that have been sold by the 'As Of' date, and compares it to sales scheduled for the previous year that were sold by the 'As Of' date for the previous year. As with most of our reports, you need a user permission to access it. The permission 'Publication Sales Pacing Report' gives you access to the report, and the sub-permission 'View All Users' lets you see data for all users, not just your own. The report results will be broken out by Publication, your 'This Year' sales, and your 'Last Year' sales. Each record will also show the Delta value, so you can easily track how your sales are performing from one year to another.
Another new report this release is the Scheduled Report Status, which will be helpful in particular for admin users of MagHub. The report lets users find saved and scheduled searches and reports, and shows information about each. In the results, you'll be able to see when the record was created and by who, as well as its status. The user permission 'Scheduled Report Status' lets you view the report, and the sub-permission 'Can Terminate Reports' allows you to perform actions on the results. The results will show the name of the search or report, as well as some information about the record. If you have the sub-permission 'Can Terminate Reports', you may see an ellipses icon on some of the records. The ellipses allows you to either reset the attempts the report or search has tried to run, or to cancel the job. Canceling the report can be helpful if it is timing out and slowing down the rest of your site.
Improvements
We now allow users to submit their timesheets for approval on a daily basis. Now, when users click the 'Submit for Approval' action on their timesheet, they will see a popup containing each day on their timesheet, with some basic information about each day. Each day has a checkbox next to it, which by default is selected, meaning that day will be submitted for approval. If you want to pick and choose which days to submit, you can uncheck or check specific days in this popup prior to submitting.
Along with this change, on your timesheets, you'll now see statuses for each day, unless the timesheet is 'Open', meaning it hasn't been submitted yet. Some statuses you may see are Submitted, Approved, or Rejected.
When approving timesheets, users now have the ability to either approve all of the days for the week, or use the checkmarks below each day to approve days individually.
Reserved Product Inventory Group Updates
Previously, if an item from an inventory group was placed in the scheduler, you wouldn't know if you were trying to place an overbooked item until you grabbed it from the runsheet and dragged it onto the calendar. This release, we made a change so that if an item from an inventory group is placed, it will gray out every slot that is no longer available. This allows you to see what is available and what would be overbooked at a glance, without needing to drag and drop an item.
Second, we also made inventory grouping less restrictive. Previously, any item that was scheduled in the future could not be placed into a new inventory group, to prevent potential overbooking. This functionality was changed so that you can add any active reserved product to an inventory group, whether it's scheduled in the future or not. If you try to add an item to a group that is scheduled in the future, you'll see a confirmation popup, letting you know you could potentially be causing an overbooking by adding the item to the group.
Determine when Service Products are Itemized
There is a new system configuration Trigger event for itemized service products that determines when an itemized line item is broken out into its individual components. The default option 'create itemized line items on creation' is how the system currently works, where as soon as an itemized service item is added to an order, it is broken up into its individual line items (an itemized service with a quantity of 3 will be broken out into 3 individual line items). If you change the configuration to 'create itemized line items on finance approval', the product will be added to the order as a single line item, and won't be broken out into individual line items until the order is fully approved.
We now support inventory management for non-GAM impression items. When an impression item is synced to Google Ad Manager, it will use GAM's inventory management system. But now, you can create inventory on non-GAM impression items. It works very similarly to our inventory system on targeted display media products. When adding or editing an impression product, you'll now see Baseline and Monthly inventory tabs. When clicked on, you can set inventory per publication and channel for every month (baseline) or specific months (monthly).
When adding your impression product to an order, if there is inventory set, you'll get a table showing the available inventory and if it will be oversold.
Unlike targeted display inventory, impression product inventory is set on a monthly basis, but is validated on a daily basis. For example, if you set an inventory of 30,000 for a month with 30 days, that means 1,000 impressions will be available per day.
On the Map Your Show setup page, there is a new option where you can map your line item dynamic attributes to a handful of Map Your Show fields. If mapped, when your line items are brought in from MYS, the values of the MYS fields will show up in the mapped attribute on the line item.
The new Payment tab on the lockbox will bring in any payments from Map Your Show that are Transfer To, Transfer From, or Applied Credit payment types. On each record, you can perform various actions including dismissing the record and removing it from the lockbox, creating credit memos (for Transfer To types), and applying from credit memo or applying from cash account (for Transfer From and Applied Credit types).
There were also a handful of small improvements made, including re-labeling some columns in the lockbox to more accurately reflect what the field does, and adding some new columns. There was also an issue with importing products that just had a description and didn't have a name, which has been fixed.
More Detailed Forecast Naming
This release, we improved the display of forecast items when adding them to orders and proposals.
Print and digital ad items will now include the opportunity name, publication, and size when applicable.
Digital media items will show the opportunity name, the product name, and the publication when applicable.
Service items will show the opportunity and product names.
Other Improvements
A 'Sold Date Range' search filter has been added to the Pre-Paid Orders Report.
A 'Publisher' display field has been added to the General Ledger Journal Report.
The option to Edit Display Fields has been added to each digital media product setup page, as well as the service product setup page. This allows you to choose which fields to show in the table, as well as set defaults such as sort order and the number of results displayed.
When a primary rep on a company is a Limited Access user, if another MagHub user requests to be a rep on the account, both the Limited Access user and the user they report to will receive notifications. Previously, only the Limited Access user would get this notification.
Users now have the ability to sort by the line item headers on their company Orders tab. This means, when you expand an order to view its line items, you can click on any of those headers to sort the line items by that column.
In last month's release, we added the ability to require timesheet notes. This release, we applied the same feature to Vendor Center timesheets.
A new Digital Media endpoint has been added to the API, as well as a GL Class endpoint.
Documentation has been added for the following API endpoints: Get Ad Positions/Channels, Get Media Price, Check Impression Product Inventory, Create Impression Line Item, and Get GL Classes.
You can now add tables to the HTML and Text elements on proposals.
The cost basis for a service item can now be determined on its sub-tasks, if applicable. This means users can define the task level cost and use that cost to compute the product level cost.
A new user permission 'Ignore timesheet notes requirement' has been added. When users have this permission, they will not be required to enter timesheet notes, even if the configuration is turned on.
If there is an XREF tied to an order, when creating a milestone on a project tied to that order, the XREF will now be shown.
'Possible' and 'Matched' columns have been added to the Google Ad Manager Inventory Report this release. This information helps provide insight to the sales rep on how large the impression count was, not just what is currently available.
Slots now show the day of week in front of the date. This applies to the add/edit line item popup, as well as the Slot Inventory Report.
When editing a slot product, any expired frequencies will now be hidden by default. You can choose to view them by clicking 'Show Expired Frequencies'.
Fixes
System emails were being picked up as changes on company records. This has been fixed so only changes manually made by users will be recorded as updates.
An error when searching for system email subtemplates has been fixed.
Tearsheet previews will no longer generate errors.
The maximum height on ticket descriptions has been updated to allow for showing more content.
On the Sales Rep Goal Metrics Report, goals are now being attributed to the correct rep when the report is broken out by Publication Issue.
A bug has been resolved that was occurring in specific circumstances when an invoice had a combination of discounts and surcharges, where the discount amount was being calculated incorrectly.
The 'Category' column header on the Order Display was connected to the 'Media Product' column content. This bug has been resolved, so the two columns are working independently.
When digital media rate cards are required on line items, there was the potential for an issue when pulling in items from AdCellerant. This issue has been resolved, and AdCellerant items will not require a rate card, even if that system configuration is enabled.
The automapping functionality on the Historical Data Tool was case sensitive. This has been changed this release, so the system will auto-map columns like 'First Name' to 'first name'.
The Consolidated Production Report is now correctly including pending sales. Line items on pending orders were only showing up when the 'include proposals' search option was selected. Now, that option will only apply to proposals, and pending items should show up when your probability fields are set to less than 100%.
The AdCellerant setup page is no longer accessible to users, since it is a global setting.
The bug preventing users from being able to approve orders with the 'PDF Upload' signature type option has been fixed.
Warning popups on order approval are now showing correctly. One example is if an order has a prepay requirement and the customer has not completed payment.
Certain order approval errors are now being displayed properly, such as if a user's ability to approve the order is removed.
An error on order PDFs when the order had a package with the 'invoice amounts' column has been fixed.
When the Forecast Summary report is filtered by issue, digital media items will no longer be included in the booked and pending amounts.
When timesheet notes are required, there was a bug preventing users from editing an entry back to 0 hours, which has been resolved. An issue was also fixed where notes were being required on 0 hour entries.
The Product Swapping functionality is now being applied to items in the Reserved Product Scheduler correctly.
On the Review and Send step of creating an order, if a template is not selected, it will be highlighted in red and you will be prevented from continuing until one is chosen.
The Assignment & Notification fields are now saving properly on event products.
The Consolidated Sales and Consolidated Snapshot reports will now show digital media line items when service sales are disabled.
Existing line items that are for disabled service products can now be edited.
When the system configuration to allow agency discounting is turned off, an agency discount will no longer be added to orders after finance approval.
The Ledger Code field in the Multi-Line CSV invoice export has been updated to show the revenue code, rather than the gl class name.
The Order Notes field when creating an order has more formatting options now.