---
# System prepended metadata

title: End of the Month Task (VPI Tab)
tags: [Jo Fitzsimons]

---

# **End of the Month Task**

### ℹ️ **TASK INFO**: 
**The task involves fetching data from the previous month and inputting it into Jo's tracker. This task is scheduled to be performed on the 1st day of each month. For instance, to acquire the latest data for the period from January 1 to 31, the numbers should be extracted and entered into the tracker on February 1.**

---

### **VPI SOCIAL:**

**Access the =="2023 Targets and Tracker,"== navigate to the =="Notes"== tab, and locate the =="Visit Prosecco Italy"== link.**

![image](https://hackmd.io/_uploads/r1drBFcj6.png)

---

**To obtain Pinterest monthly followers data, go to the =="Notes"== sheet, click on the provided Pinterest link. Retrieve the number of followers and paste the obtained number into the appropriate field in the =="VPI 2023"== tab.**

![image](https://hackmd.io/_uploads/HJ4UwFqsT.png)

---

**To obtain Pinterest Monthly Unique, copy the monthly views data and paste the copied data into the appropriate field in the =="VPI 2023"== tab.**

![image](https://hackmd.io/_uploads/S1M0DYcia.png)

---

**To obtain Facebook Monthly Followers data, go to the =="Notes"== tab and click on the provided Facebook link. Retrieve the number of followers and paste the obtained number into the appropriate field in the =="VPI 2023"== tab.**

![image](https://hackmd.io/_uploads/SkENdF5i6.png)

---

**To obtain Twitter Monthly Followers data, go to the =="Notes"== sheet and click on the provided Twitter link. Obtain the number of followers and paste the obtained number into the appropriate field in the =="VPI 2023"== tab.**

![image](https://hackmd.io/_uploads/ryaC_t5op.png)

---

**To obtain Instagram Monthly Followers data, go to the =="Notes"== sheet and click on the provided Instagram link. Retrieve the number of followers and paste the obtained number into the appropriate field in the =="VPI 2023"== tab.**

![image](https://hackmd.io/_uploads/SkZBtKcjp.png)

---

### **GOOGLE ANALYTICS DATA: No Longer Required (Pageviews)**

---

### **VPI SEO**

**Open the =="2023 Targets and Tracker,"== go to the =="VPI 2023"== tab, and find the SEO section of the tracker. Extract only the =="DA" (Domain Authority)== and =="PA" (Page Authority)== data, ignoring any other information.**

![image](https://hackmd.io/_uploads/rkxw3KqoT.png)

---

**Navigate to the =="NOTES"== tab. Click on the first link on the right side of =="DA,"== which will redirect you to the MOZ website. Log into MOZ using the login details found in the =="Log-in details"== spreadsheet.**

![image](https://hackmd.io/_uploads/SJCnnK9jT.png)

---

**Copy the URL of ==VPI (Visit Prosecco Italy)==**

![image](https://hackmd.io/_uploads/r1uW6KcsT.png)


---

**Paste VPI's URL into MOZ's website, then click =="Analyze."== Look for the =="Metrics Over Time"== section and select =="Domain Authority."== Hover over the last circle on the graph to get the DA number. Enter this DA data into the =="VPI 2023"== tab. Next, click on =="Page Authority,"== hover over the last circle on the graph to find the PA number, and input this PA data into the corresponding field in the =="VPI 2023"== tab.**

![image](https://hackmd.io/_uploads/Hk36TK9s6.png)

---

### **VPI GSC**


**Access ==Google Search Console== by opening the =="EOM Task and Logins"== and clicking on the GSC (Google Search Console) link.**

![image](https://hackmd.io/_uploads/HkGgHZRaT.png)

---

**switch the search property to =="visitproseccoitaly.com."==**

![image](https://hackmd.io/_uploads/HycrHZCaa.png)

---

**Click on the =="SEARCH RESULTS"==**

![image](https://hackmd.io/_uploads/BJxdSZA6a.png)

---

**Set the date range to =="custom"== and specify the month you want to retrieve data from.**

![image](https://hackmd.io/_uploads/SyJkI-CTa.png)

---

**Copy the following data from Google Search Console:**

**==Total Clicks (K)
Total Impressions (M)
Average CTR
Average Position==**

**Then, paste these numbers into the =="GSC"== section of the =="VPI 2023"== tracker.**

![image](https://hackmd.io/_uploads/HkeDLW066.png)

---

### **VPI KW TRACKING**

**Access Trello, go to =="Emily to Do,"== and choose the task named =="SEMRush - Traffic Position Data."==**

![image](https://hackmd.io/_uploads/BJK2vbRaT.png)

---

**Open the provided ==Semrush link==**

![image](https://hackmd.io/_uploads/H1Z1_W0aT.png)

---

**click on =="Organic Research"== to proceed**

![image](https://hackmd.io/_uploads/rkwGOZCap.png)

---

**Copy and paste the URL of the tab you are currently working on ==(the VPI link)== Click the =="Search"== button to initiate the search**

![image](https://hackmd.io/_uploads/BkcCFWATT.png)

---

**Configure the country as =="USA"== and apply a date filter to match the current month. Then, gather the following data from SEMrush:

Keywords (K)
Keyword Change % (small numbers beside the Keywords number)
Traffic (K)
Traffic Change % (small numbers beside the Traffic number)
Traffic Cost
and Traffic Cost Change % (small numbers beside the Traffic Cost number).

Finally, input the collected information into the "KW Tracking" part of the "VPI 2023 tracker."**