Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
150 lines (118 sloc) 7.09 KB
title permalink redirect_from keywords summary layout name display_name singer tap-name repo-url status certified historical frequency tier status-url anchor-scheduling extraction-logs loading-reports table-selection column-selection requirements-list setup-steps replication-sections
Campaign Manager
/integrations/saas/campaign-manager
/integrations/saas/doubleclick-campaign-manager
doubleclick campaign manager, integration, schema, etl doubleclick campaign manager, doubleclick campaign manager etl, doubleclick campaign manager schema
Connection instructions, replication info, and schema details for Stitch's Campaign Manager integration.
singer
campaign-manager
Campaign Manager
true
Campaign Manager
Released
false
1 year
30 minutes
Free
true
true
true
true
false
item
**A Campaign Manager account**. Refer to [Google's website](https://www.google.com/doubleclick/advertisers/){:target="new"} for signup information.
item
**API access.** Most Campaign Manager accounts have this enabled by default. If you're not sure, contact your DoubleClick representative or the [Campaign Manager support team](mailto: dcm-support@google.com).
item
**Access to the reports you want to replicate.** Stitch will only be able to replicate the reports that the user who authorizes the integration has access to.
title anchor content
Verify report access
verify-report-access
Before you connect {{ integration.display_name }} to Stitch, you should verify that you have access to the reports you want to replicate. Stitch will only be able to replicate data for the same reports that you have access to in {{ integration.display_name }}. 1. [Sign into your {{ integration.display_name }} account and navigate to the **Report Builder** page](https://www.google.com/analytics/dfa/){:target="new"}. 2. Under **Reports**, click **My Reports**. 3. A list of all the reports you have access to will display: ![List of reports in {{ integration.display_name }}]({{ site.baseurl }}/images/integrations/doubleclick-campaign-manager-all-reports.png) 4. Verify that the reports you want to replicate are listed on this page.
title anchor content
Locate your {{ integration.display_name }} profile ID
locate-your-profile-id
{%- capture multiple-profiles -%} **Need to connect multiple profiles?** To connect more than one {{ integration.display_name }} profile, you'll need to create additional {{ integration.display_name }} integrations in your Stitch account. {%- endcapture -%} {% include note.html type="single-line" content=multiple-profiles %} {% include layout/inline_image.html type="right" file="integrations/doubleclick-campaign-manager-profile-id.png" max-width="250px" alt="" %} 1. [Sign into your {{ integration.display_name }} account](https://www.google.com/dfa/trafficking){:target="new"}. 2. Click the user menu (your icon) in the top right corner. 3. In the dropdown beneath the **Sign out** button will be a list of the profiles you have access to. 4. Locate the ID of the profile you want to connect. This will be a seven digit number next to the name of the profile. For example: `9999999` An example is highlighted in the image to the right. 5. Copy the profile ID. Keep this handy - you'll need it in the next step.
title content
add integration
4. In the **Profile ID** field, paste the ID of the {{ integration.display_name }} profile from [Step 2](#locate-your-profile-id). This value should be a seven digit number such as `9999999`.
title
replication frequency
title anchor content
Authorize Stitch to access {{ integration.display_name }}
grant-stitch-authorization
1. If you aren't already signed into your Google account, you'll be prompted for your credentials. 2. After you sign in, you'll see a list of the permissions requested by Stitch: - **View and manage DoubleClick for Advertisers reports** - This is required to allow Stitch to view and run reports. **Note**: Stitch will not alter report settings, and will only ever read data. Refer to the [Replication section](#replication) below for more info. 3. To grant access, click the **Allow** button. 4. After you've granted access, you'll be redirected back to Stitch to finish setting up the integration.
title
track data
content subsections
When Stitch replicates data from {{ integration.display_name }}, the process will look like this: 1. Stitch runs the selected report using the report's defined date range and included dimensions and metrics. 2. {{ integration.display_name }} creates a CSV file of the report results. 3. Stitch replicates the results from the CSV. Each run of a report will have its own CSV file in {{ integration.display_name }}, which you can access by [signing into your {{ integration.display_name }} account](https://www.google.com/dfa/trafficking){:target="new"}.
title anchor content
Report date ranges
report-date-ranges
When Stitch replicates data for a given report, it will use the date range currently defined in {{ integration.display_name }} for that report. For example: The image below shows the configuration for a report named `ad_performance_report`, where the date range is set to the last 30 days. When Stitch replicates data for this report, it will run the report using these settings: ![Report date range field highlighted in {{ integration.display_name }}]({{ site.baseurl }}/images/integrations/doubleclick-campaign-manager-report-settings.png)
title anchor content subsections
Data loading and Append-Only Replication
data-loading-append-only
{% include integrations/saas/ads-append-only-replication.html type="data-loading" %}
title anchor content
Query for the latest data
query-for-the-latest-data
{% include integrations/saas/ads-append-only-replication.html type="append-only-query" %}

{% assign integration = page %} {% include misc/data-files.html %}

You can’t perform that action at this time.