Need R script developer using SearchConsoleR package

Please create a tested and working R script that pulls all search queries for every URL in a Google Search Console web property, using the SearchConsoleR package, and any other packages necessary. Ideally you will have a Google Search Console account you can use. But if necessary, I can grant you access to a Search Console account to use. **In any case, you must have a working Google account.**

The script should:

- Load the necessary packages

- Connect to Google and authorize with scr_auth (See sample R file)

- Specify start and end dates for the data pulls from Search Console (See sample R file)

- Specify the website site to pull data from (See Sample R file)

- Specify the dimension of page for the data pull (See sample R file)

- With the search_analytics function, pull all pages with a row limit of 100,000 (See sample R file)

- The pages should be written to a dataframe automatically by the SearchConsoleR package (See sample R file)

- For each URL in that data frame (url_list):

Pull all queries for each URL, and print to a new dataframe containing the Start Date in column A, URL in column B, Query in Column C, Clicks in Column D, Impressions in Column E, CTR in Column F and Position in Column G (See Screenshot B for expected output

- After All URLs have been looped through, write the second dataframe to an Excel file (See sample Excel file for expected output)

- The sample Excel file shows intended output (a sample of the top 5 pages only, for reference)

JavaScript Software Architecture Web Scraping R Programming Language Ruby on Rails

Project ID: #29902989

About the project