Google AdWords and the Power of SQL Server Integration Services (SSIS)
Do you advertise on Google using the AdWords platform? Do you have a need to download metrics data generated by AdWords campaigns into your enterprise data environment? Importing reporting data from Google AdWords into a database involves some manual steps, and if you do this frequently, the cost in the form of people’s time and effort may be significant. I recently automated this procedure for a client; leveraging the flexibility of SQL Server Integration Services and earned gratitude and smiles from some financial business analysts in the process.