> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# DCM via Google Cloud Storage Connector

<Warning>
  **Important:** Due to Google’s change in allowing Domo connectors to use OAuth authentication, all users must now use service account key authentication to create new data connections. All pre-existing DataSets will continue to run normally. Current Connectors that rely on Google OAuth authentication will no longer be able to power up new DataSets. These connectors include the following:

  * Google BigQuery
  * Google Adwords via Google BigQuery
  * [DCM via Google Cloud Storage (DTV2)](/s/article/360042926694 "DCM via Google Cloud Storage (DTV2) Connector")
  * [Google Cloud Storage](/s/article/360043433313 "Google Cloud Storage")
  * [Google Contacts](/s/article/360043435173 "Google Contacts")
  * Google Drive
  * [Google Gmail](/s/article/360042930594 "Google Gmail")
  * [Google Admin SDK Reports](/s/article/360042928714 "Google Admin SDK Reports")

  If you need to change a pre-existing Google OAuth DataSet, please use the corresponding Service Account connector. The following Service Account connectors are now available:

  * [Google BigQuery Service](/s/article/360043436593 "Google BigQuery Service")
  * [Google Ads (fomerly AdWords) via Google BigQuery Service](/s/article/360043431253 "Google Ads (fomerly AdWords) via Google BigQuery Service")
  * [Google Drive Service](/s/article/360042932014 "Google Drive Service")
  * [Google Cloud Storage Service](/s/article/360042928774 "Google Cloud Storage Service")
  * [Google Contacts Service](/s/article/360042930574 "Google Contacts Service")
  * [Google Gmail Service](/s/article/360043435193 "Google Gmail Service")
  * [Google Admin SDK Reports Service](/s/article/360043433273 "Google Admin SDK Reports Service")

  All other equivalent Google Service Account connectors are currently in development. Domo will communicate when these connectors become available. You will need to look for the Service Account equivalent connector in Data Center or the App Store and use that connector to get their data.

  Domo recommends that you proactively repower existing Google connections by creating new DataSets utilizing the new Service Account Key connectors as the connectors become available.  Domo will notify you if any further migration changes should arise.
</Warning>

## Intro

Google Cloud Storage is an Internet service used to store data in Google's cloud. You can use Domo’s DCM via Google Cloud Storage Connector to retrieve DoubleClick Campaign Manager and DoubleClick Bid Manager data. The connector brings in impression-level data and is able to join the data automatically. To learn more about the DoubleClick Campaign Manager API, visit their page ([https://developers.google.com/double...k-advertisers/](https://developers.google.com/doubleclick-advertisers/ "https://developers.google.com/doubleclick-advertisers/") ).

<Note>
  **Note:** The user interface for building this connector is not yet available in our Connectors listing in the Data Center, meaning you will not be able to configure the connector on your own. However, we at Domo are more than happy to configure the connector for you so you can begin using it to pull your data into Domo. Please don't hesitate to reach out to your CSM or Domo Support.
</Note>

<table class="mt-responsive-table" data-aura-rendered-by="33:207;a">
  <tbody>
    <tr>
      <td class="mt-noheading" rowspan="1" colspan="1">
        <p><strong>Primary Use Cases</strong></p>
      </td>

      <td class="mt-noheading" rowspan="1" colspan="1">
        <p>This connector pulls DCM tables from Google Cloud Storage into Domo. If you indicate that you want match tables included, these tables will be joined.</p>
      </td>
    </tr>

    <tr>
      <td class="mt-noheading" rowspan="1" colspan="1">
        <p><strong>Primary Metrics</strong></p>
      </td>

      <td class="mt-noheading" rowspan="1" colspan="1">
        <p>The connector brings in raw data, but you can aggregate the data to show metrics such as...</p>

        <ul>
          <li>
            <p>Impressions</p>
          </li>

          <li>
            <p>Clicks</p>
          </li>

          <li>
            <p>CTR</p>
          </li>

          <li>
            <p>Rich media delivered</p>
          </li>

          <li>
            <p>Activities for DCM campaigns</p>
          </li>
        </ul>
      </td>
    </tr>

    <tr>
      <td class="mt-noheading" rowspan="1" colspan="1">
        <p><strong>Primary Company Roles</strong></p>
      </td>

      <td class="mt-noheading" rowspan="1" colspan="1">
        <ul>
          <li>
            <p>Data specialists</p>
          </li>

          <li>
            <p>Analysts</p>
          </li>

          <li>
            <p>Major Domos</p>
          </li>
        </ul>
      </td>
    </tr>

    <tr>
      <td class="mt-noheading" rowspan="1" colspan="1">
        <p><strong>Average Implementation Time</strong></p>
      </td>

      <td class="mt-noheading" rowspan="1" colspan="1">
        <p>Average time for the phases of implementation for this connector are as follows:</p>

        <ul>
          <li>
            <p>Configuring an export of your 4 tables to Google Cloud Storage - 2 hours</p>
          </li>

          <li>
            <p>Configuring credentials in Domo - 15 minutes or less</p>
          </li>

          <li>
            <p>Configuring the connector - 20 minutes</p>
          </li>
        </ul>

        <p>The total time may also depend on the size of the files coming from DCM.</p>
      </td>
    </tr>

    <tr>
      <td class="mt-noheading" rowspan="1" colspan="1">
        <p><strong>Ease of Use (on a 1-to-10 scale with 1 being easiest)</strong></p>
      </td>

      <td class="mt-noheading" rowspan="1" colspan="1">
        <p>7</p>
      </td>
    </tr>
  </tbody>
</table>

You can connect to your DoubleClick Campaign Manager account in the Data Center. This topic discusses the fields and menus that are specific to the DoubleClick Campaign Manager connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in [Adding a DataSet Using a Data Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Data Connector").

## Prerequisites

To connect to a Google account and create a DataSet, you must have the username and password for the account you want to connect to.

You must also export these four tables from DCM to Google Cloud Storage before configuring this connector:

* Activities
* Clicks
* Impressions
* Rich Media

You can refer to this page to find the names of all of the fields that come through for these four tables:

[https://developers.google.com/doubleclick-advertisers/udt/reference/v1/file-format](https://developers.google.com/doubleclick-advertisers/udt/reference/v1/file-format "https://developers.google.com/doubleclick-advertisers/udt/reference/v1/file-format")

Do not change the output files names—Google will automatically assign these file names.

## Connecting to Your DCM via Google Cloud Storage Account

This section enumerates the options in the **Credentials** and **Details** panes in the DCM via Google Cloud Storage Connector page. The components of the other panes in this page, **Scheduling** and **Name & Describe Your DataSet,** are universal across most connector types and are discussed in greater length in [Adding a DataSet Using a Data Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Data Connector").

### Credentials Pane

The Domo DCM via Google Cloud Storage connector uses OAuth to connect, so there is no need to enter credentials within Domo. Click **Connect** (or select **Add Account** if you have existing DCM via Google Cloud Storage accounts in Domo) to open the Google OAuth screen where you can enter your Google credentials. Once you have entered valid Google credentials, you can use the same account any time you go to create a new DCM via Google Cloud Storage DataSet. You can manage connector accounts in the **Accounts** tab in the Data Center. For more information about this tab, see [Managing User Accounts for Connectors](https://domo-support.domo.com/s/article/360042926054?language=en_US "Managing User Accounts for Connectors").

<Note>
  **Note:** If you are already logged into Google when you connect in Domo, you are authenticated automatically when you click **Add account**. If you want to connect to an account that is different from the one you are logged into, you must first log out of Google.
</Note>

### Details Pane

This pane contains a primary **Reports** menu, along with various other menus which may or may not appear depending on the report type you select.

<table border="1" cellpadding="1" cellspacing="1" data-aura-rendered-by="33:201;a"><thead><tr><th colspan="1" rowspan="1"><p> Menu </p></th><th colspan="1" rowspan="1"><p> Description </p></th></tr></thead><tbody><tr><td colspan="1" rowspan="1"><p> Report </p></td><td colspan="1" rowspan="1"><p> Select the DCM via Google Cloud Storage report you want to run. The Master Report pulls all 4 DCM tables into a single report. (see <a href="#h_34407b13-454e-4a76-b215-974ff29a27ab" target="_blank" title="Prerequisites"> Prerequisites </a> for more information about these tables). All other reports allow you to retrieve individual DCM tables, with or without match tables. Match tables are used to perform joins between tables. </p><p> The following reports are available: </p><table border="1" cellpadding="1" cellspacing="1"><tbody><tr><td colspan="1" rowspan="1"> Activities Raw Data </td><td colspan="1" rowspan="1"> Retrieves the raw data from your DCM Activities table. </td></tr><tr><td colspan="1" rowspan="1"> Activities Report with Match Tables </td><td colspan="1" rowspan="1"> Retrieves your DCM Activities data with match tables. </td></tr><tr><td colspan="1" rowspan="1"> Clicks Raw Data </td><td colspan="1" rowspan="1"> Retrieves the raw data from your DCM Clicks table. </td></tr><tr><td colspan="1" rowspan="1"> Clicks Report with Match Tables </td><td colspan="1" rowspan="1"> Retrieves your DCM Clicks data with match tables. </td></tr><tr><td colspan="1" rowspan="1"> Impressions Raw Data </td><td colspan="1" rowspan="1"> Retrieves the raw data from your DCM Impressions table. </td></tr><tr><td colspan="1" rowspan="1"> Impressions Report with Match Tables </td><td colspan="1" rowspan="1"> Retrieves your DCM Impressions data with match tables. </td></tr><tr><td colspan="1" rowspan="1"> Master Report </td><td colspan="1" rowspan="1"> Compiles a report with data from all of your DCM tables—Activities, Clicks, Impressions, and Rich Media. </td></tr><tr><td colspan="1" rowspan="1"> Rich Media Raw Data </td><td colspan="1" rowspan="1"> Retrieves the raw data from your DCM Rich Media table. </td></tr><tr><td colspan="1" rowspan="1"> Rich Media Report with Match Tables </td><td colspan="1" rowspan="1"> Retrieves your DCM Rich Media data with match tables. </td></tr></tbody></table><p /></td></tr><tr><td colspan="1" rowspan="1"> Bucket Name </td><td colspan="1" rowspan="1"> Enter the name of the bucket in Google Cloud Storage where the DCM files are stored. </td></tr><tr><td colspan="1" rowspan="1"> Backfill Days for Initial Run </td><td colspan="1" rowspan="1"> Enter the number of past days you want to retrieve data for on the first run. Depending on the file size, you may not be able to backfill very many days. </td></tr></tbody></table>

### Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](https://domo-support.domo.com/s/article/360042926274?language=en_US "Adding a DataSet Using a Data Connector").

## Troubleshooting

* Make sure you have the right bucket name and the report desired.
* Make sure you have exported the required tables from DCM to Google Cloud Storage. (See
  [Prerequisites](#h_34407b13-454e-4a76-b215-974ff29a27ab "Prerequisites") for more information.)