I am looking to consolidate data from third-party advertisers like Ads Manager and Google AdWords into Adobe. Is DFA able to help me achieve this? What format does the data have to be in so that Adobe can properly "ingest" the data?
Yes, you can find more details about it here: https://marketing.adobe.com/resources/help/en_US/connectors/dfa/
Also for migrating to Adobe,it would be best if you could reach out to Adobe Account Managers or Consultants. They could make a customized solution to help you migrate fully to Adobe.
When you say about contacting an Account Manager to "get this done", are you referring to the integration steps that are described in the article you linked (link below)?
My reading of that article was that it instructed you how to do the entire integration from start to end independently - is this incorrect?
Marketing Cloud Help
It would be better if you contact your account manager to get this done with customized solutions and also they help you for better approach for migration.
So if I want to see Google AdWords data in Adobe, is that the same as migrating the data to Adobe? I nee to reach out to an Adobe Account Manager to get this done?