Skip to main content
Feedback

DoubleClick Campaign Manager walkthrough

info

DoubleClick API version 4 is currently supported.

DoubleClick source in Data Integration can be executed in the following options:

  • Creating a new report.

  • Running an existing report.

Creating a new report

General inputs in all DoubleClick reports

Procedure

  1. Select create a new report.

  2. In the Profile field (mandatory), select a profile from the list of available profiles.

  3. Enable Keep report to save the report in DoubleClick Reporting. If selected, the report is saved and available in DoubleClick Reporting.

  4. Enter the report name. If left empty, a default name will be used.

  5. Select the Time period the report.

    You can select to run for a specific date range or a customized time period (like the last 7 days or month to date).

    • Selected date range: Enter a start and end date.

    • Last days back: Specifies running the report for the given number of days before the start date.

  6. Select the Interval chunks size to split the API run into multiple requests based on the selected interval.

    • For example, if the time range is one month and the interval is weekly, the API sends four separate requests, one for each week. Use this option while working with large amounts of data.
warning

In case of pulling a column of date, running the API in intervals returns duplicated results.

After you run the river for the first time and enable Keep report, the report is saved in the DoubleClick Reporting system with the same configuration. If you schedule the river to run hourly or daily, turn off Keep report to avoid creating multiple saved reports in DoubleClick.

Standard report

  1. Dimensions: Select the dimensions to include in the report.

  2. Metrics: Select the metrics to include in the report.

important

Some combinations of dimensions, metrics, and per-interaction metrics are not supported. If an error appears, change the dimensions or metrics.

  1. Advertisers: Select the advertisers to filter the report.
    Click the field to view a list of available values.

  2. Activities: Select the activities to filter the report. Select at least one advertiser to view the available activities.

  3. Activities metrics: You can include activity metrics in the report after selecting activities. Select the metrics to include.

  4. Additional filters:

a. Campaigns: Select the campaigns to filter the report.

b. Operating Systems: Select the operating systems to filter the report.

c. Platform types: Select the campaigns to filter the report.

Path to conversion report

  1. Floodlights: Select the floodlights to include in the report. Click the input to view a list of available floodlights. If there are no results, you can click insert floodlights manually and insert any floodlight ID (floodlight IDs are only accepted).

  2. Dimensions: Select the dimensions to include in the report.

  3. Metrics: Select the metrics to include in the report.

  4. Per interaction metrics: Select the metrics to include in the report.

info

Some combinations of dimensions, metrics, and per-interaction metrics are not supported. If an error appears, change the dimensions or metrics.

  1. Look back window: Select either to run the report for a look back window from Floodlight or from custom days.

    • Custom: Select the number of days per clicks and impressions (1-90 days only).

  2. Activities: Select the advertisers to filter the report. Click to view a list of available values.

  3. Additional filters:

a. Max gap between interactions: Select the maximum number of days allowed between interactions (clicks or impressions) by the same user. You can select a value between 1 and 90 days.

b. Max number of click interactions: Select the maximum number of click interactions to include in the report.

c. Max number of Impressions interactions: Select the maximum number of impression interactions to include in the report.

d. Include unattributed IP conversions: Enable this option to include conversions tracked by IP address that are not attributed to a known interaction.

e. Include unattributed cookie conversions: Enable this option to include conversions tracked by cookies that are not attributed to a known interaction.

f. Pivot on interaction path: Select whether to pivot the report on the interaction path.

Reach report

  1. Dimensions: Select the dimensions to include in the report.

  2. Metrics: Select the metrics to include in the report.

  3. Reach by frequency metrics: Select the metrics to include in the report.

note

Some combinations of dimensions, metrics, and per-interaction metrics are not supported. If an error appears, change the dimensions or metrics.

  1. Advertisers: Select the advertisers to filter the report.

  2. Activities: Select the advertisers to filter the report. Click to view a list of all available values after selecting any advertiser.

  3. Activities metrics: You can select activities metrics in the report after choosing activities.

  4. Additional filters:

a. Campaigns: Select the campaigns to filter the report.

b. Operating systems: Select the operating systems to filter the report. c. Platform types: Select the campaigns to filter the report.

Floodlight report

  1. Dimensions: Select the dimensions to include in the report

  2. Metrics: Select the metrics to include in the report.

note

Some combinations of dimensions, metrics, and per-interaction metrics are not supported. If an error appears, change the dimensions or metrics.

  1. Floodlights(mandatory): Select the floodlights to include in the report.

  2. Advertisers: Select the advertisers to filter the report.

  3. Activities: Select the advertisers to filter the report. After selecting any advertiser or floodlight, click to view a list of all available values.

  4. Additional filters:

a. Campaigns: Select the campaigns to filter the report.

b. Operating Systems: Select the operating systems to filter the report. c. Platform types: Select the campaigns to filter the report. 7. Include unattributed IP conversions.

  1. Include unattributed cookie conversions.

Cross-dimension reach report

  1. Dimension: Select the dimension of the report.

  2. Advertisers: If selected Campaign or Site by advertiser dimensions, filter the report by advertisers.

  3. Campaigns: Select Site by campaign dimension to filter the report by campaigns.

  4. Pivot dimension: Choose to pivot the report by the selected dimension.

  5. Breakdowns: Aggregate the results by date, week, or month.

  6. Metrics: Select the metrics to include in the report.

important

Some combinations of dimensions, metrics, and per-interaction metrics are not supported. If an error appears, change the dimensions or metrics.

  1. Overlap metrics: Use these metrics to compare data and understand the overlap between two specific advertisers, campaigns, or sites, and determine the number of users who interacted with your ads on both.

Run an existing report

Data Integration supports running existing reports in the DoubleClick reporting system.

  1. Select run existing report.

  2. Select a Profile (mandatory).
    A list of available profiles is displayed.

  3. Select the Report to run.

  4. Click Load report Details to view all the inputs of the selected report. All these inputs are not editable.

    In some cases, input fields may display only IDs without names. This does not affect the ability to run the report. You can refresh the list to populate it with updated values.

  5. Turn on the Update report checkbox to edit the report inputs.

When this report is executed, the DoubleClick system will update the original report.

Scheduling reports in DoubleClick rivers

When you schedule a DoubleClick river, the report is executed at defined intervals. If the river is configured to create a new report and keep report is enabled, a new report is saved in the DoubleClick reporting system after each scheduled run. For example, if the river runs every hour, it creates 24 separate reports in DoubleClick—one for each hour. To avoid this, turn off Keep report when scheduling a river that creates a new report in DoubleClick. This ensures that only the first report is saved in DoubleClick, and all subsequent runs reuse the same configuration without creating new reports.

Limitations

  • Data Integration supports reports in CSV format. Make sure you select the CSV format and not the XLS format.
  • DoubleClick Rivers may take longer to run, depending on the time it takes for the report to generate on the DoubleClick. To optimize this, refer to DoubleClick's Reporting Best Practice.
  • Long run times may be caused by large date ranges or data volumes. DoubleClick documentation shows no correlation between report runtime and the number of rows returned in the data.
On this Page