media_file

AI-generated Key Takeaways

• A media file can be linked to a customer resource.

• Available fields for media files include audio duration, file size, ID, image URLs, media bundle URL, mime type, name, resource name, source URL, type, and various video-related fields.

• Several fields are output only, such as audio and video duration, file size, image URLs, media bundle URL, mime type, advertising ID code, ISCI code, and YouTube video ID.

• Fields like media_file.name, media_file.resource_name, media_file.source_url, and media_file.type are immutable.

• Most fields are filterable and selectable, while sortability varies depending on the specific field.

Help me build a query

A media file.

Attributed resources
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

media_file.audio.ad_duration_millis Field description Output only. The duration of the Audio in milliseconds. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.file_size Field description Output only. The size of the media file in bytes. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.id Field description Output only. The ID of the media file. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.image.full_size_image_url Field description Output only. The url to the full size version of the image. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable False Repeated False

media_file.image.preview_size_image_url Field description Output only. The url to the preview size version of the image. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable False Repeated False

media_file.media_bundle.url Field description Output only. The url to access the uploaded zipped data. For example, https://tpc.googlesyndication.com/simgad/123 This field is read-only. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable False Repeated False

media_file.mime_type Field description Output only. The mime type of the media file. Category ATTRIBUTE Data Type ENUM AUDIO_MP3 AUDIO_WAV FLASH HTML5_AD_ZIP IMAGE_GIF IMAGE_JPEG IMAGE_PNG MSEXCEL MSWORD PDF RTF TEXT_HTML UNKNOWN UNSPECIFIED Type URL google.ads.googleads.v20.enums.MimeTypeEnum.MimeType Filterable True Selectable True Sortable True Repeated False

media_file.name Field description Immutable. The name of the media file. The name can be used by clients to help identify previously uploaded media. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.resource_name Field description Immutable. The resource name of the media file. Media file resource names have the form: customers/{customer_id}/mediaFiles/{media_file_id} Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

media_file.source_url Field description Immutable. The URL of where the original media file was downloaded from (or a file name). Only used for media of type AUDIO and IMAGE. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.type Field description Immutable. Type of the media file. Category ATTRIBUTE Data Type ENUM AUDIO DYNAMIC_IMAGE ICON IMAGE MEDIA_BUNDLE UNKNOWN UNSPECIFIED VIDEO Type URL google.ads.googleads.v20.enums.MediaTypeEnum.MediaType Filterable True Selectable True Sortable True Repeated False

media_file.video.ad_duration_millis Field description Output only. The duration of the Video in milliseconds. Category ATTRIBUTE Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.video.advertising_id_code Field description Output only. The Advertising Digital Identification code for this video, as defined by the American Association of Advertising Agencies, used mainly for television commercials. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.video.isci_code Field description Output only. The Industry Standard Commercial Identifier code for this video, used mainly for television commercials. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

media_file.video.youtube_video_id Field description Immutable. The YouTube video ID (as seen in YouTube URLs). Adding prefix "https://www.youtube.com/watch?v=" to this ID will get the YouTube streaming URL for this video. Category ATTRIBUTE Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False