How to Run and Review the Renewal Report

Running the renewal report allows you to identify clients whose contracts are ending soon, enabling you to proactively engage with them about renewal options. Reviewing this report helps you stay on top of potential renewals, maintain stable magazine revenue, and demonstrate the value of continued partnership to clients.

Go to the "Reporting" section on the left-hand sidebar in ARC.
Select the "Renewals" report.
Choose your magazine from the "Name" dropdown menu.
Set the renewal month and year to view contracts ending in that period.
1. The renewal month you select is the first month after the original contract ends, when there will be no ad in the publication unless the client renews.
Click "Display" to generate the list of accounts up for renewal in that period.
Click the Excel icon to export the report as a spreadsheet for easy reference in client meetings.

Key Elements in the Report:

Account Name: This is the client’s name. The report in ARC links to their account for quick access.
Manager: The publisher or account manager responsible for the client's agreement. This helps identify the team member who initially secured the partnership and can handle the renewal.
Placements: Notes on the ad placements specified by the publisher, indicating where the ads should appear in the magazine layout (e.g., "Back Cover," "Full Premium Page").
Renewal Month: The first month after the contract ends when the client does not have an active agreement or ad in the issue.
Last Contract Term: The length of the client’s most recent contract (e.g., 36 months, 1 month).
Last Contract Value: The total value of the previous contract, showing the revenue generated by that client’s agreement.
Monthly Value: The average monthly revenue generated by the client’s ads, helpful for assessing the financial impact of a potential renewal.
Total: At the bottom of the report you will see a combined total contract value and monthly value for the agreements up for renewal.

How to Run and Review the Renewal Report

This guide will walk you through running and reviewing the Renewal Report in ARC.

Go to citylifestylehq.com

1. Running & Reviewing the Renewal Report

2. Click "Reporting"

In ARC click on the Reporting tab on the left hand side.

3. Select Renewals Report

Select the Renewals report from the drop down menu as well as the magazine and month you would like to run the report for. This is the first month after the original contract ends, when there will be no ad in the publication unless the client renews. Click Display to generate the report.

4. Click here

Here you will see a list of accounts that are ready for renewal for that month. Click the Excel icon to download the report for easy reference in client meetings.

5. Understanding the Renewal Report

Reviewing the report you will see the account name, the publisher or account manager responsible for the agreement to help identify who originally secured the partnership, any placement notes specified by the publisher, indicating where the ads should appear in the magazine layout. The first month after their contract ends for renewal, the length of the most recent contract and it's total value as well as the average monthly revenue generated by the client’s ads. This is helpful for assessing the financial impact of a potential renewal.

6. Total Value

At the bottom of the report you will see the combined total contract value and combined total monthly value for the agreements up for renewal that month.

This guide covered running and reviewing the Renewal Report in ARC.