Quick solutions to common data connection issues
Quick Diagnostics
Is Your Issue Here?
- Data not appearing in templates
- Images not loading
- Connection keeps dropping
- Only partial data syncing
- Primary key errors
- Performance problems
Data Not Appearing {#data-not-appearing}
Symptom
Smart fields show placeholder text or are completely blank in your templates.
Most Common Causes
1. Column Header Mismatch
Problem: Your data source column names don't exactly match your smart field names.
Solution:
- Go to your Data Sources tab
- Check the exact spelling of your column headers
- In your template, ensure smart fields match exactly (including capitalization)
- Example: If your column is "first_name", your smart field must be exactly "first_name", not "First Name"
2. Primary Key Not Set
Problem: No unique identifier selected for your data rows.
Solution:
- Edit your data source settings
- Choose a column with unique values (ID numbers, email addresses, etc.)
- Ensure every row has a value in this column
- Avoid: Using names or descriptions that might duplicate
3. Data Source Connection Expired
Problem: Authentication has expired (common with Google Sheets).
Solution:
- Go to Data Sources
- Look for warning icons next to your connections
- Click "Reconnect" and re-authenticate
- Test with a simple template to verify the fix
Quick Test
Create a new text box, insert a smart field, and check if any data appears. If nothing shows up, the issue is with your data connection, not your template.
Images Not Loading {#images-not-loading}
Symptom
Image placeholders appear but actual images don't load in templates.
Common Causes & Solutions
1. Private or Protected URLs
Problem: Image URLs require login or special permissions to access.
Solution:
- Test your URLs: Open each image URL in an incognito browser window
- Make images public: Change sharing settings to "Anyone with the link can view"
- Use direct links: Link to image files (.jpg, .png) not gallery pages
- Example: Use
https://drive.google.com/uc?id=FILE_ID
for Google Drive images
2. Incorrect URL Format
Problem: URLs point to web pages instead of image files.
Solution:
- Right-click images and select "Copy image address"
- Use direct file URLs ending in .jpg, .png, .gif, or .svg
- Test format: Paste URL in browser - you should see only the image, not a webpage
3. Large File Sizes
Problem: Images are too large to load quickly.
Solution:
- Optimize images: Keep under 2MB each for best performance
- Use web formats: JPG for photos, PNG for graphics with transparency
- Compress images: Use tools like TinyPNG or built-in image compression
4. Broken or Moved Links
Problem: Image files have been deleted or moved.
Solution:
- Check each URL individually
- Update broken links in your data source
- Use stable hosting: Avoid temporary file sharing links
Connection Keeps Dropping {#connection-drops}
Symptom
Data source works initially but stops syncing or shows connection errors.
For Google Sheets Connections
Re-authenticate Your Account
- Go to Data Sources
- Find your Google Sheets connection
- Click "Reconnect"
- Sign in again and grant permissions
- Test the connection with a template
Check Sharing Permissions
- Open your Google Sheet
- Click "Share" → "Change to anyone with the link"
- Set permission to at least "Viewer"
- Copy the new sharing link if it changed
For CSV URL Connections
Verify URL Accessibility
- Test URL: Open in incognito browser - should download the CSV file
- Check hosting: Ensure the hosting service is reliable
- Verify format: URL should end with .csv or have proper headers
Update Connection Settings
- Re-enter the CSV URL in your data source
- Test different update frequencies (try "Manual" first)
- Check if your hosting provider changed access requirements
Partial Data Sync {#partial-data-sync}
Symptom
Some data appears correctly, but other fields are blank or missing.
Diagnosis Steps
1. Check All Required Fields
Problem: Some template fields aren't mapped to data columns.
Solution:
- List all smart fields in your template
- Verify each has a corresponding column in your data source
- Map any unmapped fields in your data source settings
2. Verify Data Completeness
Problem: Your source data has empty cells in important columns.
Solution:
- Review your data: Check for blank cells in critical columns
- Fill missing data: Use "N/A" or appropriate defaults
- Identify patterns: Are certain rows or columns consistently empty?
3. Primary Key Uniqueness
Problem: Duplicate primary key values confuse the data sync.
Solution:
- Check your primary key column for duplicate values
- Choose a different column if duplicates exist
- Clean your data: Ensure each row has a unique identifier
Primary Key Issues {#primary-key-issues}
What is a Primary Key?
A primary key is a column that uniquely identifies each row of data. It's essential for Marq to know which data belongs to which template.
Common Primary Key Problems
1. Duplicate Values
Problem: Multiple rows have the same primary key value.
Solution:
- Identify duplicates: Sort your data by the primary key column
- Choose a different column: Use ID numbers, email addresses, or SKUs
- Create unique values: Add row numbers or modify existing data
2. Empty Primary Key Cells
Problem: Some rows don't have a value in the primary key column.
Solution:
- Fill empty cells: Add unique values for each row
- Remove incomplete rows: Delete rows that can't have unique identifiers
- Use auto-numbering: Add a simple ID column (1, 2, 3, etc.)
3. Primary Key Changes Over Time
Problem: The values in your primary key column change when you update your data.
Solution:
- Use stable identifiers: Choose columns with values that never change
- Avoid names or descriptions: These might be edited over time
- Create permanent IDs: Add an ID column that never changes
Best Primary Key Options
- Employee ID numbers
- Email addresses (if they don't change)
- Product SKUs
- Account numbers
- Auto-generated row IDs
Performance Issues {#performance-issues}
Symptom
Data loads slowly, templates take a long time to update, or the interface feels sluggish.
Optimization Solutions
1. Reduce Data Size
Large datasets slow everything down.
Solutions:
- Limit rows: Keep under 1,000 rows when possible
- Remove unused columns: Only include data you actually use
- Archive old data: Move historical data to separate files
2. Optimize Data Format
Clean, well-formatted data loads faster.
Solutions:
- Consistent formatting: Same date format, number format, etc.
- Remove special characters: Keep text simple and clean
- Standardize text length: Very long text fields slow loading
3. Connection Settings
Adjust how often data syncs.
Solutions:
- Manual sync: For data that doesn't change often
- Reduce sync frequency: Daily instead of hourly
- Use CSV uploads: For static data instead of live connections
Getting More Help
Before Contacting Support
Try these quick fixes:
- Refresh your browser and try again
- Test in incognito mode to rule out browser issues
- Try a different template to isolate the problem
- Check our status page for any known issues
When You Contact Support
Include this information for faster resolution:
For All Issues:
- Description of what you were trying to do
- Exact error message (screenshot if possible)
- Data source type (Google Sheets, CSV, etc.)
- Browser and operating system
For Google Sheets Issues:
- Sharing link to your Google Sheet
- Number of rows and columns in your data
For CSV Issues:
- Sample of your CSV file (first 5-10 rows)
- File size and number of rows
- Where the CSV is hosted (if using URL method)
For Image Issues:
- Direct links to 2-3 problem images
- Image file sizes and formats
Contact Option
- Email: support@marq.com (response within 4 hours)
Preventing Future Issues
Data Source Maintenance
- Regular cleanup: Remove old or unused data monthly
- Monitor connections: Check data source status weekly
- Keep backups: Save copies of important data sources
- Document changes: Note when and why you modify data structures
Template Best Practices
- Test with sample data before rolling out to teams
- Use descriptive names for data sources and smart fields
- Create template documentation for team members
- Regular template audits to ensure all data connections work
Related Articles
- Google Sheets Integration Setup →
- CSV File Integration Setup →
- Data Mapping Best Practices →
- Smart Fields Guide →
Still stuck? Our support team is here to help with personalized troubleshooting for your specific situation.