Open navigation

About image, date, and blank result formatting in Google Sheets

Supermetrics and Google Sheets offer different ways to format images, dates, and blank values in your data. Use these best practices to adjust images and values until they're looking the way you want.


Add images or videos to a report from URL fields

Use these steps to add an image or video — like ad creatives, post pictures, or logos — to your report from a URL.

  1. Open the Supermetrics sidebar in Google Sheets.
  2. Create a new query or select a query you want to modify.
  3. In the sidebar, select Split by dimensions.
  4. In the Split to rows field, type “Ad creative thumbnail URL” for a thumbnail image or video, or “Ad creative image URL” for a full image.
  5. Complete your query, and click Get data to table.
  6. Create a new column next to the data from the query.
  7. In any cell you want to fill with an image, add the formula =IMAGE(cell), where “cell” is the location of your image or video URL. 


Have blank or null results appear as 0

Follow these steps to get 0 values instead of blank or null results.

  1. Open the Supermetrics sidebar in Google Sheets.
  2. Select the query you want to modify.
  3. In the sidebar, go to Options.
  4. Check the Replace blank metric values with zeros checkbox.


Make changes to date formatting

Google Sheets offers a variety of formatting options for dates. To adjust the formatting that Supermetrics returns your data in, follow these steps.

  1. Open the Supermetrics sidebar in Google Sheets.
  2. Select the query you want to modify.
  3. In the sidebar, click Options.
  4. At the bottom of the list of available options, find the Advanced settings field.
  5. Type the setting from the table below that corresponds to the date formatting you want to use. Explore the full list of options.


Some common formatting examples:


Special setting

Basic format
Example output
TIME_DIMENSION_FORMAT_m/d/Ymm/dd/YYYY
01/02/2018
TIME_DIMENSION_FORMAT_m-y

mm-yy

01-18
TIME_DIMENSION_FORMAT_H:i:s
HH:ii:ss

14:23:04

TIME_DIMENSION_FORMAT_F Y
month YYYY
January 2018


If you want to include commas between different date values, write each one in as "comma". For example: 


TIME_DIMENSION_FORMAT_Y-m-d,DISABLE_DIMENSION_AUTOFORMAT



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.