Publisher Report

The Publisher Report contains click and order data. It is published to an S3 bucket accessible by the partner. The report is published on configurable interval which defaults to 24 hours. Each interval publishes data for the last 7 days. The naming convention is:

• Prefix: /<key>/YYYY/MM/ (defaults to slug)

• Clicks: narrativ_log_files_clicks_YYYYMMDD HH:00.csv

• Orders: narrativ_log_files_orders_YYYYMMDD HH:00.csv

The partner’s report reader should be compatible with Python’s csv.DictWriter

Contact your account manager to get started.

Schema

Clicks

Column	Description
click_id	Unique identifier for each click event
click_timestamp	Date Time of click in GMT
cookie_id	The cookie ID
article_url	For clicks: this is the URL which has the link that was clicked on; For impressions: the page URL that was viewed
is_clean_article_url	Bool: true if article url was passed to Howl during link creation; False if no url was passed to Howl and we read url from the page
referrer	Referrer from web browser
user_agent	User agent from web browser
is_click	Boolean flag to indicate click vs impressions Is_click will equal 1 when the record is a click, and 0 when the record is an impression
click_product_url	Product URL of the link that was clicked on
earnings	Earning for publisher. ​Please note this includes all payment models
click_product_category	Category of the product that was clicked on
click_is_brand_page	Boolean: true is the link that was clicked on linked to a brand page
click_u1_param	U1 parameter of the click
click_product_brand	Brand of the product that was clicked on
click_product_price	Price of the product that was clicked on
click_product_name	Name of the product that was clicked on
article_name	For clicks: this is the name of the article which has the link that was clicked on; For impressions: the Name of article that was viewed
link_id	Unique identifier for each Howl link, sometimes referred to as auction ID.
network	This identifies the payment model associated with the record - the values can be CPC, CPA, CPM, EPP
merchant	Merchant name of link
publication	Publisher name
link_type	Indicates if the link was created through a manual or programmatic process
channel	Digital channel of the event i.e. desktop
device_type	Device event occurred on
country_code	ISO 3166-2 Country code
link_source	Detailed information on how link was created.

Orders

Column	Description
order_product_id	Unique identifier for each record in the orders file, which is a combination of the order_id and the
product_id	Unique identifier of the order product
order_id	Unique identifier of the order generated by Howl
checkout_timestamp	Date time of the checkout in GMT
cookie_id	The cookie ID
article_url	URL of the page that has the link clicked attributed to this checkout
link_id	Unique identifier for each Howl link, sometimes referred to as auction ID. This refers to the link attributed to this checkout. Please note this can be used to join the orders file.
referrer	Referrer from web browser
user_agent	User agent from web browser
network_type	Type of network from where the checkout data is obtained - ‘Howl - No returns’ or ‘Rakuten - Returns Apply’
click_product_url	Product URL of the link that was clicked on, attributed to this checkout
click_product_category	Category of the product that was clicked on
click_is_brand_page	Boolean: true is the attributed link that was clicked on linked to a brand page
days_since_attributed_click	Number of days since the click event attributed to this checkout
purchased_product_id	Product ID of the product purchased. This is the Merchant’s product ID
purchased_product_name	Name of the product purchased
purchased_product_brand	Brand of the product purchased
purchased_product_price	Price of the product purchased
click_u1_param	U1 parameter of the click attributed to this checkout
checkout_id	Identifier of the checkout from the Merchant
earnings	This contains EPP and Linkshare earnings. Please note for orders with multiple products, the earnings column for each row is the earnings for the total order, not that individual product within the order.
revenue	Revenue driven by the order
number_products_purchased	Quantity of products purchased
click_product_brand	Brand of the product that was clicked on attributed to this checkout
click_product_price	Price of the product that was clicked on attributed to this checkout
click_product_name	Name of the product that was clicked on attributed to this checkout
article_name	name of the article which has the link that was clicked on attributed to this checkout
network	This identifies the payment model associated with the record - the values can be CPC, CPA, CPM, EPP. This can be used to pivot the earnings and identify how much the EPP earnings are, and how much the CPA earnings are
merchant	Merchant name
publication	Publisher Name
channel	Digital channel of the event i.e. desktop
device_type	Device event occurred on
country_code	ISO 3166-2 Country code
click_id	Unique identifier for each click event attributed to this checkout
click_timestamp	Date time in GMT of the click attributed to this checkout