{"id":8463,"date":"2022-11-22T14:04:41","date_gmt":"2022-11-22T14:04:41","guid":{"rendered":"https:\/\/wiki.pontiac.media\/?docs=new-test-section\/reporting\/custom-report-delivery-by-s3"},"modified":"2025-03-26T18:21:26","modified_gmt":"2025-03-26T18:21:26","slug":"custom-report-delivery-by-s3","status":"publish","type":"docs","link":"https:\/\/wiki.pontiac.media\/?docs=new-test-section\/reporting\/custom-reporting\/custom-report-delivery-by-s3","title":{"rendered":"Custom Report Delivery by S3"},"content":{"rendered":"\n

Setting up Pontiac Scheduled reports delivery in AWS S3 requires:<\/p>\n\n\n\n

    \n
  1. Creating a bucket in AWS S3 <\/strong><\/li>\n\n\n\n
  2. Setting up the report in Pontiac<\/strong><\/li>\n<\/ol>\n\n\n\n

    These are the steps to create a sample report:<\/p>\n\n\n\n

    Creating a bucket in AWS S3 to receive Pontiac scheduled reports:<\/p>\n\n\n\n

      <\/ol>\n\n\n\n
        \n
      1. In AWS S3 click Create Bucket<\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
          \n
        1. Chose a bucket name<\/strong> that is available and the desired AWS Region.<\/li>\n\n\n\n
        2. Change Object Ownership to ACLs enabled<\/strong>.<\/li>\n\n\n\n
        3. Uncheck Block all public access<\/strong> field and check “I acknowledge that the current settings might result in this bucket and the objects within becoming public”.<\/li>\n\n\n\n
        4. Click Create bucket.<\/li>\n\n\n\n
        5. Navigate to the newly created bucket and click Create folder with the output path that we chose in Pontiac (“output-path”). Confirm to create the folder.<\/li>\n<\/ol>\n\n\n\n

          Setting up the report in Pontiac<\/p>\n\n\n\n

            \n
          1. Go to Reporting<\/strong> tab and then click New Custom Report<\/strong>.<\/li>\n\n\n\n
          2. Check the box for Schedule Automated Report <\/strong>and fill out the desired details in the Custom Report tab like Advertiser ID, start and end date and select the desired metrics and dimensions.<\/li>\n\n\n\n
          3. Go to Scheduled Reports tab and check Deliver by S3<\/strong> box.<\/li>\n\n\n\n
          4. In the expandable section fill out the Bucket<\/strong> field with the AWS S3 Bucket name. Example: S3-test-bucket.<\/li>\n\n\n\n
          5. Fill out the Path field with a desired output path location and file name (To include the date macro use dateInt (YYYYMMDD) like xxx\/filename-%dateInt% otherwise your file will be overwritten each day<\/em>). Example: output-path\/Pontiac-reports.csv or output-path\/Pontiac-reports-%dateInt%.csv<\/li>\n\n\n\n
          6. Click View security policy and copy the full text area.<\/li>\n\n\n\n
          7. Go to Amazon AWS S3 and modify permissions for the bucket we chose earlier. In the Permissions tab click Edit and paste the policy text from earlier and Save.<\/li>\n\n\n\n
          8. Back in Pontiac reports screen click Verify<\/strong> and wait for a successful confirmation message. <\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n","protected":false},"author":6,"featured_media":0,"parent":1129,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-8463","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/8463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8463"}],"version-history":[{"count":5,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/8463\/revisions"}],"predecessor-version":[{"id":9705,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/8463\/revisions\/9705"}],"up":[{"embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/1129"}],"next":[{"title":"Basic Custom Reports","link":"https:\/\/wiki.pontiac.media\/?docs=new-test-section\/reporting\/custom-reporting\/basic-custom-reports","href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/1130"}],"prev":[{"title":"Custom Reporting Overview","link":"https:\/\/wiki.pontiac.media\/?docs=new-test-section\/reporting\/custom-reporting\/custom-reporting-overview","href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/6432"}],"wp:attachment":[{"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8463"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/wiki.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=8463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}