Marketing Reports

SPCTEK Marketing Reports

Developed by: SPCTEK

Overview:

SPCTEK Marketing Reports is an internal automation tool that generates weekly marketing performance summaries for clients. It connects to platforms like Google Ads, YouTube, Facebook, Instagram, TikTok, Zoho Campaigns, and Klaviyo to collect performance metrics and create visual reports.

The tool is built using n8n and runs securely on SPCTEK’s own servers.

What Data we request

SPCTEK Marketing Reports connects to:

1. Google Ads API

Data Accessed: Campaign name, impressions, clicks, spend, conversions, CTR, CPC, and CPL.
Purpose: To analyze paid advertising performance and calculate cost-effectiveness across campaigns.
How It’s Accessed: Through Google OAuth 2.0 authorization; the system retrieves only ad performance metrics from the connected account.

2. YouTube Data API

Data Accessed: Video views, watch time, likes, comments, and engagement metrics.
Purpose: To evaluate YouTube channel growth, content engagement, and audience activity for reporting.
How It’s Accessed: Using OAuth 2.0 authorization; the workflow reads public analytics data of authorized channels only.

3. Meta (Facebook & Instagram)

Data Accessed: Page or post insights such as impressions, reach, likes, comments, and engagement rates; ad performance data from Meta Ads.
Purpose: To measure organic and paid post performance for weekly social media summaries.
How It’s Accessed: Through the official Meta Graph API with system user tokens authorized under business settings.

4. TikTok API

Data Accessed: Follower counts, profile views, video views, likes, comments, and shares.
Purpose: To report on short-form video performance, reach, and engagement trends.
How It’s Accessed: Via TikTok Business API using authorized access tokens from connected accounts.

5. Zoho Campaigns API

Data Accessed: Email campaign stats including opens, clicks, bounces, unsubscribes, and deliveries.
Purpose: To generate performance summaries for email marketing campaigns and track engagement quality.
How It’s Accessed: Through Zoho Campaigns API with a secure organization-level API key.

6. Klaviyo API

Data Accessed: Campaign and flow data such as revenue, opens, clicks, bounces, unsubscribes, and spam complaints.
Purpose: To summarize automated email and flow performance for client reporting.
How It’s Accessed: Using Klaviyo’s private API key for read-only access to analytics data.

7. Meta Ad Creatives

Data Accessed: Ad titles, creative thumbnails, call-to-action links, and status.
Purpose: To visually showcase active ad creatives and their engagement summary in reports.
How It’s Accessed: Using Meta Marketing API endpoints under the business account authorization.

How It Works

The system connects securely to authorized ad accounts via Google OAuth.
Data is processed and combined with results from other marketing platforms.
A visual HTML and PDF report is generated automatically and shared internally or with clients.