Hi there,
1) Make sure that your campaign parameter is unique for each Ad within AdWords. The best way to achieve this is to use ValueTrack dynamic parameter {creative} - https://support.google.com/adwords/answer/6305529?hl=en
2) Pull daily data via API using Ad Performance Report Ad Performance Report | AdWords API | Google Developers
- Field CreativeFinalUrls is very important - you need to extract campaign parameter from this and replace {creative} placeholder with the actual ID
3) Import Impressions, Clicks and Costs using Adobe Data Sources FTP.. campaign parameter eVar is Key
- you can import all Ads even if there was no click-through (only impressions).. Adobe will create the eVar value for that day
4) Import AdWords dimensions (whatever you want) as SAINT Classification via FTP to the same eVar
This is the simple description of the process. I will create a blog post about it in the future.
- Roman