SSIS Components for Google Ads

Build 24.0.9062

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.

使用できる値は次のとおりです。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.

使用できる値は次のとおりです。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

SELECT ステートメントのWHERE 句では、疑似列フィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062