Version | 2.1 and up |
|---|---|
External Systems | Google Ad Manager, Xandr, Freewheel, Adswizz, Equativ, Google Display & Video 360 |
Role | Order Manager - Fulfilment; System Administrator |
|---|
Challenge
When automatic delivery data updates from external systems to ADvendio are scheduled, are a couple of questions might come up to the fulfilment team:
...
Some of the most common error cases here is:
Error message | Reason |
|---|---|
UNABLE_TO_LOCK_ROW : unable to obtain exclusive access to this record | Salesforce was not able to edit the record as somebody else or some other process was performing changes at the same time. In most cases, during a second run of the delivery reports this error should disappear. |
INVALID_FIELD:Foreign key external ID: XXX|YYY|ZZZ not found for field ADvendio__UniqueKey__c in entity ADvendio__AdServer_ID__c:-- | When using Sitebased Delivery Data or Enhanced Delivery Data, ADvendio needs connection ID records of the sites, key values, devices or other entities it uses to break down the delivery data. If those records do not exist in your org, the following error message appears. Please try to start the import for Inventory, Audiences or Devices again and see if the delivery report works, after your data has been updated. |
Salesforce Error FIELD_CUSTOM_VALIDATION_EXCEPTION | There is a custom validation rule which blocks the records from being created or updated, please validate your validation rules. The following objects get updated during a delivery data import: Campaign Item, Revenue Schedule, Revenue Schedule Daily, Delivery Data, Enhanced Delivery Data, Buying Item, Buy Data. |
No such file | This is often connected to Freewheel. As you will need to configure the reports to be stored on the Freewheel sftp, before ADvendio can access them, this error means that the expected files were not found on the Freewheel sftp. |
No campaign items found for "getting delivery report.". (Message key: ERROR_CAMPAIGN_ITEM_NO_FOUND ) OR No campaign items found for the AdServer Connection | There were no Campaign Items found which could be used for the ADvendio delivery import. Please note that Campaign Items will only be considered if they are still running or the end date is less than 30 days in the past. |
General Failure Email
| Info |
|---|
Available with version 2.137 and up |
...
Here is also a list of common status codes and their meaning
Status Code | Reason |
|---|---|
404 | The Gateway could not be accessed / found. There might be a general down of the ADvendio Gateway. If for some reason, the Service Version settings were changed, make sure those changes are reverted or still correct, as this error also appears, if the Gateway Version used is not existing anymore. |
504 | Temporary communication problem, please try the report again. |
...
Setup
Besides entering the email addresses in the delivery report settings, there is nothing which needs to be done to enable this feature.
...