"互联网常见广告形式介绍及分类详解"

0 下载量 24 浏览量 更新于2024-01-22 收藏 8.35MB PPT 举报
互联网广告是当今数字媒体领域中常见的一种形式,它利用互联网平台传递信息和推广产品、服务等。广告商通过购买广告位或与媒体合作,在互联网上展示自己的广告内容,以达到宣传和推广的目的。互联网广告形式的多样化给广告主和消费者带来了许多选择,同时也给媒体平台带来了更多的商业机会。 首先,根据主要的载体(平台),互联网广告形式可以分为资讯网站、搜索引擎、SNS网站和客户端(IM、EMAIL、无线)等。其中,资讯网站以图片广告、视频广告、文字广告、富媒体广告、赞助广告和置入式广告等多种形式来展示广告内容。搜索引擎主要通过行为定向广告、关键字匹配广告和定向邮件广告来实现投放。SNS网站通常采用常规硬性广告和特殊内容资源广告,而客户端则主要通过APP内嵌广告和推送广告进行投放。 其次,根据表现形式,互联网广告形式又可以分为对联广告、按钮广告、文字链广告、通栏广告、焦点图广告和视频广告等。例如,对联广告是指两个矩形或方形广告横向放置在一个页面的上下两端。按钮广告则是通过按钮的形式将广告内容与网页内容结合在一起。文字链广告是以文字的形式出现在网页上,并通过链接引导用户点击。通栏广告则是水平横跨整个网页的广告形式,焦点图广告则是以图片的形式展示广告内容。视频广告则是通过视频的形式展示广告内容,常见于视频网站和移动应用。 再次,互联网广告还可以按是否定向分为行为定向广告、关键字匹配广告和定向邮件广告。行为定向广告是根据网民的浏览习惯进行广告投放,以精确定位广告受众。关键字匹配广告则是根据页面上的关键词内容显示相关的广告。定向邮件广告则是根据用户的个人信息和订阅情况,将广告通过邮件发送给目标用户。 最后,互联网广告还可以按是否占用广告资源分为常规硬性广告和特殊内容资源广告。常规硬性广告是指那些常见的、以广告形式显示的内容,如横幅广告、弹出广告等。特殊内容资源广告则是以新闻内容、新闻专题的方式出现,通常是被用户广泛接受和关注的内容。 总的来说,互联网广告形式繁多,涵盖了平台、表现形式、定向方式和资源占用等多个方面。随着互联网技术的发展和用户需求的变化,互联网广告形式也在不断创新和演变。对于广告主来说,选择适合自己产品和目标受众的广告形式是提升广告效果的关键。对于消费者来说,科学合理地管理广告内容和频次对于提升用户体验也是非常重要的。因此,互联网广告形式的研究和应用将继续受到关注,并随着时代的发展而不断演进。

SELECT PIS.SHOW_FLT_DETAIL AS SHOW_FLT_DETAIL -- new , PIS.SHOW_AWB_DETAIL AS SHOW_AWB_DETAIL -- new , PIS.DISPLAY_AIRLINE_CODE AS CARRIER_CODE , DECODE(PIS.REVERT_FLOW,'N',PIS.FLOW_TYPE,DECODE(PIS.FLOW_TYPE,'I','E','I')) AS FLOW_TYPE , PIS.SHIP_TO_LOCATION AS SHIP_TO_LOCATION , PIS.INVOICE_SEQUENCE AS INVOICE_SEQUENCE , PFT.FLIGHT_DATE AS FLIGHT_DATE , PFT.FLIGHT_CARRIER_CODE AS FLIGHT_CARRIER_CODE , PFT.FLIGHT_SERIAL_NUMBER AS FLIGHT_SERIAL_NUMBER , PFT.FLOW_TYPE AS AIRCRAFT_FLOW , FAST.AIRCRAFT_SERVICE_TYPE AS AIRCRAFT_SERVICE_TYPE , PPT.AWB_NUMBER AS AWB_NUMBER , PPT.WEIGHT AS WEIGHT , PPT.CARGO_HANDLING_OPERATOR AS CARGO_HANDLING_OPERATOR , PPT.SHIPMENT_PACKING_TYPE AS SHIPMENT_PACKING_TYPE , PPT.SHIPMENT_FLOW_TYPE AS SHIPMENT_FLOW_TYPE , PPT.SHIPMENT_BUILD_TYPE AS SHIPMENT_BUILD_TYPE , PPT.SHIPMENT_CARGO_TYPE AS SHIPMENT_CARGO_TYPE , PPT.REVENUE_TYPE AS REVENUE_TYPE , PFT.JV_FLIGHT_CARRIER_CODE AS JV_FLIGHT_CARRIER_CODE , PPT.PORT_TONNAGE_UID AS PORT_TONNAGE_UID , PPT.AWB_UID AS AWB_UID , PIS.INVOICE_SEPARATION_UID AS INVOICE_SEPARATION_UID , PFT.FLIGHT_TONNAGE_UID AS FLIGHT_TONNAGE_UID FROM PN_FLT_TONNAGES PFT , FZ_AIRLINES FA , PN_TONNAGE_FLT_PORTS PTFP , PN_PORT_TONNAGES PPT , FF_AIRCRAFT_SERVICE_TYPES FAST , SR_PN_INVOICE_SEPARATIONS PIS --new , SR_PN_INVOICE_SEP_DETAILS PISD--new , SR_PN_INV_SEP_PORT_TONNAGES PISPT --new WHERE PFT.FLIGHT_OPERATION_DATE >= trunc( CASE :rundate WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN ADD_MONTHS(SYSDATE,-1) ELSE ADD_MONTHS(:rundate,-1) END, 'MON') AND PFT.FLIGHT_OPERATION_DATE < trunc( CASE :rundate WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN TRUNC(SYSDATE) ELSE TRUNC(:rundate) END, 'MON') AND PFT.TYPE IN ('C', 'F') AND PFT.RECORD_TYPE = 'M' AND (PFT.TERMINAL_OPERATOR NOT IN ('X', 'A') OR (PFT.TERMINAL_OPERATOR <> 'X' AND FA.CARRIER_CODE IN (SELECT * FROM SPECIAL_HANDLING_AIRLINE) AND PPT.REVENUE_TYPE IN (SELECT * FROM SPECIAL_REVENUE_TYPE) AND PPT.SHIPMENT_FLOW_TYPE IN (SELECT * FROM SPECIAL_SHIPMENT_FLOW_TYPE) AND PFT.FLIGHT_OPERATION_DATE >= (select EFF_DATE from SPECIAL_HANDLING_EFF_DATE) )) AND PFT.DELETING_DATETIME IS NULL AND FA.AIRLINE_UID = PFT.AIRLINE_UID AND FA.DELETING_DATETIME IS NULL AND PTFP.FLIGHT_TONNAGE_UID = PFT.FLIGHT_TONNAGE_UID AND PTFP.RECORD_TYPE = 'M' AND PTFP.DELETING_DATETIME IS NULL AND PPT.TONNAGE_FLIGHT_PORT_UID (+)= PTFP.TONNAGE_FLIGHT_PORT_UID AND PPT.RECORD_TYPE (+)= 'M' AND PPT.DISCREPANCY_TYPE (+)= 'NONE' AND PPT.ADJUSTMENT_INC_FLAG (+)= 'Y' AND PPT.DELETING_DATETIME (+) IS NULL AND FAST.AIRCRAFT_SERVICE_TYPE_UID = PFT.AIRCRAFT_SERVICE_TYPE_UID AND FAST.DELETING_DATETIME IS NULL AND PIS.TEMPORAL_NAME = TO_CHAR((CASE :rundate --new WHEN TO_DATE('01/01/1900', 'DD/MM/YYYY') THEN TRUNC(SYSDATE) ELSE TRUNC(:rundate) END ), 'YYYYMM') || '00' AND PIS.INVOICE_SEPARATION_UID = PISD.INVOICE_SEPARATION_UID --new AND PISD.INVOICE_SEP_DETAIL_UID = PISPT.INVOICE_SEP_DETAIL_UID --new AND PISPT.PORT_TONNAGE_UID = PPT.PORT_TONNAGE_UID --new AND PIS.PRINT_SUPPORTING_DOC = 'Y';上面是oracle的写法,请转成spark SQL的写法。

2023-06-02 上传