[RFP PG Deals] Import
- Daniel Yañez
- Nicole Jünger
How can the import be started?
On a Connection > Record Type ADMANAGER
We can import via the ‘Transfer to Advendio’ button the RFP contracts that are currently available on the Admanagers platform
Go to the Connection
Click on ‘Transfer to Advendio’
Select: Inventory > Programmatic Direct Deal then import
Run import
Once the import is done, we are going to have a Custom Contract Object associated with a Connection ID
All the RFP Deals can be found this way:
In the App Launcher search for ‘Custom Contracts’
Select the one you like to see more information
Each Custom Contract (RFP Deals) is going to be associated with its unique Connection ID
You can also access to a Custom contract through the Connection ID
Enter the connection ID
Go to related
Under ‘Custom Contracts’ you would find the available RFP’s
What fields of RFP Programmatic Guaranteed content we import and where is located
Imported from GAM | Name in GAM | Name in Advendio | Object in Advendio | SF Object Field | Description | SF Field Type |
|---|---|---|---|---|---|---|
- | - | - | Connection | Record Type ID |
| Recordtype |
Name | Name | Custom Contract | Name |
| String (80) | |
- | - | - | Custom Contract | Connection ID |
|
|
Deal ID | Deal ID | Custom Contract | DealId__c |
| text | |
Advertiser ID | Advertiser ID | Custom Contract | AdvertiserId__c |
| text | |
Budget |
| Custom Contract | Budget__c |
| currency | |
Type | Type | Connection | DealType__c |
| text | |
Inventory Type | Inventory Type | Custom Contract | InventoryType__c |
| text | |
CPM | CPM | Custom Contract | GoalBudget__c |
| currency | |
Impressions | Budget Type | Custom Contract | Total_Impressions__c |
| picklist (255), restricted | |
RFP Start Date | Start Date | Custom Contract | StartDate__c |
| DateTime | |
RFP End Date (If no end date is specified, is open-ended???) | End Date | Custom Contract | EndDate__c |
| DateTime | |
- | Audience | Audience | Custom Contract | Audience__c |
| text |
Country | Country | Custom Contract | BuyerCountry__c |
| text | |
| Additional Terms | Additional Terms | Custom Contract |
|
|
|
| Creative Size | CreativePlaceholders | Custom Contract | CreativeSize__c |
|
|
- | Buyer contacts | Buyer Contacts | Custom Contract | BuyerContacts__c |
| text |
- | Seller contacts | Seller contacts | Custom Contract | BuyerContacts__c |
|
|
- | Salesperson (completed manually) | Salesperson | Custom Contract |
|
|
|
- | Trafficker | Trafficker | Custom Contract |
|
|
|
- | Sales planners (completed manually) | Sales planners | Custom Contract | SalesplannersContacts__c |
|
|
- | Teams | Teams | Custom Contract | TeamsoContacts__c |
|
|
Currency | - | Custom Contract | Currency ISO Code |
|
| |
Message | Message | Custom Contract | Description__c |
|
|
If the fields arrive empty they can be edited later
Automatic creation of Media Campaigns for new deals
To automate the campaign creation from Programmatic Direct deals you can use a flow called “CreateMediaCampaignUponContractCreation” that we can create for you in ADvendio. Please reach out to our support team in case you would like us to add this.
In version 2.173 and up we will provide this flow as a template in our package.
Every time a new Custom Contract is imported and therefore created in ADvendio a Media Campaign will be created with the mappings as shown below.
Mapping table with template flow
Custom Contract field | Media Campaign field |
|
|---|---|---|
Custom Contract name | Media Campaign Name |
|
Start Date | Campaign Start Date | only takes the date, not the time |
End Date | Campaign End Date | only takes the date, not the time |
Record id | Custom Contract lookup | We recommend you to add the Custom Contract lookup field to the Media Campaign layout. If not done yet, please check with your Administrator. |
Advertiser Id | Programmatic Buyer | checks internally for External Account IDs and tries to match the id with the mapped Account |
Budget | Budget |
|
Message | Internal Comment |
|
Currency Code | Currency |
|
You can also do the following adjustments to automate and customize the experience further:
Create a new Media Campaign list view on the Home page which can show the recently created campaigns for Custom Contracts
You can adjust the flow above to do more mappings, set a specific stage, create reminders for the operations teams after a few days passed. For this please note that you have to clone the flow that we delivered.