Import Google Campaign Manager Reports to Platform

Overview

The Import Google Campaign Manager script template allows users to specify a report ID to import a GCM Report to Platform.

You can create your script using this link, or in Platform, navigate to Code → Scripts → More Script Templates and search for "Import Google Campaign Manager Report" or “78619”.  If you are not shared on this template, please contact support@civisanalytics.com.

Parameters

• Google Application Credential (required):  A custom Civis credential with a password that consists of a Google service account JSON definition, username can be anything. Create a new credential here. 
• Database (required): Name of the destination database for imported data.
• Database Credential (required): A valid credential for the database.
• Profile ID: Unique ID of the GCM user profile linked to the service account email address
• Report ID: Unique ID of the report to import. Must be available to the provided user profile.
• Output Table (required): Name of table to store GCM report data. 
• Output Table Setting (required): Drop or append existing rows in output table