How to Track Approvals and Rejections in Ads Reporting
Updated
Advertising Approval frameworks are important to avert any exposure to risk for brands across communication cycles. Hence, tracking the volume of approvals and rejections becomes an important KPI metric to understand agency performance and efficiency around governance.
In Sprinklr, internal teams and brands can leverage the Value Realization Dashboard (PBUC 16b, c, d, and e) and Ads Reporting respectively to have a line of sight into approval workflows coupled with better transparency around governance KPIs such as approval and rejection rates, approval SLAs, and teams involved in approvals. This will help measure and realize the value of strong approval frameworks.
For example, brands can create reports of approval volume by user/region as well as track both approvals and rejections for campaigns submitted by their agency.
Enablement Note:
To learn more about getting this capability enabled in your environment, please work with your Success Manager.
Standard Dashboard
You can assess the overall approvals and rejections of ad entities and creatives from a standard Ads Approval and Rejections Dashboard. To navigate to the standard dashboard,
Navigate to Ads Reporting, under the Sprinklr Marketing - Advertising tab.
From the Dashboard Switcher in the top-left corner, select Ads Approval and Rejections Dashboard under Standard Dashboards.
In the sub-group, select Ads Approval and Rejections Dashboard.
The dashboard is segregated into the following sections to efficiently monitor approvals and rejections and provide faster time to insights:
|
|
Custom Dashboard
Using the following metrics and dimensions in Ads Reporting, brands can build dashboards to track approvals and rejections based on different performance indices.
Note:
If an ad entity is sent for approval through a tiered approval path, then:
Approvals through multiple tiers will be counted as 1 under Volume of Approvals
Approval status at the latest stage of the approval path is considered as final. For example, if a campaign was approved at stage 1 and rejected at stage 2, then the campaign is considered to be rejected.
Approval will be attributed to the user who was last involved in approving/rejecting the campaign in the approval path.
Metrics
Metrics | Description | Compatible Dimensions | ||||||||
Volume of Approvals | Volume of Approvals for entities out of the entity sent for approval |
| ||||||||
Volume of Rejections | Volume of Rejections for entities out of the entities sent for approval | |||||||||
Volume of Entities Submitted for Approval | Volume of entities sent for approval |
| ||||||||
Volume of Ad Posts | Volume of Ad Posts published with breakdown of Ad Post | |||||||||
Volume of Ad Variants | Volume of Ad Variants published with breakdown of Ad Variant | |||||||||
Volume of Ad Sets | Volume of Ad Variants published with breakdown of Ad Variant | |||||||||
Volume of Paid Inititatives | Volume of Ad Variants published with breakdown of Ad Variant | |||||||||
Approval Rate | Volume of Approvals for entities out of the entities sent for approval / Volume of entities sent for approval Example Scenario:
The approval rate is calculated as:
| |||||||||
Rejection Rate | Volume of Rejections for entities out of the entities sent for approval / Volume of entities sent for approval | |||||||||
Average Time Taken for Approval for (Days) | Total Time taken to Approve Campaigns after being sent for approval / Volume of Campaigns approved Based on the above Example Scenario, the average approval time per campaign is calculated as:
|
Dimensions Breakdown
Level | Dimensions | |||||
Paid Initiative and related Dimensions |
| |||||
Ad Set and related Dimensions |
| |||||
Ad Variant and related Dimensions |
| |||||
Ad Post and related Dimensions |
| |||||
Approval Entity Dimensions |
|
Track Approvals in Value Realization Dashboard (VRD)
Brands can leverage the Value Realization Dashboard (PBUC 16) to quantify the value of Sprinklr approvals with new adoption measures and value indices.
Terms | Calculations | Additional Details |
PBUC 16b - Campaign Approval |
Adoption |
Campaigns sent for Approval in Sprinklr | Campaigns Involved in Approval Queues ÷ Created Campaigns | — | |||||||||
Campaigns Approval Rate | Volume of Campaign Approvals ÷ Campaigns involved in Approval Queues | Campaigns involved in Approval queues during the selected time range are considered. Example:
Approval Rate is calculated as:
| |||||||||
Campaigns Rejection Rate | Volume of Campaign Rejections ÷ Campaigns involved in Approval Queues | Campaigns involved in Approval queues during the selected time range are considered. | |||||||||
Average Approval Time per Campaign (Days) | Total Time taken to Approve Campaigns ÷ Volume of Campaign Approvals | Campaigns that were approved during the selected time range are considered. Total time taken to approve Campaigns is calculated as the time difference between when it was sent for approval until it was approved. Note that the Campaign could have been rejected one or more times before being approved, and this time is also taken into consideration. |
Users involved in Approving/Rejecting Campaigns | — |
Users involved in Submitting Campaigns for Approval | — |
Value Realization |
Revenue Opportunity | Campaigns Approved x Minutes taken to Approve Campaign without Sprinklr - Average Approval time per Campaign ÷ Minutes Per Work Day = Work Days Saved x Average Annual User Salary | — |
Opportunity Cost | Volume of Campaigns Rejected x Average Lifetime Budget allocated across these Campaigns x (Number of Days taken to detect unauthorized campaigns published ÷ Average Duration of Campaign flight) | Campaigns that were rejected during the selected time range, but later went live during the selected time range or in the future are considered. While calculating the Average duration of Campaign Flight; for the campaigns that have not been set with an end date, the end date will be considered as the date when the campaign ended or the present day, depending on whether the campaign is completed or still live. |
PBUC 16c - Ad Set Approval |
Adoption |
Ad Sets sent for Approval in Sprinklr | Ad Sets involved in Approval Queues ÷ Created Ad Sets | — | |||||||||
Ad Sets Approval Rate | Volume of Ad Set Approvals ÷ Ad Sets involved in Approval Queues | Ad Sets involved in Approval queues during the selected time range are considered. Example:
Approval Rate is calculated as:
| |||||||||
Ad Sets Rejection Rate | Volume of Ad Set Rejections ÷ Ad Sets involved in Approval Queues | Ad Sets involved in Approval queues during the selected time range are considered. | |||||||||
Average Approval Time per Ad Set (Days) | Total Time taken to Approve Ad Sets ÷ Volume of Ad Set Approvals | Ad Sets that were approved during the selected time range are considered. Total time taken to approve Ad Sets is calculated as the time difference between when it was sent for approval until it was approved. Note that the Ad Set could have been rejected one or more times before being approved, and this time is also taken into consideration. |
Users involved in Approving/Rejecting Ad Sets | — |
Users involved in Submitting Ad Sets for Approval | — |
Value Realization |
Revenue Opportunity | Ad Sets Approved x Minutes taken to Approve Ad Set without Sprinklr - Average Approval time per Ad Set ÷ Minutes per Work Day = Work Days Saved x Average Annual User Salary | — |
PBUC 16d - Ad Approval |
Adoption |
Ads sent for Approval in Sprinklr | Ad Sets involved in Approval Queues ÷ Created Ad Sets | — | |||||||||
Ads Approval Rate | Volume of Ad Set Approvals ÷ Ad Sets involved in Approval Queues | Ads involved in Approval queues during the selected time range are considered. Example:
Approval Rate is calculated as:
| |||||||||
Ads Rejection Rate | Volume of Ad Set Rejections ÷ Ad Sets involved in Approval Queues | Ads involved in Approval queues during the selected time range are considered. | |||||||||
Average Approval Time per Ad (Days) | Total Time taken to Approve Ad Sets ÷ Volume of Ad Set Approvals | Ads that were approved during the selected time range are considered. Total time taken to approve Ads is calculated as the time difference between when it was sent for approval until it was approved. Note that the Ad could have been rejected one or more times before being approved, and this time is also taken into consideration. |
Users involved in Approving/Rejecting Ads | — |
Users involved in Submitting Ads for Approval | — |
Value Realization |
Revenue Opportunity | Ads Approved x Minutes taken to Approve Ad without Sprinklr - Average Approval time per Ad ÷ Minutes per Work Day = Work Days Saved x Average Annual User Salary | — |
PBUC 16e - Ad Post Approval |
Adoption |
Ad Posts sent for Approval in Sprinklr | Ad Posts involved in Approval Queues ÷ Created Ad Posts | — | |||||||||
Ad Post Approval Rate | Volume of Ad Post Approvals ÷ Ad Post involved in Approval Queues | Ad Posts involved in Approval queues during the selected time range are considered. Example:
Approval Rate is calculated as:
| |||||||||
Ad Post Rejection Rate | Volume of Ad Post Rejections ÷ Ad Post involved in Approval Queues | Ad Posts involved in Approval queues during the selected time range are considered. | |||||||||
Average Approval Time per Ad Post (Days) | Total Time taken to Approve Ad Post ÷ Volume of Ad Post Approvals | Ad Posts that were approved during the selected time range are considered. Total time taken to approve Ad Posts is calculated as the time difference between when it was sent for approval until it was approved. Note that the Ad Post could have been rejected one or more times before being approved, and this time is also taken into consideration. |
Users involved in Approving/Rejecting Ad Posts | — |
Users involved in Submitting Ad Posts for Approval | — |
Value Realization |
Revenue Opportunity | Ad Posts Approved x Minutes taken to Approve Ad Post without Sprinklr - Average Approval time per Ad Post ÷ Minutes per Work Day = Work Days Saved x Average Annual User Salary | — |