Report formatting

Converting a CSV file:

Ad Manager reports are downloaded as CSV files. To modify this formatting, follow the steps below.

Excel

1. Select column A (where the data is stored).

2. Go to Data → Text to Columns.

3. In the Text to Columns Wizard:

• Choose Delimited and click Next.

• Check the delimiter that matches your CSV file (e.g., Comma, Tab, or another separator).

• Click Finish.

Google Spreadsheet

1. Click on File → Import.

2. In the Import File window:

• Select Upload and drag and drop your CSV file, or click Select a file from your device to browse for it.

3. Once the file is selected, you'll see import options. Choose:

• Replace Spreadsheet: Overwrite the current sheet with the CSV content.

• Insert new sheet(s): Add the content as a new sheet within the file.

• Append rows: Add the CSV data below the existing rows.

4. Click Import Data.

US v.s. UK formatting

Ad Manager reports use US formatting, where decimals are separated with a decimal point and thousands with a comma (1,234.65). However, most programs such as Excel and Google Sheets, may default to UK formatting, which uses a comma for decimals and a dot for thousands (1.234,65). This discrepancy can create issues with reporting.

To adjust settings for proper formatting, follow these steps:

Excel

1. Select the cells you want to format.

2. Right-click and select Format Cells (or go to the Home tab → Number group → "Number Format" dropdown → "More Number Formats").

3. Go to the Number or Currency category and ensure the symbols are set appropriately (e.g., a comma , as the thousands separator and a dot . for decimals instead of vice versa).

Google Spreadsheet

1. Select the cells with numbers or currency.

2. Go to Format → Number → Currency → Euro (€)

3. If needed, click Custom currencies and select Euro (€) and use commas for thousands.