Creative Approval Billing Submission Form (Updated 9.29.21)

Please provide the Lightbox Usage (in GB).

You can pull this report by going to Standard Reports --> Lightbox Report (Applicable for Wayback, and Kona)

Please provide the Number of users with 'Creator' permission

You can pull this report by going to Standard Reports --> <Client Name> User Report - By Login --> Count the number of 'Yes' in Column called 'Creative Creator' for Kona and 'Creative Project Manager' for Farm Bureau. These will be billed at $50/creative user. Only Add active users.

Please provide the Number of users with Creative Approval permissions.

You can pull this report by going to Standard Reports --> <Client Name> 'Creative Production Users' --> Count the number of 'Yes' in Column called 'CreativeAdmin' or 'CreativeCreator'. Matt will bill these at $50/user. **Per Kandi on 07.27.18, we bill BBAC for any user that has access to CA (not just those that are creators.)

Please provide the Number of Contacts included in a single Newsletter Send for Kona

Pull the 'External Report' from Portal Manager --> Email Newsletter Report --> External Report. Pull a report for a Kona email. Total the quantity in the 'sent' column. Then, separately, pull a report for a Toms email. Total the quantity in the 'sent' column. Add the Kona sent quantity to the Toms sent quantity. If the quantity is not over 260k, please escalate to Samantha before submitting.
If over 260k, we need to bill $60/month for each additional block of 10k emails. For example, if the total is 273,000, we would be an additional $120 that month.

Please provide the Number of Contacts included in a single Newsletter Send for WesBanco

Pull the 'External Report' from Portal Manager --> Email Newsletter Report --> External Report. Total the quantity in the 'sent' column. If over 15,000, please escalate to Roni or Liz S as we will need to increase our monthly fee.

Please upload a Creative Approvals Billing Spreadsheet of all Custom Requests billed for this month for HSFC only.

The spreadsheet should contain the total hours spent on each request.

Please upload a spreadsheet of Custom Requests due to be paid by HLC corp here.

In additoin, any custom requests that HLC approves for corporate to absorb should be added to this spreadsheet as well. DO NOT INCLUDE THESE CUSTOM REQUESTS IN THE CREATIVE APPROVALS UPLOAD BELOW.

***For STIHL only: Did you submit the CA form to Jenn Bass first so she can add additional information before you submit it on here.

Yes

Were there any Creative Approval entries for the month?

Below are instructions to run the report:
1. Log into Client Side
2. Go to Creative Production
3. Click 'Menu' --> 'Dashboards'
4. Uncheck 'Custom Requests'
5. Change your billing period to be day one of the month you're billing for through the last day of the month (i.e. 3/1/18 - 3/31/18)
6. Uncheck 'Show Only My Projects'
7. Click 'Show Project Billing'
8. Click 'Export XLS'