📢 Need a specialist for automating Google Ads reports in Google Sheets + Telegram bot (Combined report for 3 advertising accounts)
🛠 Project description:
There are three Google Ads advertising accounts, and it is necessary to automatically retrieve data from them, combine it into one Google Sheets, and send the report to Telegram.
❗ Important:
🔹 Data from all three accounts must be in ONE table, with the ability to filter them by account.
🔹 The Telegram bot must send one consolidated report + a brief analysis for each account separately.
🔹 The report must be updated daily automatically via API.
Goal: Automate the analysis of advertising expenses, campaign effectiveness, and report sending for quick decision-making.
🔹 What needs to be done?
1️⃣ Connecting 3 Google Ads API accounts to Google Sheets
✅ Set up Google Ads API (OAuth, Developer Token, Customer ID).
✅ Retrieve advertising data for the last 30 days from three accounts and combine them into one Google Sheet.
✅ Export the following metrics to Google Sheets:
- Account name
- Campaign
- Expenses
- Clicks
- Conversions
- CPA
- ROAS
- Optimal day of the week
- Best time of day for impressions
✅ Implement automatic updates via Google Apps Script Triggers (daily).
✅ Delete old records before loading new ones.
✅ Organize data so that it can be easily filtered by each account.
2️⃣ Optimizing Google Sheets for quick analysis
✅ One table where all accounts are in one place.
✅ Ability to filter campaigns by a specific account.
✅ Automatic sorting by campaign effectiveness (ROAS, CPA).
✅ Automatic deletion of old data to avoid "clutter".
3️⃣ Automatic sending of reports to Telegram
✅ Create a Telegram bot via BotFather.
✅ Use Telegram API to send messages.
✅ Send daily consolidated report in the following format:
📢 📊 Overview for the day (date)
🔹 Total expenses: 15,200 UAH
🔹 Number of conversions: 89
🔹 Average CPA: 171 UAH
🔹 ROAS (return on advertising spend): 6.2
🔹 Best product: "Tactical backpacks" (ROAS 8.5, budget +20%)
🔹 Worst product: "Flashlights" (ROAS 1.2, spent 500 UAH, stop)
🔹 Best day of the week for conversions: Tuesday
🔹 Optimal time for impressions: 18:00 - 22:00
📢 📊 Breakdown by accounts:
🔹 Account #1: Expenses 500 UAH, ROAS 7.1
🔹 Account #2: Expenses 300 UAH, ROAS 5.2
🔹 Account #3: Expenses 400 UAH, ROAS 4.8
✅ Weekly/monthly report in tabular format:
| Account | Campaign | Expenses | Clicks | Conversions | CPA | ROAS |
|---|
| Account 1 | Tactical backpacks | 500 | 5,800 | 140 | 89 UAH | 8.5 |
| Account 2 | Flashlights | 500 | 3,000 | 18 | 277 UAH | 1.2 |
| Account 3 | Hunting boots | 700 | 4,200 | 85 | 114 UAH | 6.3 |
✅ Automatic recommendations at the end of the report:
- ✅ Increase budget for: "Tactical backpacks" (+20%)
- ❌ Stop advertising for: "Flashlights" (ROAS < 2.0)
- ⚡ Optimize bids for: "Hunting boots" (-15% CPA)
🔹 What will I provide to the executor?
✅ Access to three Google Ads accounts.
✅ Access to Google Sheets.
✅ API Token for the Telegram bot.
🔹 Requirements for the executor:
📌 Experience with Google Ads API (retrieving data from multiple accounts).
📌 Ability to set up OAuth authorization for API requests.
📌 Experience with Google Apps Script (automation in Google Sheets).
📌 Experience creating Telegram bots via API.
📌 Preferably have experience in automating advertising reports.
📌
👨💻 Send examples of similar projects you have done.
✅ Indicate whether you have worked with Google Ads API, Google Sheets API, Telegram Bot API.
⏳ Specify completion timelines and desired payment.
📢 Looking forward to proposals! 🚀
