You Ask, I Answer: Source/Medium for Google Analytics 4 in ...

You Ask, I Answer: Source/Medium for Google Analytics 4 in Data Studio ... but where do find Source Medium Campaign In Data Studio With GA4? YouAsk,IAnswer:Source/MediumforGoogleAnalytics4inDataStudio? byChristopherSPenn|Nov3,2020|GoogleAnalytics,GoogleDataStudio,Marketing,MarketingTechnology|0comments Jakesasks,“I’vemoved5sitesToGoogleAnalytics4,setupahostofcustomeventsinTagManagertorecreatewhatI’mmissingfromGA3,butwheredofindSourceMediumCampaignInDataStudioWithGA4?AmImissingsomethingobvious?” Yeah…it’snotthereyet.Thatconnectorisstillinbeta,accordingtoaGoogleemployee,whichseemslikeanoversight.I’llshowyoutheworkaroundforhowtogetsource/mediumdatainGoogleDataStudiofromyourGoogleAnalytics4data. YouAsk,IAnswer:Source/MediumforGoogleAnalytics4inDataStudio?WatchthisvideoonYouTube. Can’tseeanything?WatchitonYouTubehere. Listentotheaudiohere: DownloadtheMP3audiohere. GotaquestionforYouAsk,I’llAnswer?Submitithere! Subscribetomyweeklynewsletterformoreusefulmarketingtips. FindolderepisodesofYouAsk,IAnsweronmyYouTubechannel. Needhelpwithyourcompany’sdataandanalytics?Letmeknow! JoinmyfreeSlackgroupformarketersinterestedinanalytics! Machine-GeneratedTranscript WhatfollowsisanAI-generatedtranscript.Thetranscriptmaycontainerrorsandisnotasubstituteforwatchingthevideo. Intoday’sepisodeJake’sasks,I’vemovedfivesitestoGoogleAnalyticsforsetupahostofcustomeventsandTagManagertorecreatewhatI’mmissingfromgathree. ButwheredoIfindsourcemediumcampaigndatainGoogleDataStudiowithga4am?Imissingsomethingobvious?Yeah,ah,it’snotthereyet. Whichseemslikeabitofanoversight. Infact,Jakewentontoaskthisexactquestion. Let’sfliparoundhere. Yes,istheexactquestiontoGoogleandaGoogleemployeesaidit’sstillinpreview. It’snotthereyet. ButfieldsthemselvesmaynotbeavailableintheAPI?Well,that’snothelpfulsincesourcemediumiskindofoneofthosecriticalthingsyouwanttoknow. Sothequestionthenis,whatcanwedotosolvethisproblemis,isthedatajustnotthereissomethingOh,what’sgoingon. Sothere’sacoupledifferentwaystohandlethis. First,let’sfigureoutisthedatabasesogoodandgointoGoogleAnalytics,oneofthefunctionsthatwehaveaccesstoitisintheadvancedsetup,isyouhaveaccesstoGoogleBigQuery,whichisGoogle’sclouddatabase. AndifyouhaveaGoogleCloudaccountsetup,whichIwouldstronglyencourageyoutosetoneup,itdoesn’tcostyouanymoneyoutofthegate,itjustcoststoragetimeandmoneyovertime,youcanconnecttoGoogleBigQuerydatabasetoyourGoogleAnalytics. Now,thisisadvancedstuff. Butforthepurposesofatleastjustbeingabletoseethedata,Ithinkit’sessential. SoinBigQuery,Iwentintomydatabase,andjuststartedlookingatwhat’sinthetable. Andweseeforeverysingleinteraction,yougetthesedozensanddozensanddozensofparameters. Right?SothisistherawdatafromfromGoogleAnalytics. ThisisoneofthereasonsBytheway,whyGoogleAnalyticsfourwilleventuallybethegoldstandardforGoogleAnalyticsdeployments. Becauseit’sreallyhardtotopthis,like,purerawdata,it’swonderful. Whatyou’llnoticehereisthatthereistrafficsourcename,medium,andsource. Sosourcemedium,andnameisinthatwhichisacampaign. Thisisagoodthing. ThisisThismeansthatthedatainfact,trafficsourcename,ifyoulookattheformattingkindalookslikeadefaultchannelgrouping,doesn’tit?It’skindofinteresting. Andthethetheplatform,whetherit’sweborapp,sothedataisthere. It’sphysicallypresent,whichmeansthatwecouldgetitintoGoogleDataStudio,thechallengesisgoingtobehowdowegetitintoGoogleDataStudio?Well,oneofthethingsthatwecandoinDataStudioisbringindataaBigQuerydatabasenatively. SoI’vegotmyGoogleAnalyticsfordatahere. Right,wecansee,it’s,it’srightthere. AndasJakeswassaying,whenyoulookinthefieldsthatareavailable,yes,sourcemedium,totallyabsent,right?It’snot,it’sjustnotthere. Sohowdowedothis?Howdowegetsourcemediumdataatall?Let’sgoaheadandaddsomedata. I’mgoingtoaddGoogleBigQuery. Andwe’regoingtochoosemyBigQueryproject. Oops,likethat. Andthenchoosemynotnotmyrealtimedatabase,butmyregulardatabase. Andlook,aswe’vebeentalkingaboutpreviousvideos,GoogleAnalyticsforreallyisGoogleFirebaseright. Andsothere’saanexistingFirebasetemplatealreadysetupforus,weaddthattoourdatasource,oh,addedtoourreport. Andnowlet’sgoaheadandmakeanewchart. Andnowforourchart,we’vegotourFirebasedatabasehereinsteadofGoogleAnalytics,right?Solet’sgoaheadandwe’vegotoureventdatethere. Andinsteadofoffset,let’sdouniqueusers. Andnow,youseeacquiredsourceacquiredmediumacquiredcampaign. Nowwe’restartingtobeabletoseethosedifferentvariables. Solet’sgoaheadandaddinsourcesofbreakdowndimension. Lookinggood,rightnow,wecanstarttoseemoreclearlywhereourtrafficiscomingfrom. Andtherearemajorsourcesifthisisdifficulttoread,obviouslyswitchthevisualizationtoanythingelsethatmakessensetoyou. Butnowwe’vegotoursourcemediumdatainherefromGoogleAnalyticsthehardway,right,usingtheBigQuerydatabaseinsteadofthefactthattheAPIdoesnothavethedatainit. Now,thisisaworkaround. Let’sbeclear. Thisisaworkaround,isn’tit?ConvenientworkaroundIwouldexpect,basedontheGoogleemployeesresponse,thatthiswillnotbethestateofthingsgoingforward. Right. Thisis,whiletheyfigureouthowtobuildallthepiecesthatneedtobebuilttosurroundtheGoogleAnalyticsecosystem,thisistheworkaround. Iwouldhopethatthisisnotpermanent,becauseit’ssilly. ButifyouaredeployingGoogleAnalyticsforrightnow,itisinyourinteresttodotheBigQueryintegration,andtohavetheBigQuerydatabaseavailableandcollectingdatasothatifyoudoneedtoreportonyourgafourdataforsomereason,becauseit’snotright,clearly,foreverybusinesstobeusingrightnow,butifyoudidn’tneedtodothatreport,andyouhavetheoptiontopullintheBigQuerydataandreportonitnativelywithinGoogleDataStudio. ThisalsospeakstothefactthatGoogleAnalyticsforyouinitsentirety,aspartoftheecosystemwithTagManageranalytics,andDataStudioisnotreadyforprimetimeyet,itisnotsomethingthatyoushouldbeusingasyoursystemofrecordforyourmarketingdata. Shouldyouhaveit?Yes. Shouldyouhaveitturnedon?Yes. Shouldyoubecollectingdata?Yes. Shouldyouberelyingonitforyourmissioncriticalreporting?knew?Notifyou’regoingtohavetokeepdoing,youknow,hacksandworkaroundslikethis,justtogetthedataoutoftheplatformorbepullingdatastraightoutofyouryourBigQuerydatabasenow?Shouldyoubedoingadvancedanalyticsandbuildingonit?Probably,becausewhatyouseeinBigQueryistherawdata,right?Itistherawdataandthatschemaiswellestablished. Soit’salready,it’salreadyestablished. It’sbeenestablished. It’sGoogleFirebase. Andthus,youcouldfeelprettyconfidentinbuildingcodeontopoftheFirebasedatabase. ButshouldyouberelyingontheGAfourAPI?Definitelynot. SotheworkaroundforbringingitintoDataStudioistouseFirebase,theFirebasedatabaseuntiltheGAfourAPIgetsupdatedwithinGoogleDataStudio,thatwillgiveyoutheabilitytovisualizethisstuffalittlemoreeasily. Butknowthatthedataisthere. Right. That’stheimportantpart,thedataisthere. Soitwilleventuallybeavailable. Soyoucanfeelconfident,deployingGoogleAnalyticsforandknowingthatitwillcollectallthedatathatit’ssupposedtobe,andbuildallthosecustomevents,asJake’swastalkingabout,getallthisCustomEventsetupandTagManager. Soyou’retrackingallthingsyouwanttobetracking?Becauseremember,it’sneverretroactive. Andthen,astheproductmaturesastheinfrastructureoverall,theGoogleMarketingPlatformmaturesaroundGoogleAnalyticsforyou’llbeabletodomoreandmorewithlessandlessheadache. Sothat’stheanswer. It’saterribleanswer. Butthat’stheanswer. Ifyouhavefollowupquestions,leavetheminthecommentsboxbelow. SubscribetotheYouTubechannelandthenewsletter,we’lltalktoyousoon. Takecarewanthelpsolvingyourcompany’sdataanalyticsanddigitalmarketingproblems?VisitTrustinsights.aitoday,andletusknowhowwecanhelpyou Youmightalsoenjoy: TheBiggestMistakeinMarketingData HowtoSetYourPublicSpeakingFee MarketingDataScience:IntroductiontoDataBlending HowToSetYourConsultingBillingRatesandFees It'sOkaytoNotBeOkayRightNow WanttoreadmorelikethisfromChristopherPenn?Getupdateshere: GetyourcopyofAIForMarketers JoinmyAnalyticsforMarketersSlackGroup! SubmitaCommentCancelreplyYouremailaddresswillnotbepublished.Requiredfieldsaremarked*Comment*Name* Email* Website Δ NeedConsulting?Needhelpwithanalyticsandyourdata? YesIdoconsulting.Clickhere»BookMeToSpeakAtYourEventWantmetospeakatyourevent? Clickheretolearnmore» AIforMarketersBook Inthisall-new,completely-rewrittenThirdEditionofAIforMarketers,learn:WhatAIisandisn't5practicalapplicationsofAIinmarketingKeyquestionstoaskofanyvendorclaimsaboutAIHowtoprepareyourcompanyandyourcareerforAIGetyourcopynow! RecentPostsbyMe YouAsk,IAnswer:AdSpendLosttoFraud? YouAsk,IAnswer:GA4ImpactonAttributionAnalysis? AlmostTimelyNews,26-June-2022:GoodHabitsLeadtoGreatChange(WARNING:POLITICAL) MarketingOverCoffeeRecentEpisodesLaMDA’sNotThinkingofYouLivefromMontenegroGettingMoreWomeninAgencyOwnershipRolesTrustInsightsRecentPostsAnanalysisofworkingfromhomestatisticsSoWhat?MasteringyourjobinterviewsHowtoknowifAIwilltakeyourjob PinItonPinterest Shares ShareThis Facebook Twitter Buffer Pinterest Gmail reddit LinkedIn PrintFriendly