{"id":9228,"date":"2023-10-16T19:08:38","date_gmt":"2023-10-16T19:08:38","guid":{"rendered":"https:\/\/docs.pontiac.media\/?docs=new-test-section\/automated-reporting"},"modified":"2024-06-21T17:45:48","modified_gmt":"2024-06-21T17:45:48","slug":"automated-reporting","status":"publish","type":"docs","link":"https:\/\/docs.pontiac.media\/?docs=new-test-section\/automated-reporting","title":{"rendered":"Automated Reporting"},"content":{"rendered":"\n

Custom reports can be automatically delivered to your email, FTP or S3 bucket, or Google Cloud Storage on the schedule of your choice. When creating a custom report, select the ‘Schedule Automated Report’ box, then open the ‘Scheduled Reports’ tab to choose the schedule and configure the delivery method.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Custom Report Delivery by S3<\/h4>\n\n\n\n

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

Creating a bucket in AWS S3<\/u><\/strong>:<\/p>\n\n\n\n

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

    Setting up the report in Pontiac<\/u><\/strong>:<\/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. Select Log Level Report <\/strong>from the Report Type Drop Down<\/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":6178,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-9228","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/9228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9228"}],"version-history":[{"count":6,"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/9228\/revisions"}],"predecessor-version":[{"id":10223,"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/9228\/revisions\/10223"}],"up":[{"embeddable":true,"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/6178"}],"prev":[{"title":"Custom Reporting","link":"https:\/\/docs.pontiac.media\/?docs=new-test-section\/custom-reporting","href":"https:\/\/docs.pontiac.media\/index.php?rest_route=\/wp\/v2\/docs\/9203"}],"wp:attachment":[{"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9228"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.pontiac.media\/index.php?rest_route=%2Fwp%2Fv2%2Fdoc_tag&post=9228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}