...
| Info |
|---|
Note: The Excel sources in Step 1 must be processed on Monday in order to be ready for the Tuesday morning ETL process. |
Each of the following data sources must be saved as Excel and copied to the H: drive for import into the warehouse.
The file drop location is:
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.
| Info | ||
|---|---|---|
| ||
Note: The following elements are no longer used, but the steps are retained in case they are resumed in future instances. |
Web Traffic (DEPRECATED)
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
...
- Save as RPT_MKT_WEB_TRAFFIC.xlsx file on H:
- DELETE THE TOP TWO ROWS FROM THE FILE (Filter details)
- Remove the filters
- Rename the tab to Export
- File is automatically processed by the EBIS team every Tuesday morning at 6am
- If the data needs to be manually processed:
- Execute the RPT_MKT_WEB_TRAFFIC import script on the terminal server to update the table
- If the data needs to be manually processed:
...
| title | Deprecated Data Sources |
|---|
...
Paid Marketing (DEPRECATED)
...