[Import] Targeting and mapping

Owned by Daniel Yañez
Last updated: 2024-12-03
3 min read

Available with Version

2.173 and up

Available with Version

2.173 and up

Role

System Administrator

External Systems

Criteo Commerce Max

How can the import be started?

  • On a Connection > Record Type CRITEODSP

  • We can import via the ‘Transfer to Advendio’ button some of the necessary features needed for targeting and configuration.

    • Go to the Connection

    • Click on ‘Transfer to Advendio’

    • Select one of the available ones defined in the table

    • Run import

      • Schedule transfer can also be used

        image-20241127-121850.png

  • Once the import is done, we are going to have Connection IDs for each import


Import supported

Category

Type

Comments

Category

Type

Comments

Account

Advertiser

 

Account

Retailer

 

Inventory

Balance

 

Inventory

Products

 

 

What we import for the ‘Advertiser’

 

Criteo Field

Advendio Field

Advendio Name

Criteo Field

Advendio Field

Advendio Name

id

ADvendio__Id__c

ID

name

Name

Name

parentAccountLabel

ADvendio__PartnerId__c

Partner/Buyer Id

companyName

ADvendio__AdServer_Name__c

Technical Name

 

What we import for the ‘Retailer’

Criteo Field

Advendio Field

Advendio Name

Comments

Criteo Field

Advendio Field

Advendio Name

Comments

id

ADvendio__Id__c

ID

 

name

Name

Name

 

parentAccountLabel

ADvendio__Parent_AdServer_ID__c

Parent ID

  • Here goes the Advertiser Connection ID

 

What we import for ‘Product’

Criteo Field

Advendio Field

Advendio Name

Comments

Criteo Field

Advendio Field

Advendio Name

Comments

id

ADvendio__Id__c

ID

 

id

ADvendio__ExtendedId__c

Extended ID

 

name

Name

Name

 

brandName

ADvendio__AdServer_Name__c

Technical Name

  • Brand + Name, separated by '-' only if the brand is not present in the name of the product in the catalog

retailerId

Advendio__Parent_AdServer_ID__c

Parent ID

  • Here goes the Retailer Connection ID

  • Added automatically in the import

-

ADvendio__UniqueKey__c

UniqueKey

  • It is constructed as:
    Connection NAME|Type|ID|

isInStock

ADvendio__Active__c

Active

 

gtin

ADvendio__PartnerId__c

Partner/Buyer Id

  • This is any type of Barcode

imageUrl

ADvendio__Url__c

URL***

  • Tu use the URL to load/display the image you need to enable the domain in SF setup → Trusted URLs → New trusted URL

Targeting Product

  • only available at a Buying Item Level

  • Will display only products associated with the Retailer of the Buying Item

  • One or more can be selected

  • On the search bar, you can search multiple UPC codes separated by ', '

 

What we import for ‘Balance’

Criteo Field

Advendio Field

Advendio Name

Comments

Criteo Field

Advendio Field

Advendio Name

Comments

id

ADvendio__Id__c

ID

 

name

Name

Name

 

poNumber

ADvendio__PartnerId__c

Partner/Buyer Id

 

name

 

ADvendio__AdServer_Name__c

Technical Name

 

spendType

ADvendio__SpendType__c

Spend Type

  • onsite

  • offsite

balanceType

ADvendio__BalanceType__c

Balance Type

  • capped

  • uncapped

  • Works together with the deposited field

  • If its “capped” we need to have a value in deposited field

deposited

ADvendio__TotalBudget__c

Total Budget

  • If a value is used, the Balance Type needs to be “capped”

  • If there is no value it is “null”

startDate

ADvendio__StartDate__c

Start Date

  • Balance start date in the account timeZone if not set

endDate

ADvendio__EndDate__c

End Date

  • Balance end date in the account timeZone

  • If no date is set will run indefinitely

memo

ADvendio__Description__c

Description

 

Account

ADvendio__Parent_AdServer_ID__c

Parent ID

 

status

ADvendio__Status__c

Status

  • Active

  • Scheduled

  • Ended

Targeting Balance

  • only available at a Buying Order level

  • One or more are accepted

  • Only Active/valid ones can be selected

 

Mapping required

We need to map the certain connection ID to an account before using it properly

  • These are the ones that need mapping:

    • Advertisers

    • Retailers


  • First, we create an Account.

    image-20241127-235312.png

  • Open your new Advertisers Account and go to the related list, search for ‘External Account IDs’. Click the new button, to create a new relation. (Your Admin might need to set this up in your Salesforce Account Page Layout)

  • Select the Connection ID that you want to connect to your Account in the lookup field.

  • Add the ID of the connection in the ID field

  • Select the ‘Active’ checkbox

  • Repeat this step for each desired assignment.