Reporting Troubleshooting

Redshift Troubleshooting

Cannot connect to redshift

[Amazon][Amazon Redshift] (10) Error occured while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x00000274C/10060) Is the server running on host ”redshiftdata.pmg.com” (52.72.60.133) and accepting TCP/IP connections on port 5439?

Solution

Are you on the office wifi? Reach out in #alli-data

If you’re not on the office wifi, connect to the VPN and try again.

Can we pull data from custom grouping from Google Analytics?

One can only pull Default grouping from Google Analytics API. Custom Groupings aren’t supported by Google Ads API.

Google Datasources 400 Error

There is a good chance your query is invalid, try using the query validator for Google Ads or query explorer for GA4 before submitting a ticket.

SA360 Datasources 400 Error

A 400 from Google Ads or SA360 usually implies that you have an invalid combination of fields. Unfortunately SA360 does not have a query validator. Please start with a minimal number of fields, gradually adding others manually to evaluate for a conflict, before submitting a ticket.

Request failed with status code 400