Automates marketing analytics by collecting advertising data from Facebook, TikTok, and Snapchat into a centralized database for daily performance analysis.
git clone https://github.com/NPodlozhniy/marketing-pipeline.gitMarketing Pipeline automates the collection of advertising performance data from Facebook, TikTok, and Snapchat into a centralized database. It solves the problem marketing teams face daily: analyzing campaign budgets and conversion metrics across multiple ad platforms without expensive third-party tools. The system uses OAuth 2.0 authentication to securely access each platform's advertising API, creating a unified data pipeline that enables teams to make data-driven decisions quickly. Setup requires obtaining API credentials from each advertising platform and configuring service accounts, making it suitable for mid-to-large organizations with dedicated marketing operations teams.
Obtain API credentials from Facebook, TikTok, and Snapchat advertising dashboards using OAuth 2.0 authentication. Configure the respective Python scripts with your App IDs, secrets, and access tokens. Run the pipeline to collect data into your database, then visualize results via connected dashboards.
Daily multi-platform ad performance monitoring and budget tracking
Centralized campaign ROI analysis across Facebook, TikTok, and Snapchat
Automated data collection for marketing dashboard visualization
Competitive analysis of advertising spend and conversion efficiency
No install command available. Check the GitHub repository for manual installation instructions.
git clone https://github.com/NPodlozhniy/marketing-pipelineCopy the install command above and run it in your terminal.
Launch Claude Code, Cursor, or your preferred AI coding agent.
Use the prompt template or examples below to test the skill.
Adapt the skill to your specific use case and workflow.
Automate the data collection process for our marketing pipeline. We need to gather data from [CAMPAIGN_PLATFORMS] like Google Ads, Facebook Ads, and LinkedIn Ads. The data should include [METRICS] such as impressions, clicks, conversions, and cost-per-click. Please provide a step-by-step guide to set up automated data collection using [TOOLS] like Google Analytics, Zapier, or custom scripts.
## Marketing Pipeline Automation Guide ### Step 1: Identify Data Sources - **Google Ads**: Impressions, Clicks, Conversions, Cost-per-Click - **Facebook Ads**: Reach, Engagement, Leads, Cost-per-Action - **LinkedIn Ads**: Views, Clicks, Leads, Cost-per-Lead ### Step 2: Set Up Data Collection Tools - **Google Analytics**: Configure goals and funnels to track conversions. - **Zapier**: Create zaps to automate data transfer from ad platforms to your CRM or analytics tool. - **Custom Scripts**: Use Python or JavaScript to fetch data via APIs and store it in a database. ### Step 3: Automate Data Collection - **Google Ads**: Use the Google Ads API to fetch data daily. - **Facebook Ads**: Use the Facebook Marketing API to pull data into your analytics tool. - **LinkedIn Ads**: Use the LinkedIn API to collect data and store it in a spreadsheet or database. ### Step 4: Analyze and Report - **Google Analytics**: Set up dashboards to visualize data trends. - **CRM Integration**: Use tools like Salesforce or HubSpot to track lead sources and conversions. - **Custom Reports**: Generate weekly or monthly reports to track campaign performance.
Take a free 3-minute scan and get personalized AI skill recommendations.
Take free scan