- AI-Agent
- Ready to Run
Import Campaign Metrics
Load daily ad report rows into your campaign analysis table
Use this Agent instantly or customize it - no programming needed
- Daily run timeDaily run time
Your scheduled start time determines the report date using your chosen time zone and delay.
- Import rulesImport rules
Your chosen accounts, field mapping, metric limits, and replacement rule guide each import.
- Campaign reportCampaign report
Your campaign report supplies dated campaign metrics, or a retrieval error when unavailable.
- Table schemaTable schema
Your table schema tells the Agent which columns and types can accept campaign metrics.
- Existing campaign rowsExisting campaign rows
Your existing rows reveal which account, campaign, and date combinations already appear.
Your ad reporting platform supplies daily campaign metrics for the accounts you choose.
Your data warehouse holds the table schema, campaign rows, and import log.
- Import log entryImport log entry
Your import log shows the report date, row counts, and reasons for skipped or failed rows.
- Import log entryImport log entry
Your import log shows the report date, row counts, and reasons for skipped or failed rows.
- Campaign metrics rowsCampaign metrics rows
Your analysis table receives checked campaign-day metrics for each confirmed insert or update.
- Import log entryImport log entry
Your import log shows the report date, row counts, and reasons for skipped or failed rows.
This Agent requests the latest closed campaign report after your daily cutoff. It checks campaign rows and writes valid figures to your table. You get a tally of loaded rows and exceptions.
Modify Agent
Customize this Agent to fit your needs using natural language.
Start Agent for Free
Enter your email address and we will send you a secure link to continue.
AirtableUsed as:
- Ad reporting platform
Airtable supplies daily campaign metrics for the accounts you choose.
- Data warehouse
Airtable holds the table schema, campaign rows, and import log.
monday.comUsed as:
- Ad reporting platform
monday.com supplies daily campaign metrics for the accounts you choose.
- Data warehouse
monday.com holds the table schema, campaign rows, and import log.
Google AdsUsed as:
- Ad reporting platform
Google Ads supplies daily campaign metrics for the accounts you choose.
LinkedIn AdsUsed as:
- Ad reporting platform
LinkedIn Ads supplies daily campaign metrics for the accounts you choose.
LinkedInUsed as:
- Ad reporting platform
LinkedIn supplies daily campaign metrics for the accounts you choose.
Superhuman DocsUsed as:
- Data warehouse
Superhuman Docs holds the table schema, campaign rows, and import log.
KintoneUsed as:
- Ad reporting platform
Kintone supplies daily campaign metrics for the accounts you choose.
- Data warehouse
Kintone holds the table schema, campaign rows, and import log.
Made for your industry
Import Campaign Metrics is made for businesses in these industries.
- Advertising and Marketing
Keep client campaign metrics current and flag rows that need correction.
Show all Agents for the Advertising and Marketing industry - Retail
Load daily ad results for retail campaigns into a checked analysis table.
Show all Agents for the Retail industry - Consumer Packaged Goods
Keep daily ad campaign figures ready for brand performance reviews.
Show all Agents for the Consumer Packaged Goods industry
Made for your role
Import Campaign Metrics is made for people in these roles.
- Marketing Analyst
Load checked campaign metrics so analysis starts from current figures.
Show all Agents for the Marketing Analyst role - Data Analyst
Add validated campaign-day rows to the analysis table.
Show all Agents for the Data Analyst role - Reporting Analyst
Map daily ad reports into campaign tables and log exceptions.
Show all Agents for the Reporting Analyst role - Paid Media Manager
Keep daily campaign results ready for spend and performance reviews.
Show all Agents for the Paid Media Manager role - Paid Media Analyst
Check daily campaign reports and load valid rows for analysis.
Show all Agents for the Paid Media Analyst role
Made for your department
Import Campaign Metrics is made for people in these departments.
- Marketing
Keep campaign performance figures current for daily reviews.
Show all Agents for the Marketing department - Data Analytics
Load checked campaign rows into the table used for analysis.
Show all Agents for the Data Analytics department - Business Intelligence
Keep campaign reporting tables current and flag rejected rows.
Show all Agents for the Business Intelligence department - Data Operations
Track daily campaign imports with row counts and exceptions.
Show all Agents for the Data Operations department
How Import Campaign Metrics works
5 steps, in order, on every run.
-
Get the latest closed reportRequest campaign figures for your selected accounts and reporting day. Record a retrieval error if the report is unavailable.
-
Check the table layoutRead your table columns and existing campaign rows. Stop table writes and log the problem if a required column is missing.
-
Check the campaign rowsMatch each row to your account and date rules. Set aside missing IDs, invalid metrics, and duplicate rows with reasons.
-
Load valid campaign figuresInsert or update rows by account, campaign, and date using your replacement rule. Count only confirmed table writes.
-
Record the import resultLog source, loaded, updated, and skipped counts for the report date. List failed rows and reasons for your review.
How to Get Started
Connect the tools you already use, such as Airtable, monday.com or Google Ads.
7 tools
- Choose the ad account IDs, daily reporting time and time zone, and the reporting delay used to select the latest closed day.
- Choose the campaign metrics table and import log table, and map account ID, campaign ID, date, impressions, clicks, and spend to their columns.
- Set accepted account IDs, metric types and ranges, and whether a later report replaces an existing row for the same account, campaign, and date.
Use safe mode to approve every result before it goes out, or let the Agent run automatically.
FAQs
Frequently asked questions about the Import Campaign Metrics:
You set the daily time, time zone, and reporting delay. The Agent uses those choices to select the latest closed reporting day.
You choose whether a later report replaces an existing campaign row. Duplicate rows within the source report go to the exceptions list.
You can review the error and affected rows in your import log. The Agent counts only confirmed writes and records an unavailable report as a zero-load error.
It stops and asks you. The Agent does not guess when it reaches a decision you have not approved.
Yes. Every run creates a plain-language log that you can review and export. Logs are kept for twelve months.
The Agent stops at the end of the billing month and its tool connections are removed. Your run logs remain available for twelve months.
Agents related to Import Campaign Metrics
More ready-to-run Agents for connected work.
Your coordinator gets both revision links in chat when the task and current proof differ, with the task held for a human choice.
17 toolsYour bill review stays on hold when a supplier sends a corrected invoice, with both versions and the earlier decision linked for your reviewer.
6 toolsYour campaign card shows whether the assigned reviewer can open the linked file, so your team can fix sharing before requesting review.
7 toolsYour review task shows file access problems before review starts. The owner sees what to fix.
6 tools