JDBC Driver for Google Ads

Build 22.0.8462

MediaFile

A media file.

Columns

Name Type Behavior Description
CustomerId Long ATTRIBUTE Output only. The ID of the customer.
MediaFileAudioAdDurationMillis Long ATTRIBUTE Output only. The duration of the Audio in milliseconds.
MediaFileFileSize Long ATTRIBUTE Output only. The size of the media file in bytes.
MediaFileId Long ATTRIBUTE Output only. The ID of the media file.
MediaFileImageFullSizeImageUrl String ATTRIBUTE Output only. The url to the full size version of the image.
MediaFileImagePreviewSizeImageUrl String ATTRIBUTE Output only. The url to the preview size version of the image.
MediaFileMediaBundleUrl String ATTRIBUTE Output only. The url to access the uploaded zipped data. For example, https://tpc.googlesyndication.com/simgad/123 This field is read-only.
MediaFileMimeType String ATTRIBUTE Output only. The mime type of the media file.

The allowed values are AUDIO_MP3, AUDIO_WAV, FLASH, HTML5_AD_ZIP, IMAGE_GIF, IMAGE_JPEG, IMAGE_PNG, MSEXCEL, MSWORD, PDF, RTF, TEXT_HTML, UNKNOWN, UNSPECIFIED.

MediaFileName String ATTRIBUTE Immutable. The name of the media file. The name can be used by clients to help identify previously uploaded media.
MediaFileResourceName String ATTRIBUTE Immutable. The resource name of the media file. Media file resource names have the form: customers/{customer_id}/mediaFiles/{media_file_id}
MediaFileSourceUrl String ATTRIBUTE 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.
MediaFileType String ATTRIBUTE Immutable. Type of the media file.

The allowed values are AUDIO, DYNAMIC_IMAGE, ICON, IMAGE, MEDIA_BUNDLE, UNKNOWN, UNSPECIFIED, VIDEO.

MediaFileVideoAdDurationMillis Long ATTRIBUTE Output only. The duration of the Video in milliseconds.
MediaFileVideoAdvertisingIdCode String ATTRIBUTE Output only. The Advertising Digital Identification code for this video, as defined by the American Association of Advertising Agencies, used mainly for television commercials.
MediaFileVideoIsciCode String ATTRIBUTE Output only. The Industry Standard Commercial Identifier code for this video, used mainly for television commercials.
MediaFileVideoYoutubeVideoId String ATTRIBUTE 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.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ManagerId Long Id of the manager account on behalf of which you are requesting customer data.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462