Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Counting pdf downoad and video plays

Avatar

Level 2

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

1 Accepted Solution

Avatar

Correct answer by
Employee

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

View solution in original post

4 Replies

Avatar

Level 10

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.

Avatar

Correct answer by
Employee

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

Avatar

Level 2

Thanks Kaushalendra. I will try this at my end.

Avatar

Level 2

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.