topic Reporting for Dynamic Sales Rep Pages: Page views and form submissions over time in Dashboards & Reporting

Reporting for Dynamic Sales Rep Pages: Page views and form submissions over time

davidjwu92 — Thu, 08 Sep 2022 20:47:38 GMT

I know the data is there, because I can see graphs and charts in rep page's details. The rep pages are generated using data from a hubdb table.

How do I generate a report that shows how each rep page is performing over time?

Like the graph below, except breaking down by rep page instead of by traffic source.

Re: Reporting for Dynamic Sales Rep Pages: Page views and form submissions over time

kvlschaefer — Mon, 12 Sep 2022 19:31:00 GMT

Hi @davidjwu92,

Thanks for reaching out!

I would like to add our subject matter experts to this conversation to see if they have insight.

Hi @ChrisoKlepke, @Bryantworks, @GRajput, @Dan1 - Do you have any recommendations for @davidjwu92?

Thank you!

Best,

Kristen

Re: Reporting for Dynamic Sales Rep Pages: Page views and form submissions over time

ChrisoKlepke — Tue, 13 Sep 2022 09:52:23 GMT

Hey @davidjwu92 ,

thank you for reaching out to the community and thank you @kvlschaefer for tagging. Here is how I would go about this:

I assume that your rep pages contain something in the slug to identify them. If not I'd say this is would be a good practice to do as you're signaling some kind of hirachiy to the user and web crawlers. So something like this: https://www.example.com/consulting-team/jane-doe
Next, go to the Custom Report Builder and select Web Activities as the primary data source.
Configure your filter for the timeframe you want to look at. I've set mine up to be the last 120 days so last 4 months. Plus, create a filter for URL contains to filter only your rep pages. In my case, I went for blog just to demo this part.
We got the data now we would like to display them in a certain way: I'd recommend area chart and on the x axis timestamp. Use what every you like here. Monthly, weekly, daily... doesn't matter. On the Y put Count of page views and then break down by URL. Since you filtered out the rep pages before, you should only see the ones you're after.
If you get a message that too many data points are requested, adjust the timeframe or the breakdown to show only like the top ten pages.

That should do it. Please follow up if there are questions.

If you found this post helpful, consider helping others in the community to find answers faster by marking this as a solution. I'd really appreciate it.

Cheers,

Chriso

Re: Reporting for Dynamic Sales Rep Pages: Page views and form submissions over time

davidjwu92 — Tue, 13 Sep 2022 20:26:17 GMT

Aww yeah. I could've SWORN I did exactly that... but following your solution step by step did EXACTLY what I was going for. Thank you, thank you, thank you!!