This integration scenario shares progress, status, and key schedule details from 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.
“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.
You must have the following access to use the functionality in this article:
|Adobe Workfront plan*||
Pro or higher
|Adobe Workfront license*||
|Adobe Workfront Fusion license**||
Workfront Fusion for Work Automation and Integration
|Product||Your 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
This scenario is scheduled to execute every 15 minutes.
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.
A Campaign Brief custom form attached to the project object to store custom data values you elect to send to Anaplan.
The following fields represent examples of fields that may be included on the custom form to aid in data mapping to Anaplan, but they are not required for this integration scenario:
|Field Name||Field Type|
|In Market Start Date||Date|
|In Market End Date||Date|
|Campaign Overview||Paragraph Text Field|
|Key Message||Paragraph Text Field|
Include options that fit your processes.
For information on creating custom forms, see Create or edit a custom form
You must have the following in Anaplan to use this scenario:
Workfront Project GUID
Planned Start Date
Planned Completion Date
Planned Expense Cost
Actual Labor Cost
Planned Labor Cost
To prepare the Anaplan Planned Expense Import file:
Copy and paste the following into a text editor or Excel
Save the file in a CSV format
Upload the file into Anaplan.
For instructions, see the Anaplan documentation about importing data into modules from a file.
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
Optional columns may include:
"itemID","Workfront Project GUID","Campaign Name","Percent Complete","Planned Start Date","Planned Completion Date","Planned Hours","Planned Cost","Planned Expense Cost","Actual Labor Cost","Planned Labor Cost","Status","Campaign Overview","Key Message","In Market Start Date","In Market End Date","Target Audience"
"202000001019","6182bc1f0025e184b2c00d9205e22c49","Launch Be U APAC Styles Catalog","0","2022-03-31","2022-05-31","88.25","0","0","0","0","Planning","","","","",""
In Market Start Date
In Market End Date
Also include any other fields you wish to set in the mapping.
For instructions on any of these actions, see the Anaplan documentation.
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.
Navigate to the Templates menu in Workfront Fusion and click the Send Workfront project updates to Anaplan list item scenario template.
Replace the variable values for the following Anaplan variables:
|Variable name||Replace value with|
|Anaplan Workspace ID||The ID of a workspace from your Anaplan account.|
|Anaplan Model ID||The ID of a model from your Anaplan account and the selected workspace.|
|Campaign List Name||The name of the list from your Anaplan account and the selected workspace & model.|
|File Name: Project Update Import||The name of the file that will receive project update data.
|Process Name: Project Update Import||
The name of the process that will execute the import of project data.
(Example: WF Int - Update Campaign Details)
|Workfront Subdomain||The 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.
Select or add an Anaplan connection profile.
Update all remaining Anaplan modules with an Anaplan connection, when prompted.
Select or add a Workfront connection profile.
The filter is configured to pull in all incomplete linked project and those projects that were completed in the last 29 minutes. If you change the frequency of the Fusion scenario you will want to update this value once the scenario template has been deployed.
On the Build Projects Update CSV module, add a new data structure to map the project attributes to CSV columns.
"Workfront Project GUID":"text",
"Percent Complete": 10.01,
"Planned Start Date":"2022-02-22",
"Planned Completion Date":"2022-02-22",
"Planned Hours": 12.5,
"Planned Cost": 123.45,
"Planned Expense Cost": 123.45,
"Planned Labor Cost": 123.45,
"In Market Start Date":"2022-02-22",
"In Market End Date":"2022-02-22",
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: