TeamRaiser - report - pulling in the participant's personal page URL

Sarah Kershaw

Hello one and all,


Is it possible to pull in a participants page URL into a report? right now I'm running the registrations report and the page URLs would be really helpful. If anyone knows what this data field is called or how to pull it in?


Many thanks!


SK

Romany Nassief

There is not currently a way to report on Personal Page URLs through either Reports Classic or Report Writer. What about this workaround?


1) Include both "Participant Constituent ID" and "Event ID" columns in your report.

2) After getting the report result, download the sheet and manually add a new column for "Personal Page" with this function for first participant row

=CONCATENATE("http://<SITE NAME>/site/TR?pg=personal&px=",A1,"&fr_id=",B1)

Where A1 for "Participant Constituent ID" column and B1 for "Event ID" column. Also replace <Site NAME> with your luminate base domain.

3) Validate the function result by opening the generated URL for first row. If it looks good, drag the function cell across the rest of participants rows.


That's it!

Sarah Kershaw

Ah! You had me at concatenate! Thank you, great work around! Much appreciated.


SK

Sarah Kershaw

Sarah Kershaw:

Ah! You had me at concatenate! Thank you, great work around! Much appreciated.


SK

Weird update - I'm using the TeamRaiser registration form and for some reason, Event ID is not a data field. Is it possibly known as something else or perhaps it lurks in another report? I can pull in lots of other random Event-related fields (such as Campaig Tax ID, previous campaign ID, etc, etc, but Event ID specifically is not listed. 


Anyone have any ideas?

Romany Nassief

TeamRaiser Registrations Report gathers participants who has registered for a specific TeamRaiser event and in this case Event ID should be static in your equation:


=CONCATENATE("http://<SITE NAME>/site/TR?pg=personal&fr_id=<EVENT ID>&px=",A1)


However, with TeamRaiser Cross Event Registrations Report, the Event ID is listed in report columns selection.

Sarah Kershaw

Goodness - thank you so much! The report data field options are still something of a rabbit hole to me. I really appreciate you taking the time to respond!


SK