CTR for content placements on main site
Hi everyone,
I am looking to explore a specific use case where I am trying to see if I can calculate the CTR for placements on the site in a simplified form.
To give you guys a background- I have a Site A which is the main site and Site B which is the content site. The data for both sites goes to different report suites. I need a solution to find the CTR for site B content on Site A page. The way I calculate this is by dividing unique pageviews of the site B placement (I use the ICID value) / unique pageviews of the page on site A (I look at the pageName variable). I track site B performance using ICIDS. This calculation process is very manual for me currently as to calculate the CTR I have to know the live date for each site B placement and calculate CTR from the start date to current. Also, with data in different report suites adds additional challenge.
I've built a new tracking to pass the pagename of site A + ICID for Site B to be showing on site A report suite so that makes it slightly easy, however, I still need to join tables and need to know the live dates for the placement to be able to calculate the CTR. Do you guys have any ideas on how can this be done in a more simplified manner where I can directly see the CTR for a site B placement against that ICID?
Thank you.
Regards