Send Adobe Workfront actual hours updates to an an Anaplan list item

Last update: January 22, 2025

CREATED FOR:

  • User

This integration scenario shares actual hours details captured on an Adobe Workfront project with an Anaplan budget list item. Sharing this information allows you to take better advantage of the spend optimization and financial analysis that Anaplan provides.

This scenario template delivers a list of hours summarized by project, day, and role recorded on active projects over then last 3 months.

IMPORTANT
“Campaign” in this article refers to the marketing campaign use case that this scenario represents, and is in no way connected to the Workfront Fusion Adobe Campaign connector or to the recently deprecated Campaign object in Workfront.

Access requirements

You must have the following access to use the functionality in this article:

Adobe Workfront plan*Pro or higher
Adobe Workfront license*Plan, Work
Adobe Workfront Fusion license**Workfront Fusion for Work Automation and Integration
ProductYour organization must purchase Adobe Workfront Fusion as well as Adobe Workfront to use functionality described in this article.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

**For information on Adobe Workfront Fusion licenses, see Adobe Workfront Fusion licenses.

Triggering Event

This scenario is scheduled to execute every 15 minutes.

Expected Workfront Configuration

You must have the following in Workfront to use this scenario:

  • A user profile in Workfront named Anaplan Integration, that has system administrator rights.

    For information on creating a user in Workfront, see Add users.

Expected Anaplan Configuration

You must have the following in Anaplan to use this scenario:

  • A user profile in Anaplan named Workfront Integration, that has system administrator rights.

  • The Anaplan Model that you want to use for this scenario.

  • The List within the Anaplan Model that you want to use for this scenario.

  • A file in Anaplan named Anaplan Actual Hours Import that contains the following columns, in this order:

    1. Workfront Project GUID

    2. Hours

    3. Hours Estimated Cost

    4. Entry Date

    5. Role Name

    6. Campaign Name

    7. Anaplan List Item ID

    To prepare the Anaplan Actual Expense Report file:

    1. Copy and paste the following into a text editor or Excel

    2. Save the file in a CSV format

    3. Upload the file into Anaplan.

      For instructions, see the Anaplan documentation about importing data into modules from a file.

    4. Make note of the name you gave to the file; it will be used during the deployment of the Fusion scenario template.

    Example CSV contents

    Workfront Project GUID,Hours,Hours Estimated Cost,Entry Date,Role Name,Workfront Project Name,Item ID
6218062a000d0442903fcfa21e11f556,2,0,3/7/22,Designer,New Project 6,202000001030

  • A Project Actual Hours Import process prepared to execute the import of data delivered in a file upload.

For instructions on any of these actions, see the Anaplan documentation.

Deploying to Workfront Fusion

Complete the following steps to deploy this integration scenario to your Fusion account. This should only be done after completing the required Workfront and Anaplan configuration.

  1. Navigate to the Templates menu in Workfront Fusion and click the Send Workfront actual hours updates to Anaplan list item scenario template.

  2. Replace the variable values for the following Anaplan variables:

    Variable nameReplace value with
    Anaplan Workspace IDThe ID of a workspace from your Anaplan account.
    Anaplan Model IDThe ID of a model from your Anaplan account and the selected workspace.
    Campaign List NameThe name of the list from your Anaplan account and the selected workspace & model.
    File Name: Actual Hours Import

    Tthe name of the file that will receive project actual hours data.

    (Example: WorkfrontUpdateLinkedProjects_HoursRoles.csv)

    Process Name: Actual Hours Import

    The name of the process that will execute the import of project hours data.

    (Example: WF Int - Load Project Hours by Role)

    Workfront SubdomainThe subdomain of your Workfront account. This is used to create a link back to your Workfront project in a note that may be generated.

    Details on how to set up the files and processes are provided in the Anaplan setup documentation.

  3. Select or add an Anaplan connection profile.

  4. Update all remaining Anaplan modules with an Anaplan connection, when prompted.

  5. Select or add a Workfront connection profile.

  6. Update all remaining Workfront modules with a Workfront connection, when prompted.

This scenario template is complimented by the following spend optimization scenario templates that may also be deployed:

Additional scenarios for linking budget requests:

Additional scenarios for linking campaign requests:

More help on this topic

Previous pageSend Adobe Workfront expenses to an Anaplan list item
Next pageCreate an Anaplan list item from an Adobe Workfront budget request

Workfront


Learn: Automating Workflows with Workfront Fusion - Unique Use Cases in Action

Workfront

Tuesday, Mar 4, 6:00 PM UTC

Looking for creative ways to use Workfront Fusion to solve business challenges? Join Pan Shahbazian of Starbucks as she shares three unique use cases that can transform your workflows.

Register

The Perfect Blend: A New Era of Collaboration with AEM and Workfront

Adobe Customer Success Webinars

Wednesday, Apr 2, 5:00 PM UTC

Explore how Adobe Experience Manager and Workfront integrate to help teams move from ideation to delivery without the usual bottlenecks, ensuring content is organized, on-brand, and ready to go live faster.

Register

Driving Marketing Agility and Scale: Transforming your Content Supply Chain with AI

Online | Strategy Keynote | General Audience

Marketers everywhere are feeling the pressure to deliver impactful campaigns faster and at greater scale. This Strategy Keynote explores...

Tue, Mar 18, 2:30 PM PDT (9:30 PM UTC)

Register

B2B Reimagined: Transforming Go-to-Market Strategies for Profitable Growth

Online | Strategy Keynote | General Audience

B2B brands are facing a digital revolution. Buyers expect hyper-relevant content and self-service, while internally AI is transforming...

Wed, Mar 19, 1:00 PM PDT (8:00 PM UTC)

Register

Connect with Experience League at Summit!

Get front-row access to top sessions, hands-on activities, and networking—wherever you are!

Learn more

Register now

Register to learn something new

WORKFRONT

Join Adobe product experts in live events where you will learn Adobe Workfront best practices, tips and tricks, and hear about the latest product features and updates.

Register