Search
Clear search
Close search
Google apps
Main menu

Welcome to the help center for DoubleClick Search, a platform for managing search marketing campaigns.  While the help center is available to the public, access to the DoubleClick Search product is available only to subscribing customers who are signed in. To subscribe or find out more, contact our sales team.

Available report formats

You can download reports in the following formats:

  • .xlsx and .xls files are Microsoft Excel files.
  • Excel-compatible text file (.csv) is in the UTF-16 (Excel-compatible) format. This allows support for double-byte characters, the registered trademark symbol (®), and more. Also, with one click, you can open these files directly into Excel.
  • Comma-separated text file (.csv) is encoded in UTF-16. Use this format if you want to view report data in a text-only format.

Formatting notes for CSV files

Note the following about files downloaded in either CSV format (Excel-compatible text file or Comma-separated text file):

  • Account ID, Campaign ID, and other ID columns are always in the following format:
    ="number"
    For example,  ="43700007111227750"

    Most spreadsheet applications interpret this format as a formula and therefore keep the value intact. Without this formatting, a spreadsheet might interpret the value as a number, and then truncate or round the number into some other value.

    Be careful when opening and saving CSV files in spreadsheets. In some cases, even if you save a CSV file as a CSV, the spreadsheet may reformat IDs as a number and therefore truncate or round the value. 

    If you're using something other than a spreadsheet to process the downloaded data, you may want to remove the preceding equals sign and the surrounding quote.   ="43700007111227750" is not a valid DoubleClick Search ID, but  43700007111227750 is valid.

  • If a cell starts with the + character, the downloaded file surrounds the cell in quotes.
    For example, the following keyword text in a Bing Ads ad group specifies the broad match modifier:
    +shoes
    When downloading to a CSV file, the cell is formatted as:
    ="+shoes"

  • Account, campaign, geo target, and other names that include a comma are surrounded by quotes in the downloaded file. For example:
    "Campaign name, with comma"

Was this article helpful?
How can we improve it?