What are the SObject Limits Media Campaign

Issue Summary:

1. Custom Relationship Limit Exceeded

• Detail: The Media Campaign SObject from the ADvendio namespace has 24 custom relationships, but Salesforce allows a maximum of 40.

• Impact: A significant number of these relationships are not in use, limiting the creation of new and necessary relationships.

2. Unique Object References Limit Reached

• Detail: The limit for unique object references on Media Campaign is 15. Fields from the ADvendio namespace, such as ADvendio__BuyerCountry__c and ADvendio__SellerCountry__c, are counting towards this limit.

• Impact: Restricts the flexibility in adding new unique object references.

Proposed Solutions:

For Issue 1:

As an ongoing solution, consider the Salesforce's suggestion to increase the limit to 50 fields for objects that might need more relationships. More details can be found in this Salesforce article.

For Issue 2:

1. Implement a checkbox formula field on the Media Campaign SObject to identify the specific fields that impact the unique object references limit.

2. Review the formula used:

   ADvendio__Account__r.Name != 'Acme' && ADvendio__QuotePreference__r.Name != 'Test' && ADvendio__Subscription__r.Name != 'Test' && ADvendio__Contact__r.LastName != 'Hello' && ADvendio__AdvertisedBrand__r.Name != 'Test' && ADvendio__AdvertiserAgencyRelation__r.Name == 'test' && ADvendio__Commitment__r.Name != 'test' && ADvendio__Briefing__r.Name != 'test' && ADvendio__InvoicePreference__r.Name != 'test' && ADvendio__LegalEntity__r.Name != 'test' && ADvendio__ProgrammaticBuyer__r.Name != 'test' && ADvendio__ProgrammaticPartner__r.Name != 'test' && ADvendio__TermsOfPayment__r.Name != 'Test' && ADvendio__SSP__r.Name != 'test' && ADvendio__Pricelist__r.Name != 'test' && ADvendio__PublisherPayoutContract__r.Name != 'test'