...
H:\Systems and Data Analysis\DATA_IMPORTS\Marketing
All of the manual Excel data sources have been deprecated (see below).
The files that exist in the drop folder need to remain as the ETL process from EBIS is expecting to pick up data files, but they do not need to be updated or changed in any way. The remain to keep the ETL process from failing due to missing data files.
All of the remaining steps are automated in documented beginning with Step 2 below.
Web Traffic
...
Use the Google Analytics Extract (My Workspace on PowerBI) to save the previous week’s data to XSLX; BE SURE TO REFRESH THE DATA BEFORE EXTRACTION
...