Resolving "Data Value Too Large" Error During Inventory Sync with Google Ad Manager

Solution

Follow these steps to resolve the "data value too large" error:

1. Identify the Problematic Value:
   • Locate the Custom Targeting Value Name in Google Ad Manager that exceeds the character limit.
2. Exclude the Entire CustomTargetingKey:
   • Modify the inventorySyncStrategy.json file to exclude the entire CustomTargetingKey associated with the problematic value.
   • Example snippet:

     {
       "customTargetings": {
         "synchronize": true,
         "items": [
           {
             "type": "customTarget",
             "filters": {
               "exclude": [
                 [
                   {
                     "field": "Id",
                     "value": "KeyId"              }
                 ]
               ]
             }
           }
         ]
       }
     }

3. Perform the Inventory Sync:
   • Upload the updated inventorySyncStrategy.json to Salesforce.
   • Initiate the inventory sync process again.
4. Verify Resolution:
   • Confirm that the inventory sync completes successfully without errors.
   • Check that the status changes from "Pending" to "Completed".

Preventive Action: Rename the Custom Targeting Value in Google Ad Manager to ensure it does not exceed the character limit in future syncs.

Note: This solution was specific to a Salesforce platform-related issue, and the customer was advised to make changes in Google Ad Manager to prevent recurrence.