This message was deleted.
# markops
s
This message was deleted.
s
Create a custom report in GA with regex and put | between url slugs. That should do. But someone has to add the slug of new blogs as and when needed
🙌 1
t
I was hoping for a complicated but automated way of using article schema to pick the author name and building a report or something! But hopefully writers will do it as a part of the publishing workflow 😄
i
Great advice, @Shaf! I think regex has character limits in GA so if you run into that you can try doing it using 2-3 vlookups. @theanand
🙌 1
Method 1: In case you need to do it multiple times. Ask your writers to tag everything in the sheet that they're maintaining. Then you can use this as a data source in a looker dashboard. Pull in the rest, use the tags to filter. Should work. https://www.portent.com/blog/analytics/troubleshooting-data-blending-in-google-data-studio.htm#:~:text=Looker%20Studio%20allows%20users%20to,as%20your%20left%2Dmost%20source.
Method 2: In case this is just a one off thing Set up: Sheet 1- Ask your writers to tag everything in the sheet that they're maintaining. Sheet 2- Your data export from whichever source you're using Sheet 3- The table you want Formulas: Add the tags to sheet 2 from sheet 1 using VLOOKUP Create a pivot table in sheet 3 and filter by the tags.
Method 3: Buy a attribution/reporting software. Lol
Start with what @Shaf suggested.
t
Thanks @Ishaan Shakunt! Much appreciated!