YPG - Campaign Metrics Report

YPG has requested a campaign metrics report to be delivered daily to an SFTP site.

This report must:

• Be delivered daily via SFTP (SFTP portion to be addressed in different task)
• File is in csv format
• File is UTF8 encoded
• First record must contain the column headers
• Must be able to rerun this report for discrepancies, network outages, etc. Must be able to specify a date to run against.
• Do not include DELETED/REMOVED campaigns
• Include zero impression campaigns (see note in comments)
• File name: YYYYMMDD_HHMMSS_YPG_AdMaxLocal_Campaign_Metrics_Report_LL.csv where the prefix is the creation timestamp of the file and LL is the language code of the taxonomy (en/fr). In case we need to produce this report for different clients in the future, please include an option that allows the user to specify the file name, even if the default is in this format.

The report must contain the following data fields.

• Date (YYYY-MM-DD) - We are required to produce this report every single day. If we miss a day we will have to rerun the report. In this scenario one file would contain data for two dates. Example: It is March 30 and for some reason we cannot deliver reports for March 29. On the next day, March 31 we would deliver a report that contains data for both March 30 and March 29.
• Revision Date (YYYY-MM-DD This is left blank unless this row is used to correct a value in the past. To be used for reruns, discrepancies, etc. )
• Merchant ID*
• SE Campaign Identifier
• SE Campaign Name
• Distribution (Google, Bing)
• Impressions
• Average Position
• Clicks
• Cost (total cost of clicks. They will calculate CPC themselves)
• Quality Score
• Impression Share lost due to Budget (This is not necessary for this story. This story does require that the column and header are created for this value. Gathering data for this value is in another story AML-4095.)
• Impression Share lost due to Rank (This is not necessary for this story. This story does require that the column and header are created for this value. Gathering data for this value is in another story AML-4095.)

* indicates column should be double quoted ("example"). While it is very unlikely we will have double quotes in any of these columns, YPG has requested we use the standard backslash () to escape any double quotes. Example if the merchant's name was The Almond "Milk" Company it would show up as "The Almond \"Milk\" Company" in the report.

See attached xls file for details. See the SE Campaign Metrics tab for specifics.

Once the report is complete please document it in Confluence: https://admaxlocal.atlassian.net/wiki/display/OPS/YPG+Specific+Reports