Excel VBA Import CSV, Categorize, Create Pivot Table Automatically: Google + Facebook Analytics

Опубликовано: 06 Октябрь 2024
на канале: ExcelVbaIsFun

2,414

📊 Free Workbooks: https://www.excelvbaisfun.com/links?u...
🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more)

Learn how to Auto-Import a CSV file, categorize it and auto create a pivot table report to find answers quickly! BACKSTORY: Facebook Ads Manager no longer tells you where your money is best spent. They removed the ability to see revenue by device, age, gender or most other statistics, only how much you've spent on these things.
So I'm exporting what little data they gave me and comparing it with a revenue report from google analytics.

Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-...
👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/