This guide will help you configure a scheduled report within Moshtix to send your event data to Audience Republic.

To Get Started

Ensure you have:
- An active Moshtix account with reporting access
- An active Audience Republic account
Share your Moshtix Control Room Credentials with your customer success manager
Make sure your Audience Republic Customer Success Manager has provided you with:
- Optional Path (this should be your Promoter OID)
- Access Key
- Secret Key

How to set up the Moshtix Shared With Me Report

Step 1: Log In to Moshtix Control Room

Step 2: Navigate to Reports > Insights > Shared with me

Select "Purchases by Ticket"

Step 3: Configure two reports: one for historical data (Send) and one for ongoing data (Schedule)

Click on the 'Actions' gear and select 'Schedule'

Step 4:

Name your schedule
Select ‘Amazon S3’ as the report destination
Enter the AWS credentials and bucket details:
- Bucket: ar-integrations-moshtix
- Optional Path: use credentials provided by Audience Republic (your OID)
- Access Key and Secret Key: use credentials provided by Audience Republic
- Region: Asia Pacific (Sydney) - ap-southeast-2
Set the file format to CSV

Step 5: Configure the filters

Booking Transaction Timestamp Time: "in the past 2 days"
Client (For Event) Shared Client: select ‘any value’
"Event is not null" ensures that all ticket orders are attached to a valid event
"Orders Subscribed To" Event Organiser - is any value

Under ‘Advanced Options', ensure the Limit ‘All Results’ is selected, otherwise, exports are limited to 5,000 rows by default.

Click Save All

Step 5: Save and Test

Click Save All, then reopen the report and click Send Test

Step 6: Verify Connection

Once the credentials have been added, please notify your customer success manager or customer support, as the Audience Republic team will need to complete one final step.

By following these steps, you'll be able to set up a scheduled report in Moshtix that will automatically send data to Audience Republic, streamlining your event management process.

Exporting historical data

You may also wish to do a historical export. To do this, open the ‘Send’ menu item from the action gear. Fill out the form as per the scheduled report (obviously, there is no scheduled in this version of the form).
The only difference should be the Booking Transaction Timestamp Time, which you can configure as per the customer’s historical data needs.
After pressing ‘Send’, keep an eye on the S3 bucket to ensure the data arrives.