2.1.4.5 How ADvendio matches your Salesforce Accounts with Advertisers, Agencies or Buyers in an external System?
Version | Version 2.107 and up |
---|---|
Supported AdServers | Google Ad Manager, AdsWizz, Xandr (Monetize & Invest), FreeWheel, Equativ, Google Display&Video 360, Triton, AdButler |
- 1 Challenge:
- 2 Solution:
- 2.1 Understanding Media Campaign Fields for External System Submission
- 2.2 How External Account IDs are Created when Submitting Media Campaigns?
- 2.3 What if ADvendio can't find a matching advertiser?
- 2.4 Limitation: Unable to Link One ADvendio Account to Multiple IDs from the Same System
- 2.5 Can I change Advertisers mid campaign?
- 2.6 How to use External Account IDs for other integrations?
- 2.7 How are advertiser IDs mapped when importing Programmatic Revenue Data?
- 3 Setup:
Challenge:
When working with external systems like AdServers, SSPs or DSPs, and especially when creating orders and line items, there needs to be an advertiser and in some cases also an agency or a buyer set. For this, each system has its own set of advertiser data, with names, IDs and maybe some additional information. Once Media Campaigns are created in ADvendio, they are assigned to the Account data from ADvendio. Now if they will be submitted to the external system, ideally there should be a mapping, deciding which accounts from ADvendio are equal to which advertisers, agencies or buyers in the external system.
How does ADvendio match those and how is this information stored in ADvendio? Which steps does a user need to take to create or modify this mapping and how can he make sure the information is consistent across multiple systems?
Solution:
ADvendio tracks how the Accounts in Salesforce are connected through what we call External Account IDs. When browsing the record details of an Account you can find a related list for the External Account IDs:
There you can see, which system is involved, how the ID in that system is and if a direct integration from ADvendio is used, which connection is involved. These ID records can also be used when tracking IDs for systems not directly integrated via ADvendio Connect, such as your finance systems or ERP systems.
Understanding Media Campaign Fields for External System Submission
The table below provides guidance on which Media Campaign fields to use for different types of advertisers when submitting to an external system:
Media Campaign Field | Usage by Advertiser Type: | Supported for following Integrations: |
---|---|---|
Account | Will be used as advertiser when pushing an order to a external booking system | All Integrations |
Agency | Will be used as an Agency | Google Ad Manager(GAM); Equativ; FreeWheel |
Programmatic Buyer | Will be used as Programmatic Buyer, required for programmatic guaranteed bookings | Google Ad Manager(GAM) |
How External Account IDs are Created when Submitting Media Campaigns?
When using the submit feature of ADvendio to directly push your Media Campaigns and Campaign Items to a connected system like an AdServer, SSP or DSP, ADvendio tries to match the data automatically. That means our Gateway looks at the Account name given in Salesforce and will search in the connected system for an advertiser with the same name as your Salesforce Account. If we can find a match, ADvendio will automatically connect those two and create the needed External Account ID records. There are no further steps needed.
What if ADvendio can't find a matching advertiser?
Should it be the case, that ADvendio can't find a matching advertiser, agency or buyer with the same name, we will proceed to automatically create a new one in the connected System. This allows you to flexibly create new Advertisers on the spot, once you create Media Campaigns in ADvendio without having to manually keep track of the data in the connected system. Again everything is happening fully automatically, without having to do any additional steps.
If there is a different spelling used for the Salesforce Account than in the external system, ADvendio will create a new advertiser in the external system, which might lead to duplicate data. If uncertain, we recommend to watch the account matching during testing phase of your implementation or to manually prepare a mapping as described here:
Setting custom names, when creating new Advertisers in Third Party Platforms
Creating new Advertisers during a Submit from ADvendio is currently only supported for Xandr, Google AdManager, Adswizz, Triton, Freewheel, AdButler & Broadsign
Usually, when ADvendio pushes new Advertisers to booking systems, we take the data we get from the Account record. You are able to define a custom name for the Advertiser, if it is created in booking systems. This allows you to take a different Naming for your CRM data vs. what is used for Advertisers in an AdServer.
To do so, simply fill the field ‘Advertiser Name’ on your Account record of the desired advertiser.
Limitation: Unable to Link One ADvendio Account to Multiple IDs from the Same System
It is not possible to link a single ADvendio account to multiple IDs from the same system. For instance, it is not possible to have one ADvendio account to represent two different Advertisers in Google and then select which one to use each time.
Can I change Advertisers mid campaign?
ADvendio does not automatically validate which advertiser / account you’ve chosen for your Media Campaign and allows you to change it, even if a Campaign has already started.
Please note that some Third Party Platforms do not allow to change the Advertiser of an already existing order. For systems, where such a change is allowed, we are updating the information via our Submit to AdServer for others we might not update all information.
Starting with ADvendio Winter 2025 (2.173): We added a new logic for our Xandr and Adswizz Integrations, that still allows you to push updates from your Media Campaign, after the advertiser was changed. We will not update the Advertiser information in the external platforms, but there will be an information message, showing you the situation:
Info: The Advertiser (Name: World Sports Federation) assigned in ADvendio is not matching the advertiser (Name: Test Advertiser, ID: 1758437) used in the Third Party Platform. Please note that ADvendio does not update Advertisers of Orders in external platforms automatically. Order and Items settings are still being updated.
How to use External Account IDs for other integrations?
When using custom-created interfaces to external systems, the External Account IDs can still be used as a single point of truth to store all relevant IDs for a Salesforce Account. To align between several systems you need to store the unique identities for each account and each system. In this case, you might need to create that ID information yourself which can be done manually or via a created table which is later uploaded to Salesforce.
To create a new record navigate to the App Launcher and type External Account ID. Click on New to create a new record.
Fill out the following fields:
External System
ID
Account Lookup
Legal Entity (if used)
Transaction Type (used by 6.5.1 Accounting Rules and 6.7 Publisher Payout)
Description (optional)
And hit Save.
How are advertiser IDs mapped when importing Programmatic Revenue Data?
While External Account IDs are the place to map Salesforce Accounts to external systems for nearly all processes, there is a slight difference for our Programmatic Revenue Import features. There will be a separate entity for mapping the data. To know more look at the following wiki section: 7.7.8.3 How to connect and match the data from SSPs / DSPs / Exchanges to your Salesforce Data
Example: Create External Account ID
Version 2.107 and up
Important Note: our integrations use External Account ID object throughout all processes instead of AdServer Advertiser ID.
You can follow 2.1.4.2.1 Adserver Advertiser ID Converter to migrate to the new object.
Before doing this make sure to 3.5.5.6 Import Accounts from your AdServer.
Create a new record (see above) and fill out the following fields:
Setup:
There is no specific setup needed to enable this feature.
If you can't find the External Account ID list while looking at Account details please make sure that the user profile has the needed permissions to the External Account ID object and that the related list is part of your Account page layout.
There is currently no way to turn off or configure the matching of advertisers while submitting Campaign Items or Buying Items, if no match can be found by ADvendio, we will always try to create a new advertiser in the connected systems.