Just paste the URL of the article you\u2019re interested in into Content Analytics\u2019 Page URL<\/strong> field:<\/p>\n\n\n\n It\u2019s also helpful to get a holistic view, to see how all your articles perform over time. For this you\u2019ll have to go beyond the dashboard \u2013 but don\u2019t worry, we\u2019re including a ready-to-use prompt from our partnerships manager Polina.<\/p>\n\n\n\n You\u2019ll end up with a highlight table showing which articles are evergreen, which are rising stars, and which need attention.<\/p>\n\n\n\n Look complicated? Thanks to AI, it\u2019s not. Here\u2019s how to generate a table like this in two minutes.<\/p>\n\n\n\n Go to Reports<\/strong> \u2192 Bookings<\/strong>, set the date range to 12 months<\/strong>, and click Download CSV<\/strong>.<\/p>\n\n\n\n Upload your CSV to any AI model (Polina recommends Claude) and paste the following:<\/p>\n\n\n\n I have a CSV file with booking data. Columns: booked_at (datetime, YYYY-MM-DD HH:MM:SS), page_url, action_state (processing \/ paid \/ cancelled), total_profit (float), bookings_pending_profit (float). Please do the following: Polina here! I\u2019m a partnerships manager at Travelpayouts, which means I help our partners set up their blogs for monetization success ☺️ Look at the first column, Page URL<\/strong>. You\u2019ll see that some pages have been categorized as \u201cevergreen,\u201d \u201crising,\u201d or \u201c(needs) attention.\u201d<\/p>\n<\/div><\/div>\n\n\n\n Evergreen articles<\/strong> are your most reliable ones. They have stable revenue year-round.<\/p>\n\n\n\n Rising stars<\/strong> are gaining revenue from month to month. They probably haven\u2019t peaked yet, so act before they do.<\/p>\n\n\n\n Articles that need attention<\/strong> require a quick diagnosis first. Is the page still ranking but not converting, or has it lost its rankings entirely?<\/p>\n\n\n\n ℹ️ A general tip: in cases like this, if you don\u2019t have a ready-made prompt, you don\u2019t even need to write one! Just describe what you need to AI and ask for a prompt.<\/p>\n\n\n\n Your Bookings report is a powerful starting point. Among other things, it can tell you which affiliate programs bring you the most orders and earnings.<\/p>\n\n\n\n But sometimes, you may want to find out more about specific sales. To do so, just hover over any row in the report, find the Description<\/strong> field, and click View details<\/strong>. You’ll get a full booking card showing details like customer country, device, referrer page, and earnings history.<\/p>\n\n\n\n Your Bookings report shows your totals per program, but if you go one level deeper, you can find out which offers are actually driving revenue.<\/p>\n\n\n\n Again, this is a task for AI, and our partnerships manager Alexandra has a readymade prompt for you.<\/p>\n\n\n\n Go to your Bookings report, select the desired period, filter by one program (your top-earning brand is the best place to start), and download the file as a CSV.<\/p>\n\n\n\n Upload your CSV to Google Sheets. Add a “Total commission” column with Method 1<\/strong>: In Google Sheets, click the Gemini button, select Analyze Data<\/strong>, and paste a prompt like this:<\/p>\n\n\n Show me the top 5 products by total commission and top 5 by number of bookings.<\/p>\n<\/blockquote>\n<\/div>\n\n\n You’ll get a ranked breakdown in seconds, no formulas needed.<\/p>\n\n\n\n Method 2<\/strong>: You can also upload your CSV to ChatGPT or Claude and ask the same thing.<\/p>\n\n\n I have a CSV with affiliate booking data. Please analyze it and show me: Hello! I\u2019m Alexandra, and I love using data to help travel creators earn more. Now that you know which products your readers book, here\u2019s what you can do with that info. <\/p>\n<\/div><\/div>\n\n\n\n Your blog analytics can tell you so much \u2013 all it takes is a few minutes of your time. And now that you have some data-informed next steps, get to them!<\/p>\n","protected":false},"excerpt":{"rendered":" Travelpayouts partnerships managers share easy ways to get advanced insights.<\/p>\n","protected":false},"author":85,"featured_media":30107,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[7,619,616,611],"tags":[560,720],"class_list":["post-30103","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-advices","category-ai-tools","category-content","category-how-it-works","tag-ai","tag-content-data"],"acf":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/posts\/30103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/users\/85"}],"replies":[{"embeddable":true,"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/comments?post=30103"}],"version-history":[{"count":12,"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/posts\/30103\/revisions"}],"predecessor-version":[{"id":30136,"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/posts\/30103\/revisions\/30136"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/media\/30107"}],"wp:attachment":[{"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/media?parent=30103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/categories?post=30103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.travelpayouts.com\/blog\/wp-json\/wp\/v2\/tags?post=30103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/www.travelpayouts.com\/blog\/wp-content\/uploads\/2026\/06\/image-9-1024x539.jpeg\")
<\/figure>\n\n\n\nTip 2: Zoom out and look at all your pages<\/h2>\n\n\n\n
![\"\"](\"https:\/\/www.travelpayouts.com\/blog\/wp-content\/uploads\/2026\/06\/image-8-1024x539.jpeg\")
<\/figure>\n\n\n\nStep 1: Export your data<\/h3>\n\n\n\n
Step 2: Check everything with AI<\/h3>\n\n\n\n
\n
1. Filter out cancelled bookings (action_state != ‘cancelled’)
2. Calculate revenue = total_profit + bookings_pending_profit
3. Extract month from booked_at in YYYY-MM format
4. Build a pivot table: rows = page_url (short slug only, without domain), columns = month (sorted chronologically), values = sum of revenue, empty cells = 0
5. Add a Total column (sum of revenue across all months per URL)
6. Round all values to 2 decimal places
7. Sort by Total descending
8. Visualize as a highlight table: color each cell with a blue gradient \u2013 the darker\/more saturated the blue, the higher the value. Use per-column normalization (each month column scaled independently) so contrast is visible even in low-revenue months. The Total column uses its own scale. Empty cells (0) show \u201c\u2014\u201d with no fill. Display short URL slugs (no domain). Use \u20ac as currency symbol. Bold the Total column values.
9. Identify evergreen articles (stable revenue year-round), rising stars (growing month over month), and articles that need attention (revenue dropping or inconsistent).<\/p>\n<\/blockquote>\n<\/div>\n\n\n![\"\"](\"https:\/\/www.travelpayouts.com\/blog\/wp-content\/uploads\/2026\/06\/image6-2.jpg\")
<\/figure>
Once you\u2019ve got your table, here\u2019s what to do with it. <\/p>\n<\/div><\/div>\n<\/div><\/div>\n<\/div><\/div>\n\n\n\n\n
\n
\n
\n\n\n\n
\n\n\n\nTip 3: Dig into specific bookings<\/h2>\n\n\n\n
![\"\"](\"https:\/\/www.travelpayouts.com\/blog\/wp-content\/uploads\/2026\/06\/image-11-1024x539.jpeg\")
<\/figure>\n\n\n\nTip 4: Find your top-earning offers<\/h2>\n\n\n\n
Step 1: Download your data<\/h3>\n\n\n\n
Step 2: Prep your data in Google Sheets<\/h3>\n\n\n\n
=total_profit + bookings_pending_profit<\/code>, and filter out bookings with status \u201ccancelled\u201d in the action_state<\/code> column.<\/p>\n\n\n\nStep 3: Let AI do the work<\/h3>\n\n\n\n
\n
\n
1. Top 15 products by number of bookings \u2014 table with: product name, number of bookings
2. Top 15 products by total commission \u2014 bar chart with: product name, total commission
Notes:
– Extract product name from the description column \u2014 take everything before “. Customer from”
– Total commission = total_profit + bookings_pending_profit
– Exclude cancelled bookings (action_state = “cancelled”)<\/p>\n<\/blockquote>\n<\/div>\n\n\n![\"\"](\"https:\/\/www.travelpayouts.com\/blog\/wp-content\/uploads\/2026\/06\/image-7-1024x539.jpeg\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/www.travelpayouts.com\/blog\/wp-content\/uploads\/2026\/06\/image3.jpg\")
<\/figure>\n