OPCAdvertising
Multichannel advertising report
Combine Facebook, Google and TikTok reports into one set of metrics, compare them with targets, and recommend how to divide the budget among channels for the next period. Each platform has its own file, column names and counting method. Facebook calls it "Results", Google calls it "Conversions", and TikTok writes "Conversions". Put the three files side by side and add them up, and you get a number bigger than the actual orders, because two platforms may both claim credit for one order. The Multichannel advertising report skill solves exactly this problem: drag all three files into the chat at once and enter the targets for the period. Everything is brought into one shared table, with a recommendation on where to focus the budget next period. What this skill does for you Recognizes which file belongs to which platform and combines differently named columns into one shared table: cost, impressions, clicks, conversions (the number of times viewers did what the ad aimed for: purchased, left their details or sent a message) and conversion value. Recalculates for each channel and the total: CTR (clicks divided by impressions), CPC (cost per click), CPM (cost per 1,000 impressions), CPA (cost per conversion) and ROAS (revenue per đồng of advertising). Compares money spent with the period budget: on target, under or over by 10%. Compares each channel with your targets, for example, CPA no more than 80k and ROAS of at least 3. If you have actual order numbers from a sales ledger or customer management software, calculates cost per actual order and places it next to the numbers reported by the platforms. Ranks each campaign: Increase · Keep · Monitor · Reduce/Turn off · Not enough data. If there is a Google keyword file, lists keywords that spent money without producing any conversions and recommends adding them to the exclusion list. Recommends the budget split for the next period by % for each channel, with reasons backed by numbers. Assign the task with just one message "Combine the October advertising reports from Facebook, Google and TikTok. CPA target no more than 80.000đ, monthly budget 30 triệu. This month we closed 312 orders and revenue was 96 triệu." (with 3 files attached) If a file uses dollars or another currency, you will be asked for the exchange rate; it will never be guessed. Targets already included in the project description or notes will be used automatically. What you get back An Excel file in bao-cao/: Overview (one column per channel, plus a total column and a note explaining the calculation), By campaign, Google keywords (when a file is provided), Recommendations and Next-period allocation (by amount and %). The app asks before saving. In the chat: a comparison table for the three channels, whether targets were met, actual orders compared with platform-reported orders, and 3 recommendations. What makes this skill different from an ordinary AI question It does not add things that should not be added. Messages, purchases and details submitted are not combined into one "total conversions" figure; "reach" is not added across rows or channels; platform conversion totals are never called actual orders. It uses the right columns. For Google, the report uses "Conversions", not "All conversions", unless you request otherwise. Existing rate columns are ignored and recalculated from the totals. It does not cut a channel just because it is more expensive. Google reaches people who already want to buy and is therefore often cheaper; Facebook and TikTok create demand. This skill recommends reducing gradually and tracking actual orders, rather than advising you to turn a channel off completely just because its CPA is high. ROAS is not profit. The report states this clearly so no one on the team misunderstands. It is a good fit if Your marketing team runs two or more platforms and everyone reports differently. You run an agency and need one reliable combined table before preparing a report for a client. Your boss asks "where should we put the money next month?" and you need a numbers-based answer. At the end of the month, you want to know whether you have overspent the budget. What to prepare Required: Excel/CSV files exported from Facebook Ads Manager, Google Ads and TikTok Ads Manager; select multiple files at once. Helpful to include: reporting period, targets and budget, actual orders and revenue, and Google's keyword-level file. Outside this skill's scope It does not log in to or change anything in your advertising accounts. It does not conclude that a campaign "should be turned off" when there is not enough data, and it does not make up missing numbers. To create a polished report for sending to a client → use Client report. If you only run Facebook and need to inspect each creative → Facebook advertising report is more concise. Use in Solo Agent After purchasing, assign this skill to an existing AI staff member on your team, or create a new staff member to handle it. One staff member can have multiple skills; the assistant sends each request to the right person with the appropriate skill. Often used together: Client report · Google advertising · TikTok advertising
New
99.000 ₫