Counting pdf downoad and video plays

[vs_jain]

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

[TanmayMathur]

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.

[Kaushalendra · Accepted solution]

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".

[vs_jain]

Thanks Kaushalendra. I will try this at my end.

[vs_jain]

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.