Microsoft Excel Notes

Basic Shortcuts and TipsData Validation and Conditional FormattingDATA Tab (Filter, Consolidate, What If Analysis)Home TabInsert TabPivot tablesPower QueryM QueryOther Small TabsFormulasTips and TricksData ModelingDAXVisualization Practice files: https://drive.google.com/drive/folders/1vmNlWsP55IHT4wrB7enVZApSNgVYUuqz Basic Shortcuts and…

Continue ReadingMicrosoft Excel Notes

Facebook Ads Notes

Quick TipsObjectivesAuctionCampaign StructureGeneralCampaign Budget Optimization CBOAudience TargetingCustom Audience, overlap and othersAd CopyFB Pixel and event trackingLead Gen CampaignCatalog Sales Campaign for ecommerceConversion CampaignOther Campaign NotesStrategies and own things Quick Tips…

Continue ReadingFacebook Ads Notes

Google Ads Notes

Search CampaignsConversion TrackingOffline ConversionsEnhanced Conversion tracking needs to be setupKeywords (Group based on Intent and Relevancy IMP)Keyword Research Sheet:Negative Keywords:UTM ParametersAudiencesFake clicksBidding StrategyDynamic Search Ad GroupsExperiment CampaignsCompetitive Metrics (Important for…

Continue ReadingGoogle Ads Notes