Create and publish a monthly search and website analytics report for [COMPANY NAME].

Use Composio with the connected Google Search Console, Google Analytics 4, and Bing Webmaster Tools accounts.

Use ChatGPT Sites to publish and maintain the report.

REPORT SITE LOGIC

If an existing report site is provided at:

[EXISTING REPORT URL]

update that exact Sites project. Preserve its project identity, URL, historical reports, design system, and existing functionality. Do not create a new website.

If no existing report URL is provided, create a new public Sites report for [COMPANY NAME].

The first version should establish the permanent report structure described below.

After creating the first report, use that same Sites project for every future monthly run.

Never create a separate website for each month.

The report should function as a continuously updated analytics dashboard with historical monthly views.

DATE LOGIC

Use [TIMEZONE] as the reporting timezone.

Report on the previous completed calendar month.

Compare it with the calendar month immediately before it.

Never include the current incomplete month.

For example, if this runs in October, report September 1–30 and compare it with August 1–31.

GOOGLE SEARCH CONSOLE

Use the exact property:

[GSC PROPERTY]

Use web search.

Collect total clicks, total impressions, CTR, average position, daily performance, search queries, ranking pages, countries, devices, and search appearance.

Retrieve every available row and paginate until the available dataset is exhausted.

For every query and page, show clicks, impressions, CTR, and average position.

Order query and page tables by impressions from highest to lowest by default.

BING WEBMASTER TOOLS

Use the exact verified property:

[BING PROPERTY]

Collect daily site totals, top queries, and top pages.

Restrict or aggregate the data to the completed reporting month.

Include clicks, impressions, CTR, and average position wherever available.

If Bing returns repeated daily or weekly entries for the same query or page, combine them.

Calculate combined average position using impressions as the weighting factor where sufficient data is available.

Clearly distinguish complete site totals from limited query/page breakdowns.

If query or page breakdown impressions do not equal site totals, explicitly state that Bing limited or withheld part of the breakdown.

Never invent missing terms or values.

GOOGLE ANALYTICS 4

Use:

Account: [GA4 ACCOUNT NAME]

Property: [GA4 PROPERTY NAME]

Collect sessions, total users, new users, engaged sessions, engagement rate, average session duration, page views, event count, and key events.

Also collect daily traffic, countries, cities, landing pages, viewed pages, source / medium, default channel group, device category, and events.

Compare the primary metrics with the preceding month.

Calculate both absolute change and percentage change.

SEARCH AND TRAFFIC ANALYSIS

Analyze the most important changes in organic visibility, rankings, website traffic, and engagement.

Identify pages with the largest impression gains and losses, newly ranking queries, queries that disappeared from the available dataset, queries with the largest impression gains and losses, meaningful ranking-position changes, and high-impression queries ranking in positions 1–10 with unusually few or no clicks.

Separate branded and non-branded search performance.

Treat [BRAND NAME] and obvious misspellings or close variants as branded.

Identify traffic from ChatGPT and other clearly identifiable AI assistants separately wherever the source data supports this.

Highlight traffic sources with unusually strong engagement, while clearly noting small sample sizes.

Check for URL consistency problems including www vs non-www, HTTP vs HTTPS, trailing slash duplicates, and multiple URL variants pointing to similar content.

Do not claim causation from correlation.

MONTHLY HISTORY

Preserve every previously published month and its underlying data.

Add each newly completed month to a selector near the top of the report.

Make the newest completed month the default view.

Switching months must happen inside the same report and must not navigate users to another website.

Do not modify historical months unless correcting an obvious factual or technical error.

If this is the first report and no historical report exists, establish this structure so future runs can append new months without rebuilding the site.

REPORT STRUCTURE

Order each monthly view as:

1. Overview
2. Google and Bing comparison
3. Key findings
4. Google Search performance
5. Bing Search performance
6. Website traffic and engagement
7. Ranking pages
8. All ranking queries
9. Countries and devices
10. Recommended actions
11. Methodology and data limitations

VISUAL DESIGN

Use:

Font: [FONT]

Primary color: [PRIMARY COLOR]

Text color: [TEXT COLOR]

Background: [BACKGROUND COLOR]

Border color: [BORDER COLOR]

Card color: [CARD COLOR]

Positive change: [POSITIVE COLOR]

Negative change: [NEGATIVE COLOR]

Keep the report compact, responsive, data-first, and easy to scan.

Do not use a large marketing-style hero.

Provide navigation for Overview, Google, Bing, Traffic, Rankings, and Actions.

TABLES AND CHARTS

Order impression-based tables from highest to lowest by default.

Provide searchable tables for queries, pages, countries, and traffic sources.

Provide CSV downloads where practical.

Use charts only where they improve understanding.

Always show exact values in tables instead of requiring users to estimate numbers from charts.

DATA QUALITY RULES

Never fabricate data.

If a primary source fails, is disconnected, or does not contain the complete requested reporting period, do not silently publish a partial report.

Explain what failed, what data is missing, and what needs to be fixed.

A limited secondary breakdown may be published only when clearly labelled as incomplete or limited.

State that query and page rows may not sum to reported totals because search providers can withhold low-volume data.

Before publishing, verify every displayed total, delta, percentage, average, and weighted position.

PUBLISHING

If this is the first run, create the permanent public Sites report and return its URL.

If this is a later run, publish the new month to the existing Sites project and keep the same URL.

Keep the report publicly accessible without requiring ChatGPT sign-in.

After publishing, return:

1. The report URL
2. The five most important findings from the newly completed month
3. Any data-quality or source limitations encountered during the run