To create a query, first open the Reportei Sync extension in Google Sheets and select the platform you want to retrieve data from.
Then select the account, metrics, dimensions, campaigns, and analysis period you want to use.
For example, suppose you want to see daily reach and impressions for your Meta Ads account. You would use these settings:
- Dimension: Date
- Metrics: Impressions and Reach.
This example would produce three columns—Date, Reach, and Impressions—with one row for each day in your selected analysis period.
This video shows an example of creating a query and then setting up automation: