Explore the Google Ads API data model

See how the various Google Ads endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Google Ads API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Google Ads API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Ad

Documentation: https://developers.google.com/google-ads/api/reference/rpc/v22/Ad

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Type string - -
DevicePreference string - -
SystemManagedResourceSource string - -
TrackingUrlTemplate string - -
DisplayUrl string - -
AddedByGoogleAds boolean - -
BusinessName string - -
Description1 string - -
Description2 string - -
Path1 string - -
Path2 string - -
Breadcrumb1 string - -
Breadcrumb2 string - -
ConversionAction string - -
CountryCode string - -
Headline1 string - -
Headline2 string - -
PhoneNumber string - -
PhoneNumberVerificationUrl string - -
ConversionReportingState string - -
CallTracked boolean - -
DisableCallConversion boolean - -
HeadlinePart1 string - -
HeadlinePart2 string - -
HeadlinePart3 string - -
AccentColor string - -
MainColor string - -
AllowFlexibleColor boolean - -
CallToActionText string - -
PromoText string - -
PricePrefix string - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

AdGroup

Documentation: https://developers.google.com/google-ads/api/fields/v22/ad_group

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Type string - -
Status string - -
PrimaryStatus string - -
PrimaryStatusReasons string - -
AdRotationMode string - -
Campaign string - -
CampaignID long Campaign → ID -
BaseAdGroup string - -
BaseAdGroupID long AdGroup → ID -
CpcBidMicros long - -
FixedCpmMicros long - -
CpmBidMicros long - -
CpvBidMicros long - -
OptimizedTargetingEnabled boolean - -
ExcludeDemographicExpansion boolean - -
TargetCpaMicros long - -
TargetCpmMicros long - -
TargetCpvMicros long - -
TargetCpcMicros long - -
TargetRoas decimal - -
EffectiveTargetCpaMicros long - -
EffectiveTargetCpc long - -
EffectiveTargetRoas decimal - -
EffectiveCpcBidMicros long - -
DisplayCustomBidDimension string - -
EffectiveTargetCpaSource string - -
EffectiveTargetCpcSource string - -
EffectiveTargetRoasSource string - -
AbsoluteTopImpressionPercentage decimal - -
ActiveViewCpm decimal - -
ActiveViewImpressions long - -
ActiveViewMeasurableCostMicros long - -
ActiveViewMeasurableImpressions long - -
ActiveViewViewability decimal - -
AllConversions decimal - -
AllConversionsByConversionDate decimal - -
AverageCost decimal - -
AverageCpc decimal - -
AverageCpe decimal - -
AverageCpm decimal - -
AveragePageViews decimal - -
AverageTimeOnSite decimal - -
BounceRate decimal - -
Clicks long - -
Conversions decimal - -
Impressions decimal - -
Interactions decimal - -
Engagements decimal - -
Orders decimal - -
ActiveViewMeasurability decimal - -
UnitsSold decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

AdGroupAd

Documentation: https://developers.google.com/google-ads/api/fields/v22/ad_group

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AdID long Ad → ID -
AdStrength string - -
AdGroupID long AdGroup → ID -
AdGroup string - -
Status string - -
AbsoluteTopImpressionPercentage decimal - -
ActiveViewCpm decimal - -
ActiveViewCtr decimal - -
ActiveViewImpressions decimal - -
ActiveViewMeasurability decimal - -
ActiveViewViewability decimal - -
ActiveViewMeasurableImpressions decimal - -
ActiveViewMeasurableCostMicros decimal - -
AllConversions decimal - -
AllConversionsValue decimal - -
AverageCartSize decimal - -
AverageCost decimal - -
AverageCpc decimal - -
AverageCpe decimal - -
AverageCpm decimal - -
BounceRate decimal - -
Clicks decimal - -
Conversions decimal - -
ConversionsValue decimal - -
CostMicros long - -
Engagements long - -
Interactions long - -
Impressions long - -
CostPerAllConversions decimal - -
CostPerConversion decimal - -
Ctr decimal - -
EngagementRate decimal - -
InteractionRate long - -
ValuePerAllConversions decimal - -
ValuePerConversion decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

AdGroupAdAsset

Documentation: https://developers.google.com/google-ads/api/fields/v22/ad_group_ad_asset_view

Column Type Relates to Notes
RemoteID string - -
AdGroupAdRemoteID string AdGroupAd → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Asset string - -
AssetID long Asset → ID -
AdGroupAd string AdGroupAd → ResourceName -
PinnedField string - -
PerformanceLabel string - -
AllConversions decimal - -
AllConversionsValue decimal - -
AllConversionsValuePerCost decimal - -
AverageCost decimal - -
AverageCpc decimal - -
AverageCpe decimal - -
AverageCpm decimal - -
Clicks decimal - -
Conversions decimal - -
ConversionsValue decimal - -
CostMicros long - -
Engagements long - -
Interactions long - -
Impressions long - -
CostPerAllConversions decimal - -
CostPerConversion decimal - -
Ctr decimal - -
EngagementRate decimal - -
InteractionRate long - -
ValuePerAllConversions decimal - -
ValuePerConversion decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

AdGroupAsset

Documentation: https://developers.google.com/google-ads/api/fields/v22/ad_group_asset

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Asset string - -
AssetID long Asset → ID -
AdGroup string - -
AdGroupID long AdGroup → ID -
Status string - -
AbsoluteTopImpressionPercentage decimal - -
AllConversions decimal - -
AllConversionsValue decimal - -
ConversionsFromInteractionsRate decimal - -
AverageCost decimal - -
AverageCpc decimal - -
AverageCpe decimal - -
AverageCpm decimal - -
Clicks decimal - -
Conversions decimal - -
ConversionsValue decimal - -
CostMicros long - -
Engagements long - -
Interactions long - -
Impressions long - -
CostPerAllConversions decimal - -
CostPerConversion decimal - -
Ctr decimal - -
EngagementRate decimal - -
InteractionRate long - -
ValuePerAllConversions decimal - -
ValuePerConversion decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

Asset

Documentation: https://developers.google.com/google-ads/api/reference/rpc/v22/asset

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Type string - -
Source string - -
PolicySummaryApprovalStatus string - -
PolicySummaryPolicyTopicEntries string - -
PolicySummaryReviewStatus string - -
CallToAction string - -
TextAssetText string - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

AssetGroup

Documentation: https://developers.google.com/google-ads/api/fields/v22/asset_group

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
PrimaryStatus string - -
Path1 string - -
Path2 string - -
AdStrength string - -
Status string - -
Campaign string - -
CampaignID long Campaign → ID -
FinalMobileUrls string - -
MobileUrls string - -
PrimaryStatusReasons string - -
AllConversions decimal - -
AllConversionsByConversionDate decimal - -
AverageCost decimal - -
AverageCpc decimal - -
AverageCartSize decimal - -
AverageOrderValueMicros decimal - -
Clicks long - -
Conversions decimal - -
Impressions decimal - -
Interactions decimal - -
Orders decimal - -
CostPerConversion decimal - -
CostPerAllConversions decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

AssetGroupAsset

Documentation: https://developers.google.com/google-ads/api/fields/v22/asset_group_asset

Column Type Relates to Notes
RemoteID string - -
AssetGroupRemoteID string AssetGroup → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Asset string - -
AssetID long Asset → ID -
AssetGroup string - -
AssetGroupID long AssetGroup → ID -
AllConversions decimal - -
AllConversionsValue decimal - -
ConversionsFromInteractionsRate decimal - -
AverageCost decimal - -
AverageCpc decimal - -
Clicks decimal - -
Conversions decimal - -
ConversionsValue decimal - -
CostMicros long - -
Engagements long - -
Interactions long - -
Impressions long - -
CostPerAllConversions decimal - -
CostPerConversion decimal - -
Ctr decimal - -
EngagementRate decimal - -
InteractionRate long - -
ValuePerAllConversions decimal - -
ValuePerConversion decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

Campaign

Documentation: https://developers.google.com/google-ads/api/reference/rpc/v22/Campaign

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
PrimaryStatus string - -
Status string - -
ServingStatus string - -
AdServingOptimizationStatus string - -
AdvertisingChannelType string - -
AdvertisingChannelSubType string - -
CommissionRateMicros long - -
UpgradedTargeting boolean - -
DomainName string - -
LanguageCode string - -
UseSuppliedUrlsOnly boolean - -
ExcludedParentAssetFieldTypes string - -
ExcludedParentAssetSetTypes string - -
ExperimentType string - -
FeedTypes string - -
FixedCpmGoal string - -
FixedCpmTargetFrequency string - -
FixedCpmTargetFrequencyInfoTimeUnit string - -
NegativeGeoTargetType string - -
PositiveGeoTargetType string - -
HotelCenterID string - -
LocationSourceType string - -
EnhancedCpcEnabled boolean - -
MaximizeConversionValueTargetRoas decimal - -
MaximizeConversionsTargetCpaMicros long - -
MaximizeConversionValueTargetRoasTolerancePercentMillis long - -
TargetContentNetwork boolean - -
TargetGoogleSearch boolean - -
TargetGoogleTvNetwork boolean - -
TargetPartnerSearchNetwork boolean - -
TargetSearchNetwork boolean - -
TargetYoutube boolean - -
ListingType string - -
BrandGuidelinesEnabled boolean - -
ContainsEuPoliticalAdvertising string - -
OptimizationScore decimal - -
PaymentMode string - -
TrackingUrlTemplate string - -
FinalUrlSuffix string - -
KeywordMatchType string - -
ManualCpa string - -
ManualCpm string - -
ManualCpv string - -
TargetCpv string - -
BrandGuidelinesAccentColor string - -
BrandGuidelinesMainColor string - -
BrandGuidelinesPredefinedFontFamily string - -
Labels string - -
BaseCampaign string - -
BaseCampaignID long Campaign → ID -
CampaignGroup string - -
CampaignGroupID long CampaignGroup → ID -
HotelPropertyAssetSet string CampaignGroup → ID -
CampaignBudget string - -
CampaignBudgetID long CampaignBudget → ID -
BiddingStrategy string - -
BiddingStrategyID long - -
AccessibleBiddingStrategy string - -
AccessibleBiddingStrategyID long - -
StartDate datetime - -
EndDate datetime - -
AbsoluteTopImpressionPercentage decimal - -
ActiveViewCpm decimal - -
ActiveViewImpressions long - -
ActiveViewMeasurableCostMicros long - -
ActiveViewMeasurableImpressions long - -
ActiveViewViewability decimal - -
AllConversions decimal - -
AllConversionsByConversionDate decimal - -
AverageCost decimal - -
AverageCpc decimal - -
AverageCpe decimal - -
AverageCpm decimal - -
AveragePageViews decimal - -
AverageTimeOnSite decimal - -
BounceRate decimal - -
Clicks long - -
UniqueUsers long - -
Conversions decimal - -
Impressions decimal - -
Interactions decimal - -
Engagements decimal - -
Orders decimal - -
ActiveViewMeasurability decimal - -
CostPerConversion decimal - -
CostPerAllConversions decimal - -
UnitsSold decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

CampaignAsset

Documentation: https://developers.google.com/google-ads/api/fields/v22/campaign_asset

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Asset string - -
AssetID long Asset → ID -
Campaign string - -
CampaignID long Campaign → ID -
Status string - -
AbsoluteTopImpressionPercentage decimal - -
AllConversions decimal - -
AllConversionsValue decimal - -
ConversionsFromInteractionsRate decimal - -
AverageCost decimal - -
AverageCpc decimal - -
AverageCpe decimal - -
AverageCpm decimal - -
Clicks decimal - -
Conversions decimal - -
ConversionsValue decimal - -
CostMicros long - -
Engagements long - -
Interactions long - -
Impressions long - -
CostPerAllConversions decimal - -
CostPerConversion decimal - -
Ctr decimal - -
EngagementRate decimal - -
InteractionRate long - -
ValuePerAllConversions decimal - -
ValuePerConversion decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

CampaignBudget

Documentation: https://developers.google.com/google-ads/api/fields/v22/campaign_budget

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
AlignedBiddingStrategyID long - -
DeliveryMethod string - -
Period string - -
Type string - -
AmountMicros long - -
RecommendedBudgetAmountMicros long - -
RecommendedBudgetEstimatedChangeWeeklyClicks long - -
RecommendedBudgetEstimatedChangeWeeklyCostMicros long - -
RecommendedBudgetEstimatedChangeWeeklyInteractions long - -
RecommendedBudgetEstimatedChangeWeeklyViews long - -
TotalAmountMicros long - -
ExplicitlyShared boolean - -
HasRecommendedBudget boolean - -
ReferenceCount long - -
Status string - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

CampaignCriterion

Documentation: https://developers.google.com/google-ads/api/fields/v22/campaign_criterion

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CriterionID long - -
Status string - -
AdScheduleDayOfWeek string - -
AdScheduleEndHour int - -
AdScheduleStartHour int - -
AdScheduleEndMinute string - -
AdScheduleStartMinute string - -
AgeRangeType string - -
BidModifier decimal - -
Campaign string - -
CampaignID long Campaign → ID -
CarrierConstant string - -
CombinedAudience string - -
CustomAudience string - -
ContentLabelType string - -
CustomAffinity string - -
DeviceType string - -
DisplayName string - -
GenderType string - -
IncomeRangeType string - -
KeywordMatchType string - -
KeywordText string - -
IpAddress string - -
FreeFormKeywordTheme string - -
FreeFormKeywordThemeConstant string - -
LanguageConstant string - -
LifeEventID long - -
LocalServiceID string - -
LocationGeoTargetConstant string - -
MobileAppCategoryMobileAppCategoryConstant string - -
MobileApplicationAppID string - -
MobileApplicationName string - -
MobileApplicationMobileDeviceConstant string - -
OperatingSystemVersionConstant string - -
ParentalStatusType string - -
PlacementUrl string - -
ProximityAddressCityName string - -
ProximityAddressCountryCode string - -
ProximityAddressPostalCode string - -
ProximityAddressProvinceCode string - -
ProximityAddressProvinceName string - -
ProximityAddressStreetAddress string - -
ProximityGeoPointLatitudeInMicroDegrees int - -
ProximityGeoPointLongitudeInMicroDegrees int - -
ProximityRadiusUnits string - -
TopicPath string - -
TopicConstant string - -
UserList string - -
VideoLineupID long - -
WebpageCoveragePercentage decimal - -
WebpageCriterionName string - -
WebpageListSharedSet string - -
YoutubeChannelChannelID string - -
YoutubeVideoVideoID string - -
Negative boolean - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

CampaignGroup

Documentation: https://developers.google.com/google-ads/api/fields/v22/campaign_group

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID long - -
Name string - -
Status string - -
AverageCost decimal - -
Conversions decimal - -
CostPerConversion decimal - -
InteractionRate decimal - -
Interactions long - -
TrueviewAverageCpv decimal - -
EntityName string - -
ResourceName string - -
LastModifiedDate datetime - -

DynamicLocalAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
AssetID string Asset → ResourceName -
Address string - -
AndroidAppLink string - -
Category string - -
DealID string - -
DealName string - -
FormattedPrice string - -
FormattedSalePrice string - -
ImageUrl string - -
IosAppLink string - -
IosAppStoreID string - -
Price string - -
SalePrice string - -
Subtitle string - -
EntityName string - -
LastModifiedDate datetime - -

DynamicJobsAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
AssetID string Asset → ResourceName -
Address string - -
AndroidAppLink string - -
JobID string - -
JobSubtitle string - -
JobTitle string - -
LocationID string - -
Salary string - -
EntityName string - -
LastModifiedDate datetime - -

DynamicCustomAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
AssetID string Asset → ResourceName -
AndroidAppLink string - -
FormattedPrice string - -
FormattedSalePrice string - -
ImageUrl string - -
Id2 string - -
IosAppLink string - -
IosAppStoreID string - -
ItemAddress string - -
ItemCategory string - -
ItemDescription string - -
ItemSubtitle string - -
ItemTitle string - -
Price string - -
SalePrice string - -
EntityName string - -
LastModifiedDate datetime - -

DynamicEducationAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string Asset → ResourceName -
AndroidAppLink string - -
Address string - -
ImageUrl string - -
IosAppLink string - -
IosAppStoreID string - -
LocationID string - -
ProgramID string - -
ProgramDescription string - -
ProgramName string - -
SchoolName string - -
ThumbnailImageUrl string - -
EntityName string - -
LastModifiedDate datetime - -

DynamicRealEstateAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
AssetID string Asset → ResourceName -
Address string - -
AndroidAppLink string - -
CityName string - -
FormattedPrice string - -
ImageUrl string - -
IosAppLink string - -
IosAppStoreID string - -
ListingID string - -
ListingName string - -
ListingType string - -
PropertyType string - -
Price string - -
EntityName string - -
LastModifiedDate datetime - -

BusinessMessageAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string Asset → ResourceName -
CallToActionDescription string - -
CallToActionSelection string - -
MessageProvider string - -
StarterMessage string - -
WhatsAppInfoCountryCode string - -
WhatsAppInfoPhoneNumber string - -
EntityName string - -
LastModifiedDate datetime - -

CallAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string Asset → ResourceName -
CallConversionAction string - -
CallConversionReportingState string - -
CountryCode string - -
PhoneNumber string - -
EntityName string - -
LastModifiedDate datetime - -

CalloutAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string Asset → ResourceName -
AdScheduleTargets string - -
CalloutText string - -
EndDate datetime - -
StartDate datetime - -
EntityName string - -
LastModifiedDate datetime - -

YoutubeVideoAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string Asset → ResourceName -
YoutubeVideoID string - -
YoutubeVideoTitle string - -
EntityName string - -
LastModifiedDate datetime - -

YoutubeVideoListAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string Asset → ResourceName -
Asset string - -
EntityName string - -
LastModifiedDate datetime - -

PromotionAssetDetail

Column Type Relates to Notes
RemoteID string - -
AssetRemoteID string Asset → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string Asset → ResourceName -
DiscountModifier string - -
EndDate datetime - -
StartDate datetime - -
RedemptionEndDate datetime - -
RedemptionStartDate datetime - -
LanguageCode string - -
PromotionCode string - -
PromotionTarget string - -
TermsAndConditionsText string - -
TermsAndConditionsUri string - -
MoneyOffAmountMicros string - -
MoneyOffAmountCurrencyCode string - -
Occasion string - -
OrdersOverAmountMicros string - -
OrdersOverAmountCurrencyCode string - -
PercentOff int - -
BarcodeContent string - -
BarcodeType string - -
EntityName string - -
LastModifiedDate datetime - -

CallAssetDetailAdSchedule

Column Type Relates to Notes
RemoteID string - -
CallAssetDetailRemoteID string CallAssetDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CallAssetDetailID string CallAssetDetail → RemoteID -
StartMinute string - -
EndMinute string - -
DayOfWeek string - -
StartHour int - -
EndHour int - -
Iterator int - -
EntityName string - -
LastModifiedDate datetime - -

YoutubeVideoAssetDetailYoutubeVideo

Column Type Relates to Notes
RemoteID string - -
YoutubeVideoListAssetDetailRemoteID string YoutubeVideoListAssetDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AssetID string YoutubeVideoListAssetDetail → RemoteID -
YoutubeVideoID string - -
YoutubeVideoTitle string - -
EntityName string - -
LastModifiedDate datetime - -

PromotionAssetDetailAdSchedule

Column Type Relates to Notes
RemoteID string - -
PromotionAssetDetailRemoteID string PromotionAssetDetail → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PromotionAssetDetailID string PromotionAssetDetail → RemoteID -
StartMinute string - -
EndMinute string - -
DayOfWeek string - -
StartHour int - -
EndHour int - -
Iterator int - -
EntityName string - -
LastModifiedDate datetime - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Google Ads data Querying Google Ads using regular SQL