Skip to main content

How do I create DoubleClick Campaign Manager metrics?

Updated

Visualize, discover, and act on your digital advertising data by creating DoubleClick Campaign Manager data feed metrics.

This article includes:

Connecting PowerMetrics to your DoubleClick Campaign Manager data

Here are a few things to note about connecting PowerMetrics to your DoubleClick Campaign Manager data:

Your data is safe with us. The first time you connect your DoubleClick Campaign Manager data to PowerMetrics, you'll be prompted to enter your DoubleClick Campaign Manager login credentials and give permission to allow access to the data within your DoubleClick Campaign Manager account. We are serious about protecting your data privacy.

Managing your connections. By default, your connection name looks like this: yourname@Google<date and time created>. You can rename connections from your list of connections (accessed by clicking the in the left navigation sidebar and selecting Connections) or within the application as you add metrics. Go here for more information on managing your account connections.

You can use the same account connection every time you connect to DoubleClick Campaign Manager. If you have trouble accessing an existing connection, your OAuth token may have expired. If that happens to you, check out these troubleshooting tips.

Creating DoubleClick Campaign Manager data feed metrics

When you create DoubleClick Campaign Manager data feed metrics, you:

Connecting to your DoubleClick Campaign Manager account and adding a data feed

Every metric needs a data feed. As you create metrics, you’ll either create a new data feed or select one from your list of existing data feeds. Learn more about data feeds.

To create a new data feed for your metric:

  1. In the left navigation sidebar click the + button beside Metrics and select See all services.
  2. On the Where is your data? page, under Data Feed Services, select DoubleClick Campaign Manager.
  3. Click +New data feed > Select DoubleClick Campaign Manager data.
  4. Select a pre-built data source from the left section of the Choose a pre-built or custom connection page or click +Create a custom DoubleClick Campaign Manager data source.
  5. If this is your first time connecting to DoubleClick Campaign Manager:
    • Click Connect an account. Enter your DoubleClick Campaign Manager login credentials and click Next. If prompted, click Allow Access to enable Klipfolio PowerMetrics to securely access your DoubleClick Campaign Manager data. Click Continue.
  6. If you've connected to DoubleClick Campaign Manager before:
    • Select an existing account from the drop-down list and click Continue.
  7. On the Configure data service page, select your DoubleClick Campaign Manager Profile and Report.
  8. At Query URL, optionally, adjust the query to return the data you need.
  9. Click Get data.
  10. Ensure this is the data you’re looking for. Then, click Continue. Next step - refine the data in the data feed editor.

To use an existing data feed for your metric:

  1. In the left navigation sidebar, click Data Feeds.
  2. In your list of Data Feeds, select the one you want to use for your metric.
  3. Click the Metrics tab in the right-side pane.
  4. Click +Add metric and proceed to Configuring your metric.

Troubleshooting tips for connecting to DoubleClick Campaign Manager data

If you're having trouble getting your DoubleClick Campaign Manager data into Klipfolio, here are some troubleshooting tips:

Scenario 1: You don't see your report in the drop-down list.

The Reports drop-down list on the Configure data service page in PowerMetrics shows your ten last modified reports. If you don't see your report in the list, go to your chosen report in DoubleClick Campaign Manager and rename it or make a minor, insignificant edit to it and then save your changes.

Scenario 2: You are getting an error message after clicking Submit.

There are two things you can do to rectify this:

  1. Verify that your report is in CSV format.
  2. Reduce the size of your report. Either shorten the date range or reduce the number of metrics in your report.

No matter what changes you make in DoubleClick, be sure to save your changes, and try setting up your DoubleClick Campaign Manager data feed again.

Refining data in the data feed editor

You’ve arrived in the data feed editor where you can choose to either accept the automatic settings or make changes.

If you’re happy with the automatic settings:

If you want to make changes:

  • Some common adjustments include changing the data format or names for columns, updating the data feed name, and combining columns using formulas - there are many customization options available.
  • If you want to adjust the original query, click the tile under Data service.
  • When you’re finished editing the data feed, click Save data feed and proceed to Configuring your metric.

Note: After you’re finished creating a metric with this data feed, you can return to it and use it to make more data feed metrics. In the left navigation sidebar, click Data Feeds. Select the desired data feed from the list and click +Add metric.

Configuring your metric

When you configure a data feed metric, you select the measure and dimensions from the data feed to include in the metric and choose settings that determine how the data will be visualized. Go here for detailed instructions on configuring your metric.

Next steps – Interacting with your data

Now that you're connected and have some metrics, it's time to start learning from your data and tracking your progress.

Here are a few suggestions for interacting with your data:

Related articles