adwords_reports
🥈SilverPython library for retrieving cross-account Google AdWords reports as pandas DataFrames, simplifying API interaction for campaign analysis.
1920Updated 1mo ago
Intermediate30min to implementmarketing
Saves ~120 min per use
Quick InstallView Source
git clone https://github.com/PYTHOMATION/adwords_reports.gitWorks with:
Claude
Overview
About This Skill
adwords_reports is a Python library that wraps the Google AdWords API to streamline cross-account reporting and data retrieval. It returns all reports as pandas DataFrames, enabling straightforward data analysis without complex API calls. The library supports Python 2.7 and 3.5+, making it accessible across environments. Users authenticate via a YAML credentials file and can access account hierarchies and detailed performance metrics. It's built for marketing teams and analysts who need programmatic access to AdWords data for reporting, optimization, and campaign analysis.
How to Use
Install via pip: `pip install adwords_reports`. Authenticate by obtaining AdWords API access and caching credentials in a YAML file. Pass the credentials path to the Client class and use the provided methods to retrieve reports. Review the examples/account_hierarchy.py file in the repository to get started.
Use Cases
Pull cross-account AdWords performance reports into pandas for analysis
Automate daily or weekly campaign reporting across multiple AdWords accounts
Extract account hierarchy and structure for multi-account management
Integrate AdWords data into Python data pipelines for marketing analytics
Tags
Setup & Installation
Quick Install
No install command available. Check the GitHub repository for manual installation instructions.
Alternative Install (Git Clone)
git clone https://github.com/PYTHOMATION/adwords_reportsRequirements
- Claude Code or compatible AI agent
- Works with: Claude
Quick Start Guide
1
Install the Skill
Copy the install command above and run it in your terminal.
2
Open Your AI Agent
Launch Claude Code, Cursor, or your preferred AI coding agent.
3
Try It Out
Use the prompt template or examples below to test the skill.
4
Customize
Adapt the skill to your specific use case and workflow.
Usage Examples
Prompt Template
Generate a comprehensive Google AdWords report for [COMPANY] in the [INDUSTRY] sector. Include key metrics like impressions, clicks, conversions, and cost-per-click (CPC) for the last 30 days. Use the following campaign data: [DATA]. Format the report in markdown with clear sections and bullet points.
Example Output
# Google AdWords Report for GreenTech Solutions ## Campaign Performance Overview - **Total Impressions:** 450,000 - **Total Clicks:** 12,000 - **Click-Through Rate (CTR):** 2.67% - **Total Conversions:** 300 - **Conversion Rate:** 2.5% - **Total Cost:** $15,000 - **Cost Per Click (CPC):** $1.25 - **Cost Per Conversion:** $50.00 ## Key Metrics by Campaign ### Eco-Friendly Products Campaign - **Impressions:** 200,000 - **Clicks:** 6,000 - **CTR:** 3.00% - **Conversions:** 180 - **Conversion Rate:** 3.00% - **Cost:** $7,500 - **CPC:** $1.25 - **Cost Per Conversion:** $41.67 ### Sustainable Living Campaign - **Impressions:** 250,000 - **Clicks:** 6,000 - **CTR:** 2.40% - **Conversions:** 120 - **Conversion Rate:** 2.00% - **Cost:** $7,500 - **CPC:** $1.25 - **Cost Per Conversion:** $62.50 ## Recommendations - **Increase Budget for Eco-Friendly Products Campaign:** This campaign has a higher conversion rate and lower cost per conversion. Consider allocating more budget to this campaign to maximize ROI. - **Optimize Ad Copy for Sustainable Living Campaign:** The lower CTR and conversion rate suggest that the ad copy may not be resonating with the target audience. Consider A/B testing different ad copies to improve performance. - **Leverage High-Performing Keywords:** Identify the keywords that are driving the most conversions and consider bidding more aggressively on these keywords to capture more traffic.
Find the right skills for your stack
Take a free 3-minute scan and get personalized AI skill recommendations.
Take free scan