You likely already have reporting set up in Looker Studio, Google Sheets, or other reporting tools to cover your standard monthly or weekly reporting needs.
However, our AI assistant comes in handy if you need an analysis that isn't available in your standard reporting. You may want to dive deeper into a specific area of your accounts or get data for a time frame that your existing reports don't cover.
This article shares a few powerful prompt examples you can copy, paste, and adjust as needed to see the results in your TrueClicks account!
Performance summaries
Performance summaries are a logical starting point for your AI assistant. Ask it to fetch, summarize, and visualize the data you care about for a time frame of your choice.
The prompt below summarizes and visualizes key performance data for the first half of 2025.
Tip: If you know the naming convention used for branded and generic campaigns in the account, include it in your prompt by adding “campaigns (not) containing the text …”. If you leave this out, the assistant will automatically infer which campaigns are branded and which are generic.
Analyze account data for the period January 1, 2025, to June 30, 2025.
1. Data Segmentation: Separate the data into two groups based on Campaign Name:
- Branded campaigns
- Generic (non-branded) campaigns
2. Performance Tables: Generate two summary tables containing the following columns: Impressions, Clicks, CTR, Avg. CPC, Cost, Conversions, Conversion Rate, and Cost / Conv.
Table A (Account Level): Show the aggregated totals for the entire account over the 6-month period.
Table B (Segmented): Show the totals for the 'Brand' segment and the 'Generic' segment side-by-side for comparison.
3. Trend Visualization: Aggregate the data monthly (Jan–Jun). Generate two separate line charts to visualize efficiency trends:
Chart 1: Monthly trend of Avg. CPC (y-axis) over time (x-axis). Plot two lines: one for Brand and one for Generic.
Chart 2: Monthly trend of Cost / Conv. (y-axis) over time (x-axis). Plot two lines: one for Brand and one for Generic.
This prompt should generate a result like this one:
Performance deviations
Let the AI assistant fetch performance data for a time period of your choice and spot when performance deviates from the average. Without asking for it, you'll likely receive some diagnostic output as well.
Example prompt:
Analyze the last 13 full weeks of account performance. Create a summary dashboard that visualizes the weekly trend of Cost vs. Conversions (using a dual-axis line chart) and ROAS (Return on Ad Spend).
Highlight any specific weeks where performance deviated significantly (>20%) from the average and summarize your findings.
This should generate a result like the one below:
