Development Proposal: No-Installation Script for Programmatic Advertising Lead Generation

Job ID: 37511698

Budget: €30 – €250 EUR

Objective:
Develop a script that operates without the need for local installation, capable of analyzing competitor seller JSON and checking the ads.txt file of a list of sites, generating a Google Sheets spreadsheet with essential information for programmatic advertising lead generation.

Features:

Competitor Seller JSON Analysis:

The user provides the competitor's website URL.
The script accesses the site's seller JSON, analyzing available information.
If the desired information (site name and domain owner's name) is available, it is recorded in a Google Sheets spreadsheet.
Each entry in the spreadsheet contains the site name and domain owner's name.
ads.txt

Verification:

The user provides a list of sites in a Google Sheets spreadsheet.
The script checks the ads.txt file of each site on the list.
If the site has only one line in the ads.txt (indicating exclusive use of Google AdSense), this information is recorded in a separate column in the spreadsheet.
The spreadsheet is updated with the information "Only Google AdSense" when applicable.

User-Friendly Interface:

Intuitive interface for ease of use, without the need for complex installation or configuration.
Security:
Implementation of security measures to protect sensitive data and ensure user privacy.

Integration with Google Sheets:

Use of the Google Sheets API to automate spreadsheet creation and updates.

Execution Reports:

Generation of execution reports for users to track progress and receive notifications about process completion.

Technical Requirements:

The application will be developed in a scripting language, such as Python, to ensure portability and execution in different environments.

Use of automation libraries and tools to access web data and interact with the Google Sheets API.

Development Timeline:
An estimated development and testing time of 2 weeks is anticipated, with partial deliveries for user validation.
Related categories: PHP JavaScript Python Web Scraping Google App Engine