To see the performance trend of ad inventory sold in June over the last five years and use this information for planning campaigns for the next June, a consultant can couple Media Cloud Advertising Sales Management with:

CRM Analytics: This tool provides advanced analytics capabilities within the Salesforce platform, enabling users to gather, analyze, and visualize data for better decision-making.

Tableau: As a powerful data visualization tool, Tableau can be integrated with Salesforce to provide detailed and customizable visualizations of historical ad campaign data, aiding in the analysis and planning process.

These reporting components enable the effective correlation and presentation of historical data, facilitating informed decision-making at the beginning of the sales cycle.

Salesforce CRM Analytics documentation: https://help.salesforce.com/

Tableau and Salesforce integration guide: https://www.tableau.com/salesforce​``oaicite:0``​

When integrating Google Ad Manager (GAM) with an existing middleware system, using a named credential with a custom authentication provider is the most secure and minimally invasive approach. This method enables Salesforce to securely manage authentication credentials, reducing the need for custom code and customizations. The use of named credentials and authentication providers streamlines the integration process, ensuring secure and straightforward access to external systems while adhering to best practices for security and maintainability. Reference: https://developer.salesforce.com/

When modeling and designing the pricing for different advertisement types (Digital, Out-of-Home, Print, or Linear Advertising), two basic ways that the advertisements could be priced are Recurring Charge and One Time Charge. Recurring charges apply to ongoing campaigns or services, while one-time charges are suited for single advertisements or campaigns with a specific start and end date.

Salesforce CPQ Billing documentation: https://help.salesforce.com/articleView?id=cpq_billing.htm

Salesforce Media Cloud Advertising Sales Management Guide: https://www.salesforce.com/products/media-cloud/overview/

In Advertising Sales Management, the correct order of execution for the pre-built Industries Order Management orchestration plan components is: Create Order, Create Line Items, Add Creative, Approve Order, Activate Order (B). This sequence ensures that the foundational elements of an order are established first (the order itself and its line items), followed by the association of creative materials, and finally, the approval and activation of the order for execution. Reference:

https://help.salesforce.com/articleView?id=industries_advertising_order_management.htm

https://www.salesforce.com/products/media-cloud/overview/

Before starting a manual upgrade to the latest ASM release, a consultant must:

Ensure they have the required permission sets and licenses: This is crucial to ensure the consultant has the necessary access rights to perform the upgrade and configure the system as needed.

Complete the post-install tasks for Salesforce Industries Communications, Media, and Energy: These tasks may include configuration adjustments, data migrations, or other necessary steps to ensure that the upgrade is successful and that the system remains stable and functional after the upgrade.

Completing these steps ensures that the upgrade process goes smoothly and that the system is properly prepared for the new release.

Salesforce Industries Upgrade Guide: https://help.salesforce.com/

Salesforce Permission Sets and Licenses documentation: https://developer.salesforce.com/docs/atlas.en-us.securityImplGuide.meta/securityImplGuide/users_profiles_permission_sets.htm