AdWords transfers | BigQuery - Google Cloud

The BigQuery Data Transfer Service for AdWords allows you to automatically schedule and manage recurring load jobs for AdWords reporting data. Overview close Accelerateyourdigitaltransformation Whetheryourbusinessisearlyinitsjourneyorwellonitswaytodigitaltransformation,GoogleCloudcanhelpsolveyourtoughestchallenges. Learnmore Keybenefits WhyGoogleCloud Topreasonsbusinesseschooseus. Multicloud Runyourappswhereveryouneedthem. Trustandsecurity Keepyourdatasecureandcompliant. Globalinfrastructure BuildonthesameinfrastructureasGoogle. DataCloud Makesmarterdecisionswithunifieddata. Opencloud Scalewithopen,flexibletechnology. Sustainability Runonthecleanestcloudintheindustry. Productivityandcollaboration ConnectyourteamswithAI-poweredapps. Solutions close IndustrySolutions Reducecost,increaseoperationalagility,andcapturenewmarketopportunities. Retail Analyticsandcollaborationtoolsfortheretailvaluechain. ConsumerPackagedGoods SolutionsforCPGdigitaltransformationandbrandgrowth. FinancialServices Computing,datamanagement,andanalyticstoolsforfinancialservices. HealthcareandLifeSciences Advanceresearchatscaleandempowerhealthcareinnovation. MediaandEntertainment Solutionsforcontentproductionanddistributionoperations. Telecommunications Hybridandmulti-cloudservicestodeployandmonetize5G. Gaming AI-drivensolutionstobuildandscalegamesfaster. Manufacturing MigrationandAItoolstooptimizethemanufacturingvaluechain. SupplyChainandLogistics Digitalsupplychainsolutionsbuiltinthecloud. Government Datastorage,AI,andanalyticssolutionsforgovernmentagencies. Education Teachingtoolstoprovidemoreengaginglearningexperiences. Notseeingwhatyou'relookingfor? Seeallindustrysolutions Notseeingwhatyou'relookingfor? Seeallsolutions ApplicationModernization Assess,plan,implement,andmeasuresoftwarepracticesandcapabilitiestomodernizeandsimplifyyourorganization’sbusinessapplicationportfolios. CAMP ProgramthatusesDORAtoimproveyoursoftwaredeliverycapabilities. ModernizeTraditionalApplications Analyze,categorize,andgetstartedwithcloudmigrationontraditionalworkloads. MigratefromPaaS:CloudFoundry,Openshift ToolsformovingyourexistingcontainersintoGoogle'smanagedcontainerservices. MigratefromMainframe Automatedtoolsandprescriptiveguidanceformovingyourmainframeappstothecloud. ModernizeSoftwareDelivery Softwaresupplychainbestpractices-innerloopproductivity,CI/CDandS3C. DevOpsBestPractices ProcessesandresourcesforimplementingDevOpsinyourorg. SREPrinciples ToolsandresourcesforadoptingSREinyourorg. Day2OperationsforGKE ToolsandguidanceforeffectiveGKEmanagementandmonitoring. FinOpsandOptimizationofGKE Bestpracticesforrunningreliable,performant,andcosteffectiveapplicationsonGKE. RunApplicationsattheEdge GuidanceforlocalizedandlowlatencyappsonGoogle’shardwareagnosticedgesolution. ArchitectforMulticloud Manageworkloadsacrossmultiplecloudswithaconsistentplatform. GoServerless Fullymanagedenvironmentfordeveloping,deployingandscalingapps. ArtificialIntelligence AddintelligenceandefficiencytoyourbusinesswithAIandmachinelearning. ContactCenterAI AImodelforspeakingwithcustomersandassistinghumanagents. DocumentAI Documentprocessinganddatacaptureautomatedatscale. ProductDiscovery Google-qualitysearchandproductrecommendationsforretailers. APIsandApplications Speedupthepaceofinnovationwithoutcoding,usingAPIs,apps,andautomation. NewBusinessChannelsUsingAPIs Attractandempoweranecosystemofdevelopersandpartners. UnlockingLegacyApplicationsUsingAPIs Cloudservicesforextendingandmodernizinglegacyapps. OpenBankingAPIx SimplifyandacceleratesecuredeliveryofopenbankingcompliantAPIs. Databases Migrateandmanageenterprisedatawithsecurity,reliability,highavailability,andfullymanageddataservices. DatabaseMigration Guidesandtoolstosimplifyyourdatabasemigrationlifecycle. DatabaseModernization Upgradestomodernizeyouroperationaldatabaseinfrastructure. GoogleCloudDatabases Databaseservicestomigrate,manage,andmodernizedata. MigrateOracleworkloadstoGoogleCloud Rehost,replatform,rewriteyourOracleworkloads. OpenSourceDatabases Fullymanagedopensourcedatabaseswithenterprise-gradesupport. SQLServeronGoogleCloud OptionsforrunningSQLServervirtualmachinesonGoogleCloud. DataCloud Unifydataacrossyourorganizationwithanopenandsimplifiedapproachtodata-driventransformationthatisunmatchedforspeed,scale,andsecuritywithAIbuilt-in. DatabasesSolutions Migrateandmanageenterprisedatawithsecurity,reliability,highavailability,andfullymanageddataservices. SmartAnalyticsSolutions Generateinstantinsightsfromdataatanyscalewithaserverless,fullymanagedanalyticsplatformthatsignificantlysimplifiesanalytics. AISolutions AddintelligenceandefficiencytoyourbusinesswithAIandmachinelearning. DataCloudforISVs Innovate,optimizeandamplifyyourSaaSapplicationsusingGoogle'sdataandmachinelearningsolutionssuchasBigQuery,Looker,SpannerandVertexAI. DataCloudAlliance Aninitiativetoensurethatglobalbusinesseshavemoreseamlessaccessandinsightsintothedatarequiredfordigitaltransformation. DigitalTransformation Acceleratebusinessrecoveryandensureabetterfuturewithsolutionsthatenablehybridandmulti-cloud,generateintelligentinsights,andkeepyourworkersconnected. DigitalInnovation Reimagineyouroperationsandunlocknewopportunities. OperationalEfficiency Prioritizeinvestmentsandoptimizecosts. COVID-19Solutions Getworkdonemoresafelyandsecurely. COVID-19SolutionsfortheHealthcareIndustry HowGoogleishelpinghealthcaremeetextraordinarychallenges. InfrastructureModernization MigratequicklywithsolutionsforSAP,VMware,Windows,Oracle,andotherworkloads. ApplicationMigration Discoveryandanalysistoolsformovingtothecloud. SAPonGoogleCloud CertificationsforrunningSAPapplicationsandSAPHANA. HighPerformanceComputing Compute,storage,andnetworkingoptionstosupportanyworkload. WindowsonGoogleCloud ToolsandpartnersforrunningWindowsworkloads. DataCenterMigration MigrationsolutionsforVMs,apps,databases,andmore. ActiveAssist Automaticcloudresourceoptimizationandincreasedsecurity. VirtualDesktops Remoteworksolutionsfordesktopsandapplications(VDI&DaaS). RapidAssessment&MigrationProgram(RAMP) End-to-endmigrationprogramtosimplifyyourpathtothecloud. BackupandDisasterRecovery Ensureyourbusinesscontinuityneedsaremet. ProductivityandCollaboration Changethewayteamsworkwithsolutionsdesignedforhumansandbuiltforimpact. GoogleWorkspace Collaborationandproductivitytoolsforenterprises. GoogleWorkspaceEssentials Securevideomeetingsandmoderncollaborationforteams. CloudIdentity UnifiedplatformforITadminstomanageuserdevicesandapps. ChromeEnterprise ChromeOS,ChromeBrowser,andChromedevicesbuiltforbusiness. CloudSearch Enterprisesearchforemployeestoquicklyfindcompanyinformation. Security Detect,investigate,andrespondtoonlinethreatstohelpprotectyourbusiness. SecurityAnalyticsandOperations Solutionforanalyzingpetabytesofsecuritytelemetry. WebAppandAPIProtection ThreatandfraudprotectionforyourwebapplicationsandAPIs. SecurityandResilienceFramework Solutionsforeachphaseofthesecurityandresiliencelifecycle. Riskandcomplianceascode(RCaC) Solutiontomodernizeyourgovernance,risk,andcompliancefunctionwithautomation. SoftwareSupplyChainSecurity Solutionforimprovingend-to-endsoftwaresupplychainsecurity. SmartAnalytics Generateinstantinsightsfromdataatanyscalewithaserverless,fullymanagedanalyticsplatformthatsignificantlysimplifiesanalytics. DataWarehouseModernization Datawarehousetojumpstartyourmigrationandunlockinsights. DataLakeModernization Servicesforbuildingandmodernizingyourdatalake. SparkonGoogleCloud RunandwriteSparkwhereyouneedit,serverlessandintegrated. StreamAnalytics Insightsfromingesting,processing,andanalyzingeventstreams. BusinessIntelligence SolutionsformodernizingyourBIstackandcreatingrichdataexperiences. DataScience PutyourdatatoworkwithDataScienceonGoogleCloud. MarketingAnalytics Solutionsforcollecting,analyzing,andactivatingcustomerdata. GeospatialAnalyticsandAI Solutionsforbuildingamoreprosperousandsustainablebusiness. Datasets DatafromGoogle,public,andcommercialproviderstoenrichyouranalyticsandAIinitiatives. StartupsandSMB AcceleratestartupandSMBgrowthwithtailoredsolutionsandprograms. StartupSolutions GrowyourstartupandsolveyourtoughestchallengesusingGoogle’sproventechnology. StartupProgram Getfinancial,business,andtechnicalsupporttotakeyourstartuptothenextlevel. SmallandMediumBusiness Exploresolutionsforwebhosting,appdevelopment,AI,andanalytics. SoftwareasaService BuildbetterSaaSproducts,scaleefficiently,andgrowyourbusiness. Products close FeaturedProducts ComputeEngine VirtualmachinesrunninginGoogle’sdatacenter. CloudStorage Objectstoragethat’ssecure,durable,andscalable. CloudSDK Command-linetoolsandlibrariesforGoogleCloud. CloudSQL RelationaldatabaseserviceforMySQL,PostgreSQLandSQLServer. GoogleKubernetesEngine Managedenvironmentforrunningcontainerizedapps. BigQuery Datawarehouseforbusinessagilityandinsights. CloudCDN Contentdeliverynetworkfordeliveringwebandvideo. Dataflow Streaminganalyticsforstreamandbatchprocessing. Operations Monitoring,logging,andapplicationperformancesuite. CloudRun Fullymanagedenvironmentforrunningcontainerizedapps. Anthos Platformformodernizingexistingappsandbuildingnewones. Notseeingwhatyou'relookingfor? Seeallproducts(100+) AIandMachineLearning VertexAI Unifiedplatformfortraining,running,andmanagingMLmodels. VertexAIWorkbench SingleinterfacefortheentireDataScienceworkflow. AIInfrastructure OptionsfortrainingdeeplearningandMLmodelscost-effectively. AutoML Custommachinelearningmodeldevelopment,withminimaleffort. NaturalLanguageAI Sentimentanalysisandclassificationofunstructuredtext. Speech-to-Text Speechrecognitionandtranscriptionacross125languages. Text-to-Speech Speechsynthesisin220+voicesand40+languages. TranslationAI Languagedetection,translation,andglossarysupport. VideoAI Videoclassificationandrecognitionusingmachinelearning. VisionAI Customandpre-trainedmodelstodetectemotion,text,andmore. Dialogflow LifelikeconversationalAIwithstate-of-the-artvirtualagents. Notseeingwhatyou'relookingfor? SeeallAIandmachinelearningproducts APIManagement ApigeeAPIManagement ManagethefulllifecycleofAPIsanywherewithvisibilityandcontrol. ApigeeIntegration API-firstintegrationtoconnectexistingdataandapplications. CloudHealthcareAPI SolutiontobridgeexistingcaresystemsandappsonGoogleCloud. AppSheet No-codedevelopmentplatformtobuildandextendapplications. APIGateway Develop,deploy,secure,andmanageAPIswithafullymanagedgateway. Compute ComputeEngine VirtualmachinesrunninginGoogle’sdatacenter. AppEngine Serverlessapplicationplatformforappsandbackends. CloudGPUs GPUsforML,scientificcomputing,and3Dvisualization. MigratetoVirtualMachines ServerandvirtualmachinemigrationtoComputeEngine. SpotVMs Computeinstancesforbatchjobsandfault-tolerantworkloads. ShieldedVMs ReinforcedvirtualmachinesonGoogleCloud. Sole-TenantNodes Dedicatedhardwareforcompliance,licensing,andmanagement. BareMetal InfrastructuretorunspecializedworkloadsonGoogleCloud. Recommender UsagerecommendationsforGoogleCloudproductsandservices. VMwareEngine Fullymanaged,nativeVMwareCloudFoundationsoftwarestack. CloudRun Fullymanagedenvironmentforrunningcontainerizedapps. Notseeingwhatyou'relookingfor? Seeallcomputeproducts Containers GoogleKubernetesEngine Managedenvironmentforrunningcontainerizedapps. ContainerRegistry Registryforstoring,managing,andsecuringDockerimages. ContainerSecurity Containerenvironmentsecurityforeachstageofthelifecycle. CloudBuild SolutionforrunningbuildstepsinaDockercontainer. DeepLearningContainers Containerswithdatascienceframeworks,libraries,andtools. KubernetesApplications Containerizedappswithprebuiltdeploymentandunifiedbilling. ArtifactRegistry Packagemanagerforbuildartifactsanddependencies. Knative ComponentstocreateKubernetes-nativecloud-basedsoftware. CloudRun Fullymanagedenvironmentforrunningcontainerizedapps. CloudCode IDEsupporttowrite,run,anddebugKubernetesapplications. DataAnalytics BigQuery Datawarehouseforbusinessagilityandinsights. Looker PlatformforBI,dataapplications,andembeddedanalytics. Dataflow Streaminganalyticsforstreamandbatchprocessing. Pub/Sub Messagingserviceforeventingestionanddelivery. Dataproc ServiceforrunningApacheSparkandApacheHadoopclusters. CloudDataFusion Dataintegrationforbuildingandmanagingdatapipelines. CloudComposer WorkfloworchestrationservicebuiltonApacheAirflow. Dataprep Servicetopreparedataforanalysisandmachinelearning. Dataplex Intelligentdatafabricforunifyingdatamanagementacrosssilos. DataCatalog Metadataservicefordiscovering,understanding,andmanagingdata. AnalyticsHub Serviceforsecurelyandefficientlyexchangingdataanalyticsassets. Notseeingwhatyou'relookingfor? Seealldataanalyticsproducts Databases AlloyDBforPostgreSQL Fullymanaged,PostgreSQL-compatibledatabasefordemandingenterpriseworkloads. CloudBigtable Cloud-nativewide-columndatabaseforlargescale,low-latencyworkloads. Firestore Cloud-nativedocumentdatabaseforbuildingrichmobile,web,andIoTapps. Memorystore In-memorydatabaseformanagedRedisandMemcached. CloudSpanner Cloud-nativerelationaldatabasewithunlimitedscaleand99.999%availability. CloudSQL FullymanageddatabaseforMySQL,PostgreSQL,andSQLServer. DatabaseMigrationService Serverless,minimaldowntimemigrationstothecloud. BareMetalSolutionforOracle InfrastructuretorunspecializedOracleworkloadsonGoogleCloud. FirebaseRealtimeDatabase NoSQLdatabaseforstoringandsyncingdatainrealtime. Datastream Serverlesschangedatacaptureandreplicationservice. DeveloperTools ArtifactRegistry Universalpackagemanagerforbuildartifactsanddependencies. CloudBuild Continuousintegrationandcontinuousdeliveryplatform. CloudCode IDEsupporttowrite,run,anddebugKubernetesapplications. CloudDeploymentManager ServiceforcreatingandmanagingGoogleCloudresources. gcloudCLI CommandlinetoolsandlibrariesforGoogleCloud. CloudScheduler Cronjobschedulerfortaskautomationandmanagement. CloudSourceRepositories PrivateGitrepositorytostore,manage,andtrackcode. CloudTasks Taskmanagementserviceforasynchronoustaskexecution. GoogleCloudDeploy FullymanagedcontinuousdeliverytoGoogleKubernetesEngine. Tekton Kubernetes-nativeresourcesfordeclaringCI/CDpipelines. ToolsforPowerShell FullcloudcontrolfromWindowsPowerShell. Notseeingwhatyou'relookingfor? Seealldevelopertools HealthcareandLifeSciences ApigeeHealthcareAPIx FHIRAPI-baseddigitalserviceproduction. CloudHealthcareAPI SolutionforbridgingexistingcaresystemsandappsonGoogleCloud. CloudLifeSciences Toolsformanaging,processing,andtransformingbiomedicaldata. DeviceConnectforFitbit Gaina360-degreepatientviewwithconnectedFitbitdataonGoogleCloud. HealthcareNaturalLanguageAI Real-timeinsightsfromunstructuredmedicaltext. HybridandMulticloud Anthos Platformformodernizingexistingappsandbuildingnewones. Looker PlatformforBI,dataapplications,andembeddedanalytics. CloudRunforAnthos IntegrationthatprovidesaserverlessdevelopmentplatformonGKE. GoogleCloudMarketplaceforAnthos Containerizedappswithprebuiltdeploymentandunifiedbilling. MigratetoContainers TooltomoveworkloadsandexistingapplicationstoGKE. Operations Monitoring,logging,andapplicationperformancesuite. CloudBuild ServiceforexecutingbuildsonGoogleCloudinfrastructure. TrafficDirector Trafficcontrolpaneandmanagementforopenservicemesh. ApigeeAPIManagement APImanagement,development,andsecurityplatform. GoogleDistributedCloud Fullymanagedsolutionsfortheedgeanddatacenters. InternetofThings CloudIoTCore IoTdevicemanagement,integration,andconnectionservice. EdgeTPU ASICdesignedtorunMLinferenceandAIattheedge. ManagementTools AnthosConfigManagement Automatepolicyandsecurityforyourdeployments. CarbonFootprint DashboardtoviewandexportGoogleCloudcarbonemissionsreports. CloudAPIs ProgrammaticinterfacesforGoogleCloudservices. Cloudconsole Web-basedinterfaceformanagingandmonitoringcloudapps. CloudMobileApp ApptomanageGoogleCloudservicesfromyourmobiledevice. CloudShell Interactiveshellenvironmentwithabuilt-incommandline. ConfigConnector Kubernetesadd-onformanagingGoogleCloudresources. CostManagement Toolsformonitoring,controlling,andoptimizingyourcosts. IntelligentManagement Toolsforeasilymanagingperformance,security,andcost. PrivateCatalog Servicecatalogforadminsmanaginginternalenterprisesolutions. TerraformonGoogleCloud OpensourcetooltoprovisionGoogleCloudresourceswithdeclarativeconfigurationfiles. MediaandGaming GameServers GameservermanagementservicerunningonGoogleKubernetesEngine. LiveStreamAPI Servicetoconvertlivevideoandpackageforstreaming. OpenCue Opensourcerendermanagerforvisualeffectsandanimation. TranscoderAPI Convertvideofilesandpackagethemforoptimizeddelivery. VideoStitcherAPI Servicefordynamicorserver-sideadinsertion. Migration ApplicationMigration Appmigrationtothecloudforlow-costrefreshcycles. BigQueryDataTransferService DataimportserviceforschedulingandmovingdataintoBigQuery. CloudFoundationToolkit ReferencetemplatesforDeploymentManagerandTerraform. DatabaseMigrationService Serverless,minimaldowntimemigrationstothecloud. MigratetoContainers ComponentsformigratingVMsintosystemcontainersonGKE. MigratetoVirtualMachines ComponentsformigratingVMsandphysicalserverstoComputeEngine. RapidAssessment&MigrationProgram(RAMP) End-to-endmigrationprogramtosimplifyyourpathtothecloud. TransferAppliance StorageserverformovinglargevolumesofdatatoGoogleCloud. StorageTransferService Datatransfersfromonlineandon-premisessourcestoCloudStorage. VMwareEngine MigrateandrunyourVMwareworkloadsnativelyonGoogleCloud. Networking CloudArmor SecuritypoliciesanddefenseagainstwebandDDoSattacks. CloudCDN Contentdeliverynetworkforservingwebandvideocontent. CloudDNS Domainnamesystemforreliableandlow-latencynamelookups. CloudLoadBalancing Servicefordistributingtrafficacrossapplicationsandregions. CloudNAT NATserviceforgivingprivateinstancesinternetaccess. HybridConnectivity ConnectivityoptionsforVPN,peering,andenterpriseneeds. NetworkConnectivityCenter Connectivitymanagementtohelpsimplifyandscalenetworks. NetworkIntelligenceCenter Networkmonitoring,verification,andoptimizationplatform. NetworkServiceTiers Cloudnetworkoptionsbasedonperformance,availability,andcost. TrafficDirector Trafficcontrolpaneandmanagementforopenservicemesh. Notseeingwhatyou'relookingfor? Seeallnetworkingproducts Operations CloudLogging GoogleCloudaudit,platform,andapplicationlogsmanagement. CloudMonitoring Infrastructureandapplicationhealthwithrichmetrics. ErrorReporting Applicationerroridentificationandanalysis. KubernetesEngineMonitoring GKEappdevelopmentandtroubleshooting. CloudTrace Tracingsystemcollectinglatencydatafromapplications. CloudProfiler CPUandheapprofilerforanalyzingapplicationperformance. CloudDebugger Real-timeapplicationstateinspectionandin-productiondebugging. IntelligentOperations Toolsforeasilyoptimizingperformance,security,andcost. SecurityandIdentity CloudIAM PermissionsmanagementsystemforGoogleCloudresources. AssuredWorkloads Complianceandsecuritycontrolsforsensitiveworkloads. CloudKeyManagement ManageencryptionkeysonGoogleCloud. ConfidentialComputing EncryptdatainusewithConfidentialVMs. SecurityCommandCenter PlatformfordefendingagainstthreatstoyourGoogleCloudassets. CloudDataLossPrevention Sensitivedatainspection,classification,andredactionplatform. ManagedServiceforMicrosoftActiveDirectory HardenedservicerunningMicrosoft®ActiveDirectory(AD). AccessTransparency Cloudprovidervisibilitythroughnearreal-timelogs. TitanSecurityKey Two-factorauthenticationdeviceforuseraccountprotection. SecretManager StoreAPIkeys,passwords,certificates,andothersensitivedata. BeyondCorpEnterprise Zerotrustsolutionforsecureapplicationandresourceaccess. Notseeingwhatyou'relookingfor? Seeallsecurityandidentityproducts ServerlessComputing CloudRun Fullymanagedenvironmentforrunningcontainerizedapps. CloudFunctions Platformforcreatingfunctionsthatrespondtocloudevents. AppEngine Serverlessapplicationplatformforappsandbackends. Workflows WorkfloworchestrationforserverlessproductsandAPIservices. Storage AllStorageProducts Cloud-basedstorageservicesforyourbusiness. CloudStorage Objectstoragethat’ssecure,durable,andscalable. Filestore Filestoragethatishighlyscalableandsecure. PersistentDisk BlockstorageforvirtualmachineinstancesrunningonGoogleCloud. CloudStorageforFirebase Objectstorageforstoringandservinguser-generatedcontent. LocalSSD Blockstoragethatislocallyattachedforhigh-performanceneeds. StorageTransferService Datatransfersfromonlineandon-premisessourcestoCloudStorage. GoogleWorkspaceEssentials Securevideomeetingsandmoderncollaborationforteams. GoogleCloudBackupandDR Managedbackupanddisasterrecoveryforapplication-consistentdataprotection. Pricing close Savemoneywithourtransparentapproachtopricing GoogleCloud'spay-as-you-gopricingoffersautomaticsavingsbasedonmonthlyusageanddiscountedratesforprepaidresources.Contactustodaytogetaquote. Requestaquote PricingOverview GoogleCloudpricing Payonlyforwhatyouusewithnolock-in. Pricingcalculator Calculateyourcloudsavings. GoogleCloudFreeProgram $300infreecreditsand20+freeproducts. Product-specificPricing ComputeEngine CloudSQL GoogleKubernetesEngine CloudStorage BigQuery Seefullpricelistwith100+products Resources close Self-serviceResources GoogleCloudFreeProgram $300infreecreditsand20+freeproducts. Onboardingessentials Getquickstartsandreferencearchitectures. DeveloperCenter Stayintheknowandbecomeaninnovator. GoogleCloudcertification Prepareandregisterforcertifications. Events BrowseupcomingGoogleCloudevents. Blog Readourlatestproductnewsandstories. Customerstories Explorecasestudiesandvideos. Analystreports Readwhatindustryanalystssayaboutus. Experthelpandtraining Consulting Partnerwithourexpertsoncloudprojects. TechnicalAccountManagement GetongoingguidancefromGoogle. Training Enrollinon-demandorclassroomtraining. GoogleCloudCommunity Askquestions,findanswers,andconnect. Partnersandthird-partytools GoogleCloudpartners Explorebenefitsofworkingwithapartner. Becomeapartner JointhePartnerAdvantageprogram. GoogleCloudMarketplace Deployready-to-gosolutionsinafewclicks. Docs Support Docs Support English Deutsch Español–AméricaLatina Français Italiano Português–Brasil 中文–简体 日本語 한국어 Signin BigQuery Overview Guides Reference Samples Support Resources ContactUs Getstartedforfree Overview More Solutions More Products More Pricing More Resources More Docs Overview Guides Reference Samples Support Resources Support Console ContactUs Getstartedforfree Discover WhatisBigQuery? BigQueryBigQueryMLBigQueryOmni HowdoesBigQuerywork? StorageAnalyticsAdministration Getstarted UsetheBigQuerysandbox Quickstarts Allquickstarts TrytheCloudconsole QuerypublicdataLoadandquerydataExploretheconsole Trythecommand-linetool QuerypublicdataLoadandquerydataExplorethecommand-linetoolTrytheclientlibrary Learnmoreabouttheconsole GeospatialanalyticsMachinelearningPublicdatasets Migrate Overview Migrateadatawarehouse IntroductiontoBigQueryMigrationServiceMigrationassessmentMigrateschemaanddataMigratedatapipelines MigrateSQL MigrateSQLcodeMapSQLobjectnamesGeneratemetadatafortranslationTranslatequeries Migrationguides AmazonRedshift MigrationoverviewMigrateAmazonRedshiftschemaanddataMigrateAmazonRedshiftschemaanddatawhenusingaVPCSQLtranslationreference IBMNetezza MigratefromIBMNetezzaSQLtranslationreference Oracle MigrationguideSQLtranslationreference Snowflake MigrationguideSQLtranslationreference Teradata MigrationoverviewMigrateTeradataschemaanddataMigrationtutorialSQLtranslationreference Design Organizeresources Managedatasets IntroductionDatasetlocationsCreatedatasetsCopydatasetsMovedatasetsListdatasetsGetinformationaboutdatasetsUpdatedatasetpropertiesManagedatasetsAvailabilityanddurability Managetables IntroductionCreateandusetablesManagetablesManagetabledataModifytabledatawithDMLWorkwithchangehistoryExporttabledata Specifytableschemas SpecifyaschemaSpecifynestedandrepeatedcolumnsAuto-detectschemasModifytableschemasSpecifydefaultcolumnvalues Segmentwithpartitionedtables IntroductionCreatepartitionedtablesManagepartitionedtablesManagepartitionedtabledataQuerypartitionedtablesUseDMLwithpartitionedtables Optimizewithclusteredtables IntroductionCreateanduseclusteredtablesQueryclusteredtables Workwithroutines ManageroutinesUser-definedfunctionsTablefunctionsRemotefunctionsStoredprocedures Load Introduction BigQueryDataTransferService IntroductionDatalocationandtransfersEnablingtheBigQueryDataTransferServiceTransferrunnotificationsWorkingwithtransfersUseserviceaccountsUsingthird-partytransfers Transferguides AmazonS3transfers OverviewofAmazonS3transfersUsingruntimeparametersintransfersAmazonS3transfers CampaignManagertransfers CampaignManagertransfersCampaignManagerreporttransformation CloudStoragetransfers OverviewofCloudStoragetransfersUsingruntimeparametersintransfersCloudStoragetransfers GoogleAdManagertransfers GoogleAdManagertransfersGoogleAdManagerreporttransformation GoogleAdstransfers AdWordstransfersAdWordsreporttransformationGoogleAdstransfersGoogleAdsreporttransformation GoogleMerchantCentertransfers GoogleMerchantCentertransfersGoogleMerchantCenterlocalinventoriestableschemaGoogleMerchantCenterpricebenchmarkstableschemaGoogleMerchantCenterproductinventorytableschemaGoogleMerchantCenterproductstableschemaGoogleMerchantCenterregionalinventoriestableschemaGoogleMerchantCentertopbrandstableschemaGoogleMerchantCentertopproductstableschema GooglePlaytransfers GooglePlaytransfersGooglePlayreporttransformation SearchAds360transfers SearchAds360transfersSearchAds360reporttransformation YouTubechannel YouTubechanneltransfersYouTubechannelreporttransformation YouTubecontentowner YouTubecontentownertransfersYouTubecontentownerreporttransformation Batchloaddata BatchloaddataLoadAvrodataLoadParquetdataLoadORCdataLoadCSVdataLoadJSONdataLoadexternallypartitioneddataLoaddatafromaDatastoreexportLoaddatafromaFirestoreexportLoaddatafromthird-partyapplications Analyze Introduction QueryBigQuerydata RuninteractiveandbatchqueriesPerformaquerydryrunWritequeryresultsUsecachedresultsRunparameterizedqueriesQuerydatausingawildcardtableAccesshistoricaldataSaveandsharequeriesSchedulequeriesUsethequeryplanexplanation QuerydatawithSQL IntroductionArraysJSONdataSketchesMulti-statementqueriesTablesamplingTransactionsWildcardtables Queryexternaldatasources Introduction BigLaketables IntroductiontoBigLaketablesCreateandmanageBigLaketables QueryAWSwithBigQueryOmni IntroductionConnecttoAWSQueryAmazonS3dataExportqueryresultstoAmazonS3TransferAWSdatatoBigQuerySetupVPCServiceControls QueryAzurewithBigQueryOmni IntroductionConnecttoAzureQueryAzureStoragedataExportqueryresultstoAzurestorageTransferAzuredatatoBigQuerySetupVPCServiceControls Externalconnections IntroductiontotheBigQueryConnectionAPIWorkwithconnections Federatedqueries IntroductiontofederatedqueriesQueryCloudSQLdataQueryCloudSpannerdata Externaltables IntroductiontoexternaltablesCreateatabledefinitionfileQueryCloudBigtabledata QueryCloudStoragedata OverviewQueryexternallypartitioneddataQueryGoogleDrivedata Workwithsessions IntroductionCreatesessionsWritequeriesinsessionsRunqueriesinsessionsTerminatesessionsViewqueryhistoryinsessionsFindsessions Workwithviews IntroductionCreateviewsListviewsGetinformationaboutviewsUpdatingviewpropertiesManageviews Workwithmaterializedviews IntroductionCreatematerializedviewsUsematerializedviewsManagematerializedviews Usegeospatialanalytics IntroductionWorkwithgeospatialanalyticsVisualizegeospatialdata BigQuerygeospatialdatatutorials Usegeospatialanalyticstoplotahurricane'spathBigQuerygeospatialdatasyntaxreference AcceleratewithBIEngine IntroductionPreferredtablesUseDataStudioUseLookerUseTableauReservecapacityMonitorBIEngineBIEngineSQLinterfaceOptimizedfunctions Useanalysisandbusinessintelligencetools IntroductionUseConnectedSheetsUseLookerUseDataStudioUseODBCandJDBCdrivers Programmatictools UseprogrammaticanalysistoolsVisualizeinJupyternotebooksUsethird-partytools BigQueryReadypartners OverviewBigQueryReadypartners SharewithAnalyticsHub IntroductionManagedataexchangesManagelistingsConfigureuserrolesViewandsubscribetolistingsSetupVPCServiceControls SearchinBigQuery IntroductionCreateasearchindexDeleteasearchindexSearchwithanindex Administer Introduction Manageworkloads Runandmanagejobs JobsoverviewRunjobsprogrammaticallyManagejobsManagedefaultconfigurationsUsequeryqueues Manageworkloadswithreservations Introduction Understandreservations SlotsCapacitycommitmentplansWorkloadmanagement Usereservations GetstartedEstimateslotcapacityrequirementsViewslotrecommendationsandinsightsPurchaseandmanageslotcapacityWorkwithslotreservationsWorkwithreservationassignments Monitorworkloads IntroductionCreatechartsandalertsUseadministrativeresourcechartsMonitorreservationsMonitorDataTransferServiceViewDataTransferServicelogs Auditworkloads AuditpolicytagsViewDataPolicyauditlogsBigQueryauditlogsreferenceMigrateauditlogsDataTransferServiceauditlogsAnalyticsHubauditlogging Manageresources LabelBigQueryresources IntroductionAddlabelsViewlabelsUpdatelabelsFilterusinglabelsDeletelabelsViewresourcemetadatawithINFORMATION_SCHEMAUseDataCatalog Makecopieswithtableclones IntroductionCreatetableclones Backupdatawithtablesnapshots IntroductionCreatetablesnapshotsRestoretablesnapshotsListtablesnapshotsViewtablesnapshotmetadataUpdatetablesnapshotmetadataCopytablesnapshotsDeletetablesnapshotsCreateperiodictablesnapshots Optimizeresources Controlcosts IntroductionEstimatestorageandquerycostsCustomcostcontrolsBestpracticesforcontrollingcosts Querybestpractices IntroductionUsenestedandrepeateddataFilteringandorderingFunctionsReducedataprocessedinqueriesOptimizequerycomputationManagequeryoutputsAvoidSQLanti-patternsOptimizestorage Understandreliability IntroductionImportreliabilityQueryreliabilityReadreliabilityDisasterplanning Govern Introduction Dataprotectionandgovernancefeatures Controlaccesstoresources Accesscontrolrolesandpermissions AccesscontrolwithIAMAccesscontrolexamples Accesscontrolbyresourcelevel Controlaccesstodatasets IntroductionControldatasetaccesswithtags Controlaccesstotables IntroductionControlaccesstotablesandviewsFAQControlaccesstoviews Accesscontrolbyauthorization AuthorizedviewsCreateauthorizedviewtutorialAuthorizeddatasetsAuthorizedfunctions Controldataaccessusingclassification UseCloudDLP Controlaccesstotablecolumns Introductiontocolumn-levelaccesscontrolRestrictaccesswithcolumn-levelaccesscontrolImpactonwrites Maskdataintablecolumns IntroductiontodynamicdatamaskingDynamicallymaskcolumndata Managepolicytags ManagepolicytagsacrosslocationsBestpracticesforusingpolicytags Controlaccesstotablerows Introductiontorow-levelsecurityWorkwithrow-levelsecurityUserow-levelsecuritywithotherBigQueryfeaturesBestpracticesforrow-levelsecurity Manageencryption EncryptionatrestCustomer-managedencryptionkeysSQLcolumnencryptionwithKMSkeysAEADencryption Develop BigQueryAPIbasics BigQueryAPIsandlibrariesoverview Authentication IntroductionGetstartedAuthenticateusingaserviceaccountkeyfileAuthenticateasanenduserAuthorizeAPIrequestsPagingthroughtablesAPIperformancetipsBatchrequests UseAPIstoreadorwriteBigQuerydata ReadtabledatawiththeStorageReadAPI IngesttabledatawiththeStorageWriteAPI OverviewoftheStorageWriteAPIStreamdatausingtheStorageWriteAPIBatchloaddatausingtheStorageWriteAPIBestpracticesUsethelegacystreamingAPI UsePythonlibraries Comparisonwithpandas-gbqMigratefromthedatalabPythonpackage Codesamples AllBigQuerycodesamplesAllcodesamplesforallproducts Accelerateyourdigitaltransformation Learnmore Keybenefits WhyGoogleCloud Multicloud Trustandsecurity Globalinfrastructure DataCloud Opencloud Sustainability Productivityandcollaboration IndustrySolutions Retail ConsumerPackagedGoods FinancialServices HealthcareandLifeSciences MediaandEntertainment Telecommunications Gaming Manufacturing SupplyChainandLogistics Government Education Seeallindustrysolutions Seeallsolutions ApplicationModernization CAMP ModernizeTraditionalApplications MigratefromPaaS:CloudFoundry,Openshift MigratefromMainframe ModernizeSoftwareDelivery DevOpsBestPractices SREPrinciples Day2OperationsforGKE FinOpsandOptimizationofGKE RunApplicationsattheEdge ArchitectforMulticloud GoServerless ArtificialIntelligence ContactCenterAI DocumentAI ProductDiscovery APIsandApplications NewBusinessChannelsUsingAPIs UnlockingLegacyApplicationsUsingAPIs OpenBankingAPIx Databases DatabaseMigration DatabaseModernization GoogleCloudDatabases MigrateOracleworkloadstoGoogleCloud OpenSourceDatabases SQLServeronGoogleCloud DataCloud DatabasesSolutions SmartAnalyticsSolutions AISolutions DataCloudforISVs DataCloudAlliance DigitalTransformation DigitalInnovation OperationalEfficiency COVID-19Solutions COVID-19SolutionsfortheHealthcareIndustry InfrastructureModernization ApplicationMigration SAPonGoogleCloud HighPerformanceComputing WindowsonGoogleCloud DataCenterMigration ActiveAssist VirtualDesktops RapidAssessment&MigrationProgram(RAMP) BackupandDisasterRecovery ProductivityandCollaboration GoogleWorkspace GoogleWorkspaceEssentials CloudIdentity ChromeEnterprise CloudSearch Security SecurityAnalyticsandOperations WebAppandAPIProtection SecurityandResilienceFramework Riskandcomplianceascode(RCaC) SoftwareSupplyChainSecurity SmartAnalytics DataWarehouseModernization DataLakeModernization SparkonGoogleCloud StreamAnalytics BusinessIntelligence DataScience MarketingAnalytics GeospatialAnalyticsandAI Datasets StartupsandSMB StartupSolutions StartupProgram SmallandMediumBusiness SoftwareasaService FeaturedProducts ComputeEngine CloudStorage CloudSDK CloudSQL GoogleKubernetesEngine BigQuery CloudCDN Dataflow Operations CloudRun Anthos Seeallproducts(100+) AIandMachineLearning VertexAI VertexAIWorkbench AIInfrastructure AutoML NaturalLanguageAI Speech-to-Text Text-to-Speech TranslationAI VideoAI VisionAI Dialogflow SeeallAIandmachinelearningproducts APIManagement ApigeeAPIManagement ApigeeIntegration CloudHealthcareAPI AppSheet APIGateway Compute ComputeEngine AppEngine CloudGPUs MigratetoVirtualMachines SpotVMs ShieldedVMs Sole-TenantNodes BareMetal Recommender VMwareEngine CloudRun Seeallcomputeproducts Containers GoogleKubernetesEngine ContainerRegistry ContainerSecurity CloudBuild DeepLearningContainers KubernetesApplications ArtifactRegistry Knative CloudRun CloudCode DataAnalytics BigQuery Looker Dataflow Pub/Sub Dataproc CloudDataFusion CloudComposer Dataprep Dataplex DataCatalog AnalyticsHub Seealldataanalyticsproducts Databases AlloyDBforPostgreSQL CloudBigtable Firestore Memorystore CloudSpanner CloudSQL DatabaseMigrationService BareMetalSolutionforOracle FirebaseRealtimeDatabase Datastream DeveloperTools ArtifactRegistry CloudBuild CloudCode CloudDeploymentManager gcloudCLI CloudScheduler CloudSourceRepositories CloudTasks GoogleCloudDeploy Tekton ToolsforPowerShell Seealldevelopertools HealthcareandLifeSciences ApigeeHealthcareAPIx CloudHealthcareAPI CloudLifeSciences DeviceConnectforFitbit HealthcareNaturalLanguageAI HybridandMulticloud Anthos Looker CloudRunforAnthos GoogleCloudMarketplaceforAnthos MigratetoContainers Operations CloudBuild TrafficDirector ApigeeAPIManagement GoogleDistributedCloud InternetofThings CloudIoTCore EdgeTPU ManagementTools AnthosConfigManagement CarbonFootprint CloudAPIs Cloudconsole CloudMobileApp CloudShell ConfigConnector CostManagement IntelligentManagement PrivateCatalog TerraformonGoogleCloud MediaandGaming GameServers LiveStreamAPI OpenCue TranscoderAPI VideoStitcherAPI Migration ApplicationMigration BigQueryDataTransferService CloudFoundationToolkit DatabaseMigrationService MigratetoContainers MigratetoVirtualMachines RapidAssessment&MigrationProgram(RAMP) TransferAppliance StorageTransferService VMwareEngine Networking CloudArmor CloudCDN CloudDNS CloudLoadBalancing CloudNAT HybridConnectivity NetworkConnectivityCenter NetworkIntelligenceCenter NetworkServiceTiers TrafficDirector Seeallnetworkingproducts Operations CloudLogging CloudMonitoring ErrorReporting KubernetesEngineMonitoring CloudTrace CloudProfiler CloudDebugger IntelligentOperations SecurityandIdentity CloudIAM AssuredWorkloads CloudKeyManagement ConfidentialComputing SecurityCommandCenter CloudDataLossPrevention ManagedServiceforMicrosoftActiveDirectory AccessTransparency TitanSecurityKey SecretManager BeyondCorpEnterprise Seeallsecurityandidentityproducts ServerlessComputing CloudRun CloudFunctions AppEngine Workflows Storage AllStorageProducts CloudStorage Filestore PersistentDisk CloudStorageforFirebase LocalSSD StorageTransferService GoogleWorkspaceEssentials GoogleCloudBackupandDR Savemoneywithourtransparentapproachtopricing Requestaquote PricingOverview GoogleCloudpricing Pricingcalculator GoogleCloudFreeProgram Product-specificPricing ComputeEngine CloudSQL GoogleKubernetesEngine CloudStorage BigQuery Seefullpricelistwith100+products Self-serviceResources GoogleCloudFreeProgram Onboardingessentials DeveloperCenter GoogleCloudcertification Events Blog Customerstories Analystreports Experthelpandtraining Consulting TechnicalAccountManagement Training GoogleCloudCommunity Partnersandthird-partytools GoogleCloudpartners Becomeapartner GoogleCloudMarketplace Home Docs BigQuery Documentation Guides Sendfeedback Stayorganizedwithcollections Saveandcategorizecontentbasedonyourpreferences. AdWordstransfers TheBigQueryDataTransferServiceforAdWords allowsyoutoautomaticallyscheduleandmanagerecurringloadjobsforAdWordsreportingdata. SupportedReports TheBigQueryDataTransferServiceforAdWordscurrentlysupportsthefollowing reportingoptions: AdWordsv201809reports ForinformationonhowAdWordsreportsaretransformedinto BigQueryDataTransferServicetablesandviews,see AdWordsreporttransformations. TomapAdWordsreportstowhatyouseeintheAdWordsUI, seeMappingreportstotheAdWordsUI. Reportingoption Support SupportedAPIversion v201809 ForinformationonAdWordsAPImigration,see MigrationGuide(v201809). Schedule Daily,atthetimetheTransferisfirstcreated(default) Youcanconfigurethetimeofday. Refreshwindow Last7days(default) Configurableupto30days SnapshotsofMatchTables aretakenonceadayandstoredinthepartitionforthelatestrundate.MatchTablesnapshotsareNOT updatedforbackfillsorfordaysloadedviatherefreshwindow.For informationonwhichMatchTablesarenotupdatedbytherefreshwindow, seeSetupabackfill. Maximumbackfillduration NolimitWhileAdWordshasnoknowndata retentionlimitsexceptClickPerformanceReport,theBigQueryDataTransferServicehaslimitsonhowmanydayscanberequestedinasinglebackfill.Forinformationon backfills,seeSetupabackfill. NumberofCustomerIDspermanageraccount 2,000TheBigQueryDataTransferServicesupportsamaximumof2000CustomerIDs perAdWordsmanageraccount(MCC). Beforeyoubegin BeforeyoucreateanAdWordstransfer: Verifythatyouhavecompletedallactionsrequiredto enabletheBigQueryDataTransferService. CreateaBigQueryDataTransferServicedataset tostoretheAdWordsdata. IfyouintendtosetuptransferrunnotificationsforPub/Sub,you musthavepubsub.topics.setIamPolicypermissions.Pub/Sub permissionsarenotrequiredifyoujustsetupemailnotifications.Formore information,see BigQueryDataTransferServicerunnotifications. Requiredpermissions Ensurethatthepersoncreatingthetransferhasthefollowingrequired permissions: BigQueryDataTransferService: bigquery.transfers.updatepermissionstocreatethetransfer Bothbigquery.datasets.getandbigquery.datasets.updatepermissionson thetargetdataset Thebigquery.adminpredefinedIAMrole includesbigquery.transfers.update,bigquery.datasets.updateand bigquery.datasets.getpermissions.Formoreinformationon IAMrolesinBigQueryDataTransferService,see Accesscontrol. AdWords:ReadaccesstotheAdWordsCustomerIDormanageraccount(MCC)thatisusedinthetransferconfiguration. SetupaAdWordsdatatransfer SettingupadatatransferforAdWordsreportingrequiresa: CustomerID:YourAdWordsCustomerIDormanageraccount(MCC)as issuedbyAdWords. TocreateadatatransferforAdWordsreporting: Console GototheBigQuerypageintheGoogleCloudconsole. GototheBigQuerypage ClickTransfers. ClickCreateTransfer. OntheCreateTransferpage: IntheSourcetypesection,forSource,choose AdWords. IntheTransferconfignamesection,forDisplayname,entera nameforthetransfersuchasMyTransfer.Thetransfernamecanbe anyvaluethatallowsyoutoeasilyidentifythetransferifyouneed tomodifyitlater. IntheScheduleoptionssection,forSchedule,leavethe defaultvalue(Startnow)orclickStartatasettime. ForRepeats,chooseanoptionforhowoftentorunthe transfer. Daily(default) Weekly Monthly Custom On-demand ForStartdateandruntime,enterthedateandtimetostart thetransfer.IfyouchooseStartnow,thisoptionisdisabled. IntheDestinationsettingssection,forDestinationdataset, choosethedatasetyoucreatedtostoreyourdata. IntheDatasourcedetailssection: ForCustomerID,enteryourCustomerIDormanageraccount. CheckExcluderemoved/disabledItemstopreventremovedor disabledentitiesandmetricsfrombeingtransferred. (Optional)IntheNotificationoptionssection: Clickthetoggletoenableemailnotifications.Whenyouenablethis option,thetransferadministratorreceivesanemailnotification whenatransferrunfails. ForSelectaPub/Subtopic,chooseyourtopic nameorclickCreateatopic.Thisoption configuresPub/Subrunnotifications foryourtransfer. ClickSave. bqEnterthebqmkcommandandsupplythetransfercreationflag— --transfer_config.Thefollowingflagsarealsorequired: --data_source --target_dataset --display_name --params Youcanalsosupplythe--project_idflagtospecifyaparticular project.If--project_idisn'tspecified,thedefaultprojectisused. bqmk\ --transfer_config\ --project_id=project_id\ --target_dataset=dataset\ --display_name=name\ --params='parameters'\ --data_source=data_source Where: project_idisyourprojectID. datasetisthetargetdatasetforthetransferconfiguration. nameisthedisplaynameforthetransferconfiguration.The transfernamecanbeanyvaluethatallowsyoutoeasilyidentifythe transferifyouneedtomodifyitlater. parameterscontainstheparametersforthecreatedtransfer configurationinJSONformat.Forexample: --params='{"param":"param_value"}'.For AdWords,youmustsupplythecustomer_idparameter.Youmay optionallysettheexclude_removed_itemsparametertotruetoprevent removedordisabledentitiesandmetricsfrombeingtransferred. data_sourceisthedatasource—adwords. Caution:Currently,youcannotconfigurenotificationsusingthecommand-line tool. Forexample,thefollowingcommandcreatesaAdWordstransfernamed MyTransferusingCustomerID123-123-1234andtargetdataset mydataset.Thetransferiscreatedinthedefaultproject: bqmk\ --transfer_config\ --target_dataset=mydataset\ --display_name='MyTransfer'\ --params='{"customer_id":"123-123-1234","exclude_removed_items":"true"}'\ --data_source=adwords Thefirsttimeyourunthecommand,youreceiveamessagelikethe following: [URLomitted]PleasecopyandpastetheaboveURLintoyourwebbrowserand followtheinstructionstoretrieveanauthenticationcode. Followtheinstructionsinthemessageandpastetheauthenticationcodeon thecommandline. Caution:WhenyoucreateaAdWordstransferusingthecommand-linetool,the transferconfigurationissetupusingthedefaultvaluesforSchedule (every24hoursatcreationtime)andRefreshwindow(0— configuresthedefaultrefreshwindowof7days). APIUsetheprojects.locations.transferConfigs.create methodandsupplyaninstanceoftheTransferConfig resource. Java Beforetryingthissample,followtheJavasetupinstructionsinthe BigQueryquickstartusing clientlibraries. Formoreinformation,seethe BigQueryJavaAPI referencedocumentation. ViewonGitHub Feedback importcom.google.api.gax.rpc.ApiException; importcom.google.cloud.bigquery.datatransfer.v1.CreateTransferConfigRequest; importcom.google.cloud.bigquery.datatransfer.v1.DataTransferServiceClient; importcom.google.cloud.bigquery.datatransfer.v1.ProjectName; importcom.google.cloud.bigquery.datatransfer.v1.TransferConfig; importcom.google.protobuf.Struct; importcom.google.protobuf.Value; importjava.io.IOException; importjava.util.HashMap; importjava.util.Map; //Sampletocreateads(formerlyAdWords)transferconfig publicclassCreateAdsTransfer{ publicstaticvoidmain(String[]args)throwsIOException{ //TODO(developer):Replacethesevariablesbeforerunningthesample. finalStringprojectId="MY_PROJECT_ID"; StringdatasetId="MY_DATASET_ID"; //thecustomer_idonlyallowsdigitsandhyphen('-'). StringcustomerId="012-345-6789"; StringrefreshWindow="100"; Mapparams=newHashMap<>(); params.put("customer_id",Value.newBuilder().setStringValue(customerId).build()); params.put("refreshWindow",Value.newBuilder().setStringValue(refreshWindow).build()); TransferConfigtransferConfig= TransferConfig.newBuilder() .setDestinationDatasetId(datasetId) .setDisplayName("YourAdsTransferConfigName") .setDataSourceId("adwords") .setParams(Struct.newBuilder().putAllFields(params).build()) .build(); createAdsTransfer(projectId,transferConfig); } publicstaticvoidcreateAdsTransfer(StringprojectId,TransferConfigtransferConfig) throwsIOException{ try(DataTransferServiceClientclient=DataTransferServiceClient.create()){ ProjectNameparent=ProjectName.of(projectId); CreateTransferConfigRequestrequest= CreateTransferConfigRequest.newBuilder() .setParent(parent.toString()) .setTransferConfig(transferConfig) .build(); TransferConfigconfig=client.createTransferConfig(request); System.out.println("Adstransfercreatedsuccessfully:"+config.getName()); }catch(ApiExceptionex){ System.out.print("Adstransferwasnotcreated."+ex.toString()); } } } SupportforAdWordsmanageraccounts ExistingcustomerswhohavemultipleCustomerID-specificAdWordsTransfers areencouragedtosetupasingleAdWordsTransferattheManagerAccount (MCC)level,scheduleabackfill,anddisableindividualCustomerID-specific AdWordsTransfers. UsingAdWordsmanageraccountsprovidesseveralbenefitsoverusing individualCustomerIDs: Younolongerneedtomanagemultipletransferstoreportonmultiple CustomerIDs. Cross-customerqueriesaremuchsimplertowritebecausealltheCustomerIDs arestoredinthesametable. UsingMCCsalleviatesBigQueryDataTransferServiceloadquotaissuesbecause multipleCustomerIDsareloadedinthesamejob. Note:TheBigQueryDataTransferServicepullsreportsforalllistedCustomerIDs,butyoumay notseeCustomerIDsinyourreportsiftheydon'treportactivityforthe requestedday. Example ThefollowinglistshowstheCustomerIDslinkedtoparticularAdWords manageraccounts: 1234567890—rootmanageraccount 1234—sub-manageraccount 1111—CustomerID 2222—CustomerID 3333—CustomerID 4444—CustomerID 567—sub-manageraccount 5555—CustomerID 6666—CustomerID 7777—CustomerID 89—sub-manageraccount 8888—CustomerID 9999—CustomerID 0000—CustomerID EachCustomerIDlinkedtoamanageraccountappearsineachreport.Formore informationontheAdWordsreportingstructureinBigQueryDataTransferService, see AdWordsreporttransformation. TransferconfigurationforCustomerID1234567890 Atransferconfigurationfortherootmanageraccount(CustomerID1234567890) wouldgeneratetransferrunsthatincludethefollowingCustomerIDs: 1111(viasub-manageraccount1234) 2222(viasub-manageraccount1234) 3333(viasub-manageraccount1234) 4444(viasub-manageraccount1234) 5555(viasub-manageraccount567andsub-manageraccount1234) 6666(viasub-manageraccount567andsub-manageraccount1234) 7777(viasub-manageraccount567andsub-manageraccount1234) 8888(viasub-manageraccount89) 9999(viasub-manageraccount89) 0000(individualCustomerID) TransferconfigurationforCustomerID1234 Atransferconfigurationforsub-manageraccount123(CustomerID1234)would generatetransferrunsthatincludethefollowingCustomerIDs: 1111 2222 3333 4444 5555(viasub-manageraccount567) 6666(viasub-manageraccount567) 7777(viasub-manageraccount567) TransferconfigurationforCustomerID567 Atransferconfigurationforsub-manageraccount567(CustomerID567)would generatetransferrunsthatincludethefollowingCustomerIDs: 5555 6666 7777 TransferconfigurationforCustomerID89 Atransferconfigurationforsub-manageraccount89(CustomerID89)would generatetransferrunsthatincludethefollowingCustomerIDs: 8888 9999 TransferconfigurationforCustomerID0000 AtransferconfigurationforCustomerID0000wouldgeneratetransferrunsthat includeonlytheindividualCustomerID: 0000 MigrateAdWordsdatatoMCCs TomigrateyourexistingAdWordsdatainBigQueryDataTransferServicetothe MCCstructure,youcansetupabackfill toaddyourexistingdatatothetablescreatedbythetransferconfiguration linkedtothemanageraccount.Notethatwhenyouscheduleabackfill,match tablesarenotupdated. Queryyourdata WhenyourdataistransferredtoBigQueryDataTransferService,thedatais writtentoingestion-timepartitionedtables.Formoreinformation,see Introductiontopartitionedtables. Ifyouqueryyourtablesdirectlyinsteadofusingtheauto-generatedviews,you mustusethe_PARTITIONTIMEpseudo-columninyourquery.Formoreinformation, seeQueryingpartitionedtables. AdWordssamplequeries YoucanusethefollowingAdWordssamplequeriestoanalyzeyourtransferred data.Youcanalsousethequeriesinavisualizationtoolsuchas GoogleDataStudio. ThesequeriesareprovidedtohelpyougetstartedonqueryingyourAdWords datawithBigQueryDataTransferService.Foradditionalquestionsonwhatyoucan dowiththesereports,contactyourAdWordstechnicalrepresentative. Ineachofthefollowingqueries,replacedatasetwithyourdataset name.Replacecustomer_idwithyourAdWordsCustomerID. Ifyouqueryyourtablesdirectlyinsteadofusingtheauto-generated views,youmustusethe_PARTITIONTIMEpseudo-columninyourquery.Formore information,seeQueryingpartitionedtables. Campaignperformance ThefollowingSQLsamplequeryanalyzesAdWordscampaign performanceforthepast30days. SELECT c.ExternalCustomerId, c.CampaignName, c.CampaignStatus, SUM(cs.Impressions)ASImpressions, SUM(cs.Interactions)ASInteractions, (SUM(cs.Cost)/1000000)ASCost FROM `dataset.Campaign_customer_id`c LEFTJOIN `dataset.CampaignBasicStats_customer_id`cs ON (c.CampaignId=cs.CampaignId ANDcs._DATA_DATEBETWEEN DATE_ADD(CURRENT_DATE(),INTERVAL-31DAY)ANDDATE_ADD(CURRENT_DATE(),INTERVAL-1DAY)) WHERE c._DATA_DATE=c._LATEST_DATE GROUPBY 1,2,3 ORDERBY ImpressionsDESC Countofkeywords ThefollowingSQLsamplequeryanalyzeskeywordsbycampaign,adgroup, andkeywordstatus.ThisqueryusestheKeywordMatchTypefunction.Keyword matchtypeshelpcontrolwhichsearchescantriggeryourad.Formore informationonkeywordmatchingoptions,see Aboutkeywordmatchingoptions. SELECT c.CampaignStatusASCampaignStatus, a.AdGroupStatusASAdGroupStatus, k.StatusASKeywordStatus, k.KeywordMatchTypeASKeywordMatchType, COUNT(*)AScount FROM `dataset.Keyword_customer_id`k JOIN `dataset.Campaign_customer_id`c ON (k.CampaignId=c.CampaignIdANDk._DATA_DATE=c._DATA_DATE) JOIN `dataset.AdGroup_customer_id`a ON (k.AdGroupId=a.AdGroupIdANDk._DATA_DATE=a._DATA_DATE) WHERE k._DATA_DATE=k._LATEST_DATE GROUPBY 1,2,3,4 Sendfeedback Exceptasotherwisenoted,thecontentofthispageislicensedundertheCreativeCommonsAttribution4.0License,andcodesamplesarelicensedundertheApache2.0License.Fordetails,seetheGoogleDevelopersSitePolicies.JavaisaregisteredtrademarkofOracleand/oritsaffiliates. Lastupdated2022-10-01UTC. [{ "type":"thumb-down", "id":"hardToUnderstand", "label":"Hardtounderstand" },{ "type":"thumb-down", "id":"incorrectInformationOrSampleCode", "label":"Incorrectinformationorsamplecode" },{ "type":"thumb-down", "id":"missingTheInformationSamplesINeed", "label":"Missingtheinformation/samplesIneed" },{ "type":"thumb-down", "id":"otherDown", "label":"Other" }] [{ "type":"thumb-up", "id":"easyToUnderstand", "label":"Easytounderstand" },{ "type":"thumb-up", "id":"solvedMyProblem", "label":"Solvedmyproblem" },{ "type":"thumb-up", "id":"otherUp", "label":"Other" }] Needtotellusmore? WhyGoogle ChoosingGoogleCloud Trustandsecurity Opencloud Multicloud Globalinfrastructure Customersandcasestudies Analystreports Whitepapers Blog Productsandpricing GoogleCloudpricing GoogleWorkspacepricing Seeallproducts Solutions Infrastructuremodernization Databases Applicationmodernization Smartanalytics ArtificialIntelligence Security Productivity&worktransformation Industrysolutions DevOpssolutions Smallbusinesssolutions Seeallsolutions Resources GoogleClouddocumentation GoogleCloudquickstarts GoogleCloudMarketplace Learnaboutcloudcomputing Support Codesamples CloudArchitectureCenter Training Certifications GoogleDevelopers GoogleCloudforStartups Systemstatus ReleaseNotes Engage Contactsales FindaPartner BecomeaPartner Events Podcasts DeveloperCenter PressCorner GoogleCloudonYouTube GoogleCloudTechonYouTube FollowonTwitter JoinUserResearch We'rehiring.JoinGoogleCloud! GoogleCloudCommunity CookieSettings AboutGoogle Privacy Siteterms GoogleCloudterms Carbonneutralsince2007 SignupfortheGoogleCloudnewsletter Subscribe English Deutsch Español–AméricaLatina Français Italiano Português–Brasil 中文–简体 日本語 한국어