This demo displays sample data only. Production access is protected by invited-email login and role-based access control.
本デモはサンプルデータを表示するモードです。実運用時は招待制ログインとロール別アクセス制御で保護されます。
Status (October 2026): The tool is in production for all of our Google Ads sub-accounts. Google Ads API Basic Access was granted in August 2026. We have applied for Standard Access because our usage averages about 72% of the Basic Access daily operation limit and has reached the limit on several days.
1. Purpose of the Application
AdGuild Ad Report Dashboard is an internal business dashboard application developed and operated in-house by ADGUILD, K.K. (Kabushiki Kaisha AdGuild), a Japan-based performance-marketing company, to streamline our own Google Ads operations. ADGUILD runs a pay-per-click (PPC) affiliate-marketing business: we create and operate landing pages for advertisers' products, drive traffic to them with Google Ads (Search, Performance Max, and Demand Gen campaigns), and earn performance-based commissions. We operate about 160 enabled Google Ads sub-accounts under our Manager Account (MCC 370-641-8337).
The dashboard uses the Google Ads API to (1) automatically ingest advertising performance reports for all sub-accounts, and (2) let our internal staff perform routine, day-to-day account operations — which we previously did by hand in the Google Ads UI — through a single audited path. It replaced our legacy Google Ads Scripts reporting setup in August 2026, removing the 30-minute execution limit and adding structured error handling, CI/CD integration, and a consolidated dashboard the whole team can reference.
2. Screenshots
The dashboard is in production and has been fed by the Google Ads API since August 2026. The screenshots below are from the live system.
Figure 1 — Main dashboard: cross-account campaign performance (impressions, clicks, conversions, cost)Figure 2 — Account overview: sub-accounts under MCC 370-641-8337 with aggregated metricsFigure 3 — Campaign detail: keyword / search-term / ad / asset level reportsFigure 4 — Monthly report: spend and conversion aggregation
3. Main Features
3.1 Reporting (read-only)
Automatic hourly and daily ingestion of campaign, ad-group, Performance Max and Demand Gen performance metrics (impressions, clicks, conversions, cost, impression share, etc.)
Cross-account views over all sub-accounts under our MCC; monthly, weekly, and custom date ranges
Cross-platform comparison with Yahoo! JAPAN Ads, Meta Ads, and Microsoft Ads
Change Events audit-log view of configuration changes
3.2 Account operations (write)
All of the following are routine tasks our staff previously performed manually in the Google Ads UI. The tool lets them run the same operations from the dashboard and from internal command-line workflows, with every write validated and audit-logged:
Creating new sub-accounts under our MCC
Creating conversion actions
Sending user-access invitations from the MCC (restricted to a fixed, pre-defined list of internal email addresses)
Creating audiences: rule-based remarketing lists, search-keyword custom segments and combined audiences (no customer data is uploaded)
Creating Search, Performance Max and Demand Gen campaigns from approved ad copy and assets (new campaigns are always created paused)
Updating Responsive Search Ad copy and extensions (sitelinks, callouts, structured snippets)
Changing campaign location targets
Uploading image and video assets for our own ads
Keyword idea generation (KeywordPlanIdeaService, seed-based suggestions)
3.3 Explicitly out of scope
Customer Match (uploading customer email / phone lists)
Offline conversion uploads
App Conversion Tracking and Remarketing API
Keyword plan forecasts (idea generation only)
Auto-applying Google recommendations
4. Who Uses It
This application is used only by ADGUILD employees and directly contracted analysts (currently 5–10 people). It is never exposed to clients, external vendors, or the general public. Access is controlled by multiple layers:
Invited-email whitelist (no profile is created without a pre-registered email, even after a successful Google login)
Role-based access control (admin / editor / viewer)
Per-operation permission matrix for every write operation
Ads API Google Ads API (Basic Access granted August 2026; Standard Access applied for), reporting + the internal write operations listed above
6. Data Handling
We retrieve aggregated advertising performance metrics only. No end-user personal information is collected.
We never upload personal data (emails, phone numbers, etc.) through the Google Ads API — no Customer Match.
Retrieved data is used only inside our own Supabase database and is never shared with third parties.
API credentials (OAuth client ID/secret, refresh tokens) are kept in Cloudflare Workers / GitHub Actions secret storage and our company password manager — never in our frontend or database.
