Content performance by author
“rank blog authors by page views, average engagement time and conversions from their posts this quarter”
Rank blog authors by page views, average engagement time and conversions from their posts this quarter in Google Analytics blog posts performance.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileGoogle Analytics blog posts performanceCSV export · 18 rows
- StepRank authors this quarterStep 1
- ResultBlog author rankings8 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 8 rows came out.
- Download Google Analytics blog posts performance sample (18 rows)Google Analytics 4: Reports > Engagement > Pages and screens > add custom dimension 'Author' > Export CSV
What you get back
The result of that run, the rows to look at first.
| Author | Page views rank | Page views | Average engagement time rank | Average engagement time (seconds) | Conversions rank | Conversions |
|---|---|---|---|---|---|---|
| Ava Chen | 1 | 5,085 | 7 | 103.30 | 1 | 79 |
| Elena Brooks | 2 | 4,095 | 8 | 89 | 2 | 60 |
| Hana Kim | 3 | 3,095 | 5 | 131.50 | 4 | 49 |
| Chloe Park | 4 | 2,550 | 6 | 120 | 5 | 40 |
| Ben Ortiz | 5 | 2,450 | 4 | 148.30 | 3 | 52 |
| Farah Malik | 6 | 1,510 | 3 | 167.50 | 6 | 29 |
| Diego Reyes | 7 | 1,090 | 2 | 193.50 | 7 | 25 |
| Gavin Stone | 8 | 970 | 1 | 194 | 8 | 16 |
How do you rank blog authors by page views, average engagement time and conversions from their posts this quarter?
Export your blog posts performance data from Google Analytics, then load it into the workflow. It ranks authors this quarter using page views, average engagement time and conversions from their posts. The result is a blog author ranking table you can review and reuse.
How it works
How to use the Blog author rankings workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Blog author rankings: questions
What file should you export for this workflow?
What happens to rows that do not match the rules?
How do you change the ranking rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Decide which pages to keep, update or prune, and find the search terms that spend without converting.
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template
- Google Ads wasted spendFind search terms with spend and no conversions in the last 30 days, ranked by spend, from a Google Ads export.See the workflow Built by the agent
- Keyword rankings changeCompare this month's average position with last month from Search Console and see which keywords moved up or down in a keyword ranking report.See the workflow Built by the agent
- Negative keyword finderEvery search term that spent money and never converted, with its share of spendSee the workflow Template
- Marketing ROI by campaignCalculate marketing ROI for each campaign from HubSpot exports, using won deal revenue and campaign spend.See the workflow Built by the agent