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
- 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
- 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 Data
- Contact your Customer Success Manager to verify that the data has been successfully ingested.
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
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.
What data is included?
- Contact ID, name, email address, mobile number,
- Date of birth and gender,
- State, postcode and city
- Event name, ID and event time,
- Event images aren't included in Moshtix exports
- Sync Tickets/Orders
- Ticket price
- Only contacts that have ordered something are synced
- Auto sync frequency is Daily
- Historical time limit is 24 months
- Marketing Opt in available from provider
What data is not included?
- Country
- Tags
- Webhook syncs
- Event images
- Only 60% of orders are synced
Data availability
Please be aware that due to the limitations of the Moshtix Control Room, some sales statistics may be one day behind.
Still need help?
Contact us at [email protected]
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article