Counting pdf downoad and video plays

Avatar

Avatar

vs_jain

Avatar

vs_jain

vs_jain

09-06-2017

Hi all,

I am implementing Adobe analytics using SQL. My data is stored on AWS. I was able to get metrics like visits, unique visitors etc using business rules from Adobe website (Page # 49 on this link: https://marketing.adobe.com/resources/help/en_US/sc/clickstream/analytics_clickstream.pdf ).

However, I am struggling to get count of pdf downloads/video plays. Has anyone implemented this earlier? Let me know

Regards,

Vishal

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Kaushalendra

Employee

Avatar

Kaushalendra

Employee

Kaushalendra
Employee

09-06-2017

Hi vs.jain​,

I believe you are calculating metrics using the Clickstream data stored on AWS.

For PDF Downloads, the call fired is a custom link call and those can be filtered based on page_event. Hence apply filter for "post_page_event = 101". For Video Plays, you can try "post_page_event = 76".

Answers (3)

Answers (3)

Avatar

Avatar

vs_jain

Avatar

vs_jain

vs_jain

21-06-2017

Kaushal - Thanks for your response earlier. It looks like pdf downloads is working at my end. However, I am not able to isolate video plays using the condition you stated. Is it possible there is another filter to video play? Let me know. I have already tried all possible filters under post_page_event. But that does not give me any result.

Avatar

Avatar

vs_jain

Avatar

vs_jain

vs_jain

09-06-2017

Thanks Kaushalendra. I will try this at my end.

Avatar

Avatar

TanmayMathur

Employee

Avatar

TanmayMathur

Employee

TanmayMathur
Employee

09-06-2017

Hi Vishal,

I am not sure about the SQL implementation but for javascript we use s.trackdownloadlinks to track file downloads - Automatic Tracking of Exit Links and File Downloads

See if this might help you.