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.
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.
5. Click Update query.

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.
6. Click Update query.

Some common formatting examples:

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